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
-
Dennis,
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.Regards,
André Arnaud de Calavon
DSA·VISION - Navision Solution Center
The Netherlands0
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