| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
The user needs to know the hierarchy used by FlowAP conversion in selecting to select tax codes in when creating Vendor Bill Lines.
...
Tax Code that is specified on the Subsidiaries tab of the Vendor record. This will only be used if the tax rate is not equal to 0. [The subsidiary sublist is only available on NetSuite Oneworld accounts. FlowAP only supports Oneworld accounts]
Purchase Tax Code set in the Non-US Nexuses tab of the Tax Schedule associated with the item.
Item standard NetSuite form > Accounting subtab > Tax Schedule
Tax Code will be searched using the Tax Code lookup Table set in the FlowAP Subsidiary Setup for the subsidiary.
If none, the system will use the Default Tax Code in the Set Up Taxes page provided it is available for purchases. The default tax code will be based on the transaction’s subsidiary country.
| Note |
|---|
Warning! If NetSuite’s Default Tax Code set in the Nexus is used, the tax rate of the default tax code will supercede supersede the XML’s tax rate during bill creation. FlowAP Conversion does not search for tax codes that are not configured in this hierarchy. A tax code will not be used for the creation of the transaction if it is not found in this hierarchy. |
...
The complete tax code lookup table is surrounded by brackets.
Example: [JSON ARRAY].
Each element in the lookup table is surrounded by curly braces and is separated by a comma.
Example: [{ELEMENT1}, {ELEMENT2}, {ELEMENT3}]
Each element of the lookup table contains four (4) parameters: two (2) mandatory parameters and two (2) optional parameters.
Tax Rate - Enter the rate in percentage. This percentage will be compared to the tax rate found in the XML ("/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent").
Tax Code - Enter the internal ID of the tax code that will be assigned if all three (3) parameters are met (tax rate, country type, item type)
Optionally, you may add the following parameters to differentiate the different taxation scenarios further:
Country type - This helps identify if the tax code is used for AP transactions that are:
Domestic
EU
Import
Item Type - Enter the nature of the item (Goods, Service). The nature of the item is based on NetSuite item types.
Goods - Used for Inventory, Assembly Item sublist lines
Service - Used for Non-Inventory, Service, Other Item sublist lines
NA - Used for expense sublist lines
Note: If either Country Type or Item Type is not included as parameters, the specific tax code applies to all country types or item types.
Tax Code Lookup Table Example
| Code Block | ||
|---|---|---|
| ||
[
{
"taxrate": "0.00%",
"countrytype": "Domestic",
"itemtype": "Goods",
"taxcode": "1126"
},
{
"taxrate": "0.00%",
"countrytype": "EU",
"itemtype": "Service",
"taxcode": "1129"
},
{
"taxrate": "0.00%",
"countrytype": "EU",
"itemtype": "Goods",
"taxcode": "1130"
},
{
"taxrate": "0.00%",
"countrytype": "Import",
"itemtype": "Service",
"taxcode": "1127"
},
{
"taxrate": "0.00%",
"countrytype": "Import",
"itemtype": "Goods",
"taxcode": "1127"
},
{
"taxrate": "0.00%",
"taxcode": "1126"
},
] |
Lookup Results
Invalid Tax Codes are not returned by the lookup
Inactive = T
trandate is not within Effective From and Valid Until.
Available on “Sales Transactions”
FlowAP Document Subsidiary does not belong to Tax Code Subsidiaries
When no tax code is found from the hierarchy: “STA_EMPTY” is set on the taxcode element of the FlowAP document JSON data.
The lookup will perform the search for each tax code table element until a taxcode tax code is found. The maximum lookup criteria is 7 elements.
The search will start from the array's first element in the array and will stop once a tax code is found.
The internal id When a tax rate is found, the internal ID of the tax code will be set on the taxcode element of the FlowAP document JSON when a tax rate is found.
Tax code lookup is not used if Inherit PO lines = T. When the inherit PO lines feature is used during conversion, the tax codes defined in the PO are used.