cancel
Showing results for 
Search instead for 
Did you mean: 
PizzaPlus
Level 2

Sales rep by transaction

Hello,

 

I've been searching, but unable to find the answer I'm looking for. I'm hoping someone can help!

 

I've assigned sales reps to specific customers.

 

I have run the report & tried to filter by a specific sales rep, but the report is blank. 

 

I went back & verified a specific customer had that rep attached to it, which it did. However, it seems you need to be able to apply the rep per transaction for it to show up maybe? But if that's the case I wasn't able to find any way to do that.

 

I'm perplexed!

 

Please respond!

Solved
Best answer September 04, 2023

Best Answers
JamaicaA
QuickBooks Team

Sales rep by transaction

I really appreciate all of those details, @PizzaPlus. Tracking Sales Reps can be tricky, and you've already verified a specific customer has assigned to it. I'm here to help show the transactions to the report and make sure you'll be an expert at it in no time.

 

You're right. You'll need to add the Reps per transaction to show them on the report. Not to worry, I'll share a way to do that.

 

Let's customize the sales orderpurchase orders, and invoices template. I'll show you how:

 

  1. Go to Customers at the top, then click Customer Center.
    Capture A1.PNG
     
  2. Under the Transactions, select the Invoices.
  3. Locate the customer's name.
    Capture A2.PNG
  4. On that page, go to the Formatting tab and then Customize Data Layout.
    Capture A3.PNG
  5. In the window that appears, select the Header tab.
  6. Find REP on the list and select the Screen and Print boxes to add it.
  7. Hit OK once done. 
    Capture A4.PNG

See this article for detailed guidance: Create and use custom fields in QuickBooks Desktop.

 

With all of that information, you should be on track to finish running Sales rep by transaction with ease. However, if you have any more questions about this, or other issues while learning QBDT, I am always here to assist in whatever way I can. In the meantime, I hope you have a great day.

View solution in original post

JamaicaA
QuickBooks Team

Sales rep by transaction

You're always welcome, @PizzaPlus. Going back & adding the correct sales rep to each transaction per customer is possible, and I'll walk you through the process.

 

On the Customers menu, go to the Customer Center again. Pick Invoices or Sales Receipts under Transactions. From there, select the customer and make the necessary changes to the REP field on each template. To save the changes, click Yes. Once done, you'll be prompted to choose between applying it to all the transactions or the current ones.

 

Here are some screenshots for reference:

 

 

Follow the steps above to add the REP field to the sales receipt template. After that, locate your customer's name for the update. I'm adding snippets for your guide:

 

1.png

 

2.png

 

You can check out this article about different reports in the program: Customize customer, job, and sales reports in QuickBooks Desktop. It provides information about creating specific custom reports, such as sales orders and payments.

 

That should do it. Please get back to me if you still have another set of questions about sales rep. I’ll be on the lookout for your response. Take care!

View solution in original post

6 Comments 6
JamaicaA
QuickBooks Team

Sales rep by transaction

I really appreciate all of those details, @PizzaPlus. Tracking Sales Reps can be tricky, and you've already verified a specific customer has assigned to it. I'm here to help show the transactions to the report and make sure you'll be an expert at it in no time.

 

You're right. You'll need to add the Reps per transaction to show them on the report. Not to worry, I'll share a way to do that.

 

Let's customize the sales orderpurchase orders, and invoices template. I'll show you how:

 

  1. Go to Customers at the top, then click Customer Center.
    Capture A1.PNG
     
  2. Under the Transactions, select the Invoices.
  3. Locate the customer's name.
    Capture A2.PNG
  4. On that page, go to the Formatting tab and then Customize Data Layout.
    Capture A3.PNG
  5. In the window that appears, select the Header tab.
  6. Find REP on the list and select the Screen and Print boxes to add it.
  7. Hit OK once done. 
    Capture A4.PNG

See this article for detailed guidance: Create and use custom fields in QuickBooks Desktop.

 

With all of that information, you should be on track to finish running Sales rep by transaction with ease. However, if you have any more questions about this, or other issues while learning QBDT, I am always here to assist in whatever way I can. In the meantime, I hope you have a great day.

PizzaPlus
Level 2

Sales rep by transaction

Thank you @JamaicaA for your quick reply!

 

It was very helpful!

 

I have most of my customers that are missing the rep in their invoices &/or sales receipts. I figured out how to globally add the field to each template.

 

However, my follow up question is: Is there a way to go back & add the correct sales rep to each transaction for each customer? This is going to otherwise take me hours...


Thank you again!

JamaicaA
QuickBooks Team

Sales rep by transaction

You're always welcome, @PizzaPlus. Going back & adding the correct sales rep to each transaction per customer is possible, and I'll walk you through the process.

 

On the Customers menu, go to the Customer Center again. Pick Invoices or Sales Receipts under Transactions. From there, select the customer and make the necessary changes to the REP field on each template. To save the changes, click Yes. Once done, you'll be prompted to choose between applying it to all the transactions or the current ones.

 

Here are some screenshots for reference:

 

 

Follow the steps above to add the REP field to the sales receipt template. After that, locate your customer's name for the update. I'm adding snippets for your guide:

 

1.png

 

2.png

 

You can check out this article about different reports in the program: Customize customer, job, and sales reports in QuickBooks Desktop. It provides information about creating specific custom reports, such as sales orders and payments.

 

That should do it. Please get back to me if you still have another set of questions about sales rep. I’ll be on the lookout for your response. Take care!

Joel-OnTrack
Level 2

Sales rep by transaction

@PizzaPlus

 

You cannot update the rep of existing transactions in bulk within QB.

 

3rd party apps like SaasAnt and Transaction Pro can handle this.

(But depending on how your invoice details look, you may get unexpected results.)

 

Advanced users accomplish this by using the SDK, ODBC, etc.

 

Let me know if this helps.

PizzaPlus
Level 2

Sales rep by transaction

Thank you-I'll check them out!

PizzaPlus
Level 2

Sales rep by transaction

Thank you so much for your help!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us