OOPS!® Technical Support - Doctor OOPS!

Problem:
Doctor OOPS! is messed up and a cleanup doesn't help.

Solution:
Run a Doctor OOPS! cleanup from the Dr. OOPS! menu.

Problem:
You want to get information from emplab and the requisition log with a special condition coming from reqlog and inventory

Solution:

1. Need to create and run TSG to create a dummy table

CREATE DUMMY TABLE

BEGIN PROCEDURE:

DEFINE DUMMY WITH "DUMMY.MST"
FIELD DUMMY STR 5
ENDDEF
ATTACH 1 TO DUMMY
FINISH DUMMY

END PROCEDURE:

2. Create a new custom report

In this case the primary file was reqlog
Put in your fields to display, remember to use emplab. for any fields coming from inventory, ie. emplab.manufnum
Special conditions: reqrecv eq "Q" from emplab pluck "m", reqlog.partno, reqlog.primloc from dummy for emplab.manuf="manuf1"
Note: you cannot use wildcards in the second special condition, ie can't put emplab.manuf="*man*"
Special instructions: use emplab.mst with emplab.ind; use dummy.mst