立信的凭证纸调账簿打印,可是怎么都调不好,纸张也自定义了-是TR201的纸张
2017-12-8 0:0:0 wondial立信的凭证纸调账簿打印,可是怎么都调不好,纸张也自定义了-是TR201的纸张
立信的凭证纸调账簿打印,可是怎么都调不好,纸张也自定义了是TR201的纸张![](http://sto.chanapp.chanjet.com/4a47ecad-3fcd-422b-879b-b2df91606e00/img/2016/01/29/1454031111FRKS.jpg)
先把左右的页边距都先调整为0,再根据打印出来的效果进行调整。
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- T3卸载就会跳到安装界面去,用360工具也卸载不了。请问这种情况哪位老师遇见过,我们应该如何处理。谢谢、在线等。2019-4-30 8:0:0
- 用友T3-用友通标准版调拨单单价问题2019-4-23 8:0:0
- 用友T3-用友通标准版老板通中我的报表查询后没有任何报表信息,只有示例报表。2019-4-23 8:0:0
- 用友T3-用友通标准版登录固定资产模块失败2019-4-23 8:0:0
- 用友T3-用友通标准版登入系统管理,账套两个字是灰色2019-4-23 8:0:0
- 用友T3-用友通标准版登入用友T3软件,提示演示期限已过期,请插加密狗进行远程注册。2019-4-23 8:0:0
- 用友T3-用友通标准版材料出库单上的自定义项点击后没反应2019-4-23 8:0:0
- 用友T3-用友通标准版明细账选择月份的下拉框中没有1、2月份2019-4-23 8:0:0
- 用友T3-用友通标准版打印的凭证上没有显示制单人、记账人的姓名2019-4-23 8:0:0
- 用友T3-用友通标准版录完期初后,总账系统和往来管理中往来科目期初余额不一致2019-4-23 8:0:0
最新信息
![用友财务通标准版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 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
![U6普及版(原U8普及版3.0)客户端连不到服务器](http://yun.kuaiji66.com/zb_users/plugin/MiniTu/noimg.png)
U6普及版(原U8普及版3.0)客户端连不到服务器U6普及版(原U8普及版3.0)客户端连不到服务器
U6普及版(原U8普及版3.0)-客户端连不到服务器
自动编号: | 19884 | 产品版本: | U6普及版(原U8普及版3.0) |
产品模块: | 总账 | 所属行业: | 通用 |
适用产品: | U8 | 关 键 字: | |
问题名称: | 客户端连不到服务器 | ||
问题现象: | 客户端连不到服务器 | ||
原因分析: | 服务器设置了安全设置,每次连的时候都要从新访问一下服务器 | ||
解决方案: | 将服务器中的安全设置重新设置,问题解决。 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |