Skip to main content

Hi All,

I’m trying to get more granular detail behind the discounts that we’re running through the system.

The idea is that I should be able to report on discounts by Customer, Warehouse, InventoryID, DiscountCode (Line Level) , DiscountCode(Group Level).

 

We are currently running multiple concurrent group level discounts with quite specific conditions so there are some instances where a single SO line has 3 group level discounts applied to it.

 

Is there a table/ query that would allow me to see which lines on the SO a single group level discount code/ discount sequence has been a applied.

 

Ideal Outcome:

 

 

Thanks in advance

Be the first to reply!

Reply