The user needs to know the hierarchy used by FlowAP conversion in selecting tax codes in creating Vendor Bill Lines.

Tax Code Hierarchy for Bill Items

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.
1. 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.

Warning! If NetSuite’s Default Tax Code set in the Nexus is used, the tax rate of the default tax code will supercede the XML’s tax rate during bill creation.

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.
- 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").
- 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 - 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)

Default Tax Code Lookup Table

[
    {
        "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"
    }
]

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 is found. The maximum lookup criteria is 7 elements.
The search will start from the first element in the array and will stop once a vendor 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.

Hierarchy Used by FlowAP Conversion When Selecting Tax Codes on Vendor Bill Lines