Hi experts,
I want to customize the Boms (Id 801) report, As we know this report displays the BOM components of the selected Item having Bill of materials.
Suppose i want show Bill of materials of more than one item then it shows Items and their bill of materials one by one.
In my case there are some finished good item that shares their component with other finished good item.
So, i want to show the common item only once but it should show the Quantity Per for both.
For ex:
Suppose I have two finished good items FG1 and FG2, and both has bill of materials
FG1 comprise of say,
Componet Required Quantity Per
===============================
Component1
> 1
Component2
> 2
Component3
> 2
Component4
> 1
and, FG2 Comprise of
Component1
> 1
Component2
> 1
Component5
> 1
Component6
> 1
here Component1 and Component2 are common in both finished goods,
so the BOMs report should look like this,
Item Filter : FG1|FG2
Component Qty Required
================================
Component1
> 2
Component2
> 3
Component3
> 2
Component4
> 1
Component5
> 1
Component6
> 1
Can anybody guide me on this
0
Comments
FD Consulting
thanx for the reply, but how it is going to help me, can u plz guide me.
Take a look in Report 24. It uses TempTables exactly they way you need them.
FD Consulting
Yes, I have gone through the guide but i am not able to relate it with my problem, can u plz guide me.
I don't want to be offensive but this forum is not a helpdesk.
FD Consulting
ok, thanx for ur suggestion , actually i am a .net developer and new to navision. i have already gone for a technical training of C/SIDE but it was not helpful to me because in the training i was taught only the basic things, i am going through the PDFs.
I have seen people asking such questions in this forum, so i did and also i know its not a helpdesk.........
FD Consulting
TempBom-> A Temp table i have created for storing data temporarly
BomComp->Record->BOM Component When i am running the report, i am getting the error message that TempBom already contain entry no: 1, but if i am opening the table to see there is nothing,
can anybody guide me
Then in R801: Change the BOMComp DataItem to not print something but alternatively fill the temp table. Use T90 as the TempTable. Sum up the qty. Think about the Line No. I don't know which table you used as the temp table in your code example but it seems not to be T90 as T90 does not contain a field Entry No.
Search the forum for temporary tables and you will find lots of more advice how to do this. Start by understanding R24 (from your code I can see you have not understood how it works at all). To understand R24 only look at DataItem 1 + 2.
FD Consulting