A short 1-page PDF to walk through reconciling and adjusting inventory for the end of the year. If you have any questions or encounter any issues, please reach out to the SGI Support Team!
1. Prepare Physical Count
- From the Inventory module, click the Prepare Physical Count screen
- Select the Type ID if preparing by type rather than the default of Full Count
- Select the desired Warehouse
- Click Generate PI
- Note: This will lock out/freeze Inventory transactions while being worked on & create the Physical Inventory Review
2. Complete Physical Inventory Review
- Update Acu Date (top right of screen) based on Business process/when Inventory should be locked for count
- All Items will pull into review automatically based on
- Select Finish Counting from More Menu – This changes status from Counting in Progress to Data Entering to allow you to edit the Physical Quantity field
- Enter Physical Qty (what was physically counted at warehouse, etc.)
- Enter every line/number that was counted
- If an Inventory Item wasn’t counted/entered, either select Set Not Entered to Zero (Qty = 0) or Set Not Entered to Skipped (Lines will be skipped) on More Menu after entering Qty values
- Variance Quantity will automatically display the adjustment value (based on what’s entered in Physical Qty field)
- Click Complete PI from More Actions menu
3. Complete Review to Generate Adjustment
- The Adjustments form will automatically create and link to the Physical Inventory Review document under the Adjustment Info tab
- The Adjustment will create in the Balanced status
- Review, make any desired changes to cost or other data, and Release
