Topic Options
#57558 - 05/23/18 11:37 AM Financial Reporter - Add only credits WITHIN acct
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 186
Loc: Victoria, BC Canada
is there the equivalent of =ADCRONLY that examines the contents of the GL account rather than just it's balance?
I have an account that contains both debits and credits and I'd like to grab just the total of the credits.
If it doesn't exist I'll stop looking, but if there is something like that and someone can point me in the general direction that would be great!
Thanks!


Edited by Hugh (05/23/18 11:38 AM)

Top
#57560 - 05/23/18 12:24 PM Re: Financial Reporter - Add only credits WITHIN acct [Re: Hugh]
Softrak Support Online   happy

Adagio Action Team

Registered: 03/09/99
Posts: 11549
Loc: Vancouver, BC Canada
Hi Hugh,

There are no formulas in the Adagio Financial Reporter that read and report on the posted transaction details. You would need to use the drill-down and export the contents to Excel, print/export the Detail Listing report for the account, or create a GridView inquiry on the GL posted transactions file for this kind of analysis.

The two different Credit formulas available in the Financial Reporter are GLCRONLY (or the older ADCRONLY) that output the sum of the account balances in a given range of accounts, only for those accounts with a credit balance, or GLCREDIT (or the older ADCREDIT) which outputs the value of the account (or range of accounts) balance only if it a credit value, otherwise 0.00.
_________________________
Regards,
Softrak Tech Support

Top
#57564 - 05/23/18 03:13 PM Re: Financial Reporter - Add only credits WITHIN acct [Re: Softrak Support]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 186
Loc: Victoria, BC Canada
Thanks Support! I'll stop looking for that feature!

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Softrak Support), 44 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14465 Topics
70658 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