Skip to Content
0

Invoice show open and in open item list, but the BP account balance is zero

May 03 at 09:26 AM

21

avatar image
Former Member

Hi,

When we running open item list for A/R invoice, some of the invoice amount is 1 or -1, but when checked the BP account balance, it showed 0

After several check, it was found that this only happen when there is currency rate difference on the A/R invoice and it related down payment

For example: A/R down payment rate is 30.01, incoming payment rate is the same.
Later on, in A/R invoice, the rate is 30.05, and we assign the DP to the invoice, due to the difference, the A/R invoice status will be not closed, always in Open status, and still can find in open item list, but the account balance is 0

Another find out is when we run the BP aging report, the open invoice and incoming payment of the down payment show in the list, but with balance due 0.

We had tried to right click to manual closed the invoice, but cannot find the option.
Also tried to restore the G/L and BP account balance, but still doesn't work

Is there any solution for this? Please help

We just don't want to credit memo the invoice and assign the same currency rate with incoming payment/down payment

Currently using SAP B1 8.81 PL 11

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers