铜梁在哪里培训物业管理
2018-3-29 0:0:0 wondial铜梁在哪里培训物业管理
铜梁在哪里培训物业管理''如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 用友T3用友通系统重装后,没有账套备份,如何恢复账套2019-4-29 8:0:0
- 企业是接单生产模式,需求不稳定,经常出现紧急订单,如何判断这样的紧急订单会不会造成计划和生产的..2019-4-27 8:0:0
- 企业在车间管理中,可以依据工段、车间、设备、员工等多种资源进行明细式派工?2019-4-27 8:0:0
- 以物易物在用友T3用友通通2005中如何实现2019-4-27 8:0:0
- 什么是安全库存、最低库存、最高库存?用友软件U8+中是如何管理的?2019-4-27 8:0:0
- 一般企业普通采购流程分为哪几种?2019-4-23 8:0:0
- 会计在填制凭证时会出现漏录某张凭证的情况,系统支持补录会计凭证吗?_12019-4-23 8:0:0
- 企业的生产班组能生产哪些品种,产能有多大很明确,这种情况下ERP系统能不能代替人工按照生产计划..2019-4-23 8:0:0
- 什么是动态安全库存?U8+的动态安全库存是如何实现的?2019-4-23 8:0:0
- 为什么说用友U8+的成本管理是一个完整的成本管理体系?2019-4-23 8:0:0
最新信息
![用友通2005如何区分全部结算和部分结算的入库单??](http://yun.kuaiji66.com/zb_users/plugin/MiniTu/noimg.png)
用友通2005如何区分全部结算和部分结算的入库单??通2005如何区分全部结算和部分结算的入库单??
通2005-如何区分全部结算和部分结算的入库单??
自动编号: | 4046 | 产品版本: | 通2005 |
产品模块: | 购销存 | 所属行业: | 通用 |
适用产品: | 1 | 关 键 字: | 不完全采购单据结算,是否可以区分 |
问题名称: | 如何区分全部结算和部分结算的入库单?? | ||
问题现象: | 一张入库单上有两条记录,但发票只开了其中一条记录的金额,只对入库单中的那一条记录和发票对应结算,但入库单上也显示“已结算”字样,在查询入库单怎样才能区分全部结算和部分结算的入库单,有什么标记或方法可以区分?? | ||
原因分析: | 在采购入库单据界面不能区分出来. 可以在采购结算表和综合统计表中查看 | ||
解决方案: | 在采购入库单据界面不能区分出来. 可以在采购结算表和综合统计表中查看 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
![用友财务通标准版821财务通现存量不对](http://yun.kuaiji66.com/zb_users/plugin/MiniTu/noimg.png)
用友财务通标准版821财务通现存量不对财务通标准版821财务通现存量不对
财务通标准版821-财务通现存量不对
自动编号: | 5782 | 产品版本: | 财务通标准版821 |
产品模块: | 存货核算 | 所属行业: | 通用 |
适用产品: | 4 | 关 键 字: | 现存量 |
问题名称: | 财务通现存量不对 | ||
问题现象: | 财务通现存量不正确怎么办? | ||
原因分析: | 执行以下脚本能解决问题 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> 0INSERT 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 | ||
解决方案: | 执行以下脚本能解决问题 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> 0INSERT 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 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |