Menu Path: Inventory > Stock Take > Stock Take as Closing Inventory (Multi Location)
| Panel |
|---|
The Instead to add the "branch code" for each ID, the Stock Take as Closing Inventory (Multi Location) screen allows the user to upload the Stock Take file for multiple location/branch in the SAME CSV file for a certain Transaction Date. After all the Stock Count of the Items for a Branch/Location has been verified. An adjustment of all the Stock for all items can be done by clicking on the “Perform Stock Adjustment” button. By default the checkbox to “Generate Journals Due to Adjustment Out of Historical Stock and Adjustment In of Actual Stock” is unchecked. |
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
| Column A | Column B | Column C | Column D | Column E | Column A |
|---|---|---|---|---|---|
| TEST-SERIAL-ZAM | 1 | 120. |
...
...
| 00 | S | A Co.-B1 | |||
| GADGET1 | 4 | 1200.00 | N | A Co.-B1 |
- Column A = Item Code
- Column B = Quantity
- Column C = Value
- Column D = Make sure to Put (N) for non serialized or (S) for serialized item
- Column E = Branch Code
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 as Closing Inventory (Multi Locations)
- Add Stock Take Session ID → add Session ID, Branch and Transaction Date
- "Process" under Stock Take Listing → under Add Session ID part
- Generate Stock Variance Report
Perform Stock Adjustment
- Key in the GL code → by default is "inventoryVariance"
- Tick the item → which need need to be adjusted
- Tick to generate journal → if any
- Click Perform Stock Adjustment
- Generate Stock Availability to check new stock available after adjustment done
- Generate Stock Movement Report to check the movement after adjusted
- Generate Stock Adjustment Listing to check the list of stock adjustment performed after the stock take process