RE: Purchase Requisitions and EXCEL

[LeLeux@xxxxxxxxxxxx]

Hey Kevin, how goes it?

You wrote 'have you tried WorkFlow' as if it's a demo CD you can try for 
60 days!  :)

Is it possible to play around with it?  Not aware of any MAPICS modules 
like that!

Just curious at this point.......

Regards...james








"Kevin Fox" <kdfox@xxxxxxxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
01/20/2004 04:29 PM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
"'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
cc

Subject
RE: Purchase Requisitions and EXCEL






Hi Wayne,

Have you tried MAPICS WorkFlow.  It works great and is very flexible.  It
will accommodate your needs.  It can easily accommodate approved vendor
lists (that don't exist in MAPICS) as well as creating quotes on a 
schedule.
For example, lets suppose you would like to receive all new quotes on your
purchased items every quarter.  You would like a system to automatically
startup the quoting process, perhaps push the quote out to the vendor as
HTML with return receipt that would automatically populate your quotations
files, allow you to compare new quotes and select quotes based upon price,
lead time, quality rating (or anything else) and route the quotes for
approval depending upon value, item type, commodity code classification,
etc. and once approved, automatically create the quotations in the MAPICS
files that MRP can use to schedule and release orders.  This of course 
would
automatically take into account quantity price breaks as quoted.

There is much more that can be done, but that is just a start.

Which AS400 faxing software do you use?

Kevin Fox
kdfox@xxxxxxxxxxxxx



-----Original Message-----
From: Baldwin, Wayne (ALIE) [mailto:Wayne.Baldwin@xxxxxxxxxxxxxxxxxxxx] 
Sent: Monday, January 19, 2004 11:22 AM
To: Mapics-l@xxxxxxxxxxxx
Subject: Re: Purchase Requisitions and EXCEL


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.
******************************************





_______________________________________________
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/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.