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: 4551
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:  Softrak Support 
Who's Online
1 registered (Softrak Support), 147 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1868 Members
5 Forums
14588 Topics
71201 Posts

Max Online: 1408 @ 12/09/25 01:48 AM
February
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