Skip to Content
0
Former Member
Jun 15, 2011 at 08:35 AM

Decimal Problem

45 Views

select

T0.U_ItemCode,

T0.U_ItemName,

T0.U_Forecast,

SUM(T0.U_mrpqty)'Simulated Qty',

(select sum(onHand) from OITW T1 where T1.ItemCode = T0.U_itemcode) 'Current Quantity',

(select T3.ItmsGrpNam from OITM T2 inner join OITB T3

on T2.ItmsGrpCod = T3.ItmsGrpCod where T2.ItemCode = T0.U_itemcode)'Item group name'

from [dbo].[@QUOTA1] T0

where T0.U_ItemCode >= '[%0]' and T0.U_ItemCode <= '[%2]'

and T0.U_Forecast = '[%1]'

group by

T0.U_itemcode,

T0.U_itemname,

T0.U_Forecast

When I run this query in SQL server 2008, in 'Simulated Qty' and Current Quantity the values are coming like 0.002084

6 decimal places after point, but in SAP B1, it comes .00