Payment transactions applied to down payment requests cannot be reconciled

[Former Member]

Help

See the scenasrio:

A customer added sales order( SO-123) of Amount 100000 dated 23/08/2009, Than request for advance INR 100000( 100 %)

from customer and added A/R down payment request( Based on S0-123) dated 24/08/2009, Customer argree to give advance,

So user added Incoming payment dated 25/08/2009 and received INR 100000. Now delivery( based on SO-123) happend on

date 26/08/2009, And A/R Invoice added on date 27/08/2009. Since customer already paid said A/R Invoice amount

through A/R downpayment request and Incoming payment on dated 25/08/2009, Now How to close the A/R Invoice

I already tried with business partner ledger and manually reconcile the incoming payment with his invoice,

than this giving error

Payment transactions applied to down payment requests cannot be reconciled here [Message 3821-19]

Regards

Arun K Singh

[jitin_chawla]

Hi,

Please check the Note 1340606 regarding the error.

Also, Downpayment Request should be used for the part of payment and not 100%.

For 100% advance amount you can check the option of the Reserve Invoice.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Jitin,

Please elaborate as to why you should not use the DownPayment for 100% payment upfront. I have done this with no issues (key is to click the DP button in the AR Invoice window to link the DP).

The DP payment transaction goes to a different GL account per the GL Acct Determination. If you are asking for payment up front, this means that goods/service have not been provided yet. The Reserve Invoice posts the credit to a revenue GL but the sale has not yet actually taken place as the goods/service have not yet been provided so from an accounting perspective, depending on local actg rules, DP may be better/correct option as it will go to a GL that reflects this. This is why we use the DP transaction.

Regards,

Heather

[Former Member]

Hi Heather,

I have found the same problem too.

In SAP Business 2005A, we allow to do Internal Reconciliation on this Downpayment Request with 100% and the Invoice.

The only differences is this Invoice with status Closed.

But In SAP Business 2007A, we not allow to do Internal Reconciliation on this Downpayment Request with 100% and the Invoice.

The only differences is this Invoice with status Open compared in 2005A.

I have checked in both version 2005A and 2007A Journal Entry, there is nothing wrong on it.

Why this happen in version 2007A?

Hope Jitin can answer our Question.

Best Regards,

danny

[former_member187989]

Reverse ar invoice by creating ar credit memo,Create ar invoice from delivery,link ar down payment request to ar invoice,

If you paid advance amount in full 100%,then ar invoice total amount should be zero.

[Former Member]

HI,

I'm facing the same problem too. I have already reverse the A/R invoice by copying it to credit memo. Then, I created a new A/R invoice but I couldn't link it to the A/R Downpayment Request. I did some testing and found out that I can only link it to A/R Downpayment Invoice.