Bank Name Within Outgoing Payment PLD

[Former Member]

Dear All,

My Client is working on SAP B1 2007 B PL10. Now my client wants Bank Name to be displaced in the Header Level of the Outgoing Payment PLD.

Please guide me in this matter.

Regards

Hitesh Parsawala

[Former Member · Accepted solution]

Hi Hitesh,

Try this,

->> Create 1 System Variable Field in Page Header on PLD.

Bank Name

Variable -> 126.

Else

->> Create 1 Database Field in Page Header on PLD.

Table -> VPM1 - Outgoing Payments - Rows.
Column -> BankCode - Account no.

Regards,

Madhan.

[Former Member · Accepted solution]

Hi Madan,

I have tried using the Variable 126 but it is throwing error,

Sir, I want to display Bank Name at the Page Header of the Outgoing Payment PLD and not the Bank Code.

Regards

Hitesh Parsawala

[Former Member · Accepted solution]

Hi Hitesh,

Try this,

->> Create 1 System Variable Field in Page Header on PLD.

Bank Name

Variable -> 126.

->> Goto Properties Window and put the Tick mark in Description on Content Tap.

OR

Try to Create FMS Query and assign the FMS in UDF.

Create UDF in Header on Outgoing Payments.

->> Choose Tools on Top menu.

->> User - Defined Fields. -> User Manage Fields.

->> Open the User Manage Fields Widnow.

->> Payments -> Title.

->> Select Title and Click Add button in Bottom on User Manage Fields Window.

->> Create Bank Name UDF(Code, Discription and Type - Character) and Add the UDF.

Create FMS in Query Generator and Save as Query Manager then Assign the FMS in UDF for Bank Name.

->> Adminstration.

->> Reports. -> Query Generator.

->> Open the Query Generator and put the below FMS query.

SELECT T0.BankName 
FROM ODSC T0, VPM1 T1 
WHERE
T1.BankCode= T0.BankCode 
AND 
T1.DocNum= $[OVPM.DocNum]

->> Assign the FMS in UDF on Outgoing Payments.

->> Auto Refresh of REMARKS or other require field

Ex.

1. Goto the UDF and Clcik ShiftAltF2.

2. Select the SEARCH BY SAVED QUERY.

3. Assign the FMS Query.

4. Select the AUTO REFRESH WHEN FIELD CHENGES.

5. Select REMARKS.

6. Check the Display Saved Values.

Use this UDF field in Page Header on Outgoing Payments PLD.

Regards,

Madhan.

[former_member206437]

Hi

Could you please try this with the FMS(Formatted Search) in the following way:

1. Create a UDF on Header level for Outgoing Payment.

2. Use the query:

select bankname from odsc t0,vpm1 t1 where

t1.bankcode=t0.bankcode and t1.docnum=$http://OVPM.DocNum

3. Link this Query to UDF

It was working 100% in my system

Giri

[Former Member]

Hi Hitesh,

->> Create 1 Database Field in Repetetive Area on PLD.

Bank Name

for example: Field_ID -> F_123.

Table -> VPM1 - Outgoing Payments - Rows.
Column -> BankCode - Account no.

->> Create 1 Formula Field in Page Header on PLD.

->> Bank Name Field_ID(F_123) Copy from Repetetive Area

and Paste to Formula field in Page Header.

or

Same way

->> Create 1 System Variable Field in Repetetive Area on PLD.

Bank Name

for example: Field_ID -> F_456.

Variable -> 126.

->> Create 1 Formula Field in Page Header on PLD.

->> Bank Name Field_ID(F_456) Copy from Repetetive Area

and Paste to Formula field in Page Header.

Regards,

Madhan.

[former_member206437]

Hi

Use VPM1-Bankcode-account code to get the bank name in PLD.

Giri

[Former Member]

Hi Giri,

I want to display Bank name and not the Bank Code. Is there any way out i can display the Bank Name in the Page Header of the Outgoing Payment PLD.

Regards

Hitesh Parsawala