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: 4514
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 (), 73 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14484 Topics
70731 Posts

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