Do physical inventory using bins/advanced warehousing

Stine
Member Posts: 1
Hi,
We have a customer using bins and various 'advanced' warehouse setups - This customers wishes to do cyclic/periodic count where the last physical inventory count date and period dictates when the item should be counted.
Problem is that in basic warehouse setup, the Phys. Inventory Ledger Entry (on which the last count date and period updates are based on), is created when posting the Item journal/Phys. inventory Journal - This works perfectly - if you however has a advanced warehouse setup using bins, we should use the Whse Journal Line/Whse. Phys. Invt. Journal, count and post. Then Go to the Item Journal, calculate whse adjustment and post.. At no point is the Phys. Inventory entries created in the 'advanced' setup which means count dates isnt updated on the skus/items (Flowfield from Phys. Inventory Entry)..
The description on docs seems off, at least flawed somehow - or am I missing something?
https://docs.microsoft.com/en-us/dynamics-nav-app/inventory-how-count-adjust-reclassify
I could program my way out of this, creating entries posing the Whse. Journal but surely I am missing something?
Best Regards, Stine
We have a customer using bins and various 'advanced' warehouse setups - This customers wishes to do cyclic/periodic count where the last physical inventory count date and period dictates when the item should be counted.
Problem is that in basic warehouse setup, the Phys. Inventory Ledger Entry (on which the last count date and period updates are based on), is created when posting the Item journal/Phys. inventory Journal - This works perfectly - if you however has a advanced warehouse setup using bins, we should use the Whse Journal Line/Whse. Phys. Invt. Journal, count and post. Then Go to the Item Journal, calculate whse adjustment and post.. At no point is the Phys. Inventory entries created in the 'advanced' setup which means count dates isnt updated on the skus/items (Flowfield from Phys. Inventory Entry)..
The description on docs seems off, at least flawed somehow - or am I missing something?
https://docs.microsoft.com/en-us/dynamics-nav-app/inventory-how-count-adjust-reclassify
I could program my way out of this, creating entries posing the Whse. Journal but surely I am missing something?
Best Regards, Stine
0
Answers
-
For Advance Warehouse you need to use - Warehouse Physical Inventory JournalThanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions