Thanks a lot Michael, will give that a try.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Hi group,
I have a BAM triggering from Job Header, which is supposed to warn a
person they are entering a job for a part without a standard cost. My
problem is, custom made parts not actually Database Part numbers are
causing an annoying error to pop up about part not on file.
I have attached the BAM below. I need some way of stopping the BAM from
triggering when there is no part on the system, ie. When there is no
Part.PartNum.
This would be a left outer join in crystal I think, is there such a
thing in Progress for the first line of the BAM?
Any help would be greatly appreciated
{ud/GlbAlert.i &TableName = "JobHead"}
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
[Non-text portions of this message have been removed]
I have a BAM triggering from Job Header, which is supposed to warn a
person they are entering a job for a part without a standard cost. My
problem is, custom made parts not actually Database Part numbers are
causing an annoying error to pop up about part not on file.
I have attached the BAM below. I need some way of stopping the BAM from
triggering when there is no part on the system, ie. When there is no
Part.PartNum.
This would be a left outer join in crystal I think, is there such a
thing in Progress for the first line of the BAM?
Any help would be greatly appreciated
{ud/GlbAlert.i &TableName = "JobHead"}
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
[Non-text portions of this message have been removed]
{ud/GlbAlert.i &TableName = "JobHead"}
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF NOT AVAILABLE Part THEN Return "Cancel Send":U.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Stuart Noble
Sent: Tuesday, August 21, 2007 10:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 BAM Help please
Hi group,
I have a BAM triggering from Job Header, which is supposed to warn a
person they are entering a job for a part without a standard cost. My
problem is, custom made parts not actually Database Part numbers are
causing an annoying error to pop up about part not on file.
I have attached the BAM below. I need some way of stopping the BAM from
triggering when there is no part on the system, ie. When there is no
Part.PartNum.
This would be a left outer join in crystal I think, is there such a
thing in Progress for the first line of the BAM?
Any help would be greatly appreciated
{ud/GlbAlert.i &TableName = "JobHead"}
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF NOT AVAILABLE Part THEN Return "Cancel Send":U.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Stuart Noble
Sent: Tuesday, August 21, 2007 10:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 BAM Help please
Hi group,
I have a BAM triggering from Job Header, which is supposed to warn a
person they are entering a job for a part without a standard cost. My
problem is, custom made parts not actually Database Part numbers are
causing an annoying error to pop up about part not on file.
I have attached the BAM below. I need some way of stopping the BAM from
triggering when there is no part on the system, ie. When there is no
Part.PartNum.
This would be a left outer join in crystal I think, is there such a
thing in Progress for the first line of the BAM?
Any help would be greatly appreciated
{ud/GlbAlert.i &TableName = "JobHead"}
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Also add NO-ERROR to the end of the FIND statement.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Stuart Noble
Sent: Tuesday, August 21, 2007 10:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 BAM Help please
Hi group,
I have a BAM triggering from Job Header, which is supposed to warn a
person they are entering a job for a part without a standard cost. My
problem is, custom made parts not actually Database Part numbers are
causing an annoying error to pop up about part not on file.
I have attached the BAM below. I need some way of stopping the BAM from
triggering when there is no part on the system, ie. When there is no
Part.PartNum.
This would be a left outer join in crystal I think, is there such a
thing in Progress for the first line of the BAM?
Any help would be greatly appreciated
{ud/GlbAlert.i &TableName = "JobHead"}
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Stuart Noble
Sent: Tuesday, August 21, 2007 10:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 BAM Help please
Hi group,
I have a BAM triggering from Job Header, which is supposed to warn a
person they are entering a job for a part without a standard cost. My
problem is, custom made parts not actually Database Part numbers are
causing an annoying error to pop up about part not on file.
I have attached the BAM below. I need some way of stopping the BAM from
triggering when there is no part on the system, ie. When there is no
Part.PartNum.
This would be a left outer join in crystal I think, is there such a
thing in Progress for the first line of the BAM?
Any help would be greatly appreciated
{ud/GlbAlert.i &TableName = "JobHead"}
FIND Part WHERE Part.PartNum = JobHead.PartNum no-lock.
IF (Part.StdBurdenCost + Part.StdLaborCost + Part.StdMaterialCost +
Part.StdSubContCost + Part.StdMtlBurCost) = 0 AND JOBHead.Revision <>""
THEN DO:
Message "PLEASE NOTE! The Standard Cost for this Part is Equal to ZERO.
Press Cancel NOW and Modify Standard Cost Before Raising the Job Please.
If the Job has been Raised through Order Job Wizard, you will need to
delete the Job through Job Entry."
View-as alert-box information buttons ok.
END.
Return "Cancel Send":U.
Return.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]