ISTech Support Forum - IN-B "Receive to QC"

Welcome, Guest. Please Login.

	05/09/25 at 15:34:08 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›

Pages: 1

IN-B "Receive to QC" (Read 873 times)

Waidesworld Browser Gnu at this! Posts: 35	IN-B "Receive to QC" 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
Back to top	IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: IN-B "Receive to QC" Reply #1 - 02/23/07 at 08:00:15 BKQCMSTR has that info.
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

Waidesworld

Browser

Gnu at this!

Posts: 35

Re: IN-B "Receive to QC"
Reply #2 - 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

IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: IN-B "Receive to QC" Reply #3 - 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.
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

Cyndee Pappas Senior Member EVO~ERP 2006.1 02/28/06 update Posts: 258 Gender:	Re: IN-B "Receive to QC" Reply #4 - 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
Back to top	Cyndee Pappas Industrial Data Systems EVO~ERP 2006.1 with 02/28/06 update Client/Server Win2000 Server Pervasive SQL 2000i IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: IN-B "Receive to QC" Reply #5 - 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
Back to top	IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: IN-B "Receive to QC" Reply #6 - 02/23/07 at 12:20:40 Wow, I am in a bigger fog than I was aware of! Key word- "System"!
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

Waidesworld Browser Gnu at this! Posts: 35	Re: IN-B "Receive to QC" Reply #7 - 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.
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›