Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHello - I'm trying to get a report in Quickbooks Desktop enterprise that shows customer payments AND the customers payment terms. We are manufacturing and need to communicate to our shipping team that payments have been made for customers that have been on hold until payment is received. I've created a report that shows the terms field but it does not carry over the terms for the customer. Any advice would be appreciated.
Thank you for sharing the details of your situation, jloomy. Let me guide you through the steps to generate the appropriate report in QuickBooks Desktop to meet your needs.
To begin with, could you clarify which report you are currently generating that shows the terms field, but it doesn't carry over the terms for the customer?
If the current report isn’t pulling the Terms data, you can run a Transaction Detail report and customize it to show the terms field and payment information. Please note that the Terms field only appears for invoice transactions, so you’ll want to ensure Invoices are included along with Payments and Deposits in the report.
Here's how:
If the Terms field is still not showing, confirm that each customer's profile has the correct payment terms set up.
You can leave a comment below if you have additional questions.
Thank you for this. I created the custom report as you've suggested and now need to know how to condense the data so that only the invoice total, customer name, terms and paid/unpaid status.
Thank you for following up, and great job on creating the custom report, jloomy.
I’m happy to help you condense the data further by removing the additional columns in the Custom Transaction Detail Report. This will help you streamline your report by keeping only the columns you need, such as invoice total, customer name, terms, and paid/unpaid status.
Here are the steps to remove any unnecessary columns from your report:
Let us know if you need further assistance while customizing your report, and we'll be happy to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here