I'm trying to copy Invoice 'Trx Date' and 'Due Date' columns from the AR Trans w Cust table into a view using the A/R Transaction Matching File table. When I paste, all the dates in these two columns disappear. I just want to know if it's possible or should I try pulling these columns from a different table?

Thanks

(If not I'll just send both tables to Excel and match things up there but it won't be as easy.)

Hi Mike

In all my years of Adagio report writing, I've used the AR Transaction Matching File table maybe twice. It's a very difficult table to work with. Describe to me the kind of report you are looking to create; there may be an easier way.

Steve

I was looking at Average Days to Pay and we have a couple of customers that don't look quite right. I read the following threads http://www.softrak.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=23277#Post23277 and http://www.softrak.com/ubbthreads/ubbthreads.php?ubb=showflat&Number=27873 and thought I would try your method to see what it returned. This table seemed to be the logical place to start.

Hi Mike,

The AR Transactions file and AR matching file are both "detail files", so would be unlikely to work well together.

A place to find out the original Due Date and Paid date is in SalesAnalysis.

Hi Andrew,

Would you like to save me some time and point me to the correct table(s)?

Hi Mike

As Andrew suggests, the only workable database that contains both the invoice date and the payment date in one record is the SalesAnalysis Transactions database. The records are not at the invoice level, but at the detail (item) level, and if SA is not set to collect the miscellaneous charges and taxes, the total of all of the details will not exactly agree to the invoice.

You have to make sure all AR cash batches are posted, and run the function Utilities | Set Invoice Paid Indicator (pick a starting date about 1 year in the past), so that the paid date field is refreshed in the table.

This table only really works for a weighted Average Days-to-Pay figure, which is more accurate anyway. Also, the paid date won't be populated until the invoice is fully paid, which also makes for a more accurate report.

The SA Detail table is really easy to work with - it can connect to all of the naturally related master tables, such as customer and item.

Steve

Hi Steve

Since we have only been using Adagio since January 2012 I'll start there. We don't use miscellaneous charges and it is set to collect taxes, so good to go.

Thanks very much