Re: Purchase Requisitions and EXCEL

["Baldwin, Wayne (ALIE)" <Wayne.Baldwin@xxxxxxxxxxxxxxxxxxxx>]

Jack,

I hope this clarifies our requirement:

The business need is as follows: 
To replace a custom green screen quoting system which lets the buyers enter a 
requisition number and it will fill in all the part,qty and description from 
the requisition onto the quote. This quote can contain many many req's and it 
can be faxed via the AS400 to multiple vendors. All the buyer has to do is key 
in the vendor number(s). 

We can't use the PM version of a quote . It has no due date and only supports 1 
item per quote!
They could cut and paste from a view in Requisitions (PM) to Excel but this is 
sloppy as it copies "everything" from the view including headers,titles etc. 

The ideal situation would be to click on a req and press a user action tool to 
invoke a macro which copies the Req required fields for that req to an Excel 
sheet. They could keep adding reqs as needed and then pull in Vendor 
information the same way to the top of the Excel sheet. Then we can fax it out 
via our Unifier Fax software.

                        Thanks in advance,
                            Wayne



                
        





******************************************
The information contained in, or attached to, this e-mail, may contain 
confidential information and is intended solely for the use of the individual 
or entity to whom they are addressed and may be subject to legal privilege.  If 
you have received this e-mail in error you should notify the sender immediately 
by reply e-mail, delete the message from your system and notify your system 
manager.  Please do not copy it for any purpose, or disclose its contents to 
any other person.  The views or opinions presented in this e-mail are solely 
those of the author and do not necessarily represent those of the company.  The 
recipient should check this e-mail and any attachments for the presence of 
viruses.  The company accepts no liability for any damage caused, directly or 
indirectly, by any virus transmitted in this email.
******************************************