E-9 configurator - Set Field on JobMtl.Description

Yahoo Archive
1
Turns out we had GetPartDefault as the last rule so it was wiping out the description. When I tested it I created another rule using the constant field and because it was after the GetpartDefault it worked. Basically we needed to set the getpartdefault rule first in the sequence than anything after that worked



________________________________
From: jckinneman <jckinneman@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 26, 2012 12:43 PM
Subject: [Vantage] Re: E-9 configurator - Set Field on JobMtl.Description


Â
that sounds like a bug but the quick work around would be to do the logic in the page on-leave statement. Create a new character control, hide it and then populate it with the value you need using an IF statement as needed. On the method rule just do a straight assignment.

Jim Kinneman
Encompass Solutions, Inc.

--- In mailto:vantage%40yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> If you open in customization mode and look at the job material description field it actually is the part.partdescription field, even though field help tells you it is jobmtl.description. If we write a method rule and use a constant expression (i.e. = orange) the description updates just fine. Its when we write an If statement to update the field that it doesnt update, although the IF statement works fine when you Test Inputs and also if we use it to populate another field such as jobmtl.character10
>
>
>
> ________________________________
> From: jckinneman <jckinneman@...>
> To: mailto:vantage%40yahoogroups.com
> Sent: Wednesday, July 25, 2012 6:15 PM
> Subject: [Vantage] Re: E-9 configurator - Set Field on JobMtl.Description
>
>
> ÂÂ
> Are there any other rules on that material? For example "Get Part Defaults", this would overwrite the description with the value from the part master.
>
> Jim Kinneman
> Encompass Solutions, Inc.
>
> --- In mailto:vantage%40yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> >
> > We have a method rule that sets a field for the job material part number and description. The rule works fine for the part number but does not update the material description field. If we use another field on the jobmtl table such as character10 it works fine and updates. The test inputs validates the expression, as does the fact that it updates the character10 field. This is a free form expression. Epicor support said they tried it on the job as configured and it worked, but our configurations are done on the sales order level and then order job wizard to create the job. When we create the job, the material part number is there without a description
> > ÂÂ
> > Anyone else trying to create a jobmtl.description from a configuration and any issues with it?
> >
> > [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
We have a method rule that sets a field for the job material part number and description. The rule works fine for the part number but does not update the material description field. If we use another field on the jobmtl table such as character10 it works fine and updates. The test inputs validates the expression, as does the fact that it updates the character10 field. This is a free form expression. Epicor support said they tried it on the job as configured and it worked, but our configurations are done on the sales order level and then order job wizard to create the job. When we create the job, the material part number is there without a description
Â
Anyone else trying to create a jobmtl.description from a configuration and any issues with it?

[Non-text portions of this message have been removed]
3
Are there any other rules on that material? For example "Get Part Defaults", this would overwrite the description with the value from the part master.

Jim Kinneman
Encompass Solutions, Inc.

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We have a method rule that sets a field for the job material part number and description. The rule works fine for the part number but does not update the material description field. If we use another field on the jobmtl table such as character10 it works fine and updates. The test inputs validates the expression, as does the fact that it updates the character10 field. This is a free form expression. Epicor support said they tried it on the job as configured and it worked, but our configurations are done on the sales order level and then order job wizard to create the job. When we create the job, the material part number is there without a description
> Â
> Anyone else trying to create a jobmtl.description from a configuration and any issues with it?
>
> [Non-text portions of this message have been removed]
>
4
If you open in customization mode and look at the job material description field it actually is the part.partdescription field, even though field help tells you it is jobmtl.description. If we write a method rule and use a constant expression (i.e. = orange) the description updates just fine. Its when we write an If statement to update the field that it doesnt update, although the IF statement works fine when you Test Inputs and also if we use it to populate another field such as jobmtl.character10



________________________________
From: jckinneman <jckinneman@...>
To: vantage@yahoogroups.com
Sent: Wednesday, July 25, 2012 6:15 PM
Subject: [Vantage] Re: E-9 configurator - Set Field on JobMtl.Description


Â
Are there any other rules on that material? For example "Get Part Defaults", this would overwrite the description with the value from the part master.

Jim Kinneman
Encompass Solutions, Inc.

--- In mailto:vantage%40yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We have a method rule that sets a field for the job material part number and description. The rule works fine for the part number but does not update the material description field. If we use another field on the jobmtl table such as character10 it works fine and updates. The test inputs validates the expression, as does the fact that it updates the character10 field. This is a free form expression. Epicor support said they tried it on the job as configured and it worked, but our configurations are done on the sales order level and then order job wizard to create the job. When we create the job, the material part number is there without a description
> Â
> Anyone else trying to create a jobmtl.description from a configuration and any issues with it?
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
5
that sounds like a bug but the quick work around would be to do the logic in the page on-leave statement. Create a new character control, hide it and then populate it with the value you need using an IF statement as needed. On the method rule just do a straight assignment.

Jim Kinneman
Encompass Solutions, Inc.

--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> If you open in customization mode and look at the job material description field it actually is the part.partdescription field, even though field help tells you it is jobmtl.description. If we write a method rule and use a constant expression (i.e. = orange) the description updates just fine. Its when we write an If statement to update the field that it doesnt update, although the IF statement works fine when you Test Inputs and also if we use it to populate another field such as jobmtl.character10
>
>
>
> ________________________________
> From: jckinneman <jckinneman@...>
> To: vantage@yahoogroups.com
> Sent: Wednesday, July 25, 2012 6:15 PM
> Subject: [Vantage] Re: E-9 configurator - Set Field on JobMtl.Description
>
>
> ÂÂ
> Are there any other rules on that material? For example "Get Part Defaults", this would overwrite the description with the value from the part master.
>
> Jim Kinneman
> Encompass Solutions, Inc.
>
> --- In mailto:vantage%40yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> >
> > We have a method rule that sets a field for the job material part number and description. The rule works fine for the part number but does not update the material description field. If we use another field on the jobmtl table such as character10 it works fine and updates. The test inputs validates the expression, as does the fact that it updates the character10 field. This is a free form expression. Epicor support said they tried it on the job as configured and it worked, but our configurations are done on the sales order level and then order job wizard to create the job. When we create the job, the material part number is there without a description
> > ÂÂ
> > Anyone else trying to create a jobmtl.description from a configuration and any issues with it?
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Thanks Jim, I had thought about the onleave rule. We have a webex with Epicor today to review it so will let you know what they say!



________________________________
From: jckinneman <jckinneman@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 26, 2012 12:43 PM
Subject: [Vantage] Re: E-9 configurator - Set Field on JobMtl.Description


Â
that sounds like a bug but the quick work around would be to do the logic in the page on-leave statement. Create a new character control, hide it and then populate it with the value you need using an IF statement as needed. On the method rule just do a straight assignment.

Jim Kinneman
Encompass Solutions, Inc.

--- In mailto:vantage%40yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> If you open in customization mode and look at the job material description field it actually is the part.partdescription field, even though field help tells you it is jobmtl.description. If we write a method rule and use a constant expression (i.e. = orange) the description updates just fine. Its when we write an If statement to update the field that it doesnt update, although the IF statement works fine when you Test Inputs and also if we use it to populate another field such as jobmtl.character10
>
>
>
> ________________________________
> From: jckinneman <jckinneman@...>
> To: mailto:vantage%40yahoogroups.com
> Sent: Wednesday, July 25, 2012 6:15 PM
> Subject: [Vantage] Re: E-9 configurator - Set Field on JobMtl.Description
>
>
> ÂÂ
> Are there any other rules on that material? For example "Get Part Defaults", this would overwrite the description with the value from the part master.
>
> Jim Kinneman
> Encompass Solutions, Inc.
>
> --- In mailto:vantage%40yahoogroups.com, Mark Wagner <mjfw2003@> wrote:
> >
> > We have a method rule that sets a field for the job material part number and description. The rule works fine for the part number but does not update the material description field. If we use another field on the jobmtl table such as character10 it works fine and updates. The test inputs validates the expression, as does the fact that it updates the character10 field. This is a free form expression. Epicor support said they tried it on the job as configured and it worked, but our configurations are done on the sales order level and then order job wizard to create the job. When we create the job, the material part number is there without a description
> > ÂÂ
> > Anyone else trying to create a jobmtl.description from a configuration and any issues with it?
> >
> > [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]