There are several settings available with the API Order Import to allow for OrderLogix calculations upon import to match the source system’s calculations.
SOME THINGS TO CONSIDER THAT MAY IMPACT THE WAY WE CALCULATE TAX ON AN IMPORTED ORDER:
OLX or source taxes – If USE_TAXES is equal to “N” then the OrderLogix tax rates will be used when validating the tax amounts sent with the order. If the rates used by the source system differ from the rates used by OrderLogix then the value passed and the calculated amount may differ by a few cents or several dollars. If USE_TAXES is
equal to “Y” then the tax rates from the source system will be submitted with the order and those rates will be used when validating the tax for the order. As long as the remaining settings match using the same rate OrderLogix will arrive at the same tax amounts.
Pre-Auth – If a Pre-Auth payment transaction is submitted with the order additional validation is done by the import to ensure that the tax values calculated match the values that were sent.
Installments – When an order contains a multi-pay(installment) product and tax is charged the import will expect the tax included with the first payment to match the set up of the installment in OrderLogix; either distributed across installments or not. If the option is set to distribute taxes then we will calculate the tax included in the amount already paid by multiplying the PAID_PRICE_PROD## by the TAX_RATE##. If the tax is not to be distributed and therefore all included in the first payment then OrderLogix will calculate the tax to be included in the amount already paid by multiplying the PRICE_PROD## by the TAX_RATE##
Tax On Shipping – If you are charging tax on shipping you must populate the SHIP_TAX_PROD## fields for OrderLogix to include tax on shipping in the validation calculations. If you calculate tax on shipping separate from tax on the unit price you will want to add the setting SHIP_TAX_CALCULATION_METHOD and set this equal to SEPARATED.
Tax Calculation Method – By default OrderLogix will assume Order level tax calculation method. If the source vendor utilizes a method other than this you may see an exception where OrderLogix is calculating tax to be one penny different than the source.
For more on the different tax calculation methods and how they work see our article on this setting here
Tax Rounding Method – By default Orderlogix will use Round as the rounding method when calculating tax. If the source is using a method other than this you may see an exception where OrderLogix is calculating tax to be one cent or more different than the source vendor.
If you still have questions regarding the material covered in this article please contact OrderLogix Customer Care for assistance. Thank you!