Versions Compared

Version Old Version 10 New Version Current
Changes made by

Lou Dizon

Krizia Ilaga

Saved on

Key

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

...

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

            "regexp": "[^0-9]"

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


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

},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID",
"nsfield": "custentity_sta_flowap_endpointid"
},
{
"xpath": 
,
            "operator": "contains"
        },
        {
            "xpath": "//cac:
PaymentMeans
AccountingSupplierParty/cac:
PayeeFinancialAccount
Party/cac:PartyIdentification/cbc:ID[
../../cbc:PaymentChannelCode/text()
@schemeID=\"
IBAN
ISO6523\"]",


            "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": 
 "vatregnumber",
            "regexp": "[^0-9]",
            "operator": "contains"
        },
        {
            "xpath": "//cac:AccountingSupplierParty/cac:Party/cac:
PartyName
PartyIdentification/cbc:
Name",
"nsfield": "entityid"
},
{
"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" : ["/cac:OrderReference/cbc:CustomerReference"]
},
"vendorname": {
"xpath": ["
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:
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" : ["//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"]
}
}
VENDOR CONTACT MAPPING
{
"entityid" : {
"xpath" : ["//cac:AccountingSupplierParty
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.

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:Contact/cbc:Name"]},
   "custbody_sta_eflow_yourref": {"xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:Contact/cbc:
Name
ElectronicMail"]

},

"phone" : {
"xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:Contact/cbc:Telephone"]
},
"email" : {
"xpath" : ["//cac:AccountingSupplierParty/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

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