cancel
Showing results for 
Search instead for 
Did you mean: 
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 2 weeks ago

Best Answers
Kevin_C
QuickBooks Team

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
QuickBooks Team

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 to get in touch?

Contact us