SOME THINGS TO CONSIDER THAT MAY IMPACT THE WAY WE CALCULATE TAX ON AN IMPORTED ORDER
There are several settings available with the API Order Import to allow for OrderLogix calculations upon import to match the source system’s calculations.
Discounts
Tax is only calculated on the price that is being collected from your customer. This means discounts need to be subtracted before tax is calculated.
((PRICE0# - DISCOUNT0#) * QUANTITY0#) = PAID_PRICE_PROD0#
PAID_PRICE_PROD0# * TAX_RATE0# = TAX_PROD0#
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 setup 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!