Vantage 8.03.405a BPM

Thanks. (Good to know.)
Rob

--- On Fri, 8/8/08, bw2868bond <bwalker@...> wrote:

From: bw2868bond <bwalker@...>
Subject: [Vantage] Re: Vantage 8.03.405a BPM
To: vantage@yahoogroups.com
Date: Friday, August 8, 2008, 7:02 AM






Rob,
I have had it happen once since going live on 8.00.811 almost two
years ago.

All the controls referenced this way survived the migration from
8.00.811 to 8.03.405 (showing how little actually gets re-written?? )

Maybe one of the good (??) features of 4xx is the customization
maintenance where this stuff gets checked.

I have used hidden, off the form controls too, but when you need to
delete they can be a pain to find.

bw

--- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...>
wrote:
>
> Bernie,
>
> When your code makes direct Native Control References (or whatever
they are called in Vantage-speak) as you did in:
>
> chkLockQty = CType(csm.GetNative ControlReference ("7c0f77d2- d26c-
4917- 8dd7-bef84066121 e"), EpiCheckBox)
>
> ...Doesn't this risk code failure after an upgrade? Don't the
ControlReference IDs often (enough) change after an upgrade to make
this a bit of a headache?
>
> ????
>
> Rob Brown
>
> --- On Thu, 8/7/08, Bernie Walker <bwalker@... > wrote:
> From: Bernie Walker <bwalker@... >
> Subject: RE: [Vantage] Re: Vantage 8.03.405a BPM
> To: "'vantage@yahoogroup s.com'" <vantage@yahoogroups .com>
> Date: Thursday, August 7, 2008, 1:27 PM
>
>
>
>
>
>
>
>
>
>
>
> For all the interested parties - here is the UI
customization. Requires no BPM.
>
>
>
> Module Script
>
>
>
> '// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard
Added Module Level Variables' Comments! **
>
> '// Begin Wizard Added Module Level Variables **
>
>
>
> Private WithEvents edvPORel As EpiDataView
>
> '// End Wizard Added Module Level Variables **
>
>
>
> '// Add Custom Module Level Variables Here **
>
> Private WithEvents chkLockQty As EpiCheckBox
>
>
>
> Sub InitializeCustomCod e()
>
>
>
> '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard
Added Variable Intialization' lines **
>
> '// Begin Wizard Added Variable Intialization
>
>
>
> edvPORel = CType(oTrans. EpiDataViews( "PORel"), EpiDataView)
>
>
>
> '// End Wizard Added Variable Intialization
>
> '// Begin Custom Method Calls
>
>
>
> '// End Custom Method Calls
>
>
>
> End Sub
>
>
>
> Sub DestroyCustomCode( )
>
>
>
> '// ** Wizard Insert Location - Do not delete 'Begin/End Wizard
Added Object Disposal' lines **
>
> '// Begin Wizard Added Object Disposal
>
>
>
> '// End Wizard Added Object Disposal
>
> '// Begin Custom Code Disposal
>
>
>
> '// End Custom Code Disposal
>
> End Sub
>
>
>
> Private Sub POEntryForm_ Load(ByVal sender As object, ByVal args As
EventArgs) Handles POEntryForm. Load
>
> '//
>
> '// Add Event Handler Code
>
> '//
>
> chkLockQty = CType(csm.GetNative ControlReference
("7c0f77d2- d26c-4917- 8dd7-bef e"), EpiCheckBox)
>
> End Sub
>
>
>
> Private Sub edvPORel_EpiViewNot ification( view As EpiDataView,
args As EpiNotifyArgs) Handles edvPORel.EpiViewNot ification
>
> '// ** Argument Properties and Uses **
>
> '// view.dataView( args.Row) ("[FieldName] ")
>
> '// args.Row, args.Column, args.Sender,
args.NotifyType
>
> '// NotifyType.Initiali ze, NotifyType.AddRow,
NotifyType.DeleteRo w, NotifyType.InitLast View, NotifyType.InitAndR
esetTreeNodes
>
> If (args.NotifyType. ToString( ) = "AddRow") Then
>
> view.dataView( args.Row) ("LockQty" ) = True
>
> End If
>
>
>
> End Sub
>
>
>
> Private Sub POEntryForm_ Closing(ByVal sender As object, ByVal args
As System.ComponentMod el.CancelEventAr gs) Handles POEntryForm.
Closing
>
> '//
>
> '// Add Event Handler Code
>
> '//
>
> oTrans.Update( )
>
> End Sub
>
>
>
> Private Sub chkLockQty_CheckedC hanged(ByVal Sender As Object,
ByVal Args As System.EventArgs) Handles chkLockQty.CheckedC hanged
>
> '// ** Place Event Handling Code Here **
>
> If Not chkLockQty.Checked Then
>
> chkLockQty.Checked = True
>
> oTrans.Update( )
>
> End If
>
> End Sub
>
>
>
> End Module
>
>
>
> -----Original Message-----
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf Of Kunal Ganguly
>
> Sent: Thursday, August 07, 2008 9:05 AM
>
> To: vantage@yahoogroups .com
>
> Subject: Re: [Vantage] Re: Vantage 8.03.405a BPM
>
>
>
> BW,
>
>
>
> I'm really curious to know if that worked for you - I never could
coax comxref into cooperating. I ran into the same issue quite some
time back and needed up setting the values for lockqty like so:
>
Trying to create a BPM that will set the PORel.LockQty field to true on
new release lines.

Created a PreProcess Directive on the PO Update Method:

Condition: the PORel.LockQty field of the added row is equal to the
false value

Action: set the PORel.LockQty field of the added row to the true value

I have verified that the condition is met by using an informational
message. The LockQty field is not being set to true.

Can anyone offer insight on how to accomplish this, or spot a flaw in
the rather obvious logic?

Thanks,

Bernie.
Bernie:

You may want to use 4GL code in the action section instead of relying on
Vantage's action wizard.

For each ttporel where (ttporel.rowmod = 'A') and ttporel.lockqty = true.
Assign ttporel.lockqty = false. End.

Carl Peterson
Nexus Software, Inc.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Wednesday, August 06, 2008 8:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03.405a BPM

Trying to create a BPM that will set the PORel.LockQty field to true on
new release lines.

Created a PreProcess Directive on the PO Update Method:

Condition: the PORel.LockQty field of the added row is equal to the
false value

Action: set the PORel.LockQty field of the added row to the true value

I have verified that the condition is met by using an informational
message. The LockQty field is not being set to true.

Can anyone offer insight on how to accomplish this, or spot a flaw in
the rather obvious logic?

Thanks,

Bernie.



[Non-text portions of this message have been removed]
Please pardon my crashing this thread.Â
Â
I'm trying to get up to speed on BPMs and find these discussions to be most valuable.Â
Â
I looked in the Vantage Data Dictionary and in our database (we're on Vantage 8.03.405) via SQL Server Management Studio and found no LockQty field in table PORel. What am I missing? Is this field only available in the temp table, ttporel? Also, how can I see a list of all temp tables and their fields?
Â
Thanks in advance for any information anyone would like to share along these lines.
Â
Ahmet ErispahaÂ

--- On Wed, 8/6/08, Carl Peterson <cpeterson@...> wrote:

From: Carl Peterson <cpeterson@...>
Subject: RE: [Vantage] Vantage 8.03.405a BPM
To: vantage@yahoogroups.com
Date: Wednesday, August 6, 2008, 9:07 AM






Bernie:

You may want to use 4GL code in the action section instead of relying on
Vantage's action wizard.

For each ttporel where (ttporel.rowmod = 'A') and ttporel.lockqty = true.
Assign ttporel.lockqty = false. End.

Carl Peterson
Nexus Software, Inc.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
bw2868bond
Sent: Wednesday, August 06, 2008 8:29 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Vantage 8.03.405a BPM

Trying to create a BPM that will set the PORel.LockQty field to true on
new release lines.

Created a PreProcess Directive on the PO Update Method:

Condition: the PORel.LockQty field of the added row is equal to the
false value

Action: set the PORel.LockQty field of the added row to the true value

I have verified that the condition is met by using an informational
message. The LockQty field is not being set to true.

Can anyone offer insight on how to accomplish this, or spot a flaw in
the rather obvious logic?

Thanks,

Bernie.


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


















[Non-text portions of this message have been removed]
No worries in jumping in on the thread :o)

The more, the merrier.

The LockQty and LockDate fields referenced in the temp tables (also
the EpiDataViews on the form) are not stored in the PORel table -
which is why I most likely am having difficulty. I tried to set
directly through 4GL code and alas, that did not work either.

My next step will be to try and set the values in the COMXref table
where the values are truely stored via a post process directive and
4GL code. I will post my results as there may be others out there
that would like to make use of automatically setting these fields as
it helps reduce suggestions generated by MRP.

--- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@...>
wrote:
>
> Please pardon my crashing this thread.Â
> Â
> I'm trying to get up to speed on BPMs and find these discussions to
be most valuable.Â
> Â
> I looked in the Vantage Data Dictionary and in our database (we're
on Vantage 8.03.405) via SQL Server Management Studio and found no
LockQty field in table PORel. What am I missing? Is this field only
available in the temp table, ttporel? Also, how can I see a list of
all temp tables and their fields?
> Â
> Thanks in advance for any information anyone would like to share
along these lines.
> Â
> Ahmet ErispahaÂ
>
> --- On Wed, 8/6/08, Carl Peterson <cpeterson@...> wrote:
>
> From: Carl Peterson <cpeterson@...>
> Subject: RE: [Vantage] Vantage 8.03.405a BPM
> To: vantage@yahoogroups.com
> Date: Wednesday, August 6, 2008, 9:07 AM
>
>
>
>
>
>
> Bernie:
>
> You may want to use 4GL code in the action section instead of
relying on
> Vantage's action wizard.
>
> For each ttporel where (ttporel.rowmod = 'A') and ttporel.lockqty =
true.
> Assign ttporel.lockqty = false. End.
>
> Carl Peterson
> Nexus Software, Inc.
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf Of
> bw2868bond
> Sent: Wednesday, August 06, 2008 8:29 AM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Vantage 8.03.405a BPM
>
> Trying to create a BPM that will set the PORel.LockQty field to
true on
> new release lines.
>
> Created a PreProcess Directive on the PO Update Method:
>
> Condition: the PORel.LockQty field of the added row is equal to the
> false value
>
> Action: set the PORel.LockQty field of the added row to the true
value
>
> I have verified that the condition is met by using an informational
> message. The LockQty field is not being set to true.
>
> Can anyone offer insight on how to accomplish this, or spot a flaw
in
> the rather obvious logic?
>
> Thanks,
>
> Bernie.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Thanks, Bernie. And good luck.
Â
Ahmet Erispaha

--- On Wed, 8/6/08, bw2868bond <bwalker@...> wrote:

From: bw2868bond <bwalker@...>
Subject: [Vantage] Re: Vantage 8.03.405a BPM
To: vantage@yahoogroups.com
Date: Wednesday, August 6, 2008, 10:11 AM






No worries in jumping in on the thread :o)

The more, the merrier.

The LockQty and LockDate fields referenced in the temp tables (also
the EpiDataViews on the form) are not stored in the PORel table -
which is why I most likely am having difficulty. I tried to set
directly through 4GL code and alas, that did not work either.

My next step will be to try and set the values in the COMXref table
where the values are truely stored via a post process directive and
4GL code. I will post my results as there may be others out there
that would like to make use of automatically setting these fields as
it helps reduce suggestions generated by MRP.

--- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ ...>
wrote:
>
> Please pardon my crashing this thread.Â
> Â
> I'm trying to get up to speed on BPMs and find these discussions to
be most valuable.Â
> Â
> I looked in the Vantage Data Dictionary and in our database (we're
on Vantage 8.03.405) via SQL Server Management Studio and found no
LockQty field in table PORel. What am I missing? Is this field only
available in the temp table, ttporel? Also, how can I see a list of
all temp tables and their fields?
> Â
> Thanks in advance for any information anyone would like to share
along these lines.
> Â
> Ahmet ErispahaÂ
>
> --- On Wed, 8/6/08, Carl Peterson <cpeterson@. ..> wrote:
>
> From: Carl Peterson <cpeterson@. ..>
> Subject: RE: [Vantage] Vantage 8.03.405a BPM
> To: vantage@yahoogroups .com
> Date: Wednesday, August 6, 2008, 9:07 AM
>
>
>
>
>
>
> Bernie:
>
> You may want to use 4GL code in the action section instead of
relying on
> Vantage's action wizard.
>
> For each ttporel where (ttporel.rowmod = 'A') and ttporel.lockqty =
true.
> Assign ttporel.lockqty = false. End.
>
> Carl Peterson
> Nexus Software, Inc.
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf Of
> bw2868bond
> Sent: Wednesday, August 06, 2008 8:29 AM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Vantage 8.03.405a BPM
>
> Trying to create a BPM that will set the PORel.LockQty field to
true on
> new release lines.
>
> Created a PreProcess Directive on the PO Update Method:
>
> Condition: the PORel.LockQty field of the added row is equal to the
> false value
>
> Action: set the PORel.LockQty field of the added row to the true
value
>
> I have verified that the condition is met by using an informational
> message. The LockQty field is not being set to true.
>
> Can anyone offer insight on how to accomplish this, or spot a flaw
in
> the rather obvious logic?
>
> Thanks,
>
> Bernie.
>
>
> [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]
I totally gave up on BPM

I too did tracing. I had BPM set the value. All the values in the dataset were always true - Even when update was called, value was still true. As soon as update finished, value was back to false! Absolute madness.

I ended up coding the value in the form

________________________________

Bernie -

I am running into the same problem on 404a. The informational message will display but when I try to update a field with a value it doesn't fire. The trace doesn't even show the action.
I have also tried 4GL and .NET code and those don't fire either.

Have been on hold with support and not getting too far with Epicor on this one either.

Have you found a way around this?

Thanks in advance,
Calvin


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bw2868bond
Sent: Wednesday, August 06, 2008 7:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03.405a BPM


Trying to create a BPM that will set the PORel.LockQty field to true on
new release lines.

Created a PreProcess Directive on the PO Update Method:

Condition: the PORel.LockQty field of the added row is equal to the
false value

Action: set the PORel.LockQty field of the added row to the true value

I have verified that the condition is met by using an informational
message. The LockQty field is not being set to true.

Can anyone offer insight on how to accomplish this, or spot a flaw in
the rather obvious logic?

Thanks,

Bernie.



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



I think you need this to be a post-process directive.



You are setting the value first then the update is being called and
setting everything as originally programmed.



If you make it a post-process the original processing take place then
your new coding processes.



Hope this helps.

Dale Schuerman

Senior Consultant


RAM Software Systems, Inc.
1701 North Collins Suite 200
Richardson, Texas 75080
Phone: (972) 669-0763
Fax: (972) 669-9603
Web Site: www.ramsys.com <blocked::http://www.ramsys.com/>

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bernie Walker
Sent: Wednesday, August 06, 2008 2:13 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Vantage 8.03.405a BPM



I totally gave up on BPM

I too did tracing. I had BPM set the value. All the values in the
dataset were always true - Even when update was called, value was still
true. As soon as update finished, value was back to false! Absolute
madness.

I ended up coding the value in the form

________________________________

Bernie -

I am running into the same problem on 404a. The informational message
will display but when I try to update a field with a value it doesn't
fire. The trace doesn't even show the action.
I have also tried 4GL and .NET code and those don't fire either.

Have been on hold with support and not getting too far with Epicor on
this one either.

Have you found a way around this?

Thanks in advance,
Calvin

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of bw2868bond
Sent: Wednesday, August 06, 2008 7:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03.405a BPM

Trying to create a BPM that will set the PORel.LockQty field to true on
new release lines.

Created a PreProcess Directive on the PO Update Method:

Condition: the PORel.LockQty field of the added row is equal to the
false value

Action: set the PORel.LockQty field of the added row to the true value

I have verified that the condition is met by using an informational
message. The LockQty field is not being set to true.

Can anyone offer insight on how to accomplish this, or spot a flaw in
the rather obvious logic?

Thanks,

Bernie.

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





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



Is there a 'get new' method for PO Rel ? Have you tried setting the
value as a post process directive there ? (It relies on the user not
changing it - depends how disciplined your users are).



kind regards



Debbie Stokes

Vantage Administrator

Hilo-PSS Group

01793 647136



*******************************************************************************************************************************************************************************************************************************************************************************
This email is intended for the addressee only and may contain information that is privileged and confidential. If you are not the intended recipient, you must not copy, distribute or take any
action in reliance on it. If this email has been sent to you in error, please notify us immediately by telephone.
This has been transmitted by -

Hilo-PSS Group
Murdock Road
Dorcan Industrial Estate
Swindon

SN3 5HY

Company Registration No: 01028915.

The views within this email are those of the author and not
necessarily those of Planned Storage Systems Ltd.

** This email has been scanned for viruses, vandals and malicious content **
************************************************************************************************************************************************************************************************



[Non-text portions of this message have been removed]
Actually it required two different directives. When new line is
created and saved, backend logic or db trigger automagically create
release 1 with no trappable method call. Therefore I used post
process directive on PO.Update where RowMod is 'A'. I used a second
post process directive on the GetNewPORel method to set the field
value to true. This all worked - the value was set in the
EpiDataViews. The value persisted throughout all other method calls
and was passed to the PO.Update method. After the update the value
changed back to false.

This has been confirmed by at least one other person who contacted me
offline.

Sounds like this would be a *fine* example for them to demonstrate at
Perspectives in a lab :>

bw

--- In vantage@yahoogroups.com, "Debbie Stokes" <debbie.stokes@...>
wrote:
>
> Hi guys,
>
>
>
> Is there a 'get new' method for PO Rel ? Have you tried setting the
> value as a post process directive there ? (It relies on the user not
> changing it - depends how disciplined your users are).
>
>
>
> kind regards
>
>
>
> Debbie Stokes
>
> Vantage Administrator
>
> Hilo-PSS Group
>
> 01793 647136
>
>
>
>
Bernie,

You can do it via BPM.

Use po.update

Update the po locked qty in the temp table

Find the XComRef record for the po release and update
this via table buffer.



Regards,

Stephen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: 07 August 2008 12:13
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03.405a BPM



Actually it required two different directives. When new line is
created and saved, backend logic or db trigger automagically create
release 1 with no trappable method call. Therefore I used post
process directive on PO.Update where RowMod is 'A'. I used a second
post process directive on the GetNewPORel method to set the field
value to true. This all worked - the value was set in the
EpiDataViews. The value persisted throughout all other method calls
and was passed to the PO.Update method. After the update the value
changed back to false.

This has been confirmed by at least one other person who contacted me
offline.

Sounds like this would be a *fine* example for them to demonstrate at
Perspectives in a lab :>

bw

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Debbie Stokes" <debbie.stokes@...>
wrote:
>
> Hi guys,
>
>
>
> Is there a 'get new' method for PO Rel ? Have you tried setting the
> value as a post process directive there ? (It relies on the user not
> changing it - depends how disciplined your users are).
>
>
>
> kind regards
>
>
>
> Debbie Stokes
>
> Vantage Administrator
>
> Hilo-PSS Group
>
> 01793 647136
>
>
>
>



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

I'm really curious to know if that worked for you - I never could coax comxref into cooperating. I ran into the same issue quite some time back and needed up setting the values for lockqty like so:

Private Sub PORel_AfterFieldChange(ByVal sender As object, ByVal args As DataColumnChangeEventArgs) Handles PORel_Column.ColumnChanged
Dim edv As EpiDataView = CType(oTrans.EpiDataViews("PORel"), EpiDataView)
Select Case args.Column.ColumnName
Case "DueDate"
edv.dataView(edv.Row)("PromiseDt") = edv.dataView(edv.Row)("DueDate")
edv.dataView(edv.Row)("LockQty") = True
Case "PromiseDt"
edv.dataView(edv.Row)("LockQty") = True
Case "XRelQty"
edv.dataView(edv.Row)("LockQty") = True
Case Else
End Select
End Sub


At the end of some more processing, I am initiating a save event to make sure the changes are carried over. I'm not too happy with this since the user has to make one of the 3 changes for this to take effect, but our purchasing dept ALWAYS sets one of those, if not all. Nevertheless, I really want to try something more reliable.

Thanks,
Kunal



----- Original Message ----
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Wednesday, August 6, 2008 9:11:34 AM
Subject: [Vantage] Re: Vantage 8.03.405a BPM


No worries in jumping in on the thread :o)

The more, the merrier.

The LockQty and LockDate fields referenced in the temp tables (also
the EpiDataViews on the form) are not stored in the PORel table -
which is why I most likely am having difficulty. I tried to set
directly through 4GL code and alas, that did not work either.

My next step will be to try and set the values in the COMXref table
where the values are truely stored via a post process directive and
4GL code. I will post my results as there may be others out there
that would like to make use of automatically setting these fields as
it helps reduce suggestions generated by MRP.

--- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ ...>
wrote:
>
> Please pardon my crashing this thread.
>
> I'm trying to get up to speed on BPMs and find these discussions to
be most valuable.
>
> I looked in the Vantage Data Dictionary and in our database (we're
on Vantage 8.03.405) via SQL Server Management Studio and found no
LockQty field in table PORel. What am I missing? Is this field only
available in the temp table, ttporel? Also, how can I see a list of
all temp tables and their fields?
>
> Thanks in advance for any information anyone would like to share
along these lines.
>
> Ahmet Erispaha
>
> --- On Wed, 8/6/08, Carl Peterson <cpeterson@. ..> wrote:
>
> From: Carl Peterson <cpeterson@. ..>
> Subject: RE: [Vantage] Vantage 8.03.405a BPM
> To: vantage@yahoogroups .com
> Date: Wednesday, August 6, 2008, 9:07 AM
>
>
>
>
>
>
> Bernie:
>
> You may want to use 4GL code in the action section instead of
relying on
> Vantage's action wizard.
>
> For each ttporel where (ttporel.rowmod = 'A') and ttporel.lockqty =
true.
> Assign ttporel.lockqty = false. End.
>
> Carl Peterson
> Nexus Software, Inc.
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf Of
> bw2868bond
> Sent: Wednesday, August 06, 2008 8:29 AM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Vantage 8.03.405a BPM
>
> Trying to create a BPM that will set the PORel.LockQty field to
true on
> new release lines.
>
> Created a PreProcess Directive on the PO Update Method:
>
> Condition: the PORel.LockQty field of the added row is equal to the
> false value
>
> Action: set the PORel.LockQty field of the added row to the true
value
>
> I have verified that the condition is met by using an informational
> message. The LockQty field is not being set to true.
>
> Can anyone offer insight on how to accomplish this, or spot a flaw
in
> the rather obvious logic?
>
> Thanks,
>
> Bernie.
>
>
> [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]
Stephen,
I made a PO.Update pre process directive based on "for each ttporel
where ttporel.rowmod = 'A'". First release on po line is never
detected. Subsequent releases are detected.

Using the base form, I enterd a PO, 1 line, 2 releases. after all
done entering, COMXref only has line 1, release 1, as a record.
Release 2 is not even there

I will stick with the UI customization.

Thanks.




--- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@...>
wrote:
>
> Bernie,
>
> You can do it via BPM.
>
> Use po.update
>
> Update the po locked qty in the temp table
>
> Find the XComRef record for the po release and
update
> this via table buffer.
>
>
>
> Regards,
>
> Stephen
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of bw2868bond
> Sent: 07 August 2008 12:13
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 8.03.405a BPM
>
>
>
> Actually it required two different directives. When new line is
> created and saved, backend logic or db trigger automagically create
> release 1 with no trappable method call. Therefore I used post
> process directive on PO.Update where RowMod is 'A'. I used a second
> post process directive on the GetNewPORel method to set the field
> value to true. This all worked - the value was set in the
> EpiDataViews. The value persisted throughout all other method calls
> and was passed to the PO.Update method. After the update the value
> changed back to false.
>
> This has been confirmed by at least one other person who contacted
me
> offline.
>
> Sounds like this would be a *fine* example for them to demonstrate
at
> Perspectives in a lab :>
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Debbie Stokes" <debbie.stokes@>
> wrote:
> >
> > Hi guys,
> >
> >
> >
> > Is there a 'get new' method for PO Rel ? Have you tried setting
the
> > value as a post process directive there ? (It relies on the user
not
> > changing it - depends how disciplined your users are).
> >
> >
> >
> > kind regards
> >
> >
> >
> > Debbie Stokes
> >
> > Vantage Administrator
> >
> > Hilo-PSS Group
> >
> > 01793 647136
> >
> >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>
Drop the rowmod = "A"

And it will work



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: 07 August 2008 15:30
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03.405a BPM



Stephen,
I made a PO.Update pre process directive based on "for each ttporel
where ttporel.rowmod = 'A'". First release on po line is never
detected. Subsequent releases are detected.

Using the base form, I enterd a PO, 1 line, 2 releases. after all
done entering, COMXref only has line 1, release 1, as a record.
Release 2 is not even there

I will stick with the UI customization.

Thanks.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Stephen Edginton" <stephene@...>
wrote:
>
> Bernie,
>
> You can do it via BPM.
>
> Use po.update
>
> Update the po locked qty in the temp table
>
> Find the XComRef record for the po release and
update
> this via table buffer.
>
>
>
> Regards,
>
> Stephen
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of bw2868bond
> Sent: 07 August 2008 12:13
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Vantage 8.03.405a BPM
>
>
>
> Actually it required two different directives. When new line is
> created and saved, backend logic or db trigger automagically create
> release 1 with no trappable method call. Therefore I used post
> process directive on PO.Update where RowMod is 'A'. I used a second
> post process directive on the GetNewPORel method to set the field
> value to true. This all worked - the value was set in the
> EpiDataViews. The value persisted throughout all other method calls
> and was passed to the PO.Update method. After the update the value
> changed back to false.
>
> This has been confirmed by at least one other person who contacted
me
> offline.
>
> Sounds like this would be a *fine* example for them to demonstrate
at
> Perspectives in a lab :>
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Debbie Stokes" <debbie.stokes@>
> wrote:
> >
> > Hi guys,
> >
> >
> >
> > Is there a 'get new' method for PO Rel ? Have you tried setting
the
> > value as a post process directive there ? (It relies on the user
not
> > changing it - depends how disciplined your users are).
> >
> >
> >
> > kind regards
> >
> >
> >
> > Debbie Stokes
> >
> > Vantage Administrator
> >
> > Hilo-PSS Group
> >
> > 01793 647136
> >
> >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
And make it post process.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: 07 August 2008 15:30
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03.405a BPM



Stephen,
I made a PO.Update pre process directive based on "for each ttporel
where ttporel.rowmod = 'A'". First release on po line is never
detected. Subsequent releases are detected.

Using the base form, I enterd a PO, 1 line, 2 releases. after all
done entering, COMXref only has line 1, release 1, as a record.
Release 2 is not even there

I will stick with the UI customization.

Thanks.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Stephen Edginton" <stephene@...>
wrote:
>
> Bernie,
>
> You can do it via BPM.
>
> Use po.update
>
> Update the po locked qty in the temp table
>
> Find the XComRef record for the po release and
update
> this via table buffer.
>
>
>
> Regards,
>
> Stephen
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of bw2868bond
> Sent: 07 August 2008 12:13
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Vantage 8.03.405a BPM
>
>
>
> Actually it required two different directives. When new line is
> created and saved, backend logic or db trigger automagically create
> release 1 with no trappable method call. Therefore I used post
> process directive on PO.Update where RowMod is 'A'. I used a second
> post process directive on the GetNewPORel method to set the field
> value to true. This all worked - the value was set in the
> EpiDataViews. The value persisted throughout all other method calls
> and was passed to the PO.Update method. After the update the value
> changed back to false.
>
> This has been confirmed by at least one other person who contacted
me
> offline.
>
> Sounds like this would be a *fine* example for them to demonstrate
at
> Perspectives in a lab :>
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Debbie Stokes" <debbie.stokes@>
> wrote:
> >
> > Hi guys,
> >
> >
> >
> > Is there a 'get new' method for PO Rel ? Have you tried setting
the
> > value as a post process directive there ? (It relies on the user
not
> > changing it - depends how disciplined your users are).
> >
> >
> >
> > kind regards
> >
> >
> >
> > Debbie Stokes
> >
> > Vantage Administrator
> >
> > Hilo-PSS Group
> >
> > 01793 647136
> >
> >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>





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

>
> Drop the ROWMOD="A"...And make it post process.
>

This is what I did but I think that had the effect of locking the quantities
on releases where the buyer cleared the box intentionally, especially on PO
changes.

If Bernie's observations are true (a trigger is firing after the business
object's code) then that's NOT good object oriented design. ALL code for an
object should be encapsulated in the object.

Epicor should do a code review of all database triggers and make sure that
they are only fired from Business Objects otherwise the entire framework is
unreliable.

Mark W.
This effectively captures the necessary 'new' events:
PO.Update Pre Process Directive Condition:
number of rows in the 'New PORel' query is not less than 1
or number of rows in the 'New POLine' query is not less than 1

The queries are simple: for each ttporel where ttporel.rowmod = 'A'
and for each ttpodetail where ttpodetail.rowmod = 'A'

The Action: enable dependent post process directives

In each case, the post process field to set is ttPORel.LockQty = true
for all unchanged rows.

This basically checks the Lock Qty checkbox on the form
I could also write the correct value to the COMXref table in a 4GL
action except for some minute sticking points.....

Create a new PO. Assign Supplier. Assign Buyer. Add new PO Line. Set
our qty. Set Vendor Qty. Click Save. Exit PO Entry. Guess what? There
is no COMXref record to modify....

Bad Vantage, Bad......... :(


--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Stephen wrote:
>
> >
> > Drop the ROWMOD="A"...And make it post process.
> >
>
> This is what I did but I think that had the effect of locking the
quantities
> on releases where the buyer cleared the box intentionally,
especially on PO
> changes.
>
> If Bernie's observations are true (a trigger is firing after the
business
> object's code) then that's NOT good object oriented design. ALL
code for an
> object should be encapsulated in the object.
>
> Epicor should do a code review of all database triggers and make
sure that
> they are only fired from Business Objects otherwise the entire
framework is
> unreliable.
>
> Mark W.
>
OK,

I've been on the phone with the Vantage MEXICAN tech support for over an hour. I've talked to three different people. They still can't tell me how to get Vantage 803 MES running. Everything seems to be setup fine. However after logging into the Vantage MES screen, nothing happens...no error, nothing.

Any ideas??

Also, does anyone know of a way to talk to an AMERICAN tech support person with Epicor? The $29,0000 that I pay for support doesn't' seem to allow me a 10 minute conversation with a someone that can help me. It's almost not worth it.

Thanks
Paul Lipham
I. S. Manager
Alabama Specialty Products, Inc.



[Non-text portions of this message have been removed]
On the server are you able to open the MES menu item?

Have you entered the license for MES.

Does the shortcut point to something like this

C:\epicor\mfgsys803\client\MfgSys.exe -MES



Do you get prompted for the login script.

Do you have enabled single sign on enabled.



These may help us identify what could be at fault.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul Lipham
Sent: 07 August 2008 17:30
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03.404A



OK,

I've been on the phone with the Vantage MEXICAN tech support for over an
hour. I've talked to three different people. They still can't tell me
how to get Vantage 803 MES running. Everything seems to be setup fine.
However after logging into the Vantage MES screen, nothing happens...no
error, nothing.

Any ideas??

Also, does anyone know of a way to talk to an AMERICAN tech support
person with Epicor? The $29,0000 that I pay for support doesn't' seem to
allow me a 10 minute conversation with a someone that can help me. It's
almost not worth it.

Thanks
Paul Lipham
I. S. Manager
Alabama Specialty Products, Inc.

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



[Non-text portions of this message have been removed]
I can open the MES menu item on the server, but the same as the client after entering my user and password nothing happens.

I have entered the license for MES

The shortcut points exactly to the path you described below.

I do get prompted for user and password.

As far as single sign on, I haven't changed it, so whatever the default is what I have in place.

Again, thanks for any help.

Paul L.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Stephen Edginton
Sent: Thursday, August 07, 2008 11:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.404A


On the server are you able to open the MES menu item?

Have you entered the license for MES.

Does the shortcut point to something like this

C:\epicor\mfgsys803\client\MfgSys.exe -MES

Do you get prompted for the login script.

Do you have enabled single sign on enabled.

These may help us identify what could be at fault.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Paul Lipham
Sent: 07 August 2008 17:30
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03.404A

OK,

I've been on the phone with the Vantage MEXICAN tech support for over an
hour. I've talked to three different people. They still can't tell me
how to get Vantage 803 MES running. Everything seems to be setup fine.
However after logging into the Vantage MES screen, nothing happens...no
error, nothing.

Any ideas??

Also, does anyone know of a way to talk to an AMERICAN tech support
person with Epicor? The $29,0000 that I pay for support doesn't' seem to
allow me a 10 minute conversation with a someone that can help me. It's
almost not worth it.

Thanks
Paul Lipham
I. S. Manager
Alabama Specialty Products, Inc.

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