MES Pre-approval

Yahoo Archive
1
Glad to hear it!

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Hollingsworth
Sent: Thursday, May 31, 2012 1:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MES Pre-approval



Finally go a chance to put this in and it works great, Thanks!

Tim Hollingsworth
Cost Accountant
Sun Country Industries
(505) 998-1980 (office)
(703) 867-4400 (cell)
thollingsworth@...<mailto:thollingsworth%40suncountryindustries.com>

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Tuesday, May 22, 2012 10:01 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Here is what you should do to make this work...

On the Labor BO, choose the update method

Create a preprocess BPM

Condition should be Number of rows in the [designed] query in not less
than 1

In your designed query, paste this code in..

for each ttlabordtl where ttlabordtl.rowmod = 'A' and
ttlabordtl.labortype = 'P'

this ensures this BPM will not fire for every labor transaction under
the sun that doesn't have anything to do with completing production
quantities against operations.

Under actions choose synchronously Execute 4GL code - execute code below

Paste the following code in the field

for each ttlabordtl where ttlabordtl.RowMod = 'A' no-lock.
find first joboper where joboper.company = ttlabordtl.company and
joboper.jobnum = ttlabordtl.jobnum and joboper.AssemblySeq =
ttlabordtl.AssemblySeq and joboper.OprSeq = ttlabordtl.OprSeq.
If avail joboper Then Do:
If joboper.QtyCompleted + ttlabordtl.LaborQty > joboper.RunQty then
{lib/PublishEx.i &ExMsg = "'There have already been ' +
string(joboper.qtycompleted) + ' parts claimed complete. The Production
quantity required for this operations is ' + string(joboper.runqty) +
'.' + ' Your additional quantity of ' + string(ttlabordtl.laborqty) + '
will result in an over reported quantity'"}.
End.
End.

This solution works in 8.03.409c, but I can't fathom any reason it won't
work in 9 unless they changed column names.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Brian Roberts
Sent: Tuesday, May 22, 2012 10:32 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Not sure how hard it will be, haven't done that one myself... but if
you've just taken a couple classes, time to practice...

To get you started: you'll probably want a method BPM on
Labor.EndActivity pre-processing (I think - do some tracing to make
sure). The quantity they are reporting should be in the
ttLaborDtl.LaborQty field, and start by just displaying an informational
message with that quantity in your BPM (no condition, just that one
action - do in your test environment of course). You'll need to figure
out where the job quantity is available, try writing the full dataset
during tracing or looking in the data dictionary. Add a condition for
LaborQty > job qty and when that is working properly, change your action
to raise exception instead of info message. Raising an exception in
pre-processing will abort the end activity before the data gets saved.

Thanks,

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Tim Hollingsworth
Sent: Tuesday, May 22, 2012 11:14 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Hello Brian,

I would love to set up a BPM preventing a quantity greater than present
on the job. I took a couple of the classes on BPMs at the conference,
but have not done one yet, how hard is this one to set up?

Tim

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf
Of Brian Roberts
Sent: Tuesday, May 22, 2012 8:58 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

You could turn off the "auto receive to inventory" on the last job
operation, and do a manual receipt from manufacturing. Of course, this
could lead to incorrect inventory if that manual entry is delayed or
that a typo is made in that quantity.. six of one error, half dozen of
another J

Here's another idea: a BPM on end activity that prevents reporting a
quantity, say greater than the job quantity.

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jobando018
Sent: Tuesday, May 22, 2012 10:20 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] MES Pre-approval

Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES?
We would like to see all the production activities submitted for a given
day and approve the quantities before moving them into inventory.Even if
there is not a pre-approval stage, are there any process in place that
you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into
inventory right after a MES user ends an activity. It can lead to
incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,

[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]



[Non-text portions of this message have been removed]
2
Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES? We would like to see all the production activities submitted for a given day and approve the quantities before moving them into inventory.Even if there is not a pre-approval stage, are there any process in place that you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into inventory right after a MES user ends an activity. It can lead to incorrect inventory if production is reported incorrectly.



Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,
3
You can create BPM's for those who are mathematically challenged. I assume you are concerned about the possibility of over reporting quantity? Is there other factors you monitor beyond that?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jobando018
Sent: Tuesday, May 22, 2012 9:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MES Pre-approval



Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES? We would like to see all the production activities submitted for a given day and approve the quantities before moving them into inventory.Even if there is not a pre-approval stage, are there any process in place that you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into inventory right after a MES user ends an activity. It can lead to incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,



