Re: Inventory Turnover

[lucas Geheniau <geheniau@xxxxxxxxxxxxxxxxxx>]

Hi Nandu,

Let your query just get the data, no sorting etc,  and refine/calculate in 
excel e.g.  There will be no problems I think.

Lucas


At 15:30 17-04-03 -0700, you wrote:
> 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.

L. Geheniau                                     M.I.S. supervisor / 
Logistic Engineer
Tokheim Corp.
Industrieweg 5, 5531 AD Bladel                  The Netherlands
Fax: +31497381950
e-mail: geheniau@xxxxxxxxxxxxxxxxxx
        l.geheniau@xxxxxxxxx
sms: No phone!  0615026840