How can I run a report that shows all the line items of the invoice, and all the payments and dates made against it?
I have an account that has been active and all of a sudden it shows 0 activity when I pull up chart of accounts or run and P&L or Balance Report, it's missing. It is not categorized as "inactive". I'm running Premier Profession Services Edition 2018. I can see the activity in my check register with that particular account but reporting doesn't show it. I've checked accrual versus cash and that didn't make a difference?
Currently, we're unable to generate a report showing the invoice line items alongside with the payments applied to it. We can, however, customize a Transaction Detail report to show the list of invoices and payments by date. Let me guide you how to do that:
Go to the Reports tab.
Click Custom Reports.
Select Transaction Detail.
Click on the Filters tab.
In the Search Filters field type Transaction Type.
Click the Transaction Type drop-down and select Multiple Transaction Types.
In the Select Transaction Types window, click Invoice and Payment.
Click OK twice.
In the Total By drop-down, select Customer.
Update the report date.
That should show you all your invoices per customer. If you're still unable to view your transactions, I'd recommend running the Verify/Rebuild Utility Tools to identify data issues within a company file.
Please update me how this goes, wwobig. I'm just a comment away if you need further assistance.