Skip to main content
Solved

Discounts on printed forms and ability to report discounts over time

  • 22 May 2022
  • 5 replies
  • 137 views

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!

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. 

Kbeatty,

 

You are officially my favorite person of the day!

Thank you for taking the time and effort to help!

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. 

 

 

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!

HI @ltussing03 

Here is one that we have used:

Let me know if this helps. 

Reply


Terms & ConditionsCookie settings