Inventory Import
Overview
Gravity offers a comprehensive multi-location inventory management system, incorporating optional bin locations. The file architecture is organized as follows:
- Inventory Master: This contains a single record for every item.
- Inventory Location: Each item/location combination is represented by a dedicated record, which summarizes information such as the quantity on hand for each item/location pairing.
- Inventory Site: This serves as a reference point for every site utilized as an inventory location.
- Inventory Bin: (Optional) This delineates the bins available at each location.
- Bin Quantity: (Optional) This field is used to monitor the quantity on hand for each item/location/bin combination.
- Serial/Lot In Stock: This denotes the serial or lot numbers and associated quantities (if applicable) for each item/location combination, specifically for inventory in the Inventory Master that is classified as serial or lot controlled.
- Country of Origin: (Optional) This maintains a record for each country involved in the procurement of inventory. The Country of Origin feature is solely available with serial or lot tracking.
- Inventory Transactions: This retains one record for each item/location transaction impacting inventory. By utilizing the Apply Date on the records, inventory can be processed with appropriate aging dates.
Note: When importing inventory items, the following tables and fields must be synchronized:
- Inventory Location
- Quantity on Hand: This must reflect the total quantity of all items in the selected unit of measure for the item/location combinations.
- Bin Quantity: The aggregate of the Quantity on Hand values for all Item/Location records must correspond with the Item Location Quantity on Hand.
- Serial/Lot In Stock: The total of the Remaining Quantity values for all Item/Location records must align with the Item Location Quantity on Hand.
- Inventory Transactions: The sum of the Inventory Quantity values for all Item/Location records must match the Item Location Quantity on Hand.