× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. July 2004

RE: MAPICS-L Digest, Vol 2, Issue 207

You can also look at MAPICS application QRMS and Enterprise Business 
Intelligence (EBI).

Barbie Fitts
Sr. Business Consultant
MAPICS, Inc.
(work) 940-321-3842
(fax) 940-497-2350
(cell) 214-460-5961
Barbie.Fitts@xxxxxxxxxx


Creating World-Class Manufacturers



-----Original Message-----
From: mapics-l-request@xxxxxxxxxxxx
[mailto:mapics-l-request@xxxxxxxxxxxx]
Sent: Monday, July 26, 2004 12:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 2, Issue 207


Send MAPICS-L mailing list submissions to
        mapics-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
        mapics-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        mapics-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."


Today's Topics:

   1. Vendor Performance (Selvaraj Pillai)
   2. RE: Vendor Performance (Russell Stuart)
   3. Re: Odd Question (Ron)
   4. Re: Vendor Performance (LeLeux@xxxxxxxxxxxx)
   5. MAPICS triggers (Willie J. Moore)


----------------------------------------------------------------------

message: 1
date: Mon, 26 Jul 2004 11:33:58 +0800
from: Selvaraj Pillai <selvaraj.pillai@xxxxxxxxxxx>
subject: Vendor Performance

Hi Group,

I am keen to understand whether MAPICS modules or any third party 
solutions provide to track vendor quality performance analysis. Basically, 
from my understanding the standard MAPICS can provide vendor performance 
analysis based on Quantity, Leadtime, Pricing etc. My intention is to 
provide a list of quality control norms to the vendor based on each 
product family and then to track down the vendor performance before the 
materials are shipped to us. Basically, the vendor has to fulfill the 
quality checks parameters before the items are shipped. Is there any one 
in the group has done this, please advise.

Regards, Selva
 


------------------------------

message: 2
date: Mon, 26 Jul 2004 10:01:10 -0400
from: "Russell Stuart" <trautsr@xxxxxxxxxxx>
subject: RE: Vendor Performance

   Dear Selvaraj,

   American Presence offers a tool called PRESENCE, that can do this, plus
   much more.  Also, PRESENCE is a Certified Enterprise Solution with MAPICS.

   PRESENCE can monitor performance indicators for vendors and then notifiy
   them (email, fax, XML, HTML, SMS, EDI, etc.), as well as someone
   internally of the conditions you set.  PRESENCE can also store historical
   data to present dashboards and scorecards to track performance.

   Please take a moment to review our information on our website
   (http://www.international-presence.com) and contact me offline if you have
   any questions.  Also, you can download a free 30-day trail of PRESENCE to
   give you a feel of the other benefits you can use.

   Regards,

   Rusty Stuart
   American Presence, Inc.
   800-429-8983 x205
   stuart@xxxxxxxxxxxxxxxxxxxxx

   >From: Selvaraj Pillai <selvaraj.pillai@xxxxxxxxxxx>
   >Reply-To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
   >To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
   >Subject: Vendor Performance
   >Date: Mon, 26 Jul 2004 11:33:58 +0800
   >
   >Hi Group,
   >
   >I am keen to understand whether MAPICS modules or any third party
   >solutions provide to track vendor quality performance analysis.
   Basically,
   >from my understanding the standard MAPICS can provide vendor performance
   >analysis based on Quantity, Leadtime, Pricing etc. My intention is to
   >provide a list of quality control norms to the vendor based on each
   >product family and then to track down the vendor performance before the
   >materials are shipped to us. Basically, the vendor has to fulfill the
   >quality checks parameters before the items are shipped. Is there any one
   >in the group has done this, please advise.
   >
   >Regards, Selva
   >
   >_______________________________________________
   >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.
   >

     ----------------------------------------------------------------------

   Don*t just search. Find. Check out the new MSN Search!


------------------------------

message: 3
date: Mon, 26 Jul 2004 09:40:38 -0500
from: Ron <Ron_H@xxxxxxxxxx>
subject: Re: Odd Question

In order to do date arithmetic for MAPICS dates in Query/400 you need to 
do three things:
1) Convert the date to character
2) Change the date to the job format (probably MM/DD/YY for most systems 
in the U.S.) in character format
3) Convert the character string to a DATE field and use the DAYS function 
to return a numeric

Here's an example I used for a query of the POMAST file:

Field           Expression 
ACTDTC          DIGITS(actdt) 
(Convert MAPICS date column to character) 
  
 
ACTDTN          SUBSTR(actdtc,4,2) || '/' || 
                        SUBSTR(actdtc,6,2) || '/' || 
                        SUBSTR(actdtc,2,2) 
(Convert MAPICS date to MM/DD/YY format)

DATEFLD3        DAYS(DATE(ACTDTN)) - 
                        DAYS(DATE(MDATEN)) 
(Convert the field to a DATE field and then use the DAYS function in the 
calculation)

You'd be surprised at the date functions you can get Query/400 to perform.
Check out some of these links for the some of the date capabilities of 
Query/400. 
http://www.midrangeserver.com/fhg/fhg052604-story03.html
http://www.midrangeserver.com/mgo/mgo092403-story01.html
http://www.mcpressonline.com/mc/.6ae686b0
http://www.midrangeserver.com/mgo/mgo100303-story01.html
http://www.midrangeserver.com/mgo/mgo120503-story02.html
http://www.midrangeserver.com/mgo/mgo090303-story01.html
http://www.midrangeserver.com/mgo/mgo102403-story02.html


Ron Hankey - CPIM
iSeries Administrator and Senior Applications Programmer


Dan wrote:
>Does anybody no how to subtract dates in query.
<SNIP>

------------------------------

message: 4
date: Mon, 26 Jul 2004 08:58:01 -0700
from: LeLeux@xxxxxxxxxxxx
subject: Re: Vendor Performance

Hello Selvaraj.

What you've described is an interesting scenario, and let me describe how 
we addressed it.

First let me say it is difficult to use non-web-enabled-software to guide 
vendors in meeting
requirements enforced by the customer (the MAPICS shop).  And the 
difficulty is compounded
when your vendors do not use the internet either.  We have many vendors 
that don't even
have email, so it is a challenge to communicate with them in an automated 
fashion.

So, how indeed do we establish a 'checklist' for them to follow?  In the 
most natural format - the PO!

We modified MAPICS to include what we call 'Standard Item Notes'.  This 
are notes that are
automatically added to a PO when it is printed.  They consist of item 
based requirements, such as
including documentation, hardness testing, packaging, bar coding, etc.

In short, the very document a vendor receives conveys the checklist 
needing review prior to shipping!

These notes are Item number driven, but could easily be expanded to 
include class, or some other
characteristic.

If you wanted to take it to the next level and be able to track/rate the 
vendor performance on these
items (requirements), assign misc item codes (item numbers) to specific 
activities you expect the vendor
to follow or include prior to shipment.  When these items are received, 
you will automatically be including
them in the MAPICS vendor analysis program that is part of purchasing. The 
item codes example
I mentioned is very common, many use them for purchasing office supplies, 
expedite charges, etc.
For example, assign an item for certs, another for hardness testing, and 
another for bar coding.
We use 9XXXX item numbers for misc. items.

Of course you may find the MAPICS program lacking, but at least you'll 
have a populated database
over which you could apply any reporting tool such as query, crystal, etc. 
 Not to mention 3rd party
MAPICS centric software.

I hope I understood correctly the second half of your message correctly in 
terms of enforcing requirements
at the vendor level, as opposed to making it an in-house activity.

Regards....james







Selvaraj Pillai <selvaraj.pillai@xxxxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
07/25/2004 08:33 PM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


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

Subject
Vendor Performance






Hi Group,

I am keen to understand whether MAPICS modules or any third party 
solutions provide to track vendor quality performance analysis. Basically, 

from my understanding the standard MAPICS can provide vendor performance 
analysis based on Quantity, Leadtime, Pricing etc. My intention is to 
provide a list of quality control norms to the vendor based on each 
product family and then to track down the vendor performance before the 
materials are shipped to us. Basically, the vendor has to fulfill the 
quality checks parameters before the items are shipped. Is there any one 
in the group has done this, please advise.

Regards, Selva
 
_______________________________________________
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.




------------------------------

message: 5
date: Mon, 26 Jul 2004 09:43:23 -0700
from: "Willie J. Moore" <WJMoore@xxxxxxxxxxxxxxx>
subject: MAPICS triggers

I am starting to look at using trigger programs in MAPICS. I would like to know 
where could I find out about them. How to use them and what programs have 
triggers built in. 
Thanks in advance for any information.
William Moore




------------------------------

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) digest 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.



End of MAPICS-L Digest, Vol 2, Issue 207
****************************************

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.