[Non-text portions of this message have been removed]
4
You could turn off the "auto receive to inventory" on the last job
operation, and do a manual receipt from manufacturing. Of course, this
could lead to incorrect inventory if that manual entry is delayed or
that a typo is made in that quantity.. six of one error, half dozen of
another J



Here's another idea: a BPM on end activity that prevents reporting a
quantity, say greater than the job quantity.



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jobando018
Sent: Tuesday, May 22, 2012 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MES Pre-approval





Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES?
We would like to see all the production activities submitted for a given
day and approve the quantities before moving them into inventory.Even if
there is not a pre-approval stage, are there any process in place that
you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into
inventory right after a MES user ends an activity. It can lead to
incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,





[Non-text portions of this message have been removed]
5
Hello Brian,

I would love to set up a BPM preventing a quantity greater than present
on the job. I took a couple of the classes on BPMs at the conference,
but have not done one yet, how hard is this one to set up?

Tim

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Roberts
Sent: Tuesday, May 22, 2012 8:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MES Pre-approval




You could turn off the "auto receive to inventory" on the last job
operation, and do a manual receipt from manufacturing. Of course, this
could lead to incorrect inventory if that manual entry is delayed or
that a typo is made in that quantity.. six of one error, half dozen of
another J

Here's another idea: a BPM on end activity that prevents reporting a
quantity, say greater than the job quantity.

Brian.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jobando018
Sent: Tuesday, May 22, 2012 10:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] MES Pre-approval

Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES?
We would like to see all the production activities submitted for a given
day and approve the quantities before moving them into inventory.Even if
there is not a pre-approval stage, are there any process in place that
you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into
inventory right after a MES user ends an activity. It can lead to
incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,

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






[Non-text portions of this message have been removed]
6
haha no that is about much it.

--- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
>
> You can create BPM's for those who are mathematically challenged. I assume you are concerned about the possibility of over reporting quantity? Is there other factors you monitor beyond that?
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
> [Description: cid:1.234354861@...]<http://www.dsmfg.com/>
> (Click the logo to view our site)<http://www.dsmfg.com/>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jobando018
> Sent: Tuesday, May 22, 2012 9:20 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] MES Pre-approval
>
>
>
> Good Morning Group,
>
> Is there a pre-approval stage after a user has ended an activity in MES? We would like to see all the production activities submitted for a given day and approve the quantities before moving them into inventory.Even if there is not a pre-approval stage, are there any process in place that you have implemented to oversee MES transactions?
>
> Manufacturing is concerned that all production is being moved into inventory right after a MES user ends an activity. It can lead to incorrect inventory if production is reported incorrectly.
>
> Epicor 9.05.607a
> SQL 64-bit
> Windows Server 2008
>
> Thanks,
>
>
>
> [Non-text portions of this message have been removed]
>
7
Not sure how hard it will be, haven't done that one myself... but if
you've just taken a couple classes, time to practice...



To get you started: you'll probably want a method BPM on
Labor.EndActivity pre-processing (I think - do some tracing to make
sure). The quantity they are reporting should be in the
ttLaborDtl.LaborQty field, and start by just displaying an informational
message with that quantity in your BPM (no condition, just that one
action - do in your test environment of course). You'll need to figure
out where the job quantity is available, try writing the full dataset
during tracing or looking in the data dictionary. Add a condition for
LaborQty > job qty and when that is working properly, change your action
to raise exception instead of info message. Raising an exception in
pre-processing will abort the end activity before the data gets saved.



Thanks,

Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tim Hollingsworth
Sent: Tuesday, May 22, 2012 11:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MES Pre-approval





Hello Brian,

I would love to set up a BPM preventing a quantity greater than present
on the job. I took a couple of the classes on BPMs at the conference,
but have not done one yet, how hard is this one to set up?

Tim

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian Roberts
Sent: Tuesday, May 22, 2012 8:58 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

You could turn off the "auto receive to inventory" on the last job
operation, and do a manual receipt from manufacturing. Of course, this
could lead to incorrect inventory if that manual entry is delayed or
that a typo is made in that quantity.. six of one error, half dozen of
another J

Here's another idea: a BPM on end activity that prevents reporting a
quantity, say greater than the job quantity.

Brian.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jobando018
Sent: Tuesday, May 22, 2012 10:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] MES Pre-approval

Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES?
We would like to see all the production activities submitted for a given
day and approve the quantities before moving them into inventory.Even if
there is not a pre-approval stage, are there any process in place that
you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into
inventory right after a MES user ends an activity. It can lead to
incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,

[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]
8
We went the BPM route.
If I remember the tricky hard part was handling multiple ending activities and quantities.
- 1st end activity - qty 20 for an operation (30 required).
- 2nd end activity - qty 10 and completes the operation.


--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Not sure how hard it will be, haven't done that one myself... but if
> you've just taken a couple classes, time to practice...
>
>
>
> To get you started: you'll probably want a method BPM on
> Labor.EndActivity pre-processing (I think - do some tracing to make
> sure). The quantity they are reporting should be in the
> ttLaborDtl.LaborQty field, and start by just displaying an informational
> message with that quantity in your BPM (no condition, just that one
> action - do in your test environment of course). You'll need to figure
> out where the job quantity is available, try writing the full dataset
> during tracing or looking in the data dictionary. Add a condition for
> LaborQty > job qty and when that is working properly, change your action
> to raise exception instead of info message. Raising an exception in
> pre-processing will abort the end activity before the data gets saved.
>
>
>
> Thanks,
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Tim Hollingsworth
> Sent: Tuesday, May 22, 2012 11:14 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] MES Pre-approval
>
>
>
>
>
> Hello Brian,
>
> I would love to set up a BPM preventing a quantity greater than present
> on the job. I took a couple of the classes on BPMs at the conference,
> but have not done one yet, how hard is this one to set up?
>
> Tim
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Brian Roberts
> Sent: Tuesday, May 22, 2012 8:58 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] MES Pre-approval
>
> You could turn off the "auto receive to inventory" on the last job
> operation, and do a manual receipt from manufacturing. Of course, this
> could lead to incorrect inventory if that manual entry is delayed or
> that a typo is made in that quantity.. six of one error, half dozen of
> another J
>
> Here's another idea: a BPM on end activity that prevents reporting a
> quantity, say greater than the job quantity.
>
> Brian.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of jobando018
> Sent: Tuesday, May 22, 2012 10:20 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] MES Pre-approval
>
> Good Morning Group,
>
> Is there a pre-approval stage after a user has ended an activity in MES?
> We would like to see all the production activities submitted for a given
> day and approve the quantities before moving them into inventory.Even if
> there is not a pre-approval stage, are there any process in place that
> you have implemented to oversee MES transactions?
>
> Manufacturing is concerned that all production is being moved into
> inventory right after a MES user ends an activity. It can lead to
> incorrect inventory if production is reported incorrectly.
>
> Epicor 9.05.607a
> SQL 64-bit
> Windows Server 2008
>
> Thanks,
>
> [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]
>
9
Here is what you should do to make this work...

On the Labor BO, choose the update method

Create a preprocess BPM

Condition should be Number of rows in the [designed] query in not less than 1

In your designed query, paste this code in..

for each ttlabordtl where ttlabordtl.rowmod = 'A' and ttlabordtl.labortype = 'P'

this ensures this BPM will not fire for every labor transaction under the sun that doesn't have anything to do with completing production quantities against operations.

Under actions choose synchronously Execute 4GL code - execute code below

Paste the following code in the field


for each ttlabordtl where ttlabordtl.RowMod = 'A' no-lock.
find first joboper where joboper.company = ttlabordtl.company and joboper.jobnum = ttlabordtl.jobnum and joboper.AssemblySeq = ttlabordtl.AssemblySeq and joboper.OprSeq = ttlabordtl.OprSeq.
If avail joboper Then Do:
If joboper.QtyCompleted + ttlabordtl.LaborQty > joboper.RunQty then
{lib/PublishEx.i &ExMsg = "'There have already been ' + string(joboper.qtycompleted) + ' parts claimed complete. The Production quantity required for this operations is ' + string(joboper.runqty) + '.' + ' Your additional quantity of ' + string(ttlabordtl.laborqty) + ' will result in an over reported quantity'"}.
End.
End.

This solution works in 8.03.409c, but I can't fathom any reason it won't work in 9 unless they changed column names.



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Roberts
Sent: Tuesday, May 22, 2012 10:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MES Pre-approval



Not sure how hard it will be, haven't done that one myself... but if
you've just taken a couple classes, time to practice...

To get you started: you'll probably want a method BPM on
Labor.EndActivity pre-processing (I think - do some tracing to make
sure). The quantity they are reporting should be in the
ttLaborDtl.LaborQty field, and start by just displaying an informational
message with that quantity in your BPM (no condition, just that one
action - do in your test environment of course). You'll need to figure
out where the job quantity is available, try writing the full dataset
during tracing or looking in the data dictionary. Add a condition for
LaborQty > job qty and when that is working properly, change your action
to raise exception instead of info message. Raising an exception in
pre-processing will abort the end activity before the data gets saved.

Thanks,

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Tim Hollingsworth
Sent: Tuesday, May 22, 2012 11:14 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Hello Brian,

I would love to set up a BPM preventing a quantity greater than present
on the job. I took a couple of the classes on BPMs at the conference,
but have not done one yet, how hard is this one to set up?

Tim

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian Roberts
Sent: Tuesday, May 22, 2012 8:58 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

You could turn off the "auto receive to inventory" on the last job
operation, and do a manual receipt from manufacturing. Of course, this
could lead to incorrect inventory if that manual entry is delayed or
that a typo is made in that quantity.. six of one error, half dozen of
another J

Here's another idea: a BPM on end activity that prevents reporting a
quantity, say greater than the job quantity.

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jobando018
Sent: Tuesday, May 22, 2012 10:20 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] MES Pre-approval

Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES?
We would like to see all the production activities submitted for a given
day and approve the quantities before moving them into inventory.Even if
there is not a pre-approval stage, are there any process in place that
you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into
inventory right after a MES user ends an activity. It can lead to
incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,

[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]
10
Correction, wherever you see rowmod = 'A' , change that to rowmod = 'U'

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Tuesday, May 22, 2012 11:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MES Pre-approval



Here is what you should do to make this work...

On the Labor BO, choose the update method

Create a preprocess BPM

Condition should be Number of rows in the [designed] query in not less than 1

In your designed query, paste this code in..

for each ttlabordtl where ttlabordtl.rowmod = 'A' and ttlabordtl.labortype = 'P'

this ensures this BPM will not fire for every labor transaction under the sun that doesn't have anything to do with completing production quantities against operations.

Under actions choose synchronously Execute 4GL code - execute code below

Paste the following code in the field

for each ttlabordtl where ttlabordtl.RowMod = 'A' no-lock.
find first joboper where joboper.company = ttlabordtl.company and joboper.jobnum = ttlabordtl.jobnum and joboper.AssemblySeq = ttlabordtl.AssemblySeq and joboper.OprSeq = ttlabordtl.OprSeq.
If avail joboper Then Do:
If joboper.QtyCompleted + ttlabordtl.LaborQty > joboper.RunQty then
{lib/PublishEx.i &ExMsg = "'There have already been ' + string(joboper.qtycompleted) + ' parts claimed complete. The Production quantity required for this operations is ' + string(joboper.runqty) + '.' + ' Your additional quantity of ' + string(ttlabordtl.laborqty) + ' will result in an over reported quantity'"}.
End.
End.

This solution works in 8.03.409c, but I can't fathom any reason it won't work in 9 unless they changed column names.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Brian Roberts
Sent: Tuesday, May 22, 2012 10:32 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Not sure how hard it will be, haven't done that one myself... but if
you've just taken a couple classes, time to practice...

To get you started: you'll probably want a method BPM on
Labor.EndActivity pre-processing (I think - do some tracing to make
sure). The quantity they are reporting should be in the
ttLaborDtl.LaborQty field, and start by just displaying an informational
message with that quantity in your BPM (no condition, just that one
action - do in your test environment of course). You'll need to figure
out where the job quantity is available, try writing the full dataset
during tracing or looking in the data dictionary. Add a condition for
LaborQty > job qty and when that is working properly, change your action
to raise exception instead of info message. Raising an exception in
pre-processing will abort the end activity before the data gets saved.

Thanks,

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
Of Tim Hollingsworth
Sent: Tuesday, May 22, 2012 11:14 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Hello Brian,

I would love to set up a BPM preventing a quantity greater than present
on the job. I took a couple of the classes on BPMs at the conference,
but have not done one yet, how hard is this one to set up?

Tim

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian Roberts
Sent: Tuesday, May 22, 2012 8:58 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

You could turn off the "auto receive to inventory" on the last job
operation, and do a manual receipt from manufacturing. Of course, this
could lead to incorrect inventory if that manual entry is delayed or
that a typo is made in that quantity.. six of one error, half dozen of
another J

Here's another idea: a BPM on end activity that prevents reporting a
quantity, say greater than the job quantity.

Brian.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jobando018
Sent: Tuesday, May 22, 2012 10:20 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] MES Pre-approval

Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES?
We would like to see all the production activities submitted for a given
day and approve the quantities before moving them into inventory.Even if
there is not a pre-approval stage, are there any process in place that
you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into
inventory right after a MES user ends an activity. It can lead to
incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,

[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]
11
Finally go a chance to put this in and it works great, Thanks!

Tim Hollingsworth
Cost Accountant
Sun Country Industries
(505) 998-1980 (office)
(703) 867-4400 (cell)
thollingsworth@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Tuesday, May 22, 2012 10:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] MES Pre-approval




Here is what you should do to make this work...

On the Labor BO, choose the update method

Create a preprocess BPM

Condition should be Number of rows in the [designed] query in not less
than 1

In your designed query, paste this code in..

for each ttlabordtl where ttlabordtl.rowmod = 'A' and
ttlabordtl.labortype = 'P'

this ensures this BPM will not fire for every labor transaction under
the sun that doesn't have anything to do with completing production
quantities against operations.

Under actions choose synchronously Execute 4GL code - execute code below

Paste the following code in the field

for each ttlabordtl where ttlabordtl.RowMod = 'A' no-lock.
find first joboper where joboper.company = ttlabordtl.company and
joboper.jobnum = ttlabordtl.jobnum and joboper.AssemblySeq =
ttlabordtl.AssemblySeq and joboper.OprSeq = ttlabordtl.OprSeq.
If avail joboper Then Do:
If joboper.QtyCompleted + ttlabordtl.LaborQty > joboper.RunQty then
{lib/PublishEx.i &ExMsg = "'There have already been ' +
string(joboper.qtycompleted) + ' parts claimed complete. The Production
quantity required for this operations is ' + string(joboper.runqty) +
'.' + ' Your additional quantity of ' + string(ttlabordtl.laborqty) + '
will result in an over reported quantity'"}.
End.
End.

This solution works in 8.03.409c, but I can't fathom any reason it won't
work in 9 unless they changed column names.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...
<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>
]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Brian Roberts
Sent: Tuesday, May 22, 2012 10:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Not sure how hard it will be, haven't done that one myself... but if
you've just taken a couple classes, time to practice...

To get you started: you'll probably want a method BPM on
Labor.EndActivity pre-processing (I think - do some tracing to make
sure). The quantity they are reporting should be in the
ttLaborDtl.LaborQty field, and start by just displaying an informational
message with that quantity in your BPM (no condition, just that one
action - do in your test environment of course). You'll need to figure
out where the job quantity is available, try writing the full dataset
during tracing or looking in the data dictionary. Add a condition for
LaborQty > job qty and when that is working properly, change your action
to raise exception instead of info message. Raising an exception in
pre-processing will abort the end activity before the data gets saved.

Thanks,

Brian.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Tim Hollingsworth
Sent: Tuesday, May 22, 2012 11:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

Hello Brian,

I would love to set up a BPM preventing a quantity greater than present
on the job. I took a couple of the classes on BPMs at the conference,
but have not done one yet, how hard is this one to set up?

Tim

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf
Of Brian Roberts
Sent: Tuesday, May 22, 2012 8:58 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] MES Pre-approval

You could turn off the "auto receive to inventory" on the last job
operation, and do a manual receipt from manufacturing. Of course, this
could lead to incorrect inventory if that manual entry is delayed or
that a typo is made in that quantity.. six of one error, half dozen of
another J

Here's another idea: a BPM on end activity that prevents reporting a
quantity, say greater than the job quantity.

Brian.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jobando018
Sent: Tuesday, May 22, 2012 10:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] MES Pre-approval

Good Morning Group,

Is there a pre-approval stage after a user has ended an activity in MES?
We would like to see all the production activities submitted for a given
day and approve the quantities before moving them into inventory.Even if
there is not a pre-approval stage, are there any process in place that
you have implemented to oversee MES transactions?

Manufacturing is concerned that all production is being moved into
inventory right after a MES user ends an activity. It can lead to
incorrect inventory if production is reported incorrectly.

Epicor 9.05.607a
SQL 64-bit
Windows Server 2008

Thanks,

[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]