AR aging - recalculate for all customers

Question

Is there a way to recalculate the AR aging for all customers at one time? I know we can change the setting in the setup going forward, but there are several hundred customers with incorrect aging, many of whom are infrequently accessed. We're investigating how the aging issue happened, but will need to fix the records in any event.

Steve Passmore · Accepted Answer

That functionality is available in Rebuild Sort Files. From the Sage 100 Desktop, Library Master > Utilities > Rebuild Sort Files. 
 Choose 'Accounts Receivable' as the Module, enter the Company and click Proceed. 
 On the Rebuild A/R Sort Files dialog, click the Recalculate Aging in Customer Master check box and enter the Aging Date. Click Proceed.

Kevin M · Answer

Or... just run the AR Aging report, which does this too.

MClark · Answer

Yes! Thank you.

Sage 100

AR aging - recalculate for all customers

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING