teddybear
11th December 2012, 07:32
I am trying to build a report that print multi-level BOM. I have no issue with printing the multi-level BOM as I am using session Print Bills of Material (Multi-level) (tobom1411m000).

Here is my issue. For every child item, I am pulling the standard cost. How can I calculate the percentage of the standard cost over total standard cost of all items ?

I am on BaanVc5. Thank you.

günther
11th December 2012, 09:49
Hi.

I'm on Baan IVc4, but I think the reporting basics haven't changed for LN.

Do you already know the total stanard cost of all items if you print the first line?
If yes, it's easy.
If no, it's a bit more difficult, but it can be done. Have a look at my thread http://www.baanboard.com/baanboard/showthread.php?t=9090. The basic idea would be: determine the costs, store these costs per item in an array and caculate the total costs -- before you print the first line. Then, in the detail line, retrieve the costs of the item from the array and calculate the percentage.

Regards,
Günther