Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Next »

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

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

  2. Purchase Tax Code set in the Non-US Nexuses tab of the Tax Schedule associated to item.

    1. Item standard NetSuite form > Accounting subtab > Tax Schedule

  3. Tax Code will be searched using the Tax Code lookup Table set in the FlowAP Subsidiary Setup for the subsidiary.

  4. If none, the system will use the Default Tax Code in the Set Up Taxes page provided it is available for purchases.

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 - Inventory, Assembly

      • Service - Non-Inventory, Service, Other

    • 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"
    }
]

  • No labels