Discussions
Invoice Date AND Payment Date on Cash Basis Sales Reports
Is there any way to include the Invoice Date on Cash Basis Sales Reports?
If a report is done on Cash Basis, the date shown is the date of the Payment applied to the Invoice. I need add another column in my report that shows the actual invoice date. Date Created does not work, because an Invoice can be dated other than the date it is created. Not to mention the fact that we recently migrated to NS from QuickBooks and the Date Created on 95% of our invoices is the date the import was done.
Example: I create an Invoice on June 2 and date it for an order that was placed on May 31. The Invoice is paid in full on June 10. On Cash Basis, that transaction is listed with a date of June 10. I need another column that tells me that Invoice was dated for May 31.