Differences between how Nopcommerce calculates taxes and charges customers and how RTP calculates taxes can lead to .01 cent discrepancies when open orders are opened inside of the RTP POS leading to additional reconciliation overhead for onsite staff when online orders are not auto-fulfilled.
Aspenware has introduced an optional MatchTaxCalculation setting to ensure alleviate these onsite fulfillment issues for orders that are not auto-fulfilled, ensuring that when there is a tax discrepancy between Nopcommerce (what the customer paid in tax) and what RTP recalculates as the tax amount, the order placed into RTP via Unity always matches RTP’s method of tax allocation. This setting does not make Nopcommerce tax and RTP tax calculation match, so while it can alleviate issues with onsite order discrepancies, accounting and other groups will need to be alerted to the fact that NOP and RTP will be out of balance slightly if this new setting is set to true.
...
When the MatchTaxCalculation setting is set to 'TRUE,' tax calculations in Unity will align with RTP calculations. RTP uses bankers rounding in most cases (see “Add a Penny Logic” exceptions below). This ensures a $0 balance when comparing orders in Unity and tax calculations in RTP.Please
| Note |
|---|
...
| Note |
|---|
IMPORTANT: DO NOT set MatchTaxCalculation to TRUE if:
|
Explanation of "Add a Penny" Logic
Add a penny logic is used when there are is more than one component on a product header that both have tax.
RTP and Unity calculate tax in two ways and comparescompare: "sum then round" and "round then sum," both using bankers rounding rules.
“Sum then round” is calculated by determining the sum of the individual live item taxes and then rounding the resulting total.
“Round then sum” is calculated by rounding the taxes at each individual line item, and then adding these rounded amounts for a total.
To determine whether to "add a penny," both methods are compared when deciding the tax for an RTP Order line item. If the "sum then round" value is greater than the "round then sum" value, a penny is added to one of the line item's taxes based on the tax apply “tax apply” order. Apply order is an RTP configuration assigned to dictate the priority of items for accounting if in the same order.
...