Topic Options
#53201 - 03/27/17 02:33 PM Formula
doctorini Offline
New Guy

Registered: 01/26/17
Posts: 8
Loc: British Columbia
What is the formula for Financial Reporter to obtain notes on the GL account data?

Top
#53202 - 03/27/17 02:50 PM Re: Formula [Re: doctorini]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4413
Loc: Vancouver, BC
There is no means to retrieve the account notes into the financial reporter.

If you need to add notes to your financial statement you will have to type the into the cell where you want them.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#53203 - 03/27/17 03:41 PM Re: Formula [Re: Douglas Dickie]
doctorini Offline
New Guy

Registered: 01/26/17
Posts: 8
Loc: British Columbia
Will it save onto the cell if I enter the date on a collapse view?

Top
#53204 - 03/27/17 03:56 PM Re: Formula [Re: doctorini]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
No. But you can get the contents of the Optional fields for an account and put them on the financial statement, so if you can fit your note into 35, 70 or 105 characters then you can have it displayed when the sheet is expanded.

Alternatively, don't make the account part of a ".Range", but specify it explicitly in the row if you want the same note always displayed.

What are you trying to accomplish?
_________________________
Andrew Bates

Top
#53370 - 04/13/17 01:11 PM Re: Formula [Re: Retired_Guy]
doctorini Offline
New Guy

Registered: 01/26/17
Posts: 8
Loc: British Columbia
Hi Andrew,

The report is to list all expenses for each department, account balance and account note. Each account for each department has notes on them.

I have been trying to use the ADNOTE formula but it still doesn't pull in the notes onto the statements. How do I achieve this?

Currently, I have .Range on the statement.

Top


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