This is article use for mInventory iOS only.
Step-by-step guide
Preparation
- "Group" all items to location- NY.
- Using Item Reclassification Journals relocation the item to the stocktake location.
- Select desire batch to separate normal daily operation.
- Copy the 1 or more row(s) from the Item Reclassification Journals.
- Complete the transfer item record in Excel and paste back to system.
- When all the item posted the Item Reclassification Journals update the location.
-----------------------------------------------------------------------------------------------------------------------------------------------------
Create a Stock Take item list(s).
- Use the Phy. Inventory Journals (mInventory) function create each item list for specify handheld.
- In this test case, we select a T1 as Testing propose.
- Calculate the item Stock on Hand in handheld location. ***Please leave the item no. field is empty if plan count the full stock take.
- Send the item list to Handheld. (using Export to Handheld function)
Tips: Show Current Handheld Result - It will shows data as handheld uploaded data. It can use for check the data lost. - Refresh the list in handheld when export completed.
- You can use switch function menu to trigger handheld refresh the data. Or restart the app.
-----------------------------------------------------------------------------------------------------------------------------------------------------
Start stock take and import to system.
- Select the stock take list in handheld.
- Start scanning the item barcode to record the stock.
- When finish scanning, press SAVE button upload data to system. (you can use Save function upload the data to system avoid the data lost)
***It will overwrite previous data.***
-----------------------------------------------------------------------------------------------------------------------------------------------------
Merge the all the handheld(s) data to final stock take batch.
- Use Configuration Packages function export all handheld data to Excel.
- Select predefine the "package" - ST.
- Add a filter like stock take batch name - T1 in Table filter. It can be skip final or other batch data.
- Export once again and the filter change final stock take batch name.
- Merge the data which from the all the handheld to this final result Excel file.
-----------------------------------------------------------------------------------------------------------------------------------------------------
Import and update Excel final result to system.
- Select final result file and import to system.
- After import the file and use Apply Data function update tp system.
- Follow the step(s) pass this reminder.
- Wait for update process complete.
-----------------------------------------------------------------------------------------------------------------------------------------------------
Confirm data import and compare the physical count and system stock on hand.
- Check the final stock take batch.
- Press "Import Handheld Count" button let system generate item journal for adjustment.
- System will base on the physical count and system data to create Negative or Positive adjustment.
- If confirm the adjustment. Then, press "Post" and complete the stock take. (You can use Open in Excel function keep a copy of discrepancy)