Re: Inventory Turnover

Hello Group,
I need some suggestions for creating inventory turnover reports. I suppose I'll have to query the IM Transaction History File for this and you all know that this file grows in size exponentially. My guess is this file already contains 200,000 records. Here are my questions:

(1) If I were to write a query that is going to pick all 'SA' transactions with order type 'CO' and multiply the quantity by the average unit cost for each line item to get the total cost of goods sold (this can then be used in another query to determine inventory turns), how big a load will this be on the AS400? I'm asking this question as I was asked to be careful while querying the IMHIST file.

(2) Is the above approach a general practice for creating inventory turnover reports? Could you suggest other ways to run an inventory turnover report.

Your suggestions will be appreciated.

Regards,
Nandu

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

www.viva-lancia.com
Best Regards,
                Lucas

A good player makes himself look good;
a great player makes the team look good.