Versions Compared

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"
        }
]

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

...