Topic Options
#37976 - 07/31/13 05:34 AM Ledger service pack 9.1A (20130726)
Lyndon_Olfert Offline
Adagio Specialist

Registered: 06/15/04
Posts: 362
Loc: Winnipeg
After installing the most recent service pack we are happy to report that the loss of focus and drill down problems we had been encountering are solved. YAY!
In the financial reporter, however, our departmental summary is now not populating the departments correctly. The balance sheet and income statements are fine.
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.

Top
#37980 - 07/31/13 07:04 AM Re: Ledger service pack 9.1A (20130726) [Re: Lyndon_Olfert]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
"Not populating with with departments correctly..." is a bit vague. Can you describe what has changed?
_________________________
Andrew Bates

Top
#37994 - 07/31/13 02:38 PM Re: Ledger service pack 9.1A (20130726) [Re: Retired_Guy]
Lyndon_Olfert Offline
Adagio Specialist

Registered: 06/15/04
Posts: 362
Loc: Winnipeg
Here is a screen shot of what is happening: http://tinyurl.com/khkannn
I tested it using the Adagio Sample data and the GL!DepartmentalSummary.sam with the same results.
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.

Top
#38023 - 08/02/13 11:11 AM Re: Ledger service pack 9.1A (20130726) [Re: Lyndon_Olfert]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Lyndon,

From the Release Note:

• The FIND function now returns zero rather error if nothing is found.

A side effect of this change is that characters in the searched string are counted from 1 rather than zero. Thus the formula to isolate the department in Column C goes from:

Code:
=TRIM(MID($B12,FIND("-",$B12,1)+2,LENGTH($B12)))


To

Code:
=TRIM(MID($B12,FIND("-",$B12,1)+1,LENGTH($B12)))


This change was necessary to make the operation of FIND() be consistent between GridView and the Financial Reporter. We’ll update the Release Note.
_________________________
Andrew Bates

Top
#38024 - 08/02/13 11:21 AM Re: Ledger service pack 9.1A (20130726) [Re: Retired_Guy]
Lyndon_Olfert Offline
Adagio Specialist

Registered: 06/15/04
Posts: 362
Loc: Winnipeg
Works like a charm!
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 64 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70650 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