We have run into an issue when processing sales orders where the inventory unit and sell unit are different.
Unit A is the inventory unit. Unit B is the sell unit.
In our scenario Unit A * 1.07 = Unit B.
The product is batch controlled and is invoiced for the following batches an quantities (note the conversion by line from Unit A to Unit B):
| Batch number |
Unit A |
Unit B |
| A1 |
957.00 |
1,023.99 |
| A2 |
957.00 |
1,023.99 |
| A3 |
980.00 |
1,048.60 |
| A4 |
980.00 |
1,048.60 |
| A5 |
980.00 |
1,048.60 |
| A6 |
957.00 |
1,023.99 |
| A7 |
957.00 |
1,023.99 |
| A8 |
980.00 |
1,048.60 |
| A9 |
957.00 |
1,023.99 |
| A10 |
957.00 |
1,023.99 |
| A11 |
980.00 |
1,048.60 |
| A12 |
957.00 |
1,023.99 |
| A13 |
957.00 |
1,023.99 |
| A14 |
957.00 |
1,023.99 |
The decimal precision on Unit B (the sell unit) is set to 0 decimal places. The quantity being invoiced looks to be calculated by the sum of all batch numbers * 1.07 and arrives at:
13,513*1.07 = 14,458.91
Rounded to 14,459.00 on the invoice line.
However, when we go to print the invoice and include the batch number, the each individual batch number is rounded in the output:
| Batch number |
Invoice Output |
| A1 |
1024 |
| A2 |
1024 |
| A3 |
1049 |
| A4 |
1049 |
| A5 |
1049 |
| A6 |
1024 |
| A7 |
1024 |
| A8 |
1049 |
| A9 |
1024 |
| A10 |
1024 |
| A11 |
1049 |
| A12 |
1024 |
| A13 |
1024 |
| A14 |
1024 |
So the total for all batches 14,461 for the batch detail does not match the invoice total 14,459.
Is there a setting somewhere in AX to control the rounding? In our business Unit B, has to be shown with 0 decimal places.
