Definition
The inventory adjustment documents are created to record the identified stock discrepancies. These stock discrepancies can be results of the inventory count and discrepancies found during the fulfillment of regular warehouse operations.
Inventory count sheet data are used for the automatic filling of new inventory adjustment documents.
If discrepancies are found in the inventory during warehouse operations, inventory adjustment documents are created and filled in manually.
In the case of creating inventory adjustment documents for the group of companies (centralized warehouse management), the actual (and positive) inventory of the company is monitored.
In the case of inventory reclassification and inventory quality change, the data on the accepting goods are filled in with the data of the disposing goods.
The result of creating inventory adjustment documents is an update of available inventory data that reflects the physical available inventory.
Business process diagram
How to review stock discrepancies
Go to the Inventory count sheets list.
Click the Reports → Stock discrepancies report.
In the Unregistered surpluses and shortages of goods report.
Review the list of stock differences to be considered and processed.
How to adjust stock using wizard
Go to the Inventory adjustments list.
Click the Create → By using wizard command.
In the Inventory adjustment wizard workplace, go to the Setup page
Select the Warehouse.
Specify the Physical inventory register period and the Inventory adjustment date.
Click the Set filter to customize the selection.
Click the Next button.
On the Reclass stock or change quality page
Select line in the Stock shortage table and relevant line in the Stock surplus table.
Click the Process selected items button and specify the quantity to reclass.
Note
Click the Reclass all stock and the Process stock quality... button to automatically reclass all matched lines.
The system will automatically fill in the Stock reclasses and quality changes table with inventory to be offset.
Review the information filled in.
Note
The stock reclassification transaction is carried out only between goods that are characterized by a common UoM (unit of measure) because during the offsetting the amount of outgoing and incoming goods is the same.
You cannot make a stock reclassification transaction for items that have different VAT rates.
The stock quality change transaction is made only for goods that have different quality attributes.
Click the Next button.
On the Assign company stock for adjustment page
Select the Stock quality change in the Operation type to process data related to changes in quality and generate the Stock quality change (by custom price) and Stock quality change (by cost) documents.
OR Select the Stock reclass in the Operation type to process data related to item reclassification and generate the Stock reclass documents.
OR Select the Stock shortage in the Operation type to process data related to inventory shortages and generate the Stock shortage recognition documents.
OR Select the Stock surplus in the Operation type to process data related to inventory surplus and generate the Stock surplus recognition documents.
Review the information in the Stock discrepancies pending company stock assignment table.
Select the line and click the Company remaining goods report button.
In the Company stock balance report
Review the list of companies in columns having the selected item in available stock.
Return to the Assign company stock for adjustment page
Select the line and click the Assign company stock manually button.
Select the Company.
Note
Click the Assign company stock automatically button to assign company stock automatically to all lines.
Define the priority for the list of companies.
If the item is identified in several companies' stocks, the system will select the first specified in the priority sequence.
The system will automatically fill in the Stock discrepancies assigned to company stock table with inventory assigned to company stock.
Click the Next button.
The system will automatically create and fill in all necessary inventory adjustment documents.
On the Review generated inventory adjustment documents page
Review the list of created and posted (if there are no errors) inventory adjustment documents.
Open the document and fill in the required fields, if the document hadn't been posted.
Select documents, click the Print button and choose the necessary print-out forms.
Note
All necessary print-out forms shall be customized during the implementation project.
How to change goods quality
Go to the Inventory adjustments list.
Click the Create command and choose the Stock quality change (by custom price) or Stock quality change (by cost) business transaction.
Note
The Stock quality change (by custom price) business transaction allows you to define the custom price for the incoming stock, which is different from the price of the outgoing stock of initial quality.
The Stock quality change (by cost) business transaction accepts incoming stock of a new quality at the same price as the outgoing stock of initial quality.
In the Stock quality change (by custom price) document, go to the Main tab.
Fill in Company, Business unit, Warehouse, Price type, Expense item and Expense dimension fields.
Go to the Stock tab.
Add a new line and fill in all required fields- original Item, original Item variant, another quality Item, another quality Item variant, Quantity, etc.
Specify the Price field manually or click the Fill in prices → by cost/price type command - depending on the business transaction.
How to reclass inventory
Go to the Inventory adjustments list.
Click the Create command and choose the Stock reclass business transaction.
In the Stock reclass document, go to the Main tab.
Fill in Company, Business unit, Warehouse, Price type
Leave the Receive goods at writing off cost checkbox unselected, specify Expense item, Expense dimension, Income item, Income dimension fields - to record cost differences of the reclassified goods.
OR Select the Receive goods at writing off cost checkbox to avoid any differences in cost of the reclassified goods.
Go to the Stock tab.
Add a new line and fill in all required fields- original Item, original Item variant, another Item, another Item variant, Quantity, etc.
Specify the Price field manually or click the Fill in prices → by cost/price type command.
How to recognize inventory shortage
Go to the Inventory adjustments list.
Click the Create command and choose the Stock shortage recognition business transaction.
In the Stock shortage recognition document, go to the Main tab.
Fill in Company, Warehouse, Price type, Expense item and Expense dimension fields.
Go to the Stock tab.
Add a new line and fill in all required fields- Item, Item variant, Quantity, etc.
The Price will be defined within the cost calculation procedure.
How to recognize inventory surplus
Go to the Inventory adjustments list.
Click the Create command and choose the Stock surplus recognition business transaction.
In the Stock surplus recognition document, go to the Main tab.
Fill in Company, Business unit, Warehouse, Price type, Income item and Income dimension fields.
Go to the Stock tab.
Add a new line and fill in all required fields- Item, Item variant, Quantity, etc.
Specify the Price field manually or click the Fill in prices → by cost/price type command.