cancel
Showing results for 
Search instead for 
Did you mean: 

A/R Down Payment not posting to A/R Invoice

Former Member
0 Kudos

We are having trouble with the a/r down payment process. We have open invoices even though we have already received payment.

For example, a customer mailed in a check to order items. We added the items on a sales order. We clicked on the Money Bag (Payment Means), and entered the check as a deposit on the order. SAP added a note that the order was linked to down payment. Through a batch process, we delivered the order and it became an a/r invoice. Because the A/R Invoice is created in a batch, we can't apply the down payment at the time of invoice creation. When we go back into the a/r invoice, the down payment money is not available to apply to the invoice. If we select the box with the triple dots next to total down payment to apply the down payment, it says u201CNo matching records found.u201D

When I click on the Business Partner, I can't see the down payment in their account balance to close it manually. What I do see is three entries. The first is a DT, debiting customer account for the a/r down payment. I donu2019t understand this entry, because this sounds like itu2019s u201Cchargingu201D the customer for their deposit. The second is an RD, crediting the customer account for the incoming payment. These two entries are reconciled against each other and closed. The third entry is an IN, for the open invoice.

How do I get the a/r down payment process to work and reconcile the incoming payment to the invoice?

Please help.

- David Daniels

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi David...........

Let me explain you how standard cycle works in SAP from Order to Invoice.

1. Sales Order

2. AR Down Payment (Partial/Full)

3. Incoming Payment (Through Check/Cash/Any) Based on Down Payment

4. Delivery

5. Down Payment in case of Partial or optional and its payment

6. AR Invoice by selecting Down Payment by following three dots........

In Above process you get to attach Down Payment to Invoice only when you customer pays you through Incoming Payment based on Down Payment else it give error No Matching record Found as you mentioned.......

Just try the above process as I suggested in Demo DB........

Regards,

Rahul

Former Member
0 Kudos

I have tested it, and it definitely works when I manually create the a/r invoice from the delivery document. But, we have hundreds of orders every day, so we have a program that automatically sends the delivery documents to a/r invoices. The down payment shows that it's attached to the order, but I can't apply after the invoice is created. Any suggestions?

Former Member
0 Kudos

David.......

System works as per its behavior. It does not change its functionality.

Once AR Invoice is accounted no one can change or edit it.

But you can have work around regarding this.

You may use Payment on account for advance amount in Incoming payment which you have to reconcile later with AR Invoice.

Or you have to modify your program so that it makes provision for autoadjusting the DownPayment Invoice amount against AR Invoice........

Regards,

Rahul

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

The Downpayment functionality is the advance payment recieved and the same needs to be assigned to the Invoice.

If possible, please test the compete scenario which you have and make the target document from the Sales Order to Delivery and from Delivery document to Invoice.

The Invoice automatically assigns the Downpayment created based on the Sales Order. (Check in 8.8 version).

If it is not helping then you can check the option of creating a Reserve Invoice to book the advance you get against the Sales Orders prepared.

Hope it helps.

Kind Regards,

Jitin

SAP Business One Forum Team