Dear All
I have an issue related to FMS which i have assigned to total field in service type document ( the FMS query is below ) its working correct but the system treating Unit Price as line total that's why the calculation difference is treating as a discount.
E.g.
Unit Price = 25
Service Qty = 50
Total = 1250 ( calculating correct by FMS - The FMS query is given below)
Discount = -4900 % ( this field is getting automatically which should be ZERO)
FMS query
declare @m as money
declare @n as nvarchar(40)
declare @o as varchar(40)
declare @p as money
declare @q as varchar(40)
declare @r as money
declare @total as money
declare @ntotal as varchar(40)
set @n = $[$39.5.0]
set @n = substring(@n,4,(len(@n)))
set @m = cast(@n as money)
set @o = $[$39.U_serviceqty.0]
set @p = cast(@o as money)
set @total=@m*@p
set @ntotal=cast(@total as nvarchar(40))
select @ntotal
SAP Business One 8.81 (8.81.315) PL: 07
Pls Suggest
Regards,
Madhukar