Re: Vendor History

[MacWheel99@xxxxxxx]

jjpfantz@lozier.com writes:
 
>  We are on V6.0.04 Client/Server on a HP900, Oracle environment.
We are 405 CD mixed mode AS/400 but many files similar contents

>  We closed our fiscal year in December 1999 and ran the PUR900/PUR910 jobs 
to
>  close the month and year.  However, a new project has come up that requires
>  the YTD Purchases for 1999 by supplier (of course they didn't think of this
>  in December).
I also have a new project ... total up what we got from a supplier by which 
customers the materials were used on, because different customers have 
different price contracts.

>  Is there any way to get this information other than restoring the AVM table
>  from the back-up prior to running the year-end close job?

It depends on how long you keep your inventory history on-line ....ours is 
366 days so that as of our End Month Processing of Dec 1999, we would have 
had 100% purchases for 1999 on-line, but in the EOM Jan 2000, some of the Jan 
1999 history would go away.  

Check SYS800 to see how long you keep your inventory ITH on-line - if yours, 
like ours is 1 year & if you have not yet run EOM January - ask the powers 
that be if the retention can be extended until you get this done.
Check INV355 to see which purchasing transaction codes are relevant.
Check your codes in IIM to see practicalities of summarizing data ... such as 
the Primary Vendor field - IVEND I think.

Then if you are in luck, run a Query or SQL list to summarize purchases in 
1999 by vendor from a union of selected ITH data & IIM fields.

I bet that the next thing they will want, beyond YTD Quantity purchased by 
vendor-item combination for 1999, is the $ value of that.  If you match item 
total with CMF cost master file, you will get the current pricing, and risk 
of performance hassle due to file sizes ... our ITH is over 1 million records 
& our CMF is 1/2 million & people who run on-line queries over both at same 
time bring our AS/400 to its knees.

There are fields associated with $ cost pricing at time of transaction but 
not all are populated in our BPCS version - something else for you to check.

Hope this helps.

Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer etc.
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---