Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
ILE and Warehouse Entry mismatch
Toddy_Boy
Member Posts: 231
Running Nav 2013
It seems something has gone wrong during the shipping of a quantity of 156 of an item. The Quantity posted to the ILE is reads Shipped -6 however the warehouse entries are correct at -156. The Value entries are also written as -6.
Any ideas how I can correct the ILE and Value entries to -156 without resorting to SQL?
It seems something has gone wrong during the shipping of a quantity of 156 of an item. The Quantity posted to the ILE is reads Shipped -6 however the warehouse entries are correct at -156. The Value entries are also written as -6.
Any ideas how I can correct the ILE and Value entries to -156 without resorting to SQL?
Life is for enjoying ... if you find yourself frowning you're doing something wrong
0
Best Answer
-
Toddy_Boy
Member Posts: 231
With a little help this is doable by posting Item Journal for a sales and updating Sales Shipt Entry No. It's a bit of a fudge but seems to work.
It is a bug in Navision. When you have a sales order for an two lines where line 1 is an assembly order and line 2 is for a manufactured item (where the manufactured item also appears in the assembly on line 1) then Navision doesn't post the shipment item ledger entries for the manufactured item (line 2).Life is for enjoying ... if you find yourself frowning you're doing something wrong5
Answers
It is a bug in Navision. When you have a sales order for an two lines where line 1 is an assembly order and line 2 is for a manufactured item (where the manufactured item also appears in the assembly on line 1) then Navision doesn't post the shipment item ledger entries for the manufactured item (line 2).