Modify Time Phase Grid List

use the values in the temp table to do a find first on the table you need the additional information from. Syntax may not be exact but gives the general concept.

find first customer where customer.company = ttxxxx.company and customer.custid = ttxxx.custid no-lock no-error.

if available customer then
do:
ttxxx.field = txxx.field & ";" & customer.custid.
end.

Then in the embedded customization trap the after event and extract the information.

Jim K.
--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hi Jim,
>
> Thanks for this but I don't have the knowledge to create the below. I have created a few BPM's etc but never dabbled with making the BPM look up additional info - how do you go about this?
>
> Regards,
> Michael
>
> --- In vantage@yahoogroups.com, "jckinneman" <jckinneman@> wrote:
> >
> > The time phase screen doesn't have any real tables associated with it, it only exists when you run it so there aren't any UD fields that you can put the information in. One approach I did was to run a Post Processing BPM on the time phase method that looks up the additional information. I added the additional information to an existing field in the temp table by concatenating it to the existing information since there aren't any UD fields to use. Then using embedded customization I trapped the after event and extracted the additional information from the concatenated field. I basically clone the existing data-view and using a new grid I added a column for the additional information and presented the new column and the original columns, user doesn't see any difference other than the new column.
> >
> > You could also trap the after event, loop through records in the grid and look-up the information in an embedded customization. The BPM approach will be faster but depending on your comfort level you may find looping through the grid/data-view easier to build.
> >
> > Jim Kinneman
> > Senior Consultant
> >
> > --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Hello,
> > >
> > > On the time phase screen on the grid list, is it possible to add either the Customer ID or Ship To ID? When I go into customization, these are not available as fields.
> > >
> > > Regards,
> > >
> > > Michael
> > >
> > > Vantage 8.03.406 / Progress
> > >
> >
>
Hello,

On the time phase screen on the grid list, is it possible to add either the Customer ID or Ship To ID? When I go into customization, these are not available as fields.

Regards,

Michael

Vantage 8.03.406 / Progress
The time phase screen doesn't have any real tables associated with it, it only exists when you run it so there aren't any UD fields that you can put the information in. One approach I did was to run a Post Processing BPM on the time phase method that looks up the additional information. I added the additional information to an existing field in the temp table by concatenating it to the existing information since there aren't any UD fields to use. Then using embedded customization I trapped the after event and extracted the additional information from the concatenated field. I basically clone the existing data-view and using a new grid I added a column for the additional information and presented the new column and the original columns, user doesn't see any difference other than the new column.

You could also trap the after event, loop through records in the grid and look-up the information in an embedded customization. The BPM approach will be faster but depending on your comfort level you may find looping through the grid/data-view easier to build.

Jim Kinneman
Senior Consultant

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> On the time phase screen on the grid list, is it possible to add either the Customer ID or Ship To ID? When I go into customization, these are not available as fields.
>
> Regards,
>
> Michael
>
> Vantage 8.03.406 / Progress
>
Hi Jim,

Thanks for this but I don't have the knowledge to create the below. I have created a few BPM's etc but never dabbled with making the BPM look up additional info - how do you go about this?

Regards,
Michael

--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> The time phase screen doesn't have any real tables associated with it, it only exists when you run it so there aren't any UD fields that you can put the information in. One approach I did was to run a Post Processing BPM on the time phase method that looks up the additional information. I added the additional information to an existing field in the temp table by concatenating it to the existing information since there aren't any UD fields to use. Then using embedded customization I trapped the after event and extracted the additional information from the concatenated field. I basically clone the existing data-view and using a new grid I added a column for the additional information and presented the new column and the original columns, user doesn't see any difference other than the new column.
>
> You could also trap the after event, loop through records in the grid and look-up the information in an embedded customization. The BPM approach will be faster but depending on your comfort level you may find looping through the grid/data-view easier to build.
>
> Jim Kinneman
> Senior Consultant
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > On the time phase screen on the grid list, is it possible to add either the Customer ID or Ship To ID? When I go into customization, these are not available as fields.
> >
> > Regards,
> >
> > Michael
> >
> > Vantage 8.03.406 / Progress
> >
>