Solved
Rounding on Sales import
Our sales have unit prices up to 8 decimal places. How do we go about importing this into MYOB when the field is limited to 4 decimals places?
For example a sale of
Quantity - 164461
Total $358,981.03
Calculated unit price
358,981.01/164461 = $2.1827730
When we import it will only allow the unit price to go up to 4 decimal places ie $2.1828
this results in a final (incorrect) total price of 164461 x 2.1828 =$358,985.47 ($4.44 difference)
How do we get the correct total amount of $358,981.03 into the system?
