RB: Quantities Locked

Thank you!!!

Juliet

-----Original Message-----
From: Sherri Hill [mailto:sherrih@...]
Sent: Tuesday, March 01, 2005 11:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB: Quantities Locked



This is the function that is run on the job screen to set the
jobqtylocked flag. Hope this helps some. I am not sure when or how the
comxref table entry is created.



FUNCTION JobQtyLocked RETURNS LOGICAL

( INPUT inCompany AS CHAR,

INPUT inJobNum AS CHAR ) :

/*----------------------------------------------------------------------
--------

Purpose:

Notes:

------------------------------------------------------------------------
------*/

RETURN CAN-FIND (comxref WHERE comxref.company = inCompany AND

comxref.FILE = "JobHead_Mapping":u AND

comxref.Key1 = inJobNum AND

comxref.Key2 = "":U AND

comxref.Key3 = "":U AND

comxref.ForeignKey1 <> "No":u).

END FUNCTION.





Sherri Hill

Sr. Programmer Analyst, GBS

330-494-5330, Ext. #2405

_____

From: Juliet Martin [mailto:jmartin@...]
Sent: Tuesday, March 01, 2005 11:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Quantities Locked



Does anyone know what table "Quantities Locked" is located?

Thanks

Juliet

-----Original Message-----
From: Juliet Martin
Sent: Monday, February 28, 2005 12:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB Help - Job Quantities Locked



I need to put a filter in my report whether the quantities were locked
or not. I can't find this in any table. I am using JobHead. Maybe I
am losing my mind - not totally outside the realm of possibility. You
can find this checkbox in Job Tracker underneath Prod Quantity.

TIA,

Juliet Martin
Does anyone know what table "Quantities Locked" is located?

Thanks

Juliet

-----Original Message-----
From: Juliet Martin
Sent: Monday, February 28, 2005 12:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB Help - Job Quantities Locked



I need to put a filter in my report whether the quantities were locked or not. I can't find this in any table. I am using JobHead. Maybe I am losing my mind - not totally outside the realm of possibility. You can find this checkbox in Job Tracker underneath Prod Quantity.

TIA,

Juliet Martin
This is the function that is run on the job screen to set the
jobqtylocked flag. Hope this helps some. I am not sure when or how the
comxref table entry is created.



FUNCTION JobQtyLocked RETURNS LOGICAL

( INPUT inCompany AS CHAR,

INPUT inJobNum AS CHAR ) :

/*----------------------------------------------------------------------
--------

Purpose:

Notes:

------------------------------------------------------------------------
------*/

RETURN CAN-FIND (comxref WHERE comxref.company = inCompany AND

comxref.FILE = "JobHead_Mapping":u AND

comxref.Key1 = inJobNum AND

comxref.Key2 = "":U AND

comxref.Key3 = "":U AND

comxref.ForeignKey1 <> "No":u).

END FUNCTION.





Sherri Hill

Sr. Programmer Analyst, GBS

330-494-5330, Ext. #2405

_____

From: Juliet Martin [mailto:jmartin@...]
Sent: Tuesday, March 01, 2005 11:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Quantities Locked



Does anyone know what table "Quantities Locked" is located?

Thanks

Juliet

-----Original Message-----
From: Juliet Martin
Sent: Monday, February 28, 2005 12:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB Help - Job Quantities Locked



I need to put a filter in my report whether the quantities were locked
or not. I can't find this in any table. I am using JobHead. Maybe I
am losing my mind - not totally outside the realm of possibility. You
can find this checkbox in Job Tracker underneath Prod Quantity.

TIA,

Juliet Martin





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor

ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129ldh2jg/M=298184.6018725.7038619.3001176/
D=groups/S=1705007183:HM/EXP=1109782352/A=2593423/R=0/SIG=11el9gslf/*htt
p:/www.netflix.com/Default?mqso=60190075>


<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group
s/S=:HM/A=2593423/rand=649694511>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]