OK... :) All available via CAS.
I guess if I go back a few yrs - I'd get a listing of file def from CAS, and then once we have identified the file ( I believe SLQNTY) I'd print the field def via CAS for the file ...
Good Luck with your AS400 Qry -- :)



Jeffrey G Snyder CPIM, CSCP
Senior Mfg Consultant
Guide Technologies, LLC
cell 724 699 2506


Date: Thu, 18 Sep 2014 12:51:08 -0500
From: lwl@xxxxxxxxxxxxx
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] Quality Control Hold

Need file and field for 3 reasons:
1. Don't know Powerlink.
2. Don't have access to Powerlink.
3. Query is to create file for subsequent processing.

Roy


Sent via the Samsung GALAXY S®4, an AT&T 4G LTE smartphone

<div>-------- Original message --------</div><div>From: Jeff Snyder <jeffreygsnyder@xxxxxxxxxxx> </div><div>Date:09/18/2014 11:57 AM (GMT-06:00) </div><div>To: mapics midrange <mapics-l@xxxxxxxxxxxx> </div><div>Subject: Re: [MAPICS-L] Quality Control Hold </div><div>
</div>Kevin is quite correct - see Item Locations business obj - subset - waiting inspection. (material application)



Jeffrey G Snyder CPIM, CSCP
Senior Mfg Consultant
Guide Technologies, LLC
cell 724 699 2506


From: kdfox2007pub@xxxxxxxxx
Date: Thu, 18 Sep 2014 10:01:55 -0500
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] Quality Control Hold

Don't build a query. Use Powerlink. It's built in

Kevin D Fox
Sent from my iPhone

On Sep 18, 2014, at 5:44 AM, "Roy Luce - Long Pier Solutions" <lwl@xxxxxxxxxxxxx> wrote:

Have a client on MAPICS v9 in EPDM mode.



Several items are indicating a portion of their on-hand quantity is on a QC
hold because that quantity does not pass inspection.

Need to build a query to highlight these holds.

What file and field are used to indicate item quantities on QC hold?





Roy Luce



Direct: 847-540-9635

800-913-PLUS (7587)

Cell: 847-910-0884

Fax: 847-737-7635

Email: lwl@xxxxxxxxxxxxx



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

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


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

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2021 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.