Tax Handling in WooCommerce in the Integration Hub

Tax Handling in WooCommerce in the Integration Hub

Tax Handling

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


Tax Handling using Freight

In the WooCommerce 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 WooCommerce and SAP Business One is handled by saving the tax amounts in a default freight mapped in the General Settings of WooCommerce.


The tax amounts that are calculated in WooCommerce irrespective of tax components are integrated as a single component in SAP Business One i.e. the tax amounts per line item of WooCommerce are summarized and are mapped to a freight in line item of the sales order in SAP Business One.

Map a freight component in SAP Business One General Settings to all tax components in WooCommerce.
  Example
For example:  A Sales Order in WooCommerce with three items has three tax components per line.

WooCommerce 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 WooCommerce per line are summarized and updated in Freight 1 (LC) field in respective lines of SAP Business One Sales Order.

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

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

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

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


WooCommerce 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 WooCommerce 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 WooCommerce General Settings, if the value selected in the Tax Posting in SAP Business One using setting is Tax Code Determination, then whenever a WooCommerce 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 WooCommerce 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 WooCommerce 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. WooCommerce and SAP Business One should be same. otherwise, it may lead to document total inconsistency


Next step: Freight Handling in WooCommerce in the Integration Hub

    • Related Articles

    • WooCommerce integration with SAP Business One

      WooCommerce is an open-source e-commerce plugin for WordPress. It is designed for small to large-sized online merchants using WordPress. The integration between WooCommerce and SAP Business One facilitates automated, bi-directional data exchange ...

    • Orders with Cash on Delivery in WooCommerce 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 ...

    • Orders with Payment created in WooCommerce in the Integration Hub

      The Information related to orders created in WooCommerce is synchronized to SAP Business One. The payment for the order can be made 1. At time of booking the order 2. Cash On Delivery.  The Application handles these scenarios differently as per ...

    • Alerts Notification of WooCommerce in Integration hub

      Configure the alert settings in the Alert Notification tab in WooCommerce Settings window.  The Alert Notification tab of WooCommerce Settings window contains the following fields: Field Name Description User Displays the list of users in SAP ...

    • Customer Master Data - WooCommerce in the Integration Hub

      The customer master data integration is unidirectional i.e. from WooCommerce to SAP Business One. Customer Information like Name, E-mail, Billing and Shipping Address, and other details are integrated from WooCommerce to SAP Business One.  When the ...