Item tracking negative entry
ria
Member Posts: 43
Dear all,
I have item "A". This item use item tracking, where the item tracking card select on "lot warehouse tracking" field.
For item A, there are lot "A1" with quantity = 200 pcs, and lot "B1" = 500pcs.
I also have location "X" with bin mandatory selected. This location non WMS.
I create SO "101" use item "A" qty 250, in the item tracking line, choose lot "A1" and change "qty (base)" from 200 --> 250. Released. Not posting.
I create SO again "102" use item "A" qty 300.
1. If i look on the item tracking summary for lot "A1", total qty = 200pcs, total requested qty = 250, total available qty = -50
2. On the item tracking lines, i choose lot "A1" and "B1". With combination like this : lot "A1" = -50, lot "B1" = 350. On this item tracking i not change the qty (base), its automatic by system when i choose lot.
Posting this SO, its run smoothly.
The result after posting, inventory on warehouse entries and item ledger entries is different.
My question:
1. why SO can be posting, since one of the item tracking line have negative qty (because have requested for SO"101")?
2. what i must do, if i want same inventory within warehouse entries and item ledger entries?
Thx all...
I have item "A". This item use item tracking, where the item tracking card select on "lot warehouse tracking" field.
For item A, there are lot "A1" with quantity = 200 pcs, and lot "B1" = 500pcs.
I also have location "X" with bin mandatory selected. This location non WMS.
I create SO "101" use item "A" qty 250, in the item tracking line, choose lot "A1" and change "qty (base)" from 200 --> 250. Released. Not posting.
I create SO again "102" use item "A" qty 300.
1. If i look on the item tracking summary for lot "A1", total qty = 200pcs, total requested qty = 250, total available qty = -50
2. On the item tracking lines, i choose lot "A1" and "B1". With combination like this : lot "A1" = -50, lot "B1" = 350. On this item tracking i not change the qty (base), its automatic by system when i choose lot.
Posting this SO, its run smoothly.
The result after posting, inventory on warehouse entries and item ledger entries is different.
My question:
1. why SO can be posting, since one of the item tracking line have negative qty (because have requested for SO"101")?
2. what i must do, if i want same inventory within warehouse entries and item ledger entries?
Thx all...
Thanks & Regards
Ria
Ria
0
Comments
-
-
Which version?
NAV 4 SP 3
Can you help me kine?
Thx[/quote]Thanks & Regards
Ria0 -
Could you reproduce this on Cronus demo database? (to rule out possibly wrong customization in your DB)0
-
Ya, i have duplicate this case on standard cronus database, this case also happening on this DB.[/list]Thanks & Regards
Ria0 -
Dear All,
Please help me on this case. You can try to duplicate this case on standard DB Cronus, with Navision Version 4 SP 3.
Is it BUG?
Thx & Regards
RiawatiThanks & Regards
Ria0
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
