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

    • Related Articles

    • Magento integration with SAP Business One

      The Magento is an eCommerce platform that provides online merchants with a flexible shopping cart system, as well as control over the look, content, and functionality of their online store. Magento offers powerful marketing, search engine ...

    • Setup in SAP Business One for Magento in the Integration Hub

      In the SAP Business One Main Menu, choose Administration → Integration Hub → Application Deployment Status. The Deployment Status field should display 'Active', indicating that the feature is deployed in the Integration Hub. If the status displays ...

    • Orders with Cash on Delivery in Magento in the Integration Hub

      For Cash on Delivery orders in SAP Business One a Sales Order, Corresponding A/R Reserve Invoice is posted. Later, when the customer makes the cash payment, an incoming payment is to be posted manually with reference to the A/R Reserve Invoice.   The ...

    • Freight Handling in Magento in the Integration Hub

      The shipping amounts that are calculated in Magento irrespective of shipping components are synchronized as a single freight component in SAP Business One. The shipping amounts of Magento are mapped to a single freight component in the header level ...

    • General Settings of Magento in the Integration Hub

      On the Main Menu go to Administration → Integration Hub → Magento Settings to configure the required Magento settings. Configure the general settings in the General Settings tab in Magento Settings window.     The General Settings tab of Magento ...