Hello Experts,
One of our customers charge Damage Fee when customers rent items for certain item groups.
Can have a user enter how much percentage the damage waiver should be so that FMS will calculate the value accordingly:
Total Order - $500
CSR enter 10 % on FMS
When clicked on globe icon system gets Damage Waiver Price - $50
Total Rental Order - $1000
CSR enter 20 % on FMS
When clicked on globe icon system gets Damage Waiver Price - $100
Declare @Percent Decimal(12,2)
Set @Percent=(Select Top 1 T4.U_DamWaiver from [@BIZ_ORDR] T4 where T4.U_DamWaiver='[%0]')
SELECT CAST(SUM(T1.U_TtlAmt) as decimal(12,2))*(@Percent/100)
FROM [@BIZ_ORDR] T0
INNER JOIN [@BIZ_RDR1] T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OITM T3 ON T1.U_ItemCode=T3.ItemCode
WHERE T3.ItmsGrpCod in ('101','102') AND T0.[DocNum]=$[@BIZ_ORDR.DocNum]