Is there a quick and easy way to pull a report in GP Smartlists for all invoices that were outstanding as of 12/31/13 that were paid in 2014? Having trouble with what columns i am needing in a report.
*This post is locked for comments
Is there a quick and easy way to pull a report in GP Smartlists for all invoices that were outstanding as of 12/31/13 that were paid in 2014? Having trouble with what columns i am needing in a report.
*This post is locked for comments
Hi Kimz,
A very simple SmartList would look for invoices dated before 01/01/2014 that had a date paid off in 2014.
If it was paid off in 2014, then it was outstanding on 12/31/2013.
You would need to use the Payables Transactions object. Is this what you were looking for?
Kind regards,
Leslie
I created a blog post regarding all of the date fields in some of the A/P tables that might interest you:
dynamicsconfessions.blogspot.com/.../whats-in-date-pm-transactions.html
Almas Mahfooz
3
User Group Leader