Versions Compared

Version Old Version 7 New Version 8
Changes made by

Lou Dizon

Lou Dizon

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse

...

Find the Vendor Lookup Criteria.

Note

You must not edit the Default FlowAP Template.

Any changes made to the default template will be overriden during new version releases of FlowAP.

To use a customized version of the FlowAP template, save a copy of the Default FlowAP Template.

Apply your own lookup criteria and XML mapping to the new FlowAP Template; and assign it to the relevant Staria FlowAP Subsidiary Setup.

...

Code Block
breakoutModewide
languagejson
[
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]",
"nsfield": "vatregnumber",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"GLN\"]",
"nsfield": "vatregnumber",
"regexp": "[^a-zA-Z0-9]"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cbc:EndpointID",
"nsfield": "custentity_sta_flowap_endpointid"
},
{
"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:AccountingSupplierParty/cac:Party/cac:PartyLegalEntity/cbc:RegistrationName",
"nsfield": "legalname"
},
{
"xpath": "//cac:AccountingSupplierParty/cac:Party/cac:PartyName/cbc:Name",
"nsfield": "entityid"
}
]

Auto-Create Vendor

This feature lets FlowAP create a new vendor in the system if one is not found during the conversion’s vendor lookup.

Navigating to the setup

...

Enable Auto Created Vendor

Navigate to FlowAP > FlowAP Configuration > Staria FlowAP Subsidiary Setup

View the record related to your subsidiary.

Navigate to the Conversion subtab > Vendor Field Group.

Find the Auto Created Vendor checkbox.

Vendor Mapping Template

Navigate to FlowAP > FlowAP Configuration > Staria FlowAP Subsidiary Setup

View the record related to your subsidiary.

Navigate to the Conversion subtab.

Find the FlowAP Template field and click the hyperlink.

View and Edit the FlowAP Template.

Navigate to the Mapping Templates field group.

Find the vendor mapping field.

Info

Syntax:

  • Each element in the vendor mapping is surrounded by curly braces and is separated by a comma. Each element represents one field being mapped from the XML to a NetSuite field.

    • Example: [{ELEMENT1}, {ELEMENT2}, {ELEMENT3}]

  • Each element of the mapping JSON array contains two (2) parameters.

    • [NetSuite Field ID] - This is the vendor field in NetSuite..

    • xpath - This is location of the XML element that contains the data to be saved in the target NetSuite field.

Default Vendor Mapping Template

Code Block
breakoutModewide
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"
]
}
}
VENDOR CONTACT MAPPING
{
"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"
]
}
}

Enabled Cross-Subsidiary Vendor

...