Overview
To record the identified stock discrepancies, inventory adjustment documents are created. These stock discrepancies can be results of the inventory count and discrepancies detected during regular warehouse operations.
The company can use inventory count sheets to automatically fill new inventory adjustment documents.
If inventory discrepancies are found during warehouse operations, the company creates and fills inventory adjustment documents manually.
When inventory adjustment documents are created for a group of companies (centralized warehouse management), the actual and positive inventory of the company is monitored.
When it comes to inventory reclassification and quality change, goods receiving data is filled with the goods disposal data.
Once inventory adjustment documents are created, available inventory data is updated. These data shows the available physical inventory.
Adjust stock flowchart
Paths
| Path | Warehouse and delivery → Surplus, shortage, stock quality change → Inventory count sheets |
|---|---|
| In-app link EN code |
e1cib/list/Document.InventoryRecount
|
| In-app link RU code |
e1cib/list/Документ.ПересчетТоваров
|
How to review stock discrepancies
1. Go to Warehouse and delivery and then click Inventory count sheets under Surplus, shortage, stock quality change.
2. Click the Reports → Stock discrepancies report.
3. In the Unregistered surpluses and shortages of goods report, review the list of stock differences to consider and process.
Paths
| Path | Warehouse and delivery → Surplus, shortage, stock quality change → Inventory adjustments |
|---|---|
| In-app link EN code |
e1cib/command/DataProcessor.WarehouseGoodsIssueReceipt.Command.WarehouseActs
|
| In-app link RU code |
e1cib/command/Обработка.ЖурналСкладскихАктов.Команда.ОткрытьФормуСпискаСкладскихАктов
|
How to adjust stock using a wizard
1. Go to Warehouse and delivery and then click Inventory adjustments under Surplus, shortage, stock quality change.
2. Click Create → By using wizard.
3. In the Inventory adjustment wizard workplace, on the Setup page, select the Warehouse.
4. Specify the Physical inventory register period and the Inventory adjustment date.
5. Click Set filter to customize the selection.
6. Click Next.
7. On the Reclass stock or change quality page, select a line in the Stock shortage table and a relevant line in the Stock surplus table.
8. Click Process selected items and specify the quantity to reclass.
Note
Click Reclass all stock and Process stock quality... to automatically reclass all matched lines.
The system will automatically fill the Stock reclasses and quality changes table with inventory to offset.
9. Review the filled information.
Note
You can reclass stock only for goods with a common unit of measure as during the offset the quantity of outbound and inbound goods is the same.
You cannot make a stock reclass transaction for items that have different VAT rates.
The stock quality change transaction is made only for the goods that have different quality attributes.
10. Click Next.
11. On the Assign company stock for adjustment page, do one of the following:
- Select the Stock quality change in the Operation type to process the data related to changes in quality and generate the Stock quality change (by custom price) and Stock quality change (by cost) documents.
- Select the Stock reclass in the Operation type to process the data related to item reclassification and generate the Stock reclass documents.
- Select the Stock shortage in the Operation type to process the data related to inventory shortages and generate the Stock shortage recognition documents.
- Select the Stock surplus in the Operation type to process the data related to inventory surplus and generate the Stock surplus recognition documents.
12. Review the information in the Stock discrepancies pending company stock assignment table.
13. Select the line and click Company remaining goods report.
14. In the Company stock balance report, review the list of companies in columns that have the selected item in available stock.
15. Go back to the Assign company stock for adjustment page.
16. Select the line and click Assign company stock manually.
17. Select the Company.
Note
Click Assign company stock automatically to assign company stock automatically to all lines.
Define the priority for the list of companies.
If the item is identified in several companies' stock, the system will select the first specified in the order of priority.
The system will automatically fill the Stock discrepancies assigned to company stock table with the inventory assigned to company stock.
18. Click Next.
The system will automatically create and fill all necessary inventory adjustment documents.
19. On the Review generated inventory adjustment documents page, review the list of created and posted inventory adjustment documents if there are no errors.
20. Open the document and fill the required fields if the document is not posted.
21. Select the documents, click Print and choose the necessary print forms.
Note
All necessary print forms shall be customized during the implementation project.
How to change goods quality
1. Go to Warehouse and delivery and then click Inventory adjustments under Surplus, shortage, stock quality change.
2. Click Create 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 a custom price for the inbound stock, which is different from the price of the outbound stock of the original quality.
The Stock quality change (by cost) business transaction accepts inbound stock of a new quality at the same price as the outbound stock of the original quality.
3. In the Stock quality change (by custom price) document, click the Main tab.
4. Fill the Company, Business unit, Warehouse, Price type, Expense item, and Expense dimension fields.
5. Click the Stock tab.
6. Add a new line and fill all required fields: original Item, original Item variant, other quality Item, other quality Item variant, Quantity, and other.
7. Specify the Price field manually or click Fill in prices → by cost/price type depending on the business transaction.
How to reclass inventory
1. Go to Warehouse and delivery and then click Inventory adjustments under Surplus, shortage, stock quality change.
2. Click Create and choose the Stock reclass business transaction.
3. In the Stock reclass document, click the Main tab.
4. Fill the Company, Business unit, Warehouse, and Price type.
5. Leave the Receive goods at adjustment cost check box cleared.
6. Do one of the following:
- Specify the Expense item, Expense dimension, Income item, and Income dimension fields to record cost differences of the reclassified goods.
- Select the Receive goods at adjustment cost check box to avoid any differences in the cost of the reclassified goods.
7. Click the Stock tab.
8. Add a new line and fill all required fields: original Item, original Item variant, other Item, other Item variant, Quantity, and other.
9. Specify the Price manually or click Fill in prices → by cost/price type.
How to recognize inventory shortage
1. Go to Warehouse and delivery and then click Inventory adjustments under Surplus, shortage, stock quality change.
2. Click Create and choose the Stock shortage recognition business transaction.
3. In the Stock shortage recognition document, click the Main tab.
4. Fill the Company, Warehouse, Price type, Expense item, and Expense dimension fields.
5. Click the Stock tab.
6. Add a new line and fill all required fields: Item, Item variant, Quantity, and other.
The Price will be defined within the cost calculation procedure.
How to recognize inventory surplus
1. Go to Warehouse and delivery and then click Inventory adjustments under Surplus, shortage, stock quality change.
2. Click Create and choose the Stock surplus recognition business transaction.
3. In the Stock surplus recognition document, click the Main tab.
4. Fill the Company, Business unit, Warehouse, Price type, Income item, and Income dimension fields.
5. Click the Stock tab.
6. Add a new line and fill all required fields: Item, Item variant, Quantity, and other.
7. Specify the Price field manually or click Fill in prices → by cost/price type.