FlowAP Subsidiary Setup

FlowAP Subsidiary Setup > FlowAP Template

Vendor Lookup Criteria

The vendor lookup criteria are used to determine which NetSuite vendor record needs to be assigned to the transaction that will be created through FlowAP e-document conversion.

Navigating to the setup

Navigate to FlowAP > FlowAP Configuration > Staria FlowAP Subsidiary Setup

View the record related to your subsidiary.

Navigate to the Conversion subtab.

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 ("/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

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

Auto-Create Vendor

Enabled Cross-Subsidiary Vendor

...