Topic Options
#34710 - 01/04/13 06:22 AM Gridview Results in 9.0F (120925)
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Since I installed the Gridview Upgrade, 9.0F (120925)last week, I have a view that displays correctly on my computer, but incorrectly on everyone else's computer.

The calculated column that is giving me a problem is this one:
ROUND( (30/365) * {Sold YTD} / YEARFRAC( FISCALSTART() , TODAY() ) , 0)

How is it possible for this formula to display correct results on one computer but not on the others? How do I fix it?

It was working for everyone before the upgrade. The results we want for this column is "one month average year to date". The table we're using is *IC Item Loc w IC Item.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#34712 - 01/04/13 06:34 AM Re: Gridview Results in 9.0F (120925) [Re: SusanTennier]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
The FiscalStart() is set in the Edit | Default (F2)mid form right side.

Look on your machine and then on one that does not work to see the difference.

Perhaps the date format on the computer in question has an impact.

Top
#34713 - 01/04/13 06:47 AM Re: Gridview Results in 9.0F (120925) [Re: Michael Mulrooney]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
That's what it is. Everyone is changed back to fiscal start of 1/1 instead of 4/1. Why has that changed to an individual user setting? How can I change it on everyone? I tried changing the SYS account, but it doesn't go to the other users. Do we have to do this on every computer now? First I would have to add the /c to every users shortcut then enable "edit gridview" for every user just so I can get in to their individual edit/default.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#34714 - 01/04/13 06:55 AM Re: Gridview Results in 9.0F (120925) [Re: SusanTennier]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
I am not aware that there has been a change here, as far as I know all defaults are associated with the view in question.

So if you open the View with no one else having it opened, change the Fiscal Start, save the View then when the other users open the View they will have the correct Fiscal Start for that View.

Top
#34715 - 01/04/13 07:11 AM Re: Gridview Results in 9.0F (120925) [Re: Michael Mulrooney]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
That is not working. I have re-saved the view while no one else is in it but other users are still not getting their fiscal start correctly. Seems I have to go on every computer one at a time and change their fiscal start to 4/1.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#34716 - 01/04/13 07:14 AM Re: Gridview Results in 9.0F (120925) [Re: SusanTennier]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
I thought I might be able to get away with logging in to each Adagio User from my computer and edit the fiscal start that way but that doesn't work either.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#34717 - 01/04/13 07:24 AM Re: Gridview Results in 9.0F (120925) [Re: SusanTennier]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
Perhaps there is a problem rolling over to the new year rather than the update to 9.0F but I will follow up with R&D

Top
#34718 - 01/04/13 07:29 AM Re: Gridview Results in 9.0F (120925) [Re: Michael Mulrooney]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Yes, I installed the upgrade over New Years so it could be either one.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (AudreyQuick), 73 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30