On the Inventory tab, you can create a list of items stocked at the warehouse or in a particular bin location and enter the actual quantities resulted from actual counting. Initially, you can automatically populate the list by using the Fill button on the toolbar. The following options are available:
- Fill by Balance at the Warehouse: To populate the list with the items stocked at the warehouse.
- Refill Accounting Data: To add to the list the items available at the warehouse according to the accounting data and populate the Quantity (Accounting) and Amount (Accounting) columns.
- Refill Accounting Data for the Selected Rows: To cancel the changes in the selected row and roll back to the accounting data.
- Refill by Price Type: To replace the prices for the listed items with the prices of the selected type.
The "Inventory Reconciliation (create)" form. The Inventory tab
To add an inventory item, click the Add or Pick button (refer to Using the pick operation). In the Item column, select an item from the Items list or create a new item. For more details, refer to Items. Alternatively, you can import the list of items with all the details from an Excel document. For this, click the button on the table toolbar and follow the step-by-step instructions in the appeared window.
The Characteristic column is available if the Enable Item Characteristics option is selected on the Administration > Settings > Purchasing and Warehouses form. In this column, you can specify additional properties (such as size, color, and so forth) of each listed item if the Use Characteristics option is selected for the item in its master record (refer to Items).
The Batch column is available, if the Enable Batches option is selected on the Purchasing and Warehouses form. In this column, you can specify the batch (lot) number for the items for which the Use Batches option is selected. Generally, you must specify batch numbers for items with expiration dates, items received from consignment or third-party contract warehouses.
The Serial Number (Accounting) column is available if the Serial Number Tracking option is selected on the Administration > Settings > Purchasing and Warehouses form. The column is populated with the serial numbers assigned to the items on their receiving. Serial numbers can be specified for items for which the Use Serial Numbers option is selected in their item master records (refer to Items). A serial number is required for each such item only if the Control Stock Balances by Serial Number option is selected on the Administration > Settings > Purchasing and Warehouses form.
The Quantity column is populated by the book quantity of the item or the quantity available at the warehouse depending on the selected option (Fill by Accounting Data or Fill by Balance at Warehouse). When entering the count data, enter the actual quantity at the warehouse location.
The UOM column shows the UOM used for the item in the warehouse. If the Multiple UOMs per Item option is selected on the Administration > Settings > Purchasing and Warehouses form.
The Deviation column shows the automatically calculated difference between the quantities in the Quantity (Accounting Data) and Quantity columns.
The Amount column shows the amount calculated for the item quantity currently available in the warehouse.
The Amount (Account) column shows the amount of the item according to the books.
The tab toolbar buttons
Use the Up and Down ( ) buttons to rearrange the items in the list.
If you are using a barcode scanner, click (the Load data from DCT) button to upload the data.