Configurator - Populating fields in order entry

system · May 12, 2010, 12:08pm

Honestly, I'm not sure, but I would try a couple of things because I substituted the character08 field in mine with some text and go no errors. First, put the run statement on a separate line. Second, since the error had to do with integers, I would try defining the ordernum and orderline as integer fields to make sure to remove the decimals. My decimal fields do have the format defined as >>>>>9 for ordernum and >>9 for line. You can also try to add "Int" to the code. Ex: Int(P01_NUM_ORDERNUM) and Int(P01_NUM_LINENUM).

Tara K. Madia
ERP Systems Analyst
Sabre Industries, Inc.
Direct Line: (817) 852-1828
Email: tmadia@...<mailto:tmadia@...>

From: Blake Clemens [mailto:blake.clemens@...]
Sent: Wednesday, May 12, 2010 10:15 AM
To: vantage@yahoogroups.com
Cc: Tara Madia
Subject: RE: [Vantage] Re: Configurator - Populating fields in order entry

Tara,
I'm trying to use this programming and receive the below error... any thoughts?

If P01_CHK_FINAL = TRUE Then Do:
Find First OrderDtl Where OrderDtl.Company = "DMC" And OrderDtl.OrderNum = P01_NUM_ORDERNUM And OrderDtl.OrderLine = P01_NUM_LINENUM no-lock no-error. Run \\appserver05\epicor\mfgsys803\server\lib\UpdateTableBuffer.p<file:///\\appserver05\epicor\mfgsys803\server\lib\UpdateTableBuffer.p> (input BUFFER OrderDtl:HANDLE, 'Character08', "ABC").
End.

[cid:image001.png@01CAF1C0.569EC120]

Thanks,
Blake Clemens
IT Systems Engineer
Delmarva Millwork Corporation
(800) 360-2364 x132
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tara Madia
Sent: Wednesday, May 12, 2010 10:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Configurator - Populating fields in order entry

S18 & S19 are decimal fields. These fields are auto-populated with the current OrderNum and OrderLine when the configurator first opens so there is no data mismatch possible when populating other fields in the OrderDtl table.

Tara K. Madia
ERP Systems Analyst
Sabre Industries, Inc.
Direct Line: (817) 852-1828
Email: tmadia@...<mailto:tmadia%40sabrecom.com><mailto:tmadia@...<mailto:tmadia%40sabrecom.com>>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Blake Clemens
Sent: Wednesday, May 12, 2010 9:46 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Configurator - Populating fields in order entry

Tara,

Your field S18... what kind of field is it? Character, decimal?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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 Tara Madia
Sent: Wednesday, May 12, 2010 10:03 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Configurator - Populating fields in order entry

Not a BPM really. Just a statement in the on leave. Here are a couple examples of the code. The first is just a using a field from my configurator. The second is a also a field, but a combo box pulling the option for prodcode from the table. All of my field names begin with "S". You must qualify the company, ordernum, and order line before you can write to it. Hope this helps!

If S20 = "Utility" And S18 > 0 and S19 > 0 Then Do:
Find First OrderDtl Where OrderDtl.Company = "SCC" And OrderDtl.OrderNum = S18 And OrderDtl.OrderLine = S19 no-lock no-error.
Run \\epicor-sc2\epicor\mfgsys803\server\lib\UpdateTableBuffer.p (input BUFFER OrderDtl:HANDLE, 'LineDesc', S01).
End.

If (GetContextMode()) = "ORDER" Then Do:
Find First OrderDtl Where OrderDtl.Company = "SCC" And OrderDtl.OrderNum = S18 And OrderDtl.OrderLine = S19 no-lock no-error.
Run \\epicor-sc2\epicor\mfgsys803\server\lib\UpdateTableBuffer.p (input BUFFER OrderDtl:HANDLE, 'ProdCode', Entry(1,S41," ")).
End.

Tara K. Madia
ERP Systems Analyst
Sabre Industries, Inc.
Direct Line: (817) 852-1828
Email: tmadia@...<mailto:tmadia%40sabrecom.com><mailto:tmadia%40sabrecom.com> <mailto:tmadia%40sabrecom.com> <mailto:tmadia@...<mailto:tmadia%40sabrecom.com><mailto:tmadia%40sabrecom.com> <mailto:tmadia%40sabrecom.com> >

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 Blake Clemens
Sent: Wednesday, May 12, 2010 8:53 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Configurator - Populating fields in order entry

No I have not but I did think of that as a last resort option. I have yet to create any BPMs.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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 erwin
Sent: Wednesday, May 12, 2010 9:24 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Configurator - Populating fields in order entry

Hi

You are correct, we have always only ever used quotes. Have you tried updating the Quotedtl field thorugh a BPM?

erwin

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "Blake Clemens" <blake.clemens@...> wrote:
>
> Erwin,
>
> We start in Sales Order Entry. Create a new Sales Order, add a line which is the configured item. Not all of our orders first start in quote.
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
> 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 erwin
> Sent: Wednesday, May 12, 2010 9:02 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] Re: Configurator - Populating fields in order entry
>
>
>
>
>
> Hi
>
> How do you have a Sales Order? is the configurator not running within the Quote? and do you not have to convert the Quote to a Sales Order? if so the Sales Order will not exist when the configurator is running.
>
> --- In 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%40yahoogroups.com> , "Blake Clemens" <blake.clemens@> wrote:
> >
> > Steven,
> >
> > Could you give us a little detail about what exactly is supposed to happen below? Here is what IÃƒÂ¢Ã¢'Â¬Ã¢"Â¢m thinkingÃƒÂ¢Ã¢'Â¬Ã‚Â¦ go to the Lib folder and run UpdateTableBuffer.p program. IÃƒÂ¢Ã¢'Â¬Ã¢"Â¢m not too sure on the input BUFFER section or the significance of HANDLE. Everything else I understand. Can you elaborate a bit?
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > 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%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> <mailto:vantage%40yahoogroups.com> ] On Behalf Of Steven Gotschall
> > Sent: Wednesday, May 12, 2010 8: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> <mailto:vantage%40yahoogroups.com>
> > Subject: Re: [Vantage] Configurator - Populating fields in order entry
> >
> >
> >
> >
> >
> > Try this in the Alt field:
> >
> > Call Program lib\UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE, 'Character08', "ABC")
> >
> > ________________________________
> > From: Blake Clemens <blake.clemens@ <mailto:blake.clemens%40d-m-c.com> >
> > To: 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%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > Sent: Tue, May 11, 2010 5:22:03 PM
> > Subject: [Vantage] Configurator - Populating fields in order entry
> >
> >
> > All,
> >
> > Here is my issue.... We want to populate a field in Order Entry when
> > coming out of the Configurator. We are putting our programming on the
> > Alt field under the Rules Tab. Here is the programming we are using..
> > OrderDtl.Character0 8 = "ABC" Obviously I'm not able to get this to
> > work. Does anyone have any ideas as to why it isn't working and what I
> > should do to fix it. We are able to push values to fields in Quote and
> > Job when coming out of the Configurator just not in Order Entry. Any
> > help would be very much appreciated. Thanks in advance.
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > [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]

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

system · May 12, 2010, 12:35pm

What version of Epicor are you on? Assuming 8, If you are populating the quote and job via the Get details this is why you see the difference. The method rules do not fire until the get details step, since there is no get details step for a sales order the rule doesn't fire. In Epicor 9 there are document rules that do fire as part of saving the configurator and returning to a sales order and thus can update the sales order.

For 8 you need to run some progress code in the configurrator, usually as part of the last page on-leave code that pulls in the order and updates the order information using the updatetablebuffer library routine that Epicor provides.

Jim Kinneman
Senior Consultant
Encompass Solutions.

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> All,
>
> Here is my issue.... We want to populate a field in Order Entry when
> coming out of the Configurator. We are putting our programming on the
> Alt field under the Rules Tab. Here is the programming we are using..
> OrderDtl.Character08 = "ABC" Obviously I'm not able to get this to
> work. Does anyone have any ideas as to why it isn't working and what I
> should do to fix it. We are able to push values to fields in Quote and
> Job when coming out of the Configurator just not in Order Entry. Any
> help would be very much appreciated. Thanks in advance.
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>
> Delmarva Millwork Corporation
>
> (800) 360-2364 x132
>
>
>
> [Non-text portions of this message have been removed]
>