如题所述
1ãä¸ä¸ç建账å¼å§æ¶æï¼è®¾ç½®åæ°ï¼å¯ä»¥éæ©æ»ä»æè
åä»æ ¸ç®ï¼ä¸æ¦éå®ï¼æé®å°±åæç°è²ï¼ä¸è½åæ¹ã
2ãå¨è½¯ä»¶ä¸ä¸è½æ¹åï¼åªè½éè¿åå°çæ¹æ³æ´æ¹ãä¸è¬ä¸å»ºè®®ä¿®æ¹ã
åèï¼
æ»ä»æ ¸ç®ï¼icbal表ä¸çFstockGroupIDå段å为0ï¼
åä»æ ¸ç®ï¼icbal表ä¸çFstockGroupIDå段å为stockid(å ·ä½çä»åºå ç )ã
åæï¼å¤ä»½è´¦å¥æ°æ®
é¦å ï¼ä¿®æ¹åè´§æ ¸ç®æ¹å¼ä¸ºåä»æ ¸ç®
select * from t_systemprofile where fcategory='ic'
update t_systemprofile set fvalue=1 where fcategory='ic' and fkey='CalculateType'
å ¶æ¬¡ï¼æ¸ é¤icbal表ä¸çæ°æ®
delete from icbal
æåï¼å°icinvbal表ä¸çæ°æ®æå ¥å°icbal表
GO
insert into icbal
select FBrNo,FYear,FPeriod,FItemID,FBatchNo,FBegQty,FReceive,FSend,FYtdReceive,
FYtdSend,FEndQty,FBegBal,FDebit,FCredit,
FYtdDebit,FYtdCredit,FEndBal,FBegDiff,FReceiveDiff,FSendDiff,FEndDiff,FBillInterID,
0,FStockID,FYtdReceiveDiff,
FYtdSendDiff,FSecBegQty,FSecReceive,FSecSend,FSecYtdReceive,FSecYtdSend,FSecEndQty,
FStockInDate,FAuxPropID
from icinvbal
GO
2ãå¨è½¯ä»¶ä¸ä¸è½æ¹åï¼åªè½éè¿åå°çæ¹æ³æ´æ¹ãä¸è¬ä¸å»ºè®®ä¿®æ¹ã
åèï¼
æ»ä»æ ¸ç®ï¼icbal表ä¸çFstockGroupIDå段å为0ï¼
åä»æ ¸ç®ï¼icbal表ä¸çFstockGroupIDå段å为stockid(å ·ä½çä»åºå ç )ã
åæï¼å¤ä»½è´¦å¥æ°æ®
é¦å ï¼ä¿®æ¹åè´§æ ¸ç®æ¹å¼ä¸ºåä»æ ¸ç®
select * from t_systemprofile where fcategory='ic'
update t_systemprofile set fvalue=1 where fcategory='ic' and fkey='CalculateType'
å ¶æ¬¡ï¼æ¸ é¤icbal表ä¸çæ°æ®
delete from icbal
æåï¼å°icinvbal表ä¸çæ°æ®æå ¥å°icbal表
GO
insert into icbal
select FBrNo,FYear,FPeriod,FItemID,FBatchNo,FBegQty,FReceive,FSend,FYtdReceive,
FYtdSend,FEndQty,FBegBal,FDebit,FCredit,
FYtdDebit,FYtdCredit,FEndBal,FBegDiff,FReceiveDiff,FSendDiff,FEndDiff,FBillInterID,
0,FStockID,FYtdReceiveDiff,
FYtdSendDiff,FSecBegQty,FSecReceive,FSecSend,FSecYtdReceive,FSecYtdSend,FSecEndQty,
FStockInDate,FAuxPropID
from icinvbal
GO
温馨提示:答案为网友推荐,仅供参考