Go figure
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karl Dash
Sent: Wednesday, June 08, 2011 12:23 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Question (Bump)
Kevin, I made the change from Integer to Decimal and it works! That was it ...
decimal vs integer.
Thanks,
-Karl
________________________________
From: Kevin Simon <ksimon@... <mailto:ksimon%40simstrak.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, June 7, 2011 6:54:25 PM
Subject: RE: [Vantage] BPM Question (Bump)
Karl,
I don’t really see anything wrong with your code.
I assume you’ve commented out the “Run Lib†command, and it works fine, then
when you uncomment it, it hangs.
You may want to change vLot from Integer to Decimal. I can’t imagine that would
make a difference, but the Number fields are decimals.
I’ve had issues with the “Run Lib†commands not updating certain fields in
V8.03, but I thought it was always non-UD fields. I can’t recall a time when
I’ve had an issue with a UD field. You may want to consider testing this out
with a different table than Company, just to see if that’s an issue. Perhaps set
up a UD table, insert a row in it, then read that table with the key hardcoded
in your script.
Worst case, you may need to get a progress developer license. I think of all the
things you can get from Epicor, that’s one of the cheaper ones. Or, upgrade to
E9 where the license to write to the database is included.
Hope that helps,
Kevin Simon
SimsTrak Consulting
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Karl
Dash
Sent: Monday, June 06, 2011 11:47 AM
To: Vantage Group
Subject: Fw: [Vantage] BPM Question (Bump)
Bumping this past the group again.
Thanks -Karl
----- Forwarded Message ----
From: Karl Dash <dashkarl@... <mailto:dashkarl%40yahoo.com> <mailto:dashkarl%40yahoo.com> >
To: Vantage Group <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> >
Sent: Fri, June 3, 2011 9:05:38 AM
Subject: [Vantage] BPM Question
I am on Progress 803.408 and want to create lot numbers for lot-controlled
parts. I have created a BPM on BO Receipt and method CheckDtlBeforeUpdate.
My Condition is:
for each ttRcvDtl where (ttRcvDtl.RowMod = 'A') no-lock,
each Part where Part.TrackLots = TRUE
and (ttRcvDtl.Company = Part.Company and
ttRcvDtl.PartNum = Part.PartNum) no-lock
My action is:
/* Calculate next Lot Number */
define var vLot as Integer no-undo.
define var newLot as character no-undo.
define var msg as character no-undo.
find last Company where Company.Company = CUR-COMP no-lock.
if available Company then do:
assign vLot = Company.Number02 + 1.
Run lib\UpdateTableBuffer.p(input BUFFER Company:Handle, 'Number02', vLot).
newLot = STRING(vLot, "9999999").
msg = "New Lot No:" + "~n" + newLot.
{lib/PublishInfoMsg.i &InfoMsg = msg }.
end.
The problem is that the presence of the Run lib... line causes the program to
hang. I need to update Number02 with the current lot number before the next lot
required receipt comes in. Should this line be in post-processing?
Thanks, -Karl
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karl Dash
Sent: Wednesday, June 08, 2011 12:23 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Question (Bump)
Kevin, I made the change from Integer to Decimal and it works! That was it ...
decimal vs integer.
Thanks,
-Karl
________________________________
From: Kevin Simon <ksimon@... <mailto:ksimon%40simstrak.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, June 7, 2011 6:54:25 PM
Subject: RE: [Vantage] BPM Question (Bump)
Karl,
I don’t really see anything wrong with your code.
I assume you’ve commented out the “Run Lib†command, and it works fine, then
when you uncomment it, it hangs.
You may want to change vLot from Integer to Decimal. I can’t imagine that would
make a difference, but the Number fields are decimals.
I’ve had issues with the “Run Lib†commands not updating certain fields in
V8.03, but I thought it was always non-UD fields. I can’t recall a time when
I’ve had an issue with a UD field. You may want to consider testing this out
with a different table than Company, just to see if that’s an issue. Perhaps set
up a UD table, insert a row in it, then read that table with the key hardcoded
in your script.
Worst case, you may need to get a progress developer license. I think of all the
things you can get from Epicor, that’s one of the cheaper ones. Or, upgrade to
E9 where the license to write to the database is included.
Hope that helps,
Kevin Simon
SimsTrak Consulting
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Karl
Dash
Sent: Monday, June 06, 2011 11:47 AM
To: Vantage Group
Subject: Fw: [Vantage] BPM Question (Bump)
Bumping this past the group again.
Thanks -Karl
----- Forwarded Message ----
From: Karl Dash <dashkarl@... <mailto:dashkarl%40yahoo.com> <mailto:dashkarl%40yahoo.com> >
To: Vantage Group <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> >
Sent: Fri, June 3, 2011 9:05:38 AM
Subject: [Vantage] BPM Question
I am on Progress 803.408 and want to create lot numbers for lot-controlled
parts. I have created a BPM on BO Receipt and method CheckDtlBeforeUpdate.
My Condition is:
for each ttRcvDtl where (ttRcvDtl.RowMod = 'A') no-lock,
each Part where Part.TrackLots = TRUE
and (ttRcvDtl.Company = Part.Company and
ttRcvDtl.PartNum = Part.PartNum) no-lock
My action is:
/* Calculate next Lot Number */
define var vLot as Integer no-undo.
define var newLot as character no-undo.
define var msg as character no-undo.
find last Company where Company.Company = CUR-COMP no-lock.
if available Company then do:
assign vLot = Company.Number02 + 1.
Run lib\UpdateTableBuffer.p(input BUFFER Company:Handle, 'Number02', vLot).
newLot = STRING(vLot, "9999999").
msg = "New Lot No:" + "~n" + newLot.
{lib/PublishInfoMsg.i &InfoMsg = msg }.
end.
The problem is that the presence of the Run lib... line causes the program to
hang. I need to update Number02 with the current lot number before the next lot
required receipt comes in. Should this line be in post-processing?
Thanks, -Karl
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]