整理现存量脚本
2015-4-3 0:0:0 wondial整理现存量脚本
整理现存量: Delete From CurrentStock if exists(select * from sysobjects where name='tempcurrentstock') drop table TempCurrentStock SELECT cWhCode,cInvCode,(CASE WHEN cFree1=''THEN NULL ELSE cFree1 END) AS cFree1 ,(CASE WHEN cFree2=''THEN NULL ELSE cFree2 END) AS cFree2 ,iainquantity AS iQuantity, CAST(0 AS FLOAT) AS fOutQuantity,CAST(0 AS FLOAT) AS fInQuantity INTO TempCurrentStock From ia_subsidiary Where cvoutype='34' group by ia_subsidiary.cWhCode,ia_subsidiary.cInvCode,ia_subsidiary.cFree1,ia_subsidiary.cFree2,ia_subsidiary.iainquantity INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,iQuantity) SELECT cWhCode, cInvCode,(CASE WHEN cFree1=''THEN NULL ELSE cFree1 END) AS cFree1 ,(CASE WHEN cFree2=''THEN NULL ELSE cFree2 END) AS cFree2 , (CASE WHEN bRdFlag<>0 THEN iQuantity ELSE -iQuantity END) AS iQuantity FROM RdRecord INNER JOIN RdRecords ON RdRecord.ID = RdRecords.ID WHERE cVouchType<>'33'AND cVouchType<>'34' AND RdRecord.dDate>='2021-1-01' (该日期为模块启用日期) INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,fOutQuantity) SELECT EnDispatchs.cWhCode, EnDispatchs.cInvCode,(CASE WHEN EnDispatchs.cFree1='' THEN NULL ELSE EnDispatchs.cFree1 END) AS cFree1 ,(CASE WHEN EnDispatchs.cFree2='' THEN NULL ELSE EnDispatchs.cFree2 END) AS cFree2 , (ISNULL(iQuantity,0)-ISNULL(fOutQuantity,0)) AS fOutQuantity FROM EnDispatch INNER JOIN EnDispatchs ON EnDispatch.EDID = EnDispatchs.EDID WHERE ISNULL(EnDispatchs.cWhCode,'')<>'' AND ISNULL(EnDispatch.cSTCode,'')<>'' AND EnDispatchs.iQuantity>0 AND bReturnFlag=0 INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,fOutQuantity) SELECT DispatchLists.cWhCode as cWhCode, DispatchLists.cInvCode as cInvCode,(CASE WHEN DispatchLists.cFree1='' THEN NULL ELSE DispatchLists.cFree1 END) AS cFree1 , (CASE WHEN DispatchLists.cFree2='' THEN NULL ELSE DispatchLists.cFree2 END) AS cFree2 , (ISNULL(iQuantity,0)-ISNULL(fOutQuantity,0)) AS fOutQuantity FROM DispatchLists INNER JOIN DispatchList ON DispatchLists.DLID = DispatchList.DLID WHERE DispatchList.cVouchType='05' AND ISNULL(DispatchLists.cWhCode,'')<>'' AND ISNULL(DispatchList.cSTCode,'')<>'' AND (DispatchList.iSale=0 or DispatchList.iSale IS NULL) AND DispatchLists.iQuantity>0 INSERT INTO TempCurrentStock(cWhCode,cInvCode,cFree1,cFree2,fOutQuantity) SELECT cWhCode, cInvCode,(CASE WHEN cFree1=''THEN NULL ELSE cFree1 END) AS cFree1 , (CASE WHEN cFree2=''THEN NULL ELSE cFree2 END) AS cFree2 , (ISNULL(iQuantity,0)-ISNULL(fOutQuantity,0)) AS fOutQuantity FROM SaleBillVouchs INNER JOIN SaleBillVouch ON SaleBillVouch.SBVID=SaleBillVouchs.SBVID WHERE ISNULL(SaleBillVouchs.cWhCode,'')<>'' AND (SaleBillVouch.iDisp=0 OR SaleBillVouch.iDisp IS NULL) AND ISNULL(cBusType,'')<>'委托' AND ISNULL(cSTCode,'')<>'' AND ISNULL(cInvalider,'')='' AND SaleBillVouchs.iQuantity>0 INSERT INTO CurrentStock(cWhCode,cInvCode,cFree1,cFree2,iQuantity,fOutQuantity,fInQuantity) SELECT cWhCode, cInvCode,cFree1,cFree2 , sum(iQuantity) AS iQuantity,sum(ISNULL(fOutQuantity,0)) AS fOutQuantity, sum(ISNULL(fInQuantity,0)) AS fInQuantity FROM TempCurrentStock GROUP BY cWhCode,cInvCode,cFree1,cFree2 Delete From CurrentStock where iquantity is null and foutquantity=0 and finquantity=0如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 用友U8材料采购科目借贷发生不平有余额是什么原因详解2021-10-9 9:57:49
- 用友ERP-U8成本管理模块培训2019-5-13 12:8:25
- invalid object name 'tempdb..temp-accvouch70554a1232019-4-23 8:0:0
- 实时错误‘404’:automation错误2019-4-23 8:0:0
- 对于用友软件进行SQL跟踪器时,应注意什么问题?能写个步骤吗?2019-4-23 8:0:0
- 我们企业成本精细核算,需要针对每一件存货的每一次出入库进行记账, u8 能够支持吗2019-4-23 8:0:0
- 明细账打印预览死机2019-4-23 8:0:0
- 进UFO时总提示“MFC42.DLL中导致无效页错误就关闭退出2019-4-23 8:0:0
- 连接不上服务器故障分析2019-4-23 8:0:0
- 下标越界,用友软件年结后查询货位票未能统计表报错2019-4-23 8:0:0
最新信息
![违约金的会计和税务处理分析 _0](https://www.kuaiji66.com/u8/zb_users/plugin/MiniTu/noimg.png)
违约金的会计和税务处理分析 _0违约金的会计和税务处理分析
企业收取和支付的违约金是单位因违反经济合同,不能履行全部或部分经济合同,依据约定的条款收取或给予对方的一种经济赔偿。在经济活动中,违约金的收付,的规定和具体的凭证处理不尽相同。
卖方收取违约金的处理
卖方收取违约金,是销售方或提供劳务方向购买方或接受劳务方收取的违约金,一般会被认定为价外费用。
例如,A公司购买B公司货物,合同约定价款100万元,付款期限为货物交付10天内。10天期限内,A公司未按约定付款。50天后,A支付货款100万元,并按合同约定,向B公司支付违约金3万元。此违约金为正向违约金。