Skip to main content
Solved

Discounts on printed forms and ability to report discounts over time


Forum|alt.badge.img+6

Hello,

I have successfully created and used multiple group discount codes on a sales order.

However, these are only printed as 1 “discount” on the sales order.  You can see each individual one in the Sales Order screen.  If a customization is required, can anyone point me in the right direction for what tables to utilize?

 

They do not print at all on the invoice, the total is just different without printing anything saying why.

 

On a different but related note, is it possible within a GI or report to show the discount amount given for Discount Code “XXX” for a given date range?  I don’t see any available reporting for discount codes.

 

If it needs to be a custom report, can anyone point me to the correct tables?

 

Thanks!

Best answer by Kandy Beatty

Hi @ltussing03 

Here is a screenshot of the Tables and Relations for you to build it. I am also adding the excel of the Results Grid for your reference. 

 

 

View original
Did this topic help you find an answer to your question?

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16

HI @ltussing03 

Here is one that we have used:

Let me know if this helps. 


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 279 replies
  • May 23, 2022

KBearry,

 

Thanks!  I don’t seem to be able to directly download the file from this post.

I was going to download your GI and import it to check it out.

Can you offer any advise on how I can get this?

Thanks again for your willingness to share!


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • Answer
  • May 23, 2022

Hi @ltussing03 

Here is a screenshot of the Tables and Relations for you to build it. I am also adding the excel of the Results Grid for your reference. 

 

 


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 279 replies
  • May 23, 2022

Kbeatty,

 

You are officially my favorite person of the day!

Thank you for taking the time and effort to help!


Kandy Beatty
Captain II
Forum|alt.badge.img+16
ltussing03 wrote:

Kbeatty,

 

You are officially my favorite person of the day!

Thank you for taking the time and effort to help!

You are so welcome! I hope this helps. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings