How to add Customer address from CRD1 to AR Invoice Print Layout (PLD)

[pvinod_kumar]

Hi experts

i need to link customer address which is been stored in CRD1 table to AR Invoice Print layout Design

when i try to link the CRD1 table to the AR Invoice directly its not previewing the Layout (PLD)

[former_member419030]

Dear P Vinod Kumar,

Why you do not use data under Ar Invoice-->Logistic?

[azizelmir · Accepted solution]

Hi Vinod,

System will retrieve the bill to address from the available information in the respective AR invoice, so if you want the updated address to reflect even in the old AR invoice layout then you have to try to get the information from business partner master (OCRD).

So try to retrieve the address information from OCRD table.

1. Open the AR Invoice PLD.

2. Select these fields from OCRD table indiviually AddrType, Block, Building, City, Country, County, BillToDef,State1, Address, StreetNo, ZipCode.

3. Create the formula Field & select the CONCAT function and insert the above fields which you required.

Thank you,

Aziz El Mir

[robert_czik]

I also need to link to CRD1 table in PLD layout but I cannot access this table - the table is needed to pick up the Billing Address

Any ideas how to do this?

Thanks

Robert