Hierarchy Used by FlowAP Conversion When Selecting Tax Codes on Vendor Bill Lines
- Lou Dizon
- Kiro Franco (Unlicensed)
The user needs to know the hierarchy used by FlowAP conversion to select tax codes when creating Vendor Bill Lines.
Tax Code Hierarchy for Bill Items
Tax Code that is specified on the Subsidiaries tab of the Vendor record. [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.
Warning!
If NetSuite’s Default Tax Code set in the Nexus is used, the tax rate of the default tax code will 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.
Tax Code Hierarchy 1,2 and 3 need to be configured to ensure that the XML tax rate will be equal to the tax rate of the created transaction.
For example, the invoice line in the XML tax rate is 20%. There must be a valid NetSuite tax code record for 20% tax rate configured in either one of the vendor-subsidiary sublist, item:tax schedule or the FlowAP subsidiary setup tax code table.
Tax Code Hierarchy 4 will use the NetSuite Default Tax Code regardless of what the tax rate in the XML is.
For example, the invoice line in the XML tax rate is 20%. There is no tax code configured for the 20% tax rate. The Default tax code is UNDEF-XX with tax rate = 0%.
The created transaction line’s tax rate will be 0%.
FlowAP Tax Code Lookup Table
Navigating to the setup
Navigate to FlowAP > FlowAP Configuration > Staria FlowAP Subsidiary Setup
Edit the record related to your subsidiary.
Navigate to the Conversion subtab > Default Tax Codes field group > Tax Code Table
Understanding the Tax Code Lookup Table
The lookup table follows the JSON array syntax.
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
Tax Code Lookup Table Example
[
{
"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 search each tax code table element until a tax code is found. The maximum lookup criteria is 7 elements.
The search will start from the array's first element and stop once a tax code is found.
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.
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.