Staria FlowAP Template
- Lou Dizon
- Krizia Ilaga (Unlicensed)
- Kiro Franco (Unlicensed)
On this page, you can setup how XML elements are mapped to NetSuite fields.
Note: Create a file cabinet folder for saving the PDF files.
Warning: Do not edit and save any of the following default templates that are included in the FlowAP SuiteApp.
Default FlowAP Template
Default FlowAP Template - Tax ID Lookup Only
Legacy FlowAP Template
If customizing the mapping for a specific use case, create a copy of the template and save it with a new name.
Navigate to FlowAP > FlowAP Configuration > Staria FlowAP Template.
View the default Staria FlowAP Template.
Hover over actions and click Make Copy.
Field name | Description |
Primary Information | |
Name | Enter a name for your FlowAP Template. |
Lookup Criteria | |
Vendor Lookup Criteria | This field should contain an array of JSON objects that would be used as criteria for searching the Vendor for the FlowAP Document. You can enter a maximum of 15 criteria and a minimum of 1. [
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",
"nsfield": "vatregnumber",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",
"nsfield": "custentity_sta_einv_businessid",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"ISO6523\"]",
"nsfield": "vatregnumber",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"ISO6523\"]",
"nsfield": "custentity_sta_einv_businessid",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID",
"nsfield": "vatregnumber",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID",
"nsfield": "custentity_sta_einv_businessid",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"legacy": true,
"xpath": "//cac:OrderReference/cbc:CustomerReference",
"nsfield": "custentity_sta_flowap_endpointid",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"xpath": "//cac:OrderReference/cbc:CustomerReference",
"nsfield": "custentity_sta_flowap_endpointid",
"regexp": "[^0-9]",
"operator": "contains"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID",
"nsfield": "custentity_sta_flowap_endpointid",
"operator": "contains"
},
{
"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:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID",
"nsfield": "custrecord_2663_parent_vendor.custrecord_2663_customer_code"
},
{
"xpath": "//cac:PaymentMeans/cac:PayeeFinancialAccount/cbc:ID",
"nsfield": "accountnumber"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyLegalEntity/cbc:RegistrationName",
"nsfield": "legalname"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name",
"nsfield": "entityid"
}
]An audit trail record will be created in the event that vendor lookup is unable to find a match or if there are multiple vendor’s found, |
Item Lookup Criteria | This field should contain an array of JSON objects that would be used as criteria for searching the Item for the FlowAP Document. You can enter a maximum of 5 criteria and a minimum of 1. [
{
"mappingfield": "vendorcode",
"nsfield": "vendorcode"
},
{
"mappingfield": "vendorcode",
"nsfield": "vendorname"
},
{
"mappingfield": "vendorcode",
"nsfield": "itemid"
}
] |
Mapping Templates | |
Transaction Mapping | Enter the mapping for the Transaction Header and Lines in a well-formed JSON object. {
"custentity_edoc_ws_id": {"xpath" : ["/cac:OrderReference/cbc:CustomerReference"]},
"vendorname": {"xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PartyName"]},
"vendorvat": {"xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]},
"subsidiaryendpointid": {"xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:PartyName"]},
"subsidiaryvat": {"xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]},
"billcountry": {"xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cac:Country/cbc:IdentificationCode"]},
"poreferencenumber" : {"xpath" : ["/cac:OrderReference/cbc:SalesOrderID"]},
"referencenumber" : {"xpath" : ["/cbc:ID"]},
"trandate": {"xpath" : ["/cbc:IssueDate"]},
"duedate": {"xpath" : ["/cac:PaymentMeans/cbc:PaymentDueDate"]},
"custbody_sta_appr_xmlmemo": {"xpath" : ["/cbc:Note"]},
"custbody_sta_nord_trandate": {"xpath" : ["/cbc:IssueDate"]},
"custbody_sta_origpostingdate": {"xpath" : ["/cbc:IssueDate"]},
"custbody_2663_reference_num": {"xpath" : ["/cac:PaymentMeans/cbc:PaymentID"]},
"currency": {"xpath" : ["/cbc:DocumentCurrencyCode"]},
"createdfrom": {"xpath" : ["/cac:OrderReference/cbc:SalesOrderID"]},
"taxpercent_total" : {"xpath" : ["/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent"]},
"taxamount_total" : {"xpath" : ["/cac:TaxTotal/cbc:TaxAmount"]},
"taxexclusiveamount": {"xpath" : ["/cac:LegalMonetaryTotal/cbc:TaxExclusiveAmount"]},
"custbody_sta_eflow_ourref": {"xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:Name"]},
"custbody_sta_eflow_yourref": {"xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:Contact/cbc:ElectronicMail"]},
"item" : {"listpath" : "/cac:InvoiceLine","fields" : [{
"firstmemo_value": {"xpath" : ["./cac:Item/cbc:Name"]},
"vendorcode": {"xpath" : ["./cac:Item/cac:SellersItemIdentification/cbc:ID"]},
"quantity": {"xpath" : ["./cbc:InvoicedQuantity"],"defaultvalue": 1},
"rate": {"xpath" : ["./cac:Price/cbc:PriceAmount"]},
"amount": {"xpath" : ["./cbc:LineExtensionAmount"]},
"description": {"xpath" : ["./cac:Item/cbc:Description"]},
"tax1amt": {"xpath" : ["./cac:TaxTotal/cbc:TaxAmount"]},
"itemname": {"xpath" : ["./cac:Item/cbc:Name"]},
"taxpercent": {"xpath" : ["./cac:Item/cac:ClassifiedTaxCategory/cbc:Percent", "/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent"]}}]},
"firstmemo": {"xpath" : ["$item[0].firstmemo_value"]},
"entitybankdetails" : {"listpath" : "/cac:PaymentMeans",
"fields" : [{
"paymentduedate": {"xpath" : ["./cbc:PaymentDueDate"]},
"paymentid": {"xpath" : ["./cbc:PaymentID"]},
"paymentchannelcode": {"xpath" : ["./cbc:PaymentChannelCode"]},
"payeefinancialaccount": {"xpath" : ["./cac:PayeeFinancialAccount/cbc:ID"]},
"financialinstitutionid": {"xpath" : [ "./cac:PayeeFinancialAccount/cac:FinancialInstitutionBranch/cac:FinancialInstitution/cbc:ID"]}
}]},
"rounding": {"xpath" : ["/cac:LegalMonetaryTotal/cbc:PayableRoundingAmount"]},
"payableamount": {"xpath" : ["/cac:LegalMonetaryTotal/cbc:PayableAmount"]},
"allowancecharge" : {"listpath" : "/cac:AllowanceCharge",
"fields" : [{
"chargeindicator": {"xpath" : ["./cbc:ChargeIndicator"]},
"allowanceamount": {"xpath" : ["./cbc:Amount"]}
}]}
} |
Vendor Mapping | Enter the mapping for the Vendor in a well-formed JSON object |
Detailed Guide
FlowAP's XML Mapping Template: A Detailed Guide
Limitations
The FlowAP conversion only supports UBL 2.1 Invoice XML schema. The UBL 2.1 (Universal Business Language) standard provides a set of predefined codes for the
InvoiceTypeCodeelement, which specifies the type of invoice being issued. The following are supportedInvoiceTypeCodevalues:380 - Commercial invoice: The most common type of invoice used for general business transactions.
381 - Credit note: Used to correct or cancel a previously issued invoice.
Mapping for Date fields in the Transaction Mapping is limited to the ff fields:
trandate,duedate,custbody_sta_nord_trandate,custbody_sta_origpostingdate. All other date fields are unsupported at this time.