Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

On this page, you can setup how XML elements are mapped to NetSuite fields.

warning
Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#B3D4FF

Note: Create a file cabinet folder for saving the PDF files.

Panel
panelIconIdatlassian-cross_mark
panelIcon:cross_mark:
bgColor#FFBDAD

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.

...

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 8 15 criteria and a minimum of 1.

Expand
titleDefault
Code Block
languagejson
[
{

        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",


            "nsfield": "vatregnumber",


            "regexp": "[
^a-zA-Z0
^0-9]"

},
{
,
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"
GLN
VAT\"]",

"nsfield

            "nsfield":
"vatregnumber",
 "custentity_sta_einv_businessid",
            "regexp": "[
^a
^0-
zA-Z0-
9]"

},
{
"xpath":
,
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/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":
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:
PartyName
PartyIdentification/cbc:
Name
ID",


            "nsfield": "
entityid
vatregnumber"

},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name",
"nsfield": "entityid"
}
]

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.

Expand
titleDefault

[
{
"mappingfield": "vendorcode",
"nsfield": "vendorcode"
},
{
"mappingfield": "vendorcode",
"nsfield": "vendorname"
}
]

Mapping Templates

Transaction Mapping

Enter the mapping for the Transaction Header and Lines in a well-formed JSON object.

Expand
titleDefault
{
"custentity_edoc_ws_id": {
"xpath" : ["
,
            "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"
]
},
"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"]
},
"taxexclusiveamount": {
"xpath" : ["/cac:LegalMonetaryTotal/cbc:TaxExclusiveAmount"]
},
"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

Expand
titleDefault
{
"companyname" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name"]
},
"currency" : {
"xpath" : ["//cbc:DocumentCurrencyCode"]
},
"vatregnumber" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]
},
"terms" : {
"xpath" : ["//cac:PaymentTerms/cbc:Note"]
},
"taxidnum" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]"]
},
"custentity_sta_einv_businessid" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]"]
},
"custentity_sta_flowap_endpointid" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID"]
},
"country" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cac:Country/cbc:IdentificationCode"]
},
"addr1" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:StreetName"]
},
"addr2" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:AdditionalStreetName"]
},
"city" : {
"xpath" : ["/
,
            "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.

Expand
titleDefault
Code Block
languagejson
[
        {
            "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.

Expand
titleDefault
Code Block
languagejson
{
   "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:
PostalAddress
Contact/cbc:
CityName
Name"]

},

"zip

   "custbody_sta_eflow_yourref": {

"xpath": ["
/
/cac:
AccountingSupplierParty
AccountingCustomerParty/cac:Party/cac:
PostalAddress
Contact/cbc:
PostalZone
ElectronicMail"]

},

"custentity_sta_einv_networkid" : {
"xpath" : ["//cac:OrderReference/cbc:CustomerReference"]
}
}
VENDOR CONTACT MAPPING
{
"entityid" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/

   "item" : {"listpath" : "/cac:InvoiceLine","fields" : [{
      "firstmemo_value": {"xpath" : ["./cac:Item/cbc:Name"]

},

"phone

      "vendorcode": {

"xpath" : ["
/
./cac:
AccountingSupplierParty
Item/cac:
Party
SellersItemIdentification/
cac:Contact/
cbc:
Telephone
ID"]

},

"email

      "quantity": {

"xpath" : ["
//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:ElectronicMail"]
}
}
./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

Expand
titleDefault - Vendor
Code Block
languagejson
{
        "companyname" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name"]},
        "currency" : {"xpath" : ["//cbc:DocumentCurrencyCode"]},
        "vatregnumber" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]},
        "terms" : {"xpath" : ["//cac:PaymentTerms/cbc:Note"]},
        "taxidnum" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]"]},
        "custentity_sta_einv_businessid" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]"]},
        "custentity_sta_flowap_endpointid" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID"]},
        "country" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cac:Country/cbc:IdentificationCode"]},
        "addr1" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:StreetName"]},
        "addr2" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:AdditionalStreetName"]},
        "city" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:CityName"]},
        "zip" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PostalAddress/cbc:PostalZone"]},
        "custentity_sta_einv_networkid" : {"xpath" : ["//cac:OrderReference/cbc:CustomerReference"]}
}
Expand
titleDefault - Vendor Contact
Code Block
languagejson
{
        "entityid" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:Name"]},
        "phone" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:Telephone"]},
        "email" : {"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:ElectronicMail"]}
}

Detailed Guide

FlowAP's XML Mapping Template: A Detailed Guide

Limitations

Warning
  • 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 InvoiceTypeCode element, which specifies the type of invoice being issued. The following are supported InvoiceTypeCode values:

    1. 380 - Commercial invoice: The most common type of invoice used for general business transactions.

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

Back to Top