Item qty received wrong

yuppicide
Member Posts: 410
Nav 3.10.. not sure if someone can help this, because some of the you might not have part of my features, but I'll ask anyway.
We have an item in Navision.. it was entered on an Purchases & Payables -> Orders. Somehow the Variant must have got deleted. So, on the Item Card it shows 318 in stock, but if you open up that color it shows -1 pieces.
So, what I think happened is we Received an Order with no Variant and posted it.
Our system has size codes also.. S, M, L, XL.
Need to fix it.. I think the answer is to do an Item Journal Negative -318 pieces with no Variant, even though there will be no S, M, L, and XL.. then do a Positive with 53 S, 106 M, 106 L, and 53 XL.
Any thoughts?
We have an item in Navision.. it was entered on an Purchases & Payables -> Orders. Somehow the Variant must have got deleted. So, on the Item Card it shows 318 in stock, but if you open up that color it shows -1 pieces.
So, what I think happened is we Received an Order with no Variant and posted it.
Our system has size codes also.. S, M, L, XL.
Need to fix it.. I think the answer is to do an Item Journal Negative -318 pieces with no Variant, even though there will be no S, M, L, and XL.. then do a Positive with 53 S, 106 M, 106 L, and 53 XL.
Any thoughts?
0
Comments
-
Hi,
did you have a look at your open ILEs for this item? If you're right then there should be an open entry without a variant code. To fix it you could post an item journal with the "no size" quantity as neg. Adjmt., apply against the open entry, and your qantities by size as positive adjustment.
with best regards
Jens0 -
Hi,
did you have a look at your open ILEs for this item? If you're right then there should be an open entry without a variant code. To fix it you could post an item journal with the "no size" quantity as neg. Adjmt., apply against the open entry, and your qantities by size as positive adjustment.
with best regards
Jens0
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