Topic Options
#37747 - 07/09/13 12:52 PM Drill down pop-up menu
CHFManitoba Offline
Stranger

Registered: 07/09/13
Posts: 4
Loc: Winnipeg, MB, Canada
When trying to drill down to G/L details there is no option in the pop-up menu to select Details or Tx Details. I'm assuming we are an upgrade (or 2) behind but would like to confirm.


Attachments
Untitled.png (66 downloads)


Top
#37748 - 07/09/13 12:57 PM Re: Drill down pop-up menu [Re: CHFManitoba]
Patricia B. Offline
Adagio Maestro

Registered: 06/26/08
Posts: 1157
Loc: Langley, BC
If it is a financial statement you are referring to, try double clicking on the amount.
_________________________
Patricia Balbuena Cotlear
AP SMART SUPPORT
236 991 3060





Top
#37749 - 07/09/13 01:23 PM Re: Drill down pop-up menu [Re: CHFManitoba]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
You have to have selected a single cell that contains a number that can be "drilled into". Check your selection.
_________________________
Andrew Bates

Top
#37751 - 07/09/13 01:30 PM Re: Drill down pop-up menu [Re: Patricia B.]
CHFManitoba Offline
Stranger

Registered: 07/09/13
Posts: 4
Loc: Winnipeg, MB, Canada
I have tried that and it will just give a formula

Here is the formula in an example cell:

=-SUM(ADGET("gldata.BAL",$A10))

Top
#37752 - 07/09/13 01:35 PM Re: Drill down pop-up menu [Re: Retired_Guy]
CHFManitoba Offline
Stranger

Registered: 07/09/13
Posts: 4
Loc: Winnipeg, MB, Canada
I've done that as well and I've also checked the Adagio Manual and the cell I have selected does contain a function listed in order to drill down.

Here is an example formula =-SUM(ADGET("gldata.BAL",$A10))

According to the Adagio manual Pag 3-93 If you have the function of ADGET you should be able to drill down.

Does it have something to do with the version of Adagio we have?

Top
#37754 - 07/09/13 02:03 PM Re: Drill down pop-up menu [Re: CHFManitoba]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
It's the SUM part that is preventing the drill-down.

You probably don't need SUM based on what the rest of the formula contents are, and may be able to use =-ADGET("gldata.BAL",$A10) to show the negative balance of the account(s) in cell A10 as of the selected fiscal period and year.

It may be desirable to see if your financial statements require 'cleaning up' to enable functionality such as this. For example, the ADGET formula has essentially been superseded by the GLAMT formula (though ADGET still works OK). If this is something worth pursuing, your Adagio consultant would be happy to assist you.
_________________________
Regards,
Softrak Tech Support

Top
#37785 - 07/10/13 12:03 PM Re: Drill down pop-up menu [Re: Softrak Support]
CHFManitoba Offline
Stranger

Registered: 07/09/13
Posts: 4
Loc: Winnipeg, MB, Canada
That was the problem! Thank you! I've switched the formula from
=SUM(ADGET("gldata.B",$A8)) to =-ADGET("gldata.BAL",$A8) and the Drill down function is now working perfectly!

Top


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