How to Fetch all Finished Goods into Report

Finance and Operations/AX Developer Forum
1

From my Prod Orders Form…based on Item Number…i want to fetch all the Items and its child items and Boms related to that Item.

GM-9119-0810 this is an Item

GM-9119-0810-01

GM-9119-0810-02 etc… are some of the child Items related to the Parent (GM-9119-0810) and BOMs related to each Item.

2

Do you want to get the details from the BOM version(BOM table) or from the sub production orders and related ProdBOM?

3

I want to get from Sub Production Orders and Related ProdBOM

4

From prodBOM related to the main production order, you can find the related production order.
Have a look \Data Dictionary\Tables\ProdBOM\Methods\updateSubProduction (for the relation)

5

Hi Kranthi,

I dont find the method UpdateSubProduction in ProdBom Table.Can u pls check it once

6

AX 2009 might not have that method.
ProdBOM.InventRefId will have the reference to sub production order. You can use that relation to get the sub production orders related the main production order.