Inventory Item Variance
Efficiently manage inventory variances with OMS-generated feeds synchronized to NetSuite using Apache NiFi integration.
This feed is used to record the Inventory variances. The Inventory Item Variance Feed of OMS will be used to prepare variance feed format required by NetSuite. These variances are logged due to reasons like if product is found damaged, missing etc. and so the variance will be logged in OMS so that its inventory count is refreshed. This variance needs to be communicated to external systems like NetSuite so that inventory is updated across all systems.
Implementation Flow
This feed flow uses below components in the integration layer
Moqui - This is used to generate the generic OMS JSON feed to include all the inventory variance item records. So here we will set the configurable parameters in the Service Job if required and it will be scheduled to run on a set frequency.
varianceReasonIds: VAR_STOLEN,VAR_DAMAGED,VAR_FOUND
Apache NiFi - This is used to generate the feed format required by NetSuite.
List and Fetch the File from the input folder.
Transforms the OMS Feed format into the NetSuite format using Jolt transform capabilities in-built in NiFi.
Generate the file name by appending the current time as per the timezone configured in OMS.
This helps in identifying the time at which feed is being kept for NetSuite.
Put the transformed feed file on SFTP.
Put the file in the folder for NetSuite.
Put the file in the folder for logging purpose in OMS.
NOTE this file resides in SFTP for a fixed configured duration like 30 days.
SFTP - This is used as the medium to put/read the feed files.
Nifi Flow
The below processors are used to prepare the NiFi flow:
ListSFTP
The ListSFTP processor is used to read the Moqui generated Inventory Item Variance Feed file from the SFTP location.
FetchSFTP
The FetchSFTP processor is used to move the Moqui generated Inventory Item Variance Feed file into the archive folder.
SplitRecord
The SplitRecord processor limits the number of orders to a given number in a single file. Eg. 20000 records per file
JoltTransformJSON
The JoltTransformJSON processor is used to transform the Moqui generated Inventory Item Variance Feed JSON into the required JSON format of external system NetSuite.
ConvertRecord
The ConvertRecord processor is used to convert the transformed Inventory Item Variance Feed JSON file into CSV format.
UpdateAttribute
The UpdateAttribute processor is used to update the file name of Inventory Item Variance Feed CSV file format.
PutSFTP
The PutSFTP processor is used to put the Inventory Item Variance Feed CSV file at the SFTP.
Note : Here, PutSFTP processor is also used to put the log Inventory Item Variance Feed file in the log folder.
NetSuite Inventory Item Variance Sample
NetSuite Feed File details
FTP locations
Path for NetSuite to consume the Inventory Item Variance Feed
Path for OMS for the log file This path represents the sftp location where the Inventory Item Variance Feed is kept for logging purpose.
Sample Feed File Name Format
Data Model Mapping
Last updated