Decimal Problem

[Former Member]

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

[Former Member]

Hi Rupa,

In SAP i will show only 0.00 because in general setting we normally give 2 to 3 decimal places. so the system takes 0.00 from 0.002..... see the first 2 decimals are 0. so it will display as 0 only...

As suggested u can add decimals but keep in mind once the decimal numbers are increased u cannot decrease them. if ur ok with that then go ahead.

regards,

Vignesh

[former_member204969]

The number of decimals can not be decreased in general, but the Decimals in Query can be decreased!

[Former Member]

HI

your question is on simulated quantity or decimals in B1?

If you want the B1 to show the additional decimals,then Administration->System initialisation->General settings.

Under 'Display' tab,set the Decimals in query as '6'..

Edited by: kambadasan on Jun 15, 2011 2:08 PM