Hello everyone,
I have a question regarding line discount calculation in Microsoft Dynamics 365 Business Central.
Scenario:
I have a Sales Order with the following details:
Item A
Quantity: 1,000
Unit Price: 29,000
Total amount = 29,000,000
I enter a Line Discount Amount of 1,000,000 (which is 1,000 discount per unit).
After entering the discount amount, the system automatically calculates the Line Discount % as 3.44828% (system allows 5 decimal places).
Issue:
When I fully ship and invoice 1,000 quantity, the total amount is correct.
However, when I partially ship and invoice 600 quantity:
Expected calculation:
600 × 28,000 = 16,800,000
But the system calculates using the discount percentage (3.44828%), and the invoice amount becomes:
16,799,999.28
There is a small rounding difference.
Question:
How can I ensure that during partial shipments the invoice amount is exactly 16,800,000 (based on fixed 1,000 discount per unit)?
Is there any standard setup or configuration in Business Central to avoid this rounding issue when using Line Discount Amount?
20
Share
Report
All responses (
Answers (
