Versions Compared

Version Old Version 13 New Version 14
Changes made by

Lou Dizon

Lou Dizon

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

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" "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": "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:LineExtensionAmountDescription"]
            },
    
       "descriptiontax1amt": {
               "xpath" : ["./cac:ItemTaxTotal/cbc:DescriptionTaxAmount"]},
            },
            "tax1amt": {
               "itemname": {"xpath" : ["./cac:TaxTotalItem/cbc:TaxAmountName"]
            },
            "itemname"taxpercent": {"xpath"                "xpath" : [": ["./cac:Item/cac:ClassifiedTaxCategory/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"]
            Percent", "/cac:TaxTotal/cac:TaxSubtotal/cac:TaxCategory/cbc:Percent"]}}]},
            "payeefinancialaccount"firstmemo": {
               "xpath" : ["./cac:PayeeFinancialAccount/cbc:ID"]$item[0].firstmemo_value"]},
  "entitybankdetails" : {"listpath"        },
   : "/cac:PaymentMeans",
        "financialinstitutionidfields" :  [{
               "paymentduedate": {"xpath" : [ "./cac:PayeeFinancialAccount/cac:FinancialInstitutionBranch/cac:FinancialInstitution/cbc:IDPaymentDueDate"]},
            }
         }"paymentid": {"xpath" : ["./cbc:PaymentID"]},
      ]    },    "roundingpaymentchannelcode": {
      "xpath" : ["/cac:LegalMonetaryTotal./cbc:PayableRoundingAmountPaymentChannelCode"]},
   },    "payableamount": {       "payeefinancialaccount": {"xpath" : ["./cac:LegalMonetaryTotalPayeeFinancialAccount/cbc:PayableAmountID"]
   },
   "allowancecharge" : {       "listpathfinancialinstitutionid" : {"/cac:AllowanceChargexpath", :  [    "fields" : [
 "./cac:PayeeFinancialAccount/cac:FinancialInstitutionBranch/cac:FinancialInstitution/cbc:ID"]}
       {     }]},
       "chargeindicatorrounding": {"xpath" : ["/cac:LegalMonetaryTotal/cbc:PayableRoundingAmount"]},
             "payableamount": {"xpath" : ["./cac:LegalMonetaryTotal/cbc:ChargeIndicatorPayableAmount"]},
   "allowancecharge" : {"listpath"       },
  : "/cac:AllowanceCharge",
         "allowanceamountfields" : [{
               "chargeindicator": {"xpath" : ["./cbc:AmountChargeIndicator"]},
            }
  "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"]
        Name"]},
        "currency" : {
            "xpath" : ["//cbc:DocumentCurrencyCode"]
        },
        "vatregnumber" : {
            "xpath" : ["//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]
        },
        "terms" : {
            "xpath" : ["//cac:PaymentTerms/cbc:Note"]
        :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"]
        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"]
        :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"]
        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"]
        }
}

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.

...