Skip to Content
0
Former Member
Jan 18, 2011 at 04:15 PM

Formatted Search - User-Defined %

29 Views

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]