cancel
Showing results for 
Search instead for 
Did you mean: 

How to Bring BP Name and Address in JE Tempalte.

Former Member
0 Kudos

Hi,

We are Adding Certain Invoice Through JE here i need to Get

BP Name and Adress for Exisiting BP Account Code

Ex.

BP Account Code Debit Amount

Travel Expen Credit Amount

Serice Tax Credit Amount

Educational Credit Amount

HEducational Credit Amount

Here i deleted Debit Amt in Row Level now it's showing only

Credit Amount but when I did this in Print Preview it's Showing

Pages 1 to 360 Pages in this layout there is no Hidden Fields

and how i can Disable only BP Code and name in Repetative

Area 0 and this Code i copied in Header Level here it's

Showing BP Code and Header part i want to show BP Name

Coresponding BP Code, For Address i Selected CRD1 table

and AddresName Field and one more i selected Field Bill to

in OCRD Table here it's Retreiving First BP Address not for

Exsiting BP Account Code how i can put a condition here wen

BP A/C Code is there that BP Address i need to show.

1.User don't want to Accept to create UDF in JE and

Assigning FMS to that UDF and Automaticlly Update Address

in UDF

2.Through Query PLD it will Bring All Fields in Repetative Area

only how i can Bring in to Header Level. Plz Guide me how i

Retreive Address for Exsiting BP A/C Code and Avoid to Un

neassary Pages in Print Preivew.

Regds,

Samapth Kumar Devunuri.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Samapth,

I suggest that you create the user defined fields (UDFs) for the fields that are not exposed in the PLD. UDFs for journal entries are created under category 'Accounting' item in User Defined Fields Management.

Julius

Former Member
0 Kudos

Hi,Julius Mastilak .

Instead of Creating UDF is there any Possiblity to get Data

Related to BP Code and Name,Address in JE Layout. Right

now iam Retreiving Data but i need to Reteive Addres for

Coresponding BP A/C Code.We need to Show only Print . Plz

Give me your Suggestions.

Regds,

Samapth Kuamr Devunuri.

Former Member
0 Kudos

Hi Samapth,

in 2007 version the BP code and BP name is printed. Address you can only get via UDF since CRD1 table that contains address field is not exposed to PLD.

Rgds,

Julius

Answers (0)