Topic Options
#14907 - 10/27/08 09:55 AM Gridview - Aging of Accounts
GAIL Offline
Adagio Graduate

Registered: 04/30/04
Posts: 43
Loc: Saskatoon, Sask.
I would like to set up a report in gridview to age my receivables
I would like it to print balances of customers that are 45 days and older.

Top
#14908 - 10/27/08 12:23 PM Re: Gridview - Aging of Accounts [Re: GAIL]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4563
Loc: Wynnewood, PA
Hi Gail

You ought to go into Receivables, and run the function Calculate Customer Aging under Maintenance. This will update the Aged Bucket fields with the correct values.

Then in GridView, you can create a view using Composite Tables and selecting the table *AR Trans w Cust Ext. The aged values will be in the fields Aged Bucket 1/2/3.

Steve

Top
#14911 - 10/27/08 02:46 PM Re: Gridview - Aging of Accounts [Re: Steve Schwartz]
GAIL Offline
Adagio Graduate

Registered: 04/30/04
Posts: 43
Loc: Saskatoon, Sask.
Thank you for your help

Top


Moderator:  Softrak Support 
Who's Online
2 registered (Bruce Gardner, 1 invisible), 27 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14630 Topics
71446 Posts

Max Online: 1408 @ 12/09/25 02:48 AM
July
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 31