Automatic Clearing with Payment Advice via EDI

[Former Member]

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

[Former Member]

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.

[Former Member]

I am working on a project to automate the application for customers that send us EDI 820. I see that people in this thread have experience with this task. I would appreciate guidance and any available documentation for the process and the configuration for using the EDI 820.

We are using ECC 6, support pack 8. We currently use the BAI format for lockbox payments. We receive payment advice data for a few customers via EDI 820. The actual payment is received via the lockbox or via a wire payment. We do have a custom process in place that creates a payment REMADV IDOCS which create payment advices. I need to understand how to utilize the payment advices to apply the customer payments at the reference level instead of at the payment level. We also have deductions that are not related to open items.

Thanks for your assistance.

[former_member189681]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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?

[Former Member]

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.

[Former Member]

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

[Former Member]

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