Tax Handling in Magento in the Integration Hub

Tax Handling in Magento in the Integration Hub

Tax Handling

The application handles the Tax integration either by posting the Magento Tax amount to the default freight mapped in the General Settings of Magento or by using the SAP Business One Tax Code Determination.


Tax Handling using Freight

In the Magento General Settings, if the value selected in the Tax Posting in SAP Business One using setting is Freight then the synchronization of the tax amounts between Magento and SAP Business One is handled by saving the tax amounts in a default freight mapped in the General Settings of Magento.

Map a freight component in SAP Business One General Settings to all tax components in Magento.


Example

For example:  A Sales Order in Magento with three items has three tax components per line.


Magento Tax Components                   SAP Business One Component

TX State Tax                                    ---- ----------- ------> Freigh1 (LC) 

Franklin County Tax                         ---- ----------- ------> Freigh1 (LC)

Mount Vernon Municipal Tax      ---- ----------- ------> Freigh1 (LC)


All the above taxes of Magento per line are summarized and updated in Freight 1 (LC) field in respective lines of SAP Business One Sales Order.

Magento Tax Components in Line 1 of Sales Order         SAP Business One Component in Line 1

28.87                            ---- ----------- ------>

2.31                         ------ ----------- ---->                             38.11

6.93                         ------ ----------- ---->         


Shopify Tax Components in Line 2 of Sales Order         SAP Business One Component in Line 2

72.17                             ---- ----------- ------>

5.77                                ---- ----------- ------>                                 92.56

17.32                              ---- ----------- ------>           


Default Tax code in SAP Business One

For all orders that are integrated from Magento to SAP Business One, a default exempt tax code is set defined in the General Settings.  The same tax code is used in the freight as well.


Tax Handling using Tax Code Determination 

In the Magento General Settings, if the value selected in the Tax Posting in SAP Business One using setting is Tax Code Determination, then whenever a Magento Order is integrated into SAP Business One, the Tax code is automatically set in SAP Business One based on the Tax code determination.

When any Order is downloaded from Magento to SAP Business One, the hub application posts the Items, quantity, discount and freight. The line level tax code and on header level freight is automatically applied by SAP Business One using Tax Code Determination, The Magento Order Tax amount will not be posted; the tax amount is automatically calculated in SAP Business One based on the applied tax Code.

Note
You must complete the Tax code determination in SAP Business One based on your requirement and ensure the tax code applied in a transaction by both application i.e. Magento and SAP Business One should be same. otherwise, it may lead to document total inconsistency


Next Step: Freight Handling in Magento in the Integration Hub