Skip to Content

Customer Statement has wrong Bill To address

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

Inv.jpg (45.8 kB)
Collection Rpt.jpg (39.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jun 17, 2016 at 10:54 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 22, 2016 at 01:13 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Jun 16, 2016 at 07:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 22, 2016 at 12:48 PM

    Hi Keith,

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

    Thanks,


    Kamlesh Naware

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.