This section describes the Inventory process for FloWorks. FloWorks acts as a mechanism to capture the transactions of parts in and out of inventories (Inventory Transfer forms), as well as capturing periodic inventory levels in the trucks (Quarterly Inventory Forms), which are then processed to NetSuite.
In NetSuite, mechanic truck inventories are treated in the same manner as any other warehouse. These warehouses and corresponding quantities, average cost, etc are calculated and maintained in NetSuite. FloWorks simply allows mechanics to fill out the appropriate forms in order to the track the movement of parts between warehouses, as well as periodically capturing current truck inventory levels. This requires FloWorks to perform a periodic sync of warehouses from NetSuite in order to allow the mechanics to have an up to date listing to choose from.
[ADD INFORMATION ABOUT CHECKBOX]
Sync Script & Schedule
Warehouse syncing is currently in development, more information will be added about this later.
Overview
Upon completion of a "Quarterly Inventory Form" by a field service mechanic, FloWorks will generate an Inventory Variance Report based on current NetSuite inventory levels for his warehouse (truck). Variance Reports calculate the difference between current NetSuite warehouse inventory levels and current warehouse inventory levels, as submitted by the mechanic, as well calculating the cost variance based on the average price of each inventoried part.
Getting Current NetSuite Inventory Levels
In order to calculate these differences, FloWorks must perform a periodic sync of current NetSuite inventory levels for each "Field Service Warehouse" (as outlined above), This syncing is based on the following NetSuite Saved Search:
[ADD NETSUITE SAVED SEARCH INFORMATION]
Sync Script & Schedule
Inventory syncing and variance report generation is currently in development, more information will be added about this later.
Variance Calculations
Qty Difference = (Submitted Inventory Qty - NetSuite Current Qty)
Note that the system will capture negative values if the mechanic reports less qty than NetSuite says he currently has.
Cost Variance = (Qty Difference * NetSuite Average Cost)