by COBS Tech Support » Thu Feb 13, 2014 11:12 am
I think you are trying to achieve a result in a roundabout sort of a way when you already have dedicated tools built into your software to do the sort of thing you are trying to achieve.
1. Open CAPITAL Business Manager
2. Open Customers area
3. Click on Overview (vertical tab near bottom left of screen)
4. Click on Collections Manager (tab near top)
If you have no snapshots yet, click on Add (button on right side) to create a debtor control snapshot. This might take a little while.
Once you have the snapshot built just click on the applicable column heading to sort the debtor list by your preferred option, i.e., sort by Period3+
The first time you use this system you will have to press Update.