Overview
When running a business and dealing with inventories, it is usually unavoidable to have the possibility of a mismatch of the stocks on records versus the physical items. For that specific reason, System Five provides functionalities and reports that will ease the customers’ work by providing the information and generating the reports needed. One of which, in regard to Inventory integrity is the Inventory Integrity Check. This report allows customer to ensure that the quantities displayed on the inventory record match the actual stock records in the system.
- The newer versions in V7 now comes with some changes on the interface and location of this Inventory Integrity. User can still locate it in the Navigator under Reports > Inventory Reports > Stock Integrity. The same report is still available under General Ledger > Integrity Checks.
- This tool will analyze the inventory transaction log and compare it to the current stock on hand. If there are differences, the item will be shown on the report. The purpose of the report is to synchronize the in-Stock values with the Calculated. Once both values are synchronized, it is recommended to do a Stock Count for those items. It is important to have a backup copy of your data before doing a Stock Integrity Check.
- Additionally, the Tool Box routine Validate Stock Quantities now opens the Stock integrity windows, which function is now moved to the Tool Box > Inventory Routines > Stock Control Routines.
Solution:
The newer versions in V7 now comes with some changes on the interface and location of this Inventory Integrity. User can still locate it in the Navigator under Reports > Inventory Reports > Stock Integrity. The same report is still available under General Ledger > Integrity Checks.
This tool will analyze the inventory transaction log and compare it to the current stock on hand. If there are differences, the item will be shown on the report. The purpose of the report is to synchronize the in Stock values with the Calculated. Once both values are synchronized, it is recommended to do a Stock Count for those items.
The user needs to Check Integrity based on the preferred setting. First report will display the Parts and Description of the stock issue, which the system will fix. Run the check again. It should generate an empty report. There will be a View – In Stock vs Calculated button at the bottom of the report.
Adjusting to In-Stock. The user has the option to fix each inventory item one at a time by clicking the selected value under the In-Stock column – which will make adjustment to the history log or press the values under Calculated column which will make a stock adjustment.
Adjust all Parts. If you want to adjust all Parts to adjust to either In-Stock or Calculated values, you can press the “-> In Stock” or “-> Calculated” buttons at the top of each columns which will make the adjustment to all the lines that have unadjusted values.
Assumptions:
It is important to have a backup copy of your data before doing a Stock Integrity Check. Additionally, the Tool Box routine Validate Stock Quantities now opens the Stock integrity windows, which function is now moved to the Tool Box > Inventory Routines > Stock Control Routines.
After making these adjustments we recommend doing a Physical count of these item. You can print the report by right-clicking and selecting Print, or export to excel.
Removing Oversold in the Tool Box routine. Run this report periodically to look for ongoing issues. You should always run the stock integrity checks before making manual adjustments.
Visuals
To use this function, navigate to Setup Tools > Utilities > Tool Box > Inventory Routines > Stock Control Routines > Validate Stock Quantities.
Inventory Stock Integrity Report was moved in Tool box under Validate Stock Quantities.
The Inventory Stock Integrity Report. You can still access it under General Ledger > Integrity Checks and Reports > Inventory Reports > Stock Integrity.
Click the Check Integrity in the Tool bar to generate the report.
Check Integrity again and it should return an empty report .View – In Stock vs Calculated is now visible at the bottom of the screen.
The value can be adjusted by clicking the selected value under In Stock or Calculated or pressing the “-> In Stock” or “-> Calculated” to adjust all the values under the column.
This will then add one to stock to make the available zero as the item has an oversold quantity. You may want to run the toolbox Clear Oversold to fix this problem before doing the stock count.
This will make a manual adjustment to remove one, the entry added to the history log, but does not make any adjustment to the log.
Removing Oversold in the Tool Box routine. Run this report periodically to look for ongoing issues. You should always run the stock integrity checks before making manual adjustments.
Tools > Utilities > Tool Box > Inventory Routines > Fixing Routines > Remove Oversold Quantities.
