Dear Experts,
Please assist me set a query that triggers an approval procedure when discount at row level for an item group component exceeds a defined limit.
I have the following querywhich picks the discount violation at row level but it does not trigger the approval procedure
SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T0.[DiscSum], T0.[GrosProfit], T1.[ItemCode], T1.[Quantity], T1.[DiscPrcnt], T2.[CstGrpCode], T2.[ItmsGrpCod] FROM [dbo].[OINV] T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T2.[ItmsGrpCod] = 104 and T1.[DiscPrcnt] >='0.2'
I have checked the following posts but am still in the dark.
calculating-total-discount-at-the-row-level
approval-procedure-in-line-discount
I am using SB0 8.81 PL9.
Your assistance is appreciated.
George Njuguna