I am looking to generate a report from Adagio AR that will show me items that were outstanding at December 31, 2015 and are still outstanding today.

I can do this with the normal AR Overdue receivables but that prints me 45 pages with most of it being 2016 invoices that are outstanding leading to a lot of noise and manual searching in the report for balances that may be there.

I'm trying to do this in an effort to clean up collections on receivables and would like to be able to adjust the date to show items that were outstanding as of XXX XX, 20XX and are still outstanding today so that I can run the report for different periods.

I assume this can be done with the right set of filters in Grid view but I wanted to check if there was an AR report that would do the work for me before I spend a few hours playing in grid view.

Thanks

Hello Braedon:

What version of Receivables are you using?

Have you tried the Aged Trial Balance report using the "Calculate as of" choice?

You would spend more than a few hours trying to achieve the same thing using GridView and it definitely wouldn't feel like "playing"!

I am using receivables 9.2A and if I use the "Calculate choice" with a date of 2015-12-31 it shows the AR as it was at that date. Items that later cleared in 2016 are still showing which is what I would like to remove from the report.

If I use the aged as of option it might give me the right reply but I get the error that "Enter a date later than the last clearing date". Suggesting that I can't chose to look at a date earlier than my last bank rec work.

Hi Braedon,

What you want to do is not available in Adagio Receivables as a standard report. You will have to come up with a custom report/inquiry. It will involve using the Customer Transactions file, creating a list of all invoices with a date equal to or less than Dec 31, 2015 and the Current Amount not equal to 0. This would be a fairly routine inquiry to create in Adagio GridView, if you have that program.

You might be able to use the SmartFinder search on the Document number field to accomplish the same search criteria, then export the results to Excel.

Some reports in Adagio that allow backdating and recalculation have labels to indicate that the transaction has been either partially or completely settled by future-dated transactions. It appears that the Aged Trial Balance report is not one of them.

Hi Braedon:

Support's answer is better than mine - i missed the part about "...are still outstanding today",

Thanks, I'll try that with Grid View

Hi Braedon,

You don't even need to use GridView. Just press F5 on the main Customer grid and click on the Document number field. Press F6. Create a SmartFinder Query that tests that Current Amount is not equal $0.00 and Due Date (or Document Date) is less than December 31, 2016.

The SmartFinder will list all the Invoices that meet the criteria. You may want to add some columns to the Grid displayed, or drop it into Excel to add the customer names and Phone numbers using a VLOOKUP() formula.