tzwetan
18th January 2006, 13:04
Hello all,

in Baan4c there is t_stmr column in ttiitm001, reffering to the overall nettable stock (used by MRP). Does anybody know if something similar exists in Baan5?

Or what is the easiest way to calculate it, I must nest it in some queries...

Thanks in advance

jcorwine
19th January 2006, 16:03
take a look at session tcibd1500s100 Item Inventory (table is tcibd100)
this summarizes item inventory information across the company.

You will probably have to calculate what you want from fields in this table.
It might be that (OnHand - Allocated) is what you are looking for.

naabi0
19th January 2006, 18:06
The field is cprpd100.stoc.

tzwetan
20th January 2006, 10:32
Thank you naabi0, that's exactly what I need...