...

Find the FlowAP Template field and click the hyperlink.

Understanding the Tax Code Lookup Table

The lookup criteria 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 (3) parameters.

  • Tax Rate - Enter the rate in percentage. This percentage will be compared to the tax rate found in the XML xpath - XML element which ("/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent").

  • Country type nsfield - This helps identify if the tax code is used for AP transactions that are:

    • Domestic

    • EU

    • Import

  • Item Type regexp - 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)

• Each

Default Tax Code Lookup Table

[
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",
"nsfield": "vatregnumber",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]",
"nsfield": "vatregnumber",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID",
"nsfield": "custentity_sta_flowap_endpointid"
},
{
"xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID[../../cbc:PaymentChannelCode/text()=\"IBAN\"]",
"nsfield": "custrecord_2663_parent_vendor.custrecord_2663_entity_iban"
},
{
"xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID[../../cbc:PaymentChannelCode/text()=\"BBAN\"]",
"nsfield": "custrecord_2663_parent_vendor.custrecord_2663_entity_bban"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyLegalEntity/cbc:RegistrationName",
"nsfield": "legalname"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name",
"nsfield": "entityid"
}
]

...