Setting Customer On-Hold

[ieaston]

Hi,

Need help to set the "on-hold" flag for customers that are over 45 days. We can use Crystal or SQL to do this. Problem is when the same customer has multiple o/s invoices where the days o/s can be variable.

Any help at all would be greatly appreciated.

Thanks,
Ivan