Topic Options
#16337 - 03/16/09 03:16 PM Inactive accounts in A/R & O/E
Sammy Offline
Adagio Maven

Registered: 02/02/07
Posts: 165
Loc: Summerland, B.C. Canada
We have a number of inactive and one time only customers. Is there a way to have these customers not included when printing statistics and/or even basic customer list.

Top
#16338 - 03/16/09 03:21 PM Re: Inactive accounts in A/R & O/E [Re: Sammy]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11557
Loc: Vancouver, BC Canada
Hi Sammy,

Not yet, but when Adagio Receivables 9.0A is available, there are a number of reports that you can restrict to print only those customers that are marked Active. The AR Customer List/Statistics is one of these reports with the feature, and also the Transaction reports such as Overdue Receivables and Aged Trial Balance.
_________________________
Regards,
Softrak Tech Support

Top
#16339 - 03/16/09 03:33 PM Re: Inactive accounts in A/R & O/E [Re: Softrak Support]
Sammy Offline
Adagio Maven

Registered: 02/02/07
Posts: 165
Loc: Summerland, B.C. Canada
Any ETA on AR 9.0? I want to figure out if I am better to wait for it or if I have to go one by one through our customer list to get the info I need on active accounts only.

Top
#16340 - 03/16/09 04:38 PM Re: Inactive accounts in A/R & O/E [Re: Sammy]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Sammy,

If you are not using (any one of) Report Group, or Territory, Salesperson or Short Name, then you could use SmartFinder to export a list of your active customers to Excel, and then set one of these fields to a range you could select in this report (perhaps ReportGroup = "ACTIVE" for example) and import it back into the database.

If you are just trying to sum on of the fields in the customer statistics, then just include it and the Active/Inactive flag on the SmartFinder grid and select only Active customers and export the list to Excel to do the math.

GridView would be able to select these customers easily too.

Do any of these interim solutions work for you?
_________________________
Andrew Bates

Top


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