Hi guys,
I added field tiitm011.aitm into BOM report tibom141101000 and BaaN added the field into fields list. But I do not get any data on the customized report.
It should be easy but it isn't. What do I miss? (the data exists in tiitm011.aitm)
Thanks,
Batmush

I would say that tibom1411m000 does not pull any alternative items. I do not have source to validate this assumption. So just adding the field to the report may not be enough. What you can do is in the report script do a query for the component part number on table tiitm011. This will get you the alternate items. Of course if there is more than 1 alternate items that you need to print then you will need to use something like layout.again. Search this forum for layout.again to get more info on it.

Hi guys,
I added field tiitm011.aitm into BOM report tibom141101000 and BaaN added the field into fields list. But I do not get any data on the customized report.
It should be easy but it isn't. What do I miss? (the data exists in tiitm011.aitm)
Thanks,
Batmush

Hello,
in Reportscript you are able to read the need information from tiitm011 with :

detail.x: (or something)
before.layout:

select tiitm011.*
from tiitm011
where tiitm011._index1 = {:tiitm001.item}
selectdo
endselect

Maybe in session print bom there is no integration with table tiitm011, therefore the table was'nt read.

Regards

If you choose to read the alternative item data in the report script, you should remove tiitm011 fields from the input fields (these fields are meant for data coming from the program script only). By declaring the table tiitm011 in the report script you can then use the table fields in the layouts (and ignore the warnings that fields are not defined as input fields).

Youp

BDITTMAR & YOOP2001 - Thank you guys.