【問(wèn)題現(xiàn)象】

選項(xiàng)設(shè)置中數(shù)量/單價(jià)小數(shù)位修改成4位，保存后，新增單據(jù)界面顯示的還是2位小數(shù)位，并且選項(xiàng)設(shè)置中不能再改為2位小數(shù)位，選項(xiàng)設(shè)置未生效。

【解決方案】

1、單價(jià)小數(shù)位不生效

備份賬套執(zhí)行下面腳本，將單價(jià)小數(shù)位恢復(fù)默認(rèn)值，然后再重新修改單價(jià)小數(shù)位數(shù)選項(xiàng)即可。

update EAP_AccInformation set Value = 2 where [SysID]=N'UA' and [Name] =N'PricePrecision'

2、數(shù)量小數(shù)位不生效

請(qǐng)備份賬套執(zhí)行下面腳本，然后再重新修改數(shù)量小數(shù)位數(shù)選項(xiàng)即可。

UPDATE sm_optexpression SET ExpressionType='string'

WHERE ExpressionName in ('XT_IsDiscardZero_MultiUnit_QuantityPrecision','XT_IsDiscardZero_QuantityPrecision')

AND TableName='eap_reporttablecol'

AND ColumnName='format' AND ExpressionType='bool'

DECLARE @acc_QuantityPrecision int

SELECT @acc_QuantityPrecision=value FROM dbo.EAP_AccInformation WHERE Name='QuantityPrecision'

DECLARE @Pur_QuantityPrecision int

SELECT TOP 1 @Pur_QuantityPrecision=Precision FROM dbo.eap_VoucherTableColumn WHERE VoucherID IN(SELECT id FROM eap_voucher WHERE name='PurchaseOrder') AND FieldName='Quantity'

IF(@acc_QuantityPrecision<>@Pur_QuantityPrecision)

BEGIN

UPDATE EAP_AccInformation SET Value= @Pur_QuantityPrecision WHERE Name='QuantityPrecision'

End