Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 15 Next »

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.

  1. Navigate to FlowAP > FlowAP Configuration > Staria FlowAP Template.

  2. View the default Staria FlowAP Template.

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

 Default
[
        {
            "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.

 Default
[
        {
            "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.

 Default
{
   "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

 Default - Vendor
{
        "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"]}
}
 Default - Vendor Contact
{
        "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

https://staria.atlassian.net/wiki/spaces/SIS/pages/1677361154/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 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.

Back to Top

  • No labels