Hello everyone,
I have a Sales Return Order which is in USD-currency.
The Currency Factor is 1.3856
The Sales Return Oder has one line. A discount was entered.
| Item No. |
Quantity |
Unit Price (USD) |
Line Discount % |
Line Amount |
Line Discount Amount |
| 1001 |
1 |
32.00 |
20 |
25.60 |
6.40 |
So far so good.
Now, when I post the Return Order, I do receive the inconsistent-error:
The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function is used in the transaction to find the reason for the error. Contact your system administrator.
And, there is actually an inconsistency.
Looking into the Posting Preview, I can see the following numbers and how they add up:
| G/L Account |
Amount (LCY) |
| Discount Account |
-4,62 |
| Credit Memo Account |
23,09 |
| Customer Receivable Account |
-18,48 |
The problem is the sum of the Discount Acc. and the Credit Memo Acc: 23,09 - 4,62 = 18,47
Because the sum does not equal the amount of the Customer Receivable Account, the posting is aborted with the inconsitency-error.
The difference of 0,01 occurs because of the Currency Factor.
Please see below table as explanation:
| G/L Account |
Amount (USD) |
Currency Factor |
Amount (LCY) |
Rounded Amount (LCY) |
| Discount Account |
-6,40 |
1.3856 |
-4,618937644341801 |
-4,62 |
| Credit Memo Account |
32 |
1.3856 |
23,094688221709007 |
23,09 |
| Customer Receivable Account |
-25,60 |
1.3856 |
-18,475750577367206 |
-18,48 |
|
|
Total |
0 |
-0,01 |
So, the reason for the inconsistency is that the LCY amounts are rounded per Discount Account and Credit Memo individually. But the LCY amount posted into the Customer Receivable Account is taken from the Line Amount/Order Total.
I do understand the problem. But, is there a way in (standard) Business Central to handle such scenario?
I tried the Realized/Unrealized Gains from the Currency-setup & Customer Posting Setup. I also tried invoice rounding. Unfortunately, with no success.
Does someone here have an idea how to solve the inconsistency (without a code change)?
The inconsistency amount could be posted into a designated G/L Account.
