Skip to Content
0
Former Member
Dec 09, 2011 at 04:05 PM

APPROVAL PROCEDURE FOR DISCOUNT AT ROW LEVEL

83 Views

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

discount-query

I am using SB0 8.81 PL9.

Your assistance is appreciated.

George Njuguna