|
問(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, Goo±₩±dsID, BaseID, InAndOutType, ∞"€Qua, Optime, [Date], 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, eoIte∑σ£ms.ID FROM eoItems INNER JOIN eoSheet ON eoItems.SheetID = ☆←eoSheet.SheetID WHERE (eoSheet.IsAcc = 1) AND (eoShee✘™÷t.IsStop = 0) AND (eoSh> eet.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ù)部。 |