必须每月都要报税吗?如果当月有事报不了怎么办 _0
2018-2-23 0:0:0 wondial必须每月都要报税吗?如果当月有事报不了怎么办 _0
必须每月都要报税吗?如果当月有事报不了怎么办[]交罚款交滞纳金只有这样了?哎每月必须申报纳税,就是零也要零申报的罚滞纳金
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 登录T3提示运行错误48 无法找到文件 getAccossmode 卸载软件重新安装 T3卸载不掉怎么办2019-5-10 7:0:0
- 用友T3用友通系统重装后,没有账套备份,如何恢复账套2019-4-29 8:0:0
- CRM11.5中将线索转换成客户,转换失败2019-4-23 8:0:0
- U8+的条码管理在存货拆箱场景如何应用?2019-4-23 8:0:0
- U8+可否与仓库温湿度自动监控系统数据对接?2019-4-23 8:0:0
- U8+中财务会计的内容与以前的版本相比有哪些改进?2019-4-23 8:0:0
- U8+HR产品的特色主要有哪些?2019-4-23 8:0:0
- U8+HR中在不同的应用阶段,其模块应如何选择?2019-4-23 8:0:0
- U8+ MA的核心价值是什么,能帮助客户解决的关键问题是什么?2019-4-23 8:0:0
- U8+ HR如何处理离职人员再入职业务?2019-4-23 8:0:0
最新信息

T+专业版系统,基础设置~常用信息设置~计量单位~单计量和多计量,请问这单计量和多计量怎么区分?什么样的计量单位是单计量范单位?什么样计量单位是多计量单位? T+专业版系统,基础设置~常用信息设置~计量单位~单计量和多计量,请问这单计量和多计量怎么区分?什么样的计量单位是单计量范单位?什么样计量单位是多计量单位?[]
只有一个单位,比如1箱就是单计量,比如啤酒1箱=12瓶,就要用到多计量。

用友通2005现存量整理后还是不对怎么办-通2005现存量整理后还是不对怎么办?
通2005-现存量整理后还是不对怎么办?
自动编号: | 6311 | 产品版本: | 通2005 |
产品模块: | 总账 | 所属行业: | 通用 |
适用产品: | 关 键 字: | 现存量整理有误 | |
问题名称: | 现存量整理后还是不对怎么办? | ||
问题现象: | 现存量整理后还是不对怎么办? | ||
原因分析: | 见问题答案 | ||
解决方案: | 执行如下脚本: 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 >= '2007-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) 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |