Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
finance-liveoaks
Level 1

In a custom Sales Detail by Customer report, how do I add a field called "Status" with the same content "Paid" in each entry?

Based on an import template for membership platform donations. All fields are: Date, Type (Sales Receipt), Number, Donor (Customer), Due Date (Blank - using Service Date), Balance, Amount, Status (???? = Always "Paid")
Solved
Best answer April 22, 2024

Best Answers
Kevin_C
Moderator

In a custom Sales Detail by Customer report, how do I add a field called "Status" with the same content "Paid" in each entry?

I appreciate you for reaching out to us, finance-liveoaks. I'm here to provide an alternative way to run a report with status column.

 

Currently, the option to add a Status column in your report is unavailable. You can add an A/R Paid column instead, but please know that it works for some paid transactions and is not specific to sales receipts if you're using the classic report view.

 

Follow these steps on how you can do it:

 

  1. Go to the Sales by Customer Detail report and click Switch to classic view.
  2. Select the Customize button.
  3. Place a checkmark in the A/R Paid column.
  4. From the Filter section, choose Paid in the A/R Paid.

 

While the option to add a specific column in a report is unavailable, you can always submit a feature request directly to our product developers. This way, they can evaluate the possibility of including this functionality in future updates. Here's how:

 

  1. Go to the Gear icon at the top.
  2. Select Feedback.
  3. Type in your feedback and product suggestions.
  4. Click Next to submit them.

 

You can also visit this article to learn more about tailoring your reports, displaying particular accounts or customers, and configuring the layout for precise data placement: Customize reports in QuickBooks Online.

 

We're always around to lend a hand if you need more help managing your reports or anything else related to QuickBooks. Take care and stay safe always!

View solution in original post

1 Comment 1
Kevin_C
Moderator

In a custom Sales Detail by Customer report, how do I add a field called "Status" with the same content "Paid" in each entry?

I appreciate you for reaching out to us, finance-liveoaks. I'm here to provide an alternative way to run a report with status column.

 

Currently, the option to add a Status column in your report is unavailable. You can add an A/R Paid column instead, but please know that it works for some paid transactions and is not specific to sales receipts if you're using the classic report view.

 

Follow these steps on how you can do it:

 

  1. Go to the Sales by Customer Detail report and click Switch to classic view.
  2. Select the Customize button.
  3. Place a checkmark in the A/R Paid column.
  4. From the Filter section, choose Paid in the A/R Paid.

 

While the option to add a specific column in a report is unavailable, you can always submit a feature request directly to our product developers. This way, they can evaluate the possibility of including this functionality in future updates. Here's how:

 

  1. Go to the Gear icon at the top.
  2. Select Feedback.
  3. Type in your feedback and product suggestions.
  4. Click Next to submit them.

 

You can also visit this article to learn more about tailoring your reports, displaying particular accounts or customers, and configuring the layout for precise data placement: Customize reports in QuickBooks Online.

 

We're always around to lend a hand if you need more help managing your reports or anything else related to QuickBooks. Take care and stay safe always!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up