AR Aging

[mdewis]

Hi There,

Does anyone know what the 'Current' column is for in AR Aging? How is it different from '1 to 30'? I am using the Accpac Insight tool to query the AR Aging from several databases and cannot determine how to replicate what goes in the 'Current' column.

Your help is greatly appreciated,
Mike

 

[ettienne]

Anything not included in the other aging columns: credit notes, prepayments, etc. This depends on your AR setup options settings.

 

[mdewis]

Thanks for the reply.

When I go to AR Setup Options, I see that I have 'Age Unapplied Credit Notes...' and 'Age Receipts...' both set to 'By Date'. But it seems most of credit notes are aged in the columns except I do have one from February that still shows in Current. Any ideas?

I guess I am looking for an easy way to query the ARDocuments and ARScheduledPayments table (included in query provided by Insight) and come up with the amounts in the current column.

Thanks,
Mike