Skip to Content
0
Former Member
Oct 30, 2012 at 11:32 AM

Service type document total calculation issue (FMS)

278 Views

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