414
If you are seeing order import exceptions where the ORDER_STATE_SALES_TAX differs from the OrderLogix calculated amount by a few cents and you have already verified with your vendor that you are utilizing the correct Tax Calculation Method (_see article explaining this setting here https://support.orderlogix.com/portal/en/kb/articles/tax-calculation-methods then you should check which method of rounding your vendor is using when calculating tax so that they can send the setting to match the method used.
OrderLogix defaults to use the method ROUND but also supports UP DOWN and BANKERS for imported orders.
Round: The number will be rounded down if the following digit is less than 5 (0 1 2 3 4) and will be rounded up if the following digit is 5 or greater (5 6 7 8 9). (ex. 1.234 would round to 1.23 and 1.237 would round to 1.24)
Up: If there are any digits following then the number will be rounded up _(ex. 10.5602 would round to 10.57)
Down: If there are any digits following then the number will be rounded down _(ex. 10.629 would round to 10.62)
Bankers: The number will be rounded down if the following digit is less than 5 (0 1 2 3 4). It will be rounded up if the following digit is greater than 5 (6 7 8 9). If the following digit is 5 then round up or down to the even number (ex. 10.565 would round down to 10.56 because 6 is an even number. 10.575 would round up to 10.58 because 8 is an even number.) This method is also sometimes referred to as half round even.
The rounding method is set on the import configuration page for Batch File imports by selecting from the drop down labeled “Tax rounding method”.
For the API Order Import this is a setting labeled “TAX_ROUNDING_METHOD”.
If you still have questions regarding the material covered in this article please contact OrderLogix Customer Care for assistance. Thank you!