BPM Question (Bump)

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]
Bumping this past the group again.
Thanks -Karl



----- Forwarded Message ----
From: Karl Dash <dashkarl@...>
To: Vantage Group <vantage@yahoogroups.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]
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@yahoogroups.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> >
To: Vantage Group <vantage@yahoogroups.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]
We never use the update table buffer we simple do assing
Company.Character02=val....

Can you try that? It may require a fancier progress lic though.
*
*
*
*
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Mon, Jun 6, 2011 at 11:46 AM, Karl Dash <dashkarl@...> wrote:

>
>
> Bumping this past the group again.
> Thanks -Karl
>
> ----- Forwarded Message ----
> From: Karl Dash <dashkarl@...>
> To: Vantage Group <vantage@yahoogroups.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]
Kevin, I made the change from Integer to Decimal and it works! That was it ...
decimal vs integer.

Thanks,
-Karl



________________________________
From: Kevin Simon <ksimon@...>
To: vantage@yahoogroups.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@yahoogroups.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> >
To: Vantage Group <vantage@yahoogroups.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]