Customization to TimePhase Display Grid - Epicor 9.05.607b

Yahoo Archive
1
Here is a thread I used to get started adding field to collections.
It happens to be the the TimePhase grid.
It might give you some ideas.
You'd need to replace the parentpart with your calculation.

http://tech.groups.yahoo.com/group/vantage/message/106535

--- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@...> wrote:
>
> I would like to add into the Time Phase Inquiry display grid a
> calculated field that reads the DUE DATE and returns the MONTH number.
>
> Then I could group on this field and summarize the "Required Qty" and
> "Receipts" columns to show monthly bucket amounts.
>
> Seems like a great addition to the screen but:
>
>
>
> When I try to Customize the form the "grdList" is just reading the
> TimePhase table and doesn't allow adding a calculated field.
>
> I thought I would create a BAQ but the TimePhase table is not listed.
>
>
>
> What is the simplest way around this? Is it even possible?
>
>
>
> I found it kinda funny that the "Tips" table is listed in BAQ Designer
> but the "TimePhase" table isn't.
>
>
>
> Patrick Winter
>
> Testing: Epicor 9.05.607b, Progress Database
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I would like to add into the Time Phase Inquiry display grid a
calculated field that reads the DUE DATE and returns the MONTH number.

Then I could group on this field and summarize the "Required Qty" and
"Receipts" columns to show monthly bucket amounts.

Seems like a great addition to the screen but:



When I try to Customize the form the "grdList" is just reading the
TimePhase table and doesn't allow adding a calculated field.

I thought I would create a BAQ but the TimePhase table is not listed.



What is the simplest way around this? Is it even possible?



I found it kinda funny that the "Tips" table is listed in BAQ Designer
but the "TimePhase" table isn't.



Patrick Winter

Testing: Epicor 9.05.607b, Progress Database







[Non-text portions of this message have been removed]
3
Add a column to the grid itself, then on InitializeRow do the calculation
and insert the value into the appropriate column.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Mar 13, 2012 at 11:31 AM, Winter, Patrick <pjw@...>wrote:

> **
>
>
> I would like to add into the Time Phase Inquiry display grid a
> calculated field that reads the DUE DATE and returns the MONTH number.
>
> Then I could group on this field and summarize the "Required Qty" and
> "Receipts" columns to show monthly bucket amounts.
>
> Seems like a great addition to the screen but:
>
> When I try to Customize the form the "grdList" is just reading the
> TimePhase table and doesn't allow adding a calculated field.
>
> I thought I would create a BAQ but the TimePhase table is not listed.
>
> What is the simplest way around this? Is it even possible?
>
> I found it kinda funny that the "Tips" table is listed in BAQ Designer
> but the "TimePhase" table isn't.
>
> Patrick Winter
>
> Testing: Epicor 9.05.607b, Progress Database
>
> [Non-text portions of this message have been removed]
>
>
>


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