Stock Take Maintenance
Menu Path: Inventory > Stock Take > Stock Take Maintenance
The act or process of inventorying merchandise or the supplies on hand. In other term stock-taking or inventory checking is the physical verification of the quantities and condition of items held in an inventory or warehouse. This may be done to provide an audit of existing stock valuation. It is also the source of stock discrepancy information.
Stock-taking may be performed as an intensive annual check or may be done continuously by means of a cycle count. The Stock Take will be done at CURRENT MA value
PREPARING THE FILE
Step 1: Open New Spreadsheet File
- It is recommended to use open office spreadsheet to prepare the file
Step 2: Fill Up Data
- Format:
| Column A | Column B | Column C | Column D |
|---|---|---|---|
| ITEM CODE | Quantity | Serialized (S) or Non Serialized (N) | EOR |
- Make sure to Put (S) or (N) on column C
Sample Spreadsheet File:
Step 3: Save File as comma separated values (.csv) format
- Change the Field Delimiter " | " and text Delimiter " blank "
STOCK TAKE PROCESS
Step 4: Upload File
Menu Path: Inventory > Stock Take > Stock Take Maintenance
- Add Stock Take Session ID → add Session ID, Branch and Transaction Date
- Process under Stock Take Listing → under Add Session ID part
- Upload File → after click Process Action
- Generate Stock Variance Report → after upload file
- Perform Stock Adjustment
- Key in the GL code → by default is "inventoryVariance"
- Tick the item → which need need to be adjusted
- Click Perform Stock Adjustment
- Generate Stock Availability to check new stock available after adjustment done
Related Wiki Pages:
Found 5 search result(s) for stock take.
Private & Confidential