ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> IN-B "Receive to QC"
http://www.istechforum.com/YaBB.pl?num=1172244763

Message started by Waidesworld on 02/23/07 at 07:32:43

Title: IN-B "Receive to QC"
Post by Waidesworld on 02/23/07 at 07:32:43

What is the name of this file and the field that holds this information? Basically I want to run a report of all items that are currently received to QC by the system?

TIA
Donal

Title: Re: IN-B "Receive to QC"
Post by cathyh on 02/23/07 at 08:00:15

BKQCMSTR has that info.

Title: Re: IN-B "Receive to QC"
Post by Waidesworld on 02/23/07 at 08:18:32

Cathy, do you know the actual name of the file as I checked that and it lists all these
BKQC.VKEY
BKQC.VEND.CODE
BKQC.DKEY
BKQC.RECV.DATE
BKQC.PKEY
BKQC.PO.NUM
BKQC.RKEY
BKQC.RECVR.NUM
BKQC.IKEY
BKQC.POL.ITM.NO
BKQC.PKSLIP.NUM
BKQC.QTY.RECVD
BKQC.QTY.BUYOFF
BKQC.QTY.REJECT
BKQC.PKSLIP.QTY
BKQC.PROD.CODE
BKQC.UNIT.COST
BKQC.EXTRA

I believe it's a one or two character field

Title: Re: IN-B "Receive to QC"
Post by cathyh on 02/23/07 at 10:38:24

BKQC.QTY.RECVD if there are none bought off (BKQC.QTY.BUYOFF) or rejected (BKQC.QTY.REJECT).

If I was doing a report in Access I would search for records with "0" in buyoff and rejected and a quantity >0 in recvd to get a list of current product codes in QC.

Title: Re: IN-B "Receive to QC"
Post by Cyndee Pappas on 02/23/07 at 11:40:14

I read that completely different than cathyh. If you want to know which parts have the "receive to QC" in IN-B set to "Y", you'll find it in MTICMSTR. The field is MTIT.PROD.OPTCS

Title: Re: IN-B "Receive to QC"
Post by GasGiant on 02/23/07 at 11:54:23

Yes, I would read it that we are looking for which items are set to Y for receiving to QC. Although the spreadsheet guide to fields says that MTIC.PROD.OPTCS is not used, it is indeed where that code is stored in MTICMSTR

Title: Re: IN-B "Receive to QC"
Post by cathyh on 02/23/07 at 12:20:40

Wow, I am in a bigger fog than I was aware of!
Key word- "System"! :P

Title: Re: IN-B "Receive to QC"
Post by Waidesworld on 02/23/07 at 12:33:03

Thanks all. I will give the data to my Crystal Report person on Monday and she may have further questions....we'll see.