博主 畅捷通T+存货 体积在哪里设置小数位 比如4-5位，修改语句
[全站通告] 想快速节省您的时间并可接受付费的朋友，可扫右边二维码加博主微信-非诚勿扰！
这个小数位数不能设置，只能通过数据库执行语句修改
修改语句
下面语句把重量和体积小数位改成了3位。操作前建议备份账套
DECLARE @idVoucher AS INT
SELECT @idVoucher=id FROM dbo.eap_Voucher WHERE Title='存货'
update dbo.eap_VoucherControls SET Precision=3 WHERE voucherid=@idVoucher AND name IN ('InvVolume','InvWeight')
UPDATE dbo.Eap_ColumnSet_user SET Precision =3 WHERE SolutionID IN(SELECT id FROM dbo.Eap_ColumnSetSolution_User WHERE Name=N'InventoryDTO') AND Field IN ('InvWeight','InvVolume')
UPDATE dbo.Eap_ColumnSet SET Precision =3 WHERE SolutionID IN(SELECT id FROM dbo.Eap_ColumnSetSolution WHERE Name=N'InventoryDTO') AND Field IN ('InvWeight','InvVolume')
