存貨生成憑證問(wèn)題
發(fā)布于:2018-02-05 13:42:58
問(wèn)題現(xiàn)象:存貨模塊生成憑證時(shí),按調(diào)撥單制單,借貸方差一分錢,不能保存. 有好幾張單子如此,舉例具體單據(jù)為:其他入庫(kù)單 :0000035977.其他出庫(kù)單: 0000035011.
解決方案:請(qǐng)執(zhí)行如下腳本進(jìn)行調(diào)整,修改前請(qǐng)務(wù)必做好數(shù)據(jù)備份: update b set iaoutprice= round((iaoutquantity * ioutcost),2) from rdrecords a join ia_subsidiary b on a.autoid=b.id where a.id in (25350,36062,25349,36061) and iaoutprice<> round((iaoutquantity * ioutcost),2)