RE: Vendor History

["Lacelle, Marc" <LACELLE@xxxxxxxxx>]

Hi Ho.

        We got 5 inches of snow today, another 5 inches on it way. Were is
that ground hog

        I'm a AS/400 person but databases are databases.

The AVM is irrelevant in this case. Run your report(SQL, IQ, ASSET) based on
HPH (PO Header) and HPO (PO Detail). Your report may be based on when the PO
was opened or when goods were received. RE: PO opened in 1998 but goods
received in 1999 or PO opened in 1999 but goods received in 2000. Either
case the HPH and HPO have vendor number in them. Have your HPH as Primary
file, HPO joined to HPH by PO number, and AVM joined to HPH by Vendor
Number.

        Is that what you are looking for.

        Marc Lacelle
        Royal Canadian Mint



 

> ----------
> From:         jjpfantz@lozier.com[SMTP:jjpfantz@lozier.com]
> Reply To:     BPCS-L@midrange.com
> Sent:         Wednesday, February 09, 2000 2:25 PM
> To:   BPCS-L@midrange.com
> Cc:   dslic@aol.com
> Subject:      Vendor History
> 
> We are on V6.0.04 Client/Server on a HP900, Oracle environment.
> 
> 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).
> 
> 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?
> +---
> | 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
> +---
> 
+---
| 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
+---