The user item lookup criteria are used to determine which NetSuite item record needs to know the hierarchy used by FlowAP conversion in selecting tax codes in creating Vendor Bill Lines.

JSON array

param 1 comes from the transaction mapping

use the same element name

param 2 is the NS fieldbe used for each transaction lines that will be created through FlowAP e-document conversion.

Navigating to the setup

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.

Find the Item Lookup Criteria.

Understanding the Item Lookup Criteria

The lookup criteria follows the JSON array syntax.

• The complete item code lookup table is surrounded by brackets

  • Example: [JSON ARRAY].

• Each element in the lookup table is surrounded by curly braces and is separated by a comma.

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

• Each element of the lookup table contains four (2) parameters.

  • mappingfield - This is a string used in the FlowAP Template > Mapping Templates > Transaction Mapping. This string identifies the XML element will be the source of the item’s name/number/text that will be used to find the item in NetSuite.

    • e.g.: “vendorcode”

      Image Added

  • nsfield - This is the NetSuite item record field that will be used to compare the text from the mappingfield to find the item record in NetSuite.

Default Item Lookup Criteria

[
{
"mappingfield": "vendorcode",
"nsfield": "vendorcode"
},
{
"mappingfield": "vendorcode",
"nsfield": "vendorname"
}
]

To delete

references: https://staria.atlassian.net/wiki/spaces/SIS/pages/1073152086/List+of+INFlow+Integration+and+Conversion+Features#Perform-Item-Lookup-and-Set-Items