Dynamics NAV - Stock Count
- Before beginning
- Identify all blocked items and remove blocks before counting if required
- Post all transfers, shipments, invoices, journals and anything that will impact inventory
- Run the adjust costs job
- Print an inventory valuation report
- Ensure that the Unit Cost on all Items is correct (This is what all positive adjustments will be costed at)
- Set all Unit Costs to the Last direct cost * Exchange Rate if necessary
- It is also possible to enter the Cost manually on the Inventory Journal itself
- Regular Location
- Departments
> Warehouse > Good Handling Multiple Orders > Periodic Activities > Phys. Inventory Journals
- Create Batch if one does not exist
- Home>Process>Calculate Inventory
- Include Items not on inventory
- Include items with no transactions
- Enter Document number
- Enter Filters for location
- Where Blocked is No
- Click Ok
- This will populate the journal with all items that can be found in that location
- Enter quantity counted in the Qty.(Phys. Inventory) column
- If any items are not populated, manually enter them
- Click Post to post adjustments
- Store Location using LS NAV - Stock Counting Worksheet
- Create anew counting worksheet
- Departments/LS Retail/InStore Management/Setup/Inventory Management/Inventory Mask Setup
- Type:Counting
- Pull up worksheet on device with scanner
- Departments/LS Retail/InStore Management/Worksheets
- Scan Item barcode to pull up item on worksheet
- Enter count under Qty. (Phys. Inventory) column
- Click Accept
- Compress transactions if you want it to summarize similar lines, otherwise say no
- Click Post to post changes as Item Ledger Entries and update GL
- Warehouse Location
- Departments > Warehouse > Good Handling Multiple Orders > Periodic Activities > Whse. Phys. Inv. Journals
- Create Batch if one does not exist
- Home>Functions>Calculate Inventory
- Include Items not on inventory
- Enter Document number
- Enter Filters for location: WH
- Enter filter for BIN if required
- Click Ok
- This will populate the journal with all items that can be found in that location
- Enter quantity counted in the Qty.(Phys. Inventory) column
- If any items are not populated, manually enter them, but enter the quantity in the Quantity column instead of the Qty.(Phys. Inventory) column
- OR the Whse. Item Journal screen can be used instead after passing adjustment to set all stock to zero first.
- Transactions should all start from the ADJUSTMENT zone
- Click Register to finalize adjustments (This has not updated inventory or GL as yet)
- Create Item Journal
- DEPARTMENTS
> WAREHOUSE > INVENTORY > TASKS > Item Journals
- Select Template and journal
- Home>Process>Calculate Whse. Adjustment
- Click Post (This updates the GL and Inventory)
- Warehouse Location with Tasklet Offline Count
- Departments > Warehouse > Good Handling Multiple Orders > Periodic Activities > Whse. Phys. Inv. Journals
- Create Batch if one does not exist
- Home>Functions>Calculate Inventory
- Enter Document number
- Enter Filters for location: WH
- Enter filter for BIN if required
- Click Ok
- This will populate the journal with all items that can be found in that location
- Enter quantity counted Using the Tasklet Handhelds
- Navigate back to Departments > Warehouse > Good Handling Multiple Orders > Periodic Activities > Whse. Phys. Inv. Journals
- Pull up the batch and journal you calculated originally
- Click Actions>"Import Offline Count"
- Enter Handheld Number (1-4)
- This will import the Tasklet Count into the calculated list
- It will automatically insert new lines if necessary
- Make any changes necessary
- Click Register to finalize adjustments (This has not updated inventory or GL as yet)
- Create Item Journal
- DEPARTMENTS > WAREHOUSE > INVENTORY > TASKS > Item Journals
- Select Template and journal
- Home>Process>Calculate Whse. Adjustment
- Click Post (This updates the GL and Inventory)
No comments:
Post a Comment