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
- 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Bill of materials
Dennis_Decoene
Member Posts: 123
If you post a BOM Journal, Item Ledger Entries are created accordingly.
For the BOM, a positive adustment is created and for its components, negative adjustments.
I now want to generate a list of these entries. The question the list has to anwer is:"Which entries where created, when i posted a certain BOM Journal Line?"
The problem is that in that BOM Journal, there where more lines than just this one. If you look at the BOM Register and then the Item Ledger, you see all the entries the BOM Journal generated (which is logical of course <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" /> ).
To my knowledge, there is no link between the positive adjustment and the negative adjustments.
If there is a way to make the connection, please inform me...
Dennis Decoene
For the BOM, a positive adustment is created and for its components, negative adjustments.
I now want to generate a list of these entries. The question the list has to anwer is:"Which entries where created, when i posted a certain BOM Journal Line?"
The problem is that in that BOM Journal, there where more lines than just this one. If you look at the BOM Register and then the Item Ledger, you see all the entries the BOM Journal generated (which is logical of course <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" /> ).
To my knowledge, there is no link between the positive adjustment and the negative adjustments.
If there is a way to make the connection, please inform me...
Dennis Decoene
0
Comments
The following fields in table 32 will link the entries:
Source Type = CONST(Item)
Source No. = Item which is created
Posting Date and Document no. must match the contents of the positive adjustment entry.
André Arnaud de Calavon
DSA·VISION - Navision Solution Center
The Netherlands