Topic Options
#33393 - 09/26/12 12:59 PM Calculate as of report in AR - omits data
Gary Offline
Adagio Enthusiast

Registered: 10/05/06
Posts: 29
Loc: Ontario
I have read a bit about this report and seen that some people had issues as well, however it seemed that they had cleared history. I have the history in the customer listing, but it will not give me a useful report when I backdate the date of the report?

Using AR 9.0C 120224

Top
#33395 - 09/26/12 01:25 PM Re: Calculate as of report in AR - omits data [Re: Gary]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
Gary:

Define not useful. Is it missing transaction, customers, both?

Are you printing the 'Aged Trial Balance' or one of the other reports. Each report has their own specific purpoase. The Aged Trial Balance is the only one that will mathc Ledger.

Check the parameter ranges and make sure they are all blank to zzzzz (enter all of the z's the fields will take).
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#33401 - 09/27/12 04:48 AM Re: Calculate as of report in AR - omits data [Re: Douglas Dickie]
Gary Offline
Adagio Enthusiast

Registered: 10/05/06
Posts: 29
Loc: Ontario
I am printing the aged trial balance. For example, I am attempting to get the listing as at June 30, 2012. Invoices dated before July 1, 2012 that had payments on or after July 1, 2012 applied to them are not included in the balance.

I clarified the zzzzz were correct already and have done a data integrity with "check history dic" flagged in the setup.

any other recommendations would be great.

Top
#33402 - 09/27/12 05:59 AM Re: Calculate as of report in AR - omits data [Re: Gary]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Make sure that under the "Print options" of the report you have chosen "Calculate as of" rather than "Aged as of".
_________________________
Andrew Bates

Top
#33403 - 09/27/12 07:12 AM Re: Calculate as of report in AR - omits data [Re: Retired_Guy]
Gary Offline
Adagio Enthusiast

Registered: 10/05/06
Posts: 29
Loc: Ontario
Yes, I have chosen the proper "calculate as of"

Top
#33405 - 09/27/12 07:54 AM Re: Calculate as of report in AR - omits data [Re: Gary]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
If you make a backup of your AR data (File | Backup) you can e-mail it to me (smaller than 2 Mbytes) or upload it to http:\\www.softrak.com\dbr. Send me an email with a couple of the invoice numbers that you think should be on the report that are not.

Before doing this, ascertain that you are running the current version of Receivables (9.0C (120224)).
_________________________
Andrew Bates

Top


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