Topic Options
#14907 - 10/27/08 08: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 11:23 AM Re: Gridview - Aging of Accounts [Re: GAIL]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4527
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 01: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:  Christa_Meissner 
Who's Online
0 registered (), 101 Guests and 2 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14506 Topics
70844 Posts

Max Online: 432 @ 01/20/25 10:17 PM
June
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