I use Baan IVc3. I need to capture the number of Approvals / Rejects (after Inspection) for a given period range. So, I am planning to use the Inventory Transactions by Item (tdinv700) and the Receipts (tdpur045) tables to get this information.

I am wondering if there is any other way of doing this.

Ram.

This is how I do it,for a given period I total the number of deliveries and query the transactions based on inventory adjustment code and we have different codes for each products and type of reject i.e a1 =production scrap a2 supplier scrap a3 stock adjustment. from these two calculate the PPM scrap

Appreciate your feedback, Darren.

In our situation, we need to capture number of approvals based on Approval Date (and not on Receipt Date) and BaaN does not seem to be keeping Approval Date anywhere.

Ram.