Show 'REP' with credit memo

JvP79 · ‎November 18, 2019

Hi all, when I run a report showing all invoices by customer it lists the credit memo's as well (which is great!).

The only thing is that, for a reason unknown to me, it does not list the rep assigned to that customer. It does list the rep with all 'normal' invoices, just not with the credit memo's.

As I need to calculate commission for my reps, credit memo's are quite an important item in this matter :)

How can I change this?

Mark_R · ‎November 19, 2019

I appreciate you getting back to us and performing the steps provided by my colleague above, @JvP79.

You'll have to make sure that the credit memo has a designated REP to show it on the report. And I'd be glad to walk you through the steps.

First off, let's edit the credit memo template to add the REP header. Here's how:

Go to the Lists menu.
Select Template.
In the Template window, choose Credit Memo.
Click the Additional Customization button.
In the Header tab, put a check-mark on the REP.
Click OK, then select OK in the Basic Customization.

Then, run and customize the Transaction List by Customer report and choose each Credit Memo to select a REP. Let me guide you how.

In the Transaction List by Customer report, double-click the Credit Memo.
In the REP drop-down, select the appropriate rep.
Click Save & Close.

Once done, repeat the steps for the rest of the credit memo.

I've attached screenshots below for your visual reference.

You might also want to read this article to learn how to memorized reports: Create, Access and Modify Memorized Reports.

Just hit the Reply button if you have any other questions. I'll be right here to help.

View solution in original post

GraceC · ‎November 18, 2019

Hello there, @JvP79

You can customize the transaction list by customer and ensure that your credit memo has a rep. Let guide you how:

Here's how:

Go to the Reports.
Click the Custom Reports, select the Transaction List by Customer.
Click Customize Report.
Select Filter, then choose the Transaction type.
Under Transactions type, click the drop-down arrow.
Choose a Credit memo, then double click the Credit memo.
Under Rep, select the drop-down memo. then choose the rep you want.
Click Save and close.

For more information, you can check this article: Customize reports in QuickBooks Desktop

If there's anything else I can help you with, feel free to comment or post again here in the Community!

JvP79 · ‎November 19, 2019

Thank you for your answer, but it does not solve the issue. When the report is shown it shows the exact same issue I described in my first report.

The credit memo's are all shown with all selected reporting fields, except for the rep. This one is empty..

Below a screenshot from the report with the credit memo's

JvP79 · ‎November 19, 2019

And here is the screenshot of a report showing the invoices, which do show the rep.

JvP79 · ‎November 19, 2019

please remove

Mark_R · ‎November 19, 2019

I appreciate you getting back to us and performing the steps provided by my colleague above, @JvP79.

You'll have to make sure that the credit memo has a designated REP to show it on the report. And I'd be glad to walk you through the steps.

First off, let's edit the credit memo template to add the REP header. Here's how:

Go to the Lists menu.
Select Template.
In the Template window, choose Credit Memo.
Click the Additional Customization button.
In the Header tab, put a check-mark on the REP.
Click OK, then select OK in the Basic Customization.

Then, run and customize the Transaction List by Customer report and choose each Credit Memo to select a REP. Let me guide you how.

In the Transaction List by Customer report, double-click the Credit Memo.
In the REP drop-down, select the appropriate rep.
Click Save & Close.

Once done, repeat the steps for the rest of the credit memo.

I've attached screenshots below for your visual reference.

You might also want to read this article to learn how to memorized reports: Create, Access and Modify Memorized Reports.

Just hit the Reply button if you have any other questions. I'll be right here to help.

JvP79 · ‎November 27, 2019

Thanks for your answer Mark!!!

Works as I hoped now!

Topics

Training

Community

Resources

Show 'REP' with credit memo