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