Physical Inventory and Lot Numbers
bob_up
Member Posts: 155
Our client has V4.00 SP2. They use lot numbered items.
They generate a physical inventory journal by location. There are 2 lot numbers for one item at location X. The counted quantities differ on the lot numbers and on the item overall, as follows
So the overall journal line is a positive adjustment but one of the lot numbers needs to be adjusted down (negatively). You cant enter a negative quantity in the item tracking lines. How is the client supposed to enter this into the journal ?
In fact I will be dataporting the counted quantities in from a spreadsheet, but the principle is the same.
They generate a physical inventory journal by location. There are 2 lot numbers for one item at location X. The counted quantities differ on the lot numbers and on the item overall, as follows
Lot Calc. Phys. Difference ABC 10 100 90 DEF 30 20 -10 Overall 40 120 80
So the overall journal line is a positive adjustment but one of the lot numbers needs to be adjusted down (negatively). You cant enter a negative quantity in the item tracking lines. How is the client supposed to enter this into the journal ?
In fact I will be dataporting the counted quantities in from a spreadsheet, but the principle is the same.
0
Answers
-
You need to create two separate item journal lines for each lot and sign.
So all positive difference will be in one item journal lines and all negative in another journal line for a given item.0 -
Thank you Rashed.
I also found some detailed help here http://dynamicsuser.net/forums/p/5424/26750.aspx#267500
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
