Topic Options
#33150 - 09/10/12 10:30 AM Ledger Question
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Is there a fast way to look at an account (i.e. 1300 Inventory Control) and see the numbers for several years as of a certain date? (i.e. As of Aug 30, 2012, 2011, 2010, 2009, 2008 & 2007)

I want to create a graph in excel for this account and other accounts to see where there have been large fluctuations over the years.

The only method I found is to look each amount up in Ledger and paste it into a spreadsheet for each year and manually put it together.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#33151 - 09/10/12 10:33 AM Re: Ledger Question [Re: SusanTennier]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi Susan,

The Financial Reporter should be able to handle this easily, either for balances or net changes. Prefixing any field code with {n} will give the numeric result for the same field but n years ago.
_________________________
Regards,
Softrak Tech Support

Top
#33153 - 09/10/12 11:14 AM Re: Ledger Question [Re: Softrak Support]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Thanks!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


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