Dear Gurus,
“First to mention that I am new to NAV Report Design & Programming”
I have Scenario wherein I am Calculating a Cost of an Item in a report.
I have Exploded the BOM for the Parent Item, which in turn have Components & Assembiles.
Just to mention the in Production BOM we have Item code & Production BOM No. , Routing No. the same
i.e. Item Code 111.0000 will have Production BOM as 111.0000 and Routing 111.0000;
I also have Calculated the Routing cost of a sub-Assembly based on the Routing & Its version whichever is active & applicable.
Now the Problem is:
I have a Sub-assmbly for a Parent ; which in turn may have sub-Assly and definately a Routing associated.
I have calculated the Routing Costs for the First Level Assly but am Unable to find the loopled Sub-Assly costs.
I have This Report
Parent Item 111.0000
Routing Time
Component1 0
Sub-Assly1 2
Please note that Sub-Assly1 have following details in BOM
Parent Item Sub-Assly1
Qty
Component 1 1
Sub-Assly2 1
I want to have the Consolidated routing for the First Sub-Assembly and subsequent Sub-Assembly unless there exists no Sub-Assembly for the BOM
How to archive this?
Please guide… Please help me with the crux code in order to move ahead.
Thanking you in advance for the Support,
Regards,
Nitin