Skip to Content
avatar image
Former Member

Automatic Clearing with Payment Advice via EDI

I am trying to automate the cash application process via the receipt of the customer inbound 820 (using message type REMADV, type PEXR2002). I can successfully post payment, clear open items, and set up deductions relating to a specific invoice, but I haven't been able to post deductions unrelated to an invoice. Our customers often take deductions not related to a specific invoice at the same time as remitting payment for invoices. Has anyone managed to post 'independent' deductions when posting a payment advice via EDI?

I also have one small problem selecting the customer open item for clearing. Our billing document number does not equal the financial accounting document number. We store our billing document number in the Assignment field, and this is the number the customer will reference when remitting payment. I have not been able to find a way to use the customer's reference number (e.g. Assignment field) to select the open item. Has anyone had any success using the Selection Rule assigned to the payer to select open items by something other than the accounting document number? Or is this functionality only available for manual processing of payment advices.

Any advice would be greatly appreciated!

Thank-you,

Shauna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Nov 28, 2007 at 02:44 AM

    Hi Shauna,

    I was trying to achieve the same process.

    Could you please send me the configuration details and explain me how to automate the payment advice

    I have a payment advice, i want to know how this payment advice is used to clear the open items for the customer

    Help in this regard is highly appreciated and rewarded with points

    Thanks

    Rajanikanth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2008 at 11:16 PM

    Hi Shauna,

    We are facing the same issue. Did you find a solution on how to handle deductions not related to an invoice through EDI 820? As long as the deduction is related to an invoice, SAP is handling it well. For the unrelated deductions, SAP is putting the whole lumpsum of all unrelated deductions as "On account posting" instead of putting them as separate deductions with different reason codes.

    Thanks,

    Nile

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2009 at 02:38 PM

    We need to Configure the Payment Incoming advice and provide the rule that Assignment field should be used to pick up the Doc no.Once we have done that it would work.I am doing the same using Delivery Ref number.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2011 at 01:44 PM

    All

    I have a somewhat similar qs.

    We are bringing in IDOCS REMADV and are trying to do the following:

    1.If the external Reason Code XYZ, we want the system to do customer clearing and bank posting lumpsum for all the items within the payment advice.

    2. If the external Reason Code ABC, we want the system to do customer account Dr posting and bank posting lumpsum for all the items within the payment advice.

    3. If the external Reason Code 123, we want the system to do customer account Cr posting and bank posting lumpsum for all the items within the payment advice.

    4.If the external Reason Code 789, we want the system to do GL Dr and bank posting lumpsum for all the items within the payment advice.

    In the payment advice posting rule configuration, I have associated the customer with one posting rule, however that allows me to do only one of the above.

    How and where do I associate the various scenarios above to the payment advice posting rules?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2011 at 09:39 PM

    First try to do it with F-28. How you are doing it with F-28 will give you the solution for the Idoc.

    You can write off automatically using a reasin code and residual item.

    If you want a mass write off, you have to do it for each item, as AVIP does probably not allow you to post on a given GL account.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2011 at 03:28 PM

    Hi

    Can you please let us know what segments and fields you are populating to do the customer clearing and passign deductions?

    A cut and paste of the idoc print would be very helpful.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2011 at 01:28 AM

    Hi

    We are working on the same issue listed in the thread i.e how to handle deductions not related to an invoice through EDI 820?

    For the unrelated deductions, SAP is putting the whole lumpsum of all unrelated deductions as "On account posting" instead of putting them as separate deductions with different reason codes, even though we have the reason codes assigned and have configured them to post to GL accounts.

    Also when posting the deductions relating to invoice we get an error when processing the IDOC that no batch SAP... data available. We processed a manually created payment advice and saw that the error was coming on the screen wherein one has to accept and continue the differences against the invoice.

    Any input is highly appreciated.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kirti,

      We are in the process of implementing incoming payments through EDI 820. However we are getting the below error when we generate the IDOC.

      "

      Formatting error in the field BKPF-WAERS ; see next message

      Message no. 00298

      Diagnosis

      During batch input or when executing CALL TRANSACTION... USING a screen

      field was filled with an invalid input format.

      System Response

      Processing was terminated.

      Procedure

      The screen field has the technical name BKPF-WAERS . The cause of the

      error is described in the following message.

      Correct the appropriate BDC data."

      -


      We tried to debug and but we got below

      In the 1st screen, the currency/ rate field comes up as blank. The value u2018USDu2019 was entered manually by me.

      The Amount comes as blank as well u2013 hence the transaction shows an warning message that the line will be ignored because of the 0 amount

      Lastly the following screen shows up and stops with the error message.

      "Different Currencies in payment advice and document header /USD.

      Any help is highly appreciated.

      Thanks in advance

      Krishna