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.
View and Edit the FlowAP Template.
Find the Vendor Lookup Criteria.
You must not edit the Default FlowAP Template.
Any changes made to the default template will be overriden during new version releases of FlowAP.
To use a customized version of the FlowAP template, save a copy of the Default FlowAP Template.
Apply your own lookup criteria and XML mapping to the new FlowAP Template; and assign it to the relevant Staria FlowAP Subsidiary Setup.
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.
xpath - XML element which ("/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent").
nsfield - This helps identify if the tax code is used for AP transactions that are:
Domestic
EU
Import
regexp - Enter the nature of the item (Goods, Service). The nature of the item is based on NetSuite item types.
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"
}
]