销售月结,检查的时候,提示有收款单没有核销,怎么补上收款单的核销?谢谢
2018-5-9 0:0:0 wondial销售月结,检查的时候,提示有收款单没有核销,怎么补上收款单的核销?谢谢
销售月结,检查的时候,提示有收款单没有核销,怎么补上收款单的核销?谢谢[]您好:您可以将该收款单删除或者将其生成预付,或者核销应收款项我就是想核销应收款项?但是,一直操作不对,怎么操作?谢谢界面截图明天发给你,我下班了ok您只需要选择这个客户就会带出没有核销的收款单,然后点核销,在表体部分选择需要核销的记录和输入本次核销金额保存即可您好:请去付款单界面操作,按照我上面的操作方法我是销售,怎么在付款单界面操作?第一张核销了,第二章点核销按钮的时候,出现灰色的,并且没有带出数据来,您帮我看看是怎么回事?谢谢你是不是这个客户已经没有应收款核销了我可能多做了一笔收款单,不好意思,我在检查一下,谢谢!不客气[/微笑]不客气
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
最新信息
用友财务通标准版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 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
开征遗产税需要更多的现实论证 开征遗产税需要更多的现实论证
在很多国家,遗产税都已推行多年。特别是在欧美的一些福利制度较完善的发达国家,遗产税的征收已成为国家调控国民收入、缓和贫富悬殊的重要手段。但在前段时间,当中国拟征收遗产税的消息传出,便迅速发酵成一个社会热点话题。对于中国现阶段该不该征收遗产税及遗产税起征点的问题,民间争议四起。
根据以往其他国家的经验,征收遗产税的时机相当重要。征收得早了,税源缺乏稳定、有保障的基本面,政府实际上征收到的钱可能不多,却对社会资本的热情会起到不合时宜的打击作用,甚至可能会引发资本外逃的现象;征收得晚了,遗产税调控国民收入、缓和贫富悬殊的初衷以及实际意义已不复存在,因为真正的税源已经失去—上一代人的巨额财富可能已通过各种手段成功转移给下一代人。