Payment on account

[Former Member]

Hi Experts,

My client has taking advance(Payment on account) for a particular BP. How do I link the incoming payment doc to A/R invoice. So that the Balance due amount should be right(ie Amount- Advance).

Please give me solution asap.

Thanks & Regards

Subhradip

[jitin_chawla · Accepted solution]

Hi,

If you are on Version 2007 or above, then you can perform the Internal Reconciliation between the Incoming Payment and the Invoice.

For the reconciliation :

1) Goto the Business Partner Module > Internal Reconciliation > Reconciliation > Select the BP Code.

2) Select the Payment on Account and Invoice and change the Amount to reconcile to balance out the credit and debit to make total as zero.

3) The balance due for the Invoice is updated to the remaining balance due amount.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

When I doing the internal reconciliation the error shows "Reconciliation difference must be zero before reconciling".

Thanks & Regards

Subhradip

[Former Member · Accepted solution]

Hi Subhradip,

For such error, your reconciliation has not balance either by decimal rounding or by bug. You have to find it out. Better in test environment.

Thanks,

Gordon

[jitin_chawla · Accepted solution]

Hi,

The issue it seems is happening because of the Decimal places mismatch.

Check whether you have defined the 'Automatic Reconciliation Diff.' account defined in: Administration -> Setup -> Financials -> G/L Account Determination -> General Tab.

Also, please make sure that Version and patch is above SAP Business One 2007 A PL 46 or SAP Business One 2007 B Patch 09 if you are using B version.

Check by defining the Automatic Reconciliation Diff account and update us.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

I am using SAP B1 8.8 PL 10.

Thanks & Regards

Subhradip

[jitin_chawla · Accepted solution]

Hi,

Please check for the Automatic Difference Account defined at the path mentioned by me in earlier reply.

Be sure that the column 'AMOUNT TO RECONCILE' in the internal Reconciliation totals to zero after selecting the Payment on account and Invoice. (meaning you have changed the Invoice Amount to reconcile as equal to Payment on account amount

If still not, then let me know. There are a few Notes regarding the error and may be we can find which relates to your issue.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

What will the account name of Automatic reconciliation Diff...

Thanks & Regards

Subhradip

[Former Member · Accepted solution]

Hi Subhradip.........

You can adjust the Advance Payment against an Invoice by using BP Internal Reconciliation Option.

For this go to Business Partner--> Internal Reconciliation --> Reconciliation and Select Customer.

Once you select this it will show you both entries i.e. Advance Payment and Invoice entries.

Select Both the entries and see the difference of both entries it should be zero.

If any difference occurs say very negligible then you can adjust it by press Adjustment Button and it will open Journal Entry Screen where you have to give Rate Difference of Reconciliation Account where minor rounding can be managed. and then add it and then press Reconcile Button.

This will handle your Invoice adjustment against Incoming On Account Payment Scenario........

Regards,

Rahul

[jitin_chawla · Accepted solution]

Hi,

The Automatic Reconciliation difference account working should be similar to one as rounding as it moves the nominal decimal values to the G\L Account selected in the Automatic Reconciliation difference account.

Also, as per my earlier reply , Be sure that the column 'AMOUNT TO RECONCILE' in the internal Reconciliation totals to zero after selecting the Payment on account and Invoice. (meaning you have changed the Invoice Amount to reconcile as equal to Payment on account amount.

Kind Regards,

Jitin

SAP Business One Forum Team