Creating reports for past due invoices

[garyx23]

Does anyone know how to create a report that will generate all invoices that fall into the 120 days past due category without manually going into each individual account and printing the invoice in question?

 

[vionca]

This can become quite complex. You will need to use Crystal. Before you jump in, however, have you checked the a/r custom reports menu for any report that will show you this info? If you happen to find one, you can always copy the report and edit it as you wish.

vionca

 

[Orica]

Won't the aged trial balance do this?

 

[mas90guru]

Be careful on simply modifying the Aged AR Custom report in A/R -- last I saw it had some problems properly aging. This bug appears to have been carried over version to version.

One good resource (though you'll have to go through your reseller) is a package of pre-made reports from Bennet Porter available for preview at

http://www.benpor.com/crystal/index.php

Remember that when Version 4 of MAS90 arrives in February 2004 (scheduled) that all reports s/b in Crystal and much more easily modified. The rollout will be gradual so you may not get the Accounts Receivable module until a future month.

Regards,

Wayne Schulz


Schulz Consulting, LLC

http://www.s-consult.com