Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2011 at 05:08 PM

    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........



    Add a comment
    10|10000 characters needed characters exceeded

    • 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,


      SAP Business One Forum Team

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.