|
問(wèn)題:企業(yè)版,出貨單關聯了(le)訂單入賬之後出貨數(shù)量不(bù)回寫訂單,訂單中的(de)已出貨數(shù)量不(bù)變。
分(fēn)析:這(zhè)都(dōu)是(shì)從(cóng)舊(jiù)版本升級上(shàng)來(lái)的(de)數(shù)據才會(huì)有(yǒ↕u)此問(wèn)題,并且這(zhè)些(xiē)訂單也(yě)都(dōu)是(shì)在用(yòng)舊(jiù)版本的(de)時(shí)候開(kāi)的(de),如(rú)果是(¥shì)新開(kāi)的(de)就(jiù)不(bù)會(huì)有(yǒu)此問(wèn)題。
處理(lǐ):在查詢分(fēn)析器(qì)中執行(xíng)以下(xià)語句, INSERT INTO TempCustoday (SheetID, SheetType, GoodsID, BaseID, InAndOutType, Qua, Optime, [Da↕te], Hold, IsHold, itemid) SELECT eoItems.SheetID, 3 AS Sheettype, eoItems.GoodsID, eoSheet.BaseID, 2 AS inAndOutType, eoItems.Qua, 2010 - 03 - 03 AS optime, 2010 - 03 - 03 AS dat, 0 AS hold, 0 AS ishold, eoItems.ID FROM eoItems INNER JOIN eoSheet ON eoItems.SheetID = eoSheet.SheetID WHERE (eoSheet.IsAcc = 1) AND (eoSheet.IsStop = 0) AND (eoSheet✔.IsEnd = 0) 然後将eosheet表的(de)errdate為(wèi)空(kōng)的(de)更新今天的(de)日(rì)期進去(qù),問(wèn)題解決。 總結:從(cóng)舊(jiù)版本升級到(dào)企業(yè)版,由于數(shù)據結構不(bù)一(yī)樣,σ所有(yǒu)多(duō)多(duō)少(shǎo)少(shǎo)會(huì)出現(xiàn)一(yī)些(xiē)σ小(xiǎo)問(wèn)題,如(rú)遇到(dào)問(wèn)題具體(tǐ)解決方法請(qǐng)來(lái)電(diànγ)咨詢我們的(de)技(jì)術(shù)部。 |