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
- 301 Dynamics CRM
- 109 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Determine Production Order Component purchased from which Vendor
Toddy_Boy
Member Posts: 231
Dynamics 2013 - Is there a way to determine which Vendor provided which component on a production order? Components are FIFO.
Life is for enjoying ... if you find yourself frowning you're doing something wrong
0
Best Answer
-
Toddy_Boy
Member Posts: 231
Not sure if anything exits out of the box but I can use SQL to join Item Ledger Entry consumption records to Item Application Entry records (IAP.[Outbound Item Entry No] = ILE.[Entry No]) and then join to Item Ledger Entry (IAP.[Inbound Item Entry No] = ILE2.[Entry No]) which will give the ILE purchase receipt detail finally joining to Purch. Rcpt Line. and Vendor.
Seems to work for me.
Life is for enjoying ... if you find yourself frowning you're doing something wrong0
Answers
Seems to work for me.