Solved

Discounts on printed forms and ability to report discounts over time

L
Rank
Userlevel 6
Badge +5

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!

icon

Best answer by Kandy Beatty 23 May 2022, 17:23

View original
If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

5 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @ltussing03 

Here is one that we have used:

Let me know if this helps. 

1 Attachment
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
L
Rank
Userlevel 6
Badge +5

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!

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Kandy Beatty
Rank
Userlevel 7
Badge +16

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. 

 

 

1 Attachment
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
L
Rank
Userlevel 6
Badge +5

Kbeatty,

 

You are officially my favorite person of the day!

Thank you for taking the time and effort to help!

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Kandy Beatty
Rank
Userlevel 7
Badge +16

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. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved