Customer Statement has wrong Bill To address

[keith_hitchner]

All,

I am using a slightly modified PLD for Customer Statements.  The past due AR Invoices have the correct Bill To address but the Statement shows the old Bill To address (on previous AR Invoices).  How do I get the system to print using the current Bill To?

I checked the forms and the Field info for the AR Invoice PLD and the Collection Report PLD are the same for the Bill To info.

Please see the attached for info.

Basically I need to know how do I force the system to take the Bill To from the invoices that are printed on the statement?

Thank you,

Keith

[former_member227598 · Accepted solution]

Hi Keith,

In SAP B1 PDL concat function are available , by using this function and Add the from OCRD table (i.e Business Partner master data table), Because in PDL CRD1 are not available.

Thanks

Kamlesh Naware

[keith_hitchner]

Because I am still relatively new to SAP - I do not know how to concat the various address fields into 1 field.

The existing PLD uses 1 Field (BillTo) from the A/R Invoice.  How do I create this "1" field from the multiple fields in CRD1?

Thank you again for the help.  I have learned much from the various groups but this is new to me.

Keith

[former_member227598]

Hi Keith,

Please follow the below step by step

1. Open the AR Invoice PLD.

2. Select these are the feilds from OCRD table indidually AddrType (i.e F_001) , Block (i.e F_002),

Building (i.e F_003),City (i.e F_004),Country (i.e F_005),County (i.e F_006),BillToDef (i.e F_007),State1 (i.e F_008),Address (i.e F_009),StreetNo(i.e F_010),ZipCode (i.e F_011)

3. Create the formula feild & select the concat command & insert the above feilds which you reqried

Concat(F_001,F_002,F_003,F_004,F_001,F_001,). If you required space then F_001,' ',F_0010

Rgds,

Kamlesh Naware

[keith_hitchner]

Kamlesh,

I was able to use your info but for some reason had to have 4 fields for the address (each line),  I tried to use the chr(10) to enter a line break but it did not work.  I tried "chr(10)" and that failed also, no idea why but I was able to get the form to print the default Bill-To addresses.

Thank you,

Keith Hitchner

[former_member227598]

Hi Keith,

If your issue are resolved, So kindly close the thread with marked the correct  or Helpful answer.

Thanks,

Kamlesh Naware

[former_member185296]

Hi,

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.

So try to retrieve the address information from CRD1 table.

Regards

Vinoth