Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

AR Aged Invoice Report - Past Due

Posted By Brandon Hoying 5 months ago

I am looking to customize our AR Aged Invoice Report to replace a manually done Past Due Report. The report is fine how it is for the most part, but I am wanting to filter the 30, 60, 90, 120 Days columns to exclude all zero's. The report is way longer than needed right now.

0 Kevin M 5 months ago
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Brandon Hoying 5 months ago in reply to Kevin M

Thank you, is there a way to exclude negative balances at all? We have customers with outstanding credit memo's that we would prefer not to be on this report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Brandon Hoying 4 months ago in reply to Brandon Hoying

Sorry I see where to exclude credit memo's, but meant to say prepayments on their account.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M 4 months ago in reply to Brandon Hoying

You'd probably have to edit the Crystal Report design for that. (Be careful with all customer / report totals if you filter out some row data).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

AR Aged Invoice Report - Past Due

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING