Versions Compared

Version Old Version 5 New Version 6
Changes made by

Lou Dizon

Lou Dizon

Saved on

Key

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

...

Name

Description

XML Folder ID

Enter ID of a folder where the incoming XML files should be placed.

JSON Folder ID

Enter ID of a folder where the parsed JSON Data of incoming XML files should be placed.

PDF Folder ID

Enter ID of a folder where the incoming PDF files should be placed.

Exclude Vendor Credits From Bulk Conversion

Check to exclude vendor credits from processing.

Subsidiary Lookup Criteria

This field should contain an array of JSON objects that would be used as criteria for searching the Subsidiary for the FlowAP Document. The maximum number of criteria that can be entered is 5.

Expand
titleDefault

[
{
"xpath": "//cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",
"nsfield": "taxidnum",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]",
"nsfield": "taxidnum",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",
"nsfield": "custrecord_sta_flowap_endpointid",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]",
"nsfield": "custrecord_sta_flowap_endpointid",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingCustomerParty/cac:Party/cac:Contact/cbc:ElectronicMail",
"nsfield": "email"
}
]

Info

Subsidiary Lookup Criteria Syntax

  • Each criteria is separated by a comma

  • The maximum lookup criteria is 5.

  • The minimum lookup criteria is 1.

  • Each lookup criteria must have:

    • xpath - This is the complete source element from the XML. If the element has a parent, all parent elements must be included in the path definition.

    • nsfield - the field ID of the subsidiary field where the string found in the XML element will be compared to.

  • Optional parameter of the lookup criteria

    • regexp - enter a regular expression to clean up unwanted text in both the XML element string and the NetSuite field value being compared.

Example: