发票未开,客户已把钱汇入对公账户。如何处理?
2017-8-10 0:0:0 wondial发票未开,客户已把钱汇入对公账户。如何处理?
发票未开,客户已把钱汇入对公账户。如何处理?[]预收账款或应收账款挂着做预收账款,等发票开了,做应收预收账款做应收账款啊做预收账款处理,如果在应收账款的时候又这个企业的名字,避免多头挂账,可以做应收账款,只是方向错误的问题
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- T3标准版,在打开“系统管理”的时候提示运行时错误-2147319779 automation错误2021-6-16 9:2:54
- 普及版,正常的年结步骤,为什么年结后没有总账期初余额2021-6-16 8:59:38
- T3固定资产卡片上自动带出折旧科目2021-4-26 17:18:14
- 用友T3标准版和速达的区别2020-4-30 10:20:48
- 用友软件期初余额里面没有没有年初余额和累计借方金额、累计贷方金额2020-4-28 12:37:13
- T1待摊费用如何处理?2020-4-26 13:12:33
- 请问下,我建账选择的是小企业会计准则(2013年)行业性质,但是为什么在会计科目那里显示的都是小企业会计制度的会计科目?2019-5-25 7:0:0
- 前台收银程序T+pos启动后,提示数据库错误,编号11,绑定数据库错误。如何处理啊?2019-5-22 8:0:0
- 老师请问:怎么样才能把不能够按照默认供货商为单位来查询诸如销量、库存等等各类参数的问题反馈给开发团队??我们超市这单是和各个供货商对接库存和销售量都快疯了。这样一个带前端销售的软件怎么会这个基本的功能都没有……还需要做什么自定义项那么麻烦2019-5-22 8:0:0
- 怎么删除已经单据记账的单子2019-5-22 8:0:0
最新信息
- 用友U8 仓库(A、B)计价方式:移动平均 存货X在仓库A的结存单价为0 存货X在仓库B的结存单价为5 操作如下:做调拨单从A到B,记账后,其他出库单单价为0,而其他入库单单价为5,不是为0 补充:存货选项中的入库金额和零出库金额选择为结存成本
- 用友U8 软件无法登陆,在管理工具的服务中发现SQL无法启动,提示可能是WINDOWS错误
- 用友U8 客户能够ping通服务器,但是不能登陆用友软件。
- 用友U8 录入银行对账单保存、退出后再进入,数就变了,有些数总会重复多出一条,估计需要跟一下数据库。客户今天发现问题的时候,已经让客户把有问题的帐套做了帐套输出。
- 用友U8 总帐和存货总帐对不上
- 在录入凭证或查询辅助余额表时,能__否改成以表的形式显示项目辅助核算?
- 用友NC物资管理系统解决方案
- NC资产管理系统解决方案
- NC销售管理系统解决方案
- 用友NC软件凭证打印设置方法
用友U8 应收账款中选择一家客户依销售发票(外币USD核算,汇率为固定汇率8.09200)合并制单生成转账凭证时,出现借方金额1315957.11不对和借贷不平衡(借:1315957.11 贷:1315957.15),生成转账凭证时,结果应该为借方金额1315957.05(162624.45 - 8.092),贷方金额也为1315957.05。用友U8 应收账款中选择一家客户依销售发票(外币USD核算,汇率为固定汇率8.09200)合并制单生成转账凭证时,出现借方金额1315957.11不对和借贷不平衡(借:1315957.11 贷:1315957.15),生成转账凭证时,结果应该为借方金额1315957.05(162624.45 * 8.092),贷方金额也为1315957.05。
问题原因:1、此问题是由于没有打销售模块补丁造成,(补丁编号:1596,补丁名称:clsVouOpSA.dll USSAServer.dll 解决税率为0时,含税单价与无税单价不等的问题) 2、打上补丁后,应该保证SaleBillVouchs表的inatmoney(本币无税金额)=inatsum(本币价税合计),而在您的表中这两个字段却出现尾差现象 3、对于所生成的凭证,借方金额1315957.05(162624.45 * 8.092),不应该这样理解。此金额在生成凭证时直接取SaleBillVouchs表inatsum字段的合计数,换算率 8.092,在凭证上显示长度有限,因此只做参照使用。 解决方法:1、请从网站下载最新的U860HotFix(补丁编号:1606,补丁发布日期:2005-9-6 9:51:22)、U860DBHotfix(补丁编号:1627,补丁发布日期:2005-9-6 9:51:15)、销售模块补丁(补丁编号:1596)、应收应付模块补丁(补丁编号:1615),打上此补丁后会保证后续工作不会产生此类问题。 2、对于以前所产生的错误,可以执行如下脚本进行修改(执行前请做好数据备份): update SaleBillVouchs set inatmoney=inatsum where autoid in (1073,1166,1182,470) update SaleBillVouchs set inatdiscount=-185.14 where autoid=1073 update SaleBillVouchs set inatdiscount=-569.51 where autoid=1182
解决方案:
问题原因:1、此问题是由于没有打销售模块补丁造成,(补丁编号:1596,补丁名称:clsVouOpSA.dll USSAServer.dll 解决税率为0时,含税单价与无税单价不等的问题) 2、打上补丁后,应该保证SaleBillVouchs表的inatmoney(本币无税金额)=inatsum(本币价税合计),而在您的表中这两个字段却出现尾差现象 3、对于所生成的凭证,借方金额1315957.05(162624.45 * 8.092),不应该这样理解。此金额在生成凭证时直接取SaleBillVouchs表inatsum字段的合计数,换算率 8.092,在凭证上显示长度有限,因此只做参照使用。 解决方法:1、请从网站下载最新的U860HotFix(补丁编号:1606,补丁发布日期:2005-9-6 9:51:22)、U860DBHotfix(补丁编号:1627,补丁发布日期:2005-9-6 9:51:15)、销售模块补丁(补丁编号:1596)、应收应付模块补丁(补丁编号:1615),打上此补丁后会保证后续工作不会产生此类问题。 2、对于以前所产生的错误,可以执行如下脚本进行修改(执行前请做好数据备份): update SaleBillVouchs set inatmoney=inatsum where autoid in (1073,1166,1182,470) update SaleBillVouchs set inatdiscount=-185.14 where autoid=1073 update SaleBillVouchs set inatdiscount=-569.51 where autoid=1182
凭证管理界面怎么设置固定列? 凭证管理界面怎么设置固定列?
问题号: | 35001 |
---|---|
适用产品: | T十系列 |
软件版本: | T+ 11.5 |
软件模块: | 总账-凭证 |
问题名称: | 凭证管理界面怎么设置固定列? |
问题现象: | 凭证管理界面如何设置固定列? |
问题原因: | 见问题答案。 |
关键字: | 固定列 |
解决方案: | 固定列是始终显示在页面的固定位置上不动的列,可以在“凭证管理”界面进行设置。在“凭证管理”界面,点击“栏目”按钮,在想要设置固定列的栏目前的“固定列”打上勾。只支持从左端第一列起向右顺序设置固定列,不支持跳跃设置,也不支持从中间开始设置,即如果设置某一列为固定列时,那么该列前的所有列全部为固定列。并且固定列只支持在页面显示的字段,不显示的字段设置后不生效。 |
行业: | 通用 |
补丁编号: | |
解决状态: | 临时解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 用友t3怎样取消审核
- 用友t6如何取消审核凭证
- 请问下,我建账选择的是小企业会计准则(2013年)行业性质,但是为什么在会计科目那里显示的都是小企业会计制度的会计科目?
- 前台收银程序T+pos启动后,提示数据库错误,编号11,绑定数据库错误。如何处理啊?
- 老师请问:怎么样才能把不能够按照默认供货商为单位来查询诸如销量、库存等等各类参数的问题反馈给开发团队??我们超市这单是和各个供货商对接库存和销售量都快疯了。这样一个带前端销售的软件怎么会这个基本的功能都没有……还需要做什么自定义项那么麻烦
- 请问t3标准版为什么从系统卸载不掉,请问怎么才能卸载掉?
- T3卸载不了提示这个是什么意思?
- 请问这是怎么一回事,老是说登录不上服务器,防火墙都已经关闭了,提示下面这种
- 为什么卸载的时候提示这个??
- 我用的是用友T3普及版 ,现在我点击注册登录时输入密码之后没有账套出来,我确定密码和用户名都是对的!还有点击系统管理的时候电脑没有反应,打不开系统管理!这个是什么原因呢?
库存管理——日常业务——红字采购入库单:在哪里开权限给采购员?-我们在权限列表里没找到,麻烦知道的告知下,谢谢。 库存管理——日常业务——红字采购入库单:在哪里开权限给采购员?我们在权限列表里没找到,麻烦知道的告知下,谢谢。
采购入库单点增加,在单据中把蓝子修改为红字就可以,权限同采购入库单权限,没有单独权限
单位的慈善捐款是否可以作为税前扣除 单位的慈善捐款是否可以作为税前扣除
问:单位的慈善捐款是否可以作为税前扣除?
答:根据《财政部 国家税务总局关于向中华健康快车基金会等5家单位的捐赠所得税税前扣除问题的通知》(财税〔2003〕204号)规定,纳税人向中华慈善总会的捐赠,允许在企业所得税和个人所得税税前全额扣除。
七招挖出企业账中的疑点 七招挖出企业账中的疑点 在企业时,审计的重点是收入的完整性、费用的合理性以及税金的缴纳,审计主要通过查看资金流水明细账、购销合同、应收应付明细,原材料明细和产成品明细、费用明细等来检验记录的真实性,通过对这些科目的审计,大多数问题就会暴露出来。那什么样的数据是反常的,值得被怀疑的呢? 1.大量的现金交易。处在网络时代,现金的交易越来越少,除了与自然人的交易外,企业与企业之间有大量或者大额现金交易,就很不正常了。如可能存在会计人员的舞弊行为或者收入不账。 2.资金流的方向。企业收取客户的货款,支付供应商的材料费等这些资金的流向是正确的,如果企业给客户钱,供应商给企业钱,这些就值得怀疑了。如应收款中的负数或者是应收款余额为负,很可能就是隐藏的收入。 3.往来的真实性。这个主要是通过购入合同进行审计,即双方的买卖都在经营范围之内,如果一个汽车加工制造企业卖高科技软件就值得怀疑了。购货的虚假交易是增大成本,减少利润;发货的虚假交易则多是粉饰。 4.预付与应收的挂账。买东西预付和卖东西赊账都是很正常的,但是长时间不处理就不正常了。对预付和应收的审计主要通过对合同真实性的审查,确定预付和应收的真实性,是否存在隐瞒收入的情况。 5.存货的造假。利用存货来调节利润是很多企业惯用的伎俩,如企业生产需储备原材料,但是一储备一年的就不正常了;存货发出但迟迟不记账也是不正常的;期末存货单价与平常存货单价比较,看是否正常。 6.产量与设备购置的关系。产量的飞跃式变化一般与固定资产的新扩建有关,如果产量在某月猛增,之前却没有机械设备的购置更新,这就很不正常了。 7.收入与费用的配比。行业会有季节性收入变化,突击性收入过大就不正常了;收入与成本是正比例变化的,如果收入增加,成本不增或者降低就更不正常了。 在审计时,不正常的就是疑点,会计人员都会给出解释,审计人不仅仅是听解释,而是需要会计人员给出证据。
用友U8 查看销售专用发票时,有一张发票表头为空白,也无法修改与删除用友U8 查看销售专用发票时,有一张发票表头为空白,也无法修改与删除
问题原因:同解决方案 解决方法:在销售发票主表中有一与发货单关联字段中cdlcode中最后有一非法字符,删除即可。
解决方案:
问题原因:同解决方案 解决方法:在销售发票主表中有一与发货单关联字段中cdlcode中最后有一非法字符,删除即可。
www.kuaiji66.com 天龙瑞德
用友U8 U821在数据精度定义中设置存货数量小数位为6位,销售系统中的委托代销统计表统计出来的发货数量、结算数量、结存数量虽显示为6位小数但全被四舍五入为4位有效位数,并且当选择了起始日期、结束日期与未选择时查询出来的结果不一致。用友U8 U821在数据精度定义中设置存货数量小数位为6位,销售系统中的委托代销统计表统计出来的发货数量、结算数量、结存数量虽显示为6位小数但全被四舍五入为4位有效位数,并且当选择了起始日期、结束日期与未选择时查询出来的结果不一致。
问题原因:Sa_MoveTrustDetail存储过程未考虑小数位数的问题,当查询条件不同时发货数量、结算数量、结存数量的字段有时被定义为Money型,有时被定义为Float型,当被定义为Money型时则查询结果的有效位数为4位,故有上述结果。 解决方法:修改Sa_MoveTrustDetail存储过程如下,即可解决问题:IF EXISTS (SELECT * FROM sysobjects WHERE name='Sa_MoveTrustDetail' and type='P')DROP PROCEDURE Sa_MoveTrustDetailGO/* 改正当数据精度设置中存货数量小数位大于4位时委托代销统计表 发货数量、结算数量、结存数量只显示4位的问题 2003.06.13 南京用友维护部 丁德安 */CREATE PROCEDURE Sa_MoveTrustDetail @chrTableName varchar(255) = null,@chrWhere1 varchar(255) = null,@chrStartDate varchar(30) = null,@chrEndDate varchar(30) = nullASdeclare @chrSQL varchar(4000)declare @chrWhere varchar(4000)/*取得超长参数方法*/if ltrim(rtrim(@chrWhere1)) = 'newReport_ParameterFromTempTable' begin--从临时表中取得超长参数 为了解决SQL SERVER 7.0 中的问题set @chrWhere = (select name from tempdb..newReportParameter )endelsebeginset @chrWhere = @chrWhere1 end/*取得需要处理的最小数据集合*//*取委托代销发货数据 */if exists(select name from tempdb..sysobjects where name='tmp_saletrust') drop table tempdb..tmp_saletrustset @chrSQL = 'Select ddate, autoid, iQuantity, iNum, iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_saletrustfrom Endispatchs Inner join EndispatchOn EnDispatchs.EDID = Endispatch.EDID 'if ltrim(rtrim(@chrWhere)) = '' or @chrWhere is nullbegin/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + 'Where ddate <= ''' + @chrEndDate + ''''endelse/* 设置其他条件 */beginset @chrSQL = @chrSQL + 'Where ' + @chrWhere/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''endexec (@chrSQL)/*取得委托结算数据*/if exists(select name from tempdb..sysobjects where name = 'tmp_resulttrust') drop table tempdb..tmp_resulttrustset @chrSQL = 'Select dDate, iCorID as autoid, iQuantity, iNum,iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_resulttrustfrom Dispatchlistsinner join dispatchlist on Dispatchlists.dlid = Dispatchlist.dlidWhere Dispatchlist.cVouchtype = ''07'''if ltrim(rtrim(@chrWhere)) <> '' and not (@chrWhere is null)set @chrSQL = @chrSQL + ' and ' + @chrWhereif rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''exec (@chrSQL)/*分析出委托代销期初,本期发货,本期结算和结存数据 *//*从临时表 tempdb..tmp_saletrust 取委托发货数据,从 tempdb..tmp_resulttrust 取结算数据*/if exists(select name from tempdb..sysobjects where name='tmp_trustDetail') drop table tempdb..tmp_trustDetail/*计算期初*/if ltrim(rtrim(@chrStartDate)) <> '' and not (@chrStartDate is null)begin/* 期初发货 */Select autoid, dDate,iQuantity as qc_iQuantity, iNum as qc_iNum, iMoney as qc_iMoney, iTax as qc_iTax,iSum as qc_iSum, iDiscount as qc_iDiscount, iNatMoney as qc_iNatMoney,iNatTax as qc_iNatTax, iNatSum as qc_iNatSum, iNatDiscount as qc_iNatDiscount,iQuantity - iQuantity as fh_iQuantity , iNum - iNum as fh_iNum, iMoney - iMoney as fh_iMoney, iTax - iTax as fh_iTax, iSum - iSum as fh_iSum, iDiscount - iDiscount as fh_iDiscount, iNatMoney - iNatMoney as fh_iNatMoney,iNatTax - iNatTax as fh_iNatTax, iNatSum - iNatSum as fh_iNatSum, iNatDiscount - iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum , iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax, iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax, iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetailfrom tempdb..tmp_saletrust where dDate < @chrStartDate/* 期初结算 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,- iQuantity as qc_iQuantity, - iNum as qc_iNum, - iMoney as qc_iMoney, - iTax as qc_iTax, - iSum as qc_iSum, - iDiscount as qc_iDiscount, - iNatMoney as qc_iNatMoney,- iNatTax as qc_iNatTax, - iNatSum as qc_iNatSum, - iNatDiscount as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum , 0 as fh_iMoney, 0 as fh_iTax, 0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax, 0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax, 0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where dDate < @chrStartDateend /*计算本期发货 */ if ltrim(rtrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/* 没有输入期初日期的情况 */Select autoid, dDate,iQuantity - iQuantity as qc_iQuantity, iNum - iNum as qc_iNum, iMoney - iMoney as qc_iMoney, iTax - iTax as qc_iTax,iSum - iSum as qc_iSum, iDiscount - iDiscount as qc_iDiscount, iNatMoney - iNatMoney as qc_iNatMoney,iNatTax - iNatTax as qc_iNatTax, iNatSum - iNatSum as qc_iNatSum, iNatDiscount - iNatDiscount as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax , iNatSum as fh_iNatSum , iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum, iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax,iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax,iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetail from tempdb..tmp_saletrustendelse begin/*有期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax, iNatSum as fh_iNatSum, iNatDiscount as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax,0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_saletrust where dDate >= @chrStartDateend /*计算本期结算 */if rtrim(ltrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/*没有输入期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrustendelse/*输入期初日期的情况 */begininsert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount, 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where ddate >= @chrStartDateend/*组织最后的数据源临时表 *//*初始化临时表 */if exists(select name from tempdb..sysobjects where name = @chrTableName ) exec ('drop table tempdb..'+ @chrTableName)/*生成临时表 *//*数据源输出列:仓库, 销售类型, 部门,业务员,客户名称,存货名称,规格型号,主计量单位, 辅助计量单位,存货供应商,币种,客户自定义项(1-3),存货自定义项(1-3)单据体自定义项(1-6),单据头自定义项(1-10),期初(数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣)本期发货(数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣),本期结算(数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣),期末结存 (数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣)*/set @chrSQL = 'Select a.*, warehouse.cwhname,saletype.cstname, department.cDepname,person.cPersonname, customer.cCusname,customer.cCusDefine1, customer.cCusDefine2,customer.cCusDefine3, inventory.cinvName,inventory.cinvstd, inventory.cInvM_Unit,inventory.cInvA_Unit, vendor.cVenName,inventory.cInvDefine1, inventory.cInvDefine2,inventory.cInvDefine3, c.cexch_name,c.cDefine1, c.cDefine2, c.cDefine3, c.cDefine4, c.cDefine5,c.cDefine6, c.cDefine7, c.cDefine8, c.cDefine9, c.cDefine10,b.cDefine22, b.cDefine23, b.cDefine24,b.cDefine25, b.cDefine26, b.cDefine27into tempdb..'+ @chrTableName +'from tempdb..tmp_trustdetail ainner join endispatchs b on a.autoid = b.autoidinner join endispatch c on b.EDID = c.EDIDleft join inventory on b.cInvCode = inventory.cInvCodeleft join warehouse on b.cWhCode = warehouse.cWhcodeleft join department on c.cDepCode = department.cDepcodeleft join person on c.cPersoncode = person.cpersoncodeleft join customer on c.cCuscode = customer.cCuscodeleft join vendor on inventory.cVencode = vendor.cVencodeleft join saletype on c.cstcode = saletype.cstcode'exec (@chrSQL)GO
解决方案:
问题原因:Sa_MoveTrustDetail存储过程未考虑小数位数的问题,当查询条件不同时发货数量、结算数量、结存数量的字段有时被定义为Money型,有时被定义为Float型,当被定义为Money型时则查询结果的有效位数为4位,故有上述结果。 解决方法:修改Sa_MoveTrustDetail存储过程如下,即可解决问题:IF EXISTS (SELECT * FROM sysobjects WHERE name='Sa_MoveTrustDetail' and type='P')DROP PROCEDURE Sa_MoveTrustDetailGO/* 改正当数据精度设置中存货数量小数位大于4位时委托代销统计表 发货数量、结算数量、结存数量只显示4位的问题 2003.06.13 南京用友维护部 丁德安 */CREATE PROCEDURE Sa_MoveTrustDetail @chrTableName varchar(255) = null,@chrWhere1 varchar(255) = null,@chrStartDate varchar(30) = null,@chrEndDate varchar(30) = nullASdeclare @chrSQL varchar(4000)declare @chrWhere varchar(4000)/*取得超长参数方法*/if ltrim(rtrim(@chrWhere1)) = 'newReport_ParameterFromTempTable' begin--从临时表中取得超长参数 为了解决SQL SERVER 7.0 中的问题set @chrWhere = (select name from tempdb..newReportParameter )endelsebeginset @chrWhere = @chrWhere1 end/*取得需要处理的最小数据集合*//*取委托代销发货数据 */if exists(select name from tempdb..sysobjects where name='tmp_saletrust') drop table tempdb..tmp_saletrustset @chrSQL = 'Select ddate, autoid, iQuantity, iNum, iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_saletrustfrom Endispatchs Inner join EndispatchOn EnDispatchs.EDID = Endispatch.EDID 'if ltrim(rtrim(@chrWhere)) = '' or @chrWhere is nullbegin/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + 'Where ddate <= ''' + @chrEndDate + ''''endelse/* 设置其他条件 */beginset @chrSQL = @chrSQL + 'Where ' + @chrWhere/*设置日期条件 */if rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''endexec (@chrSQL)/*取得委托结算数据*/if exists(select name from tempdb..sysobjects where name = 'tmp_resulttrust') drop table tempdb..tmp_resulttrustset @chrSQL = 'Select dDate, iCorID as autoid, iQuantity, iNum,iMoney, iTax, iSum, iDisCount,iNatMoney, iNatTax, iNatSum, iNatDisCountinto tempdb..tmp_resulttrustfrom Dispatchlistsinner join dispatchlist on Dispatchlists.dlid = Dispatchlist.dlidWhere Dispatchlist.cVouchtype = ''07'''if ltrim(rtrim(@chrWhere)) <> '' and not (@chrWhere is null)set @chrSQL = @chrSQL + ' and ' + @chrWhereif rtrim(ltrim(@chrEndDate)) <> '' and not (@chrEndDate is null)set @chrSQL = @chrSQL + ' and ddate <= ''' + @chrEndDate + ''''exec (@chrSQL)/*分析出委托代销期初,本期发货,本期结算和结存数据 *//*从临时表 tempdb..tmp_saletrust 取委托发货数据,从 tempdb..tmp_resulttrust 取结算数据*/if exists(select name from tempdb..sysobjects where name='tmp_trustDetail') drop table tempdb..tmp_trustDetail/*计算期初*/if ltrim(rtrim(@chrStartDate)) <> '' and not (@chrStartDate is null)begin/* 期初发货 */Select autoid, dDate,iQuantity as qc_iQuantity, iNum as qc_iNum, iMoney as qc_iMoney, iTax as qc_iTax,iSum as qc_iSum, iDiscount as qc_iDiscount, iNatMoney as qc_iNatMoney,iNatTax as qc_iNatTax, iNatSum as qc_iNatSum, iNatDiscount as qc_iNatDiscount,iQuantity - iQuantity as fh_iQuantity , iNum - iNum as fh_iNum, iMoney - iMoney as fh_iMoney, iTax - iTax as fh_iTax, iSum - iSum as fh_iSum, iDiscount - iDiscount as fh_iDiscount, iNatMoney - iNatMoney as fh_iNatMoney,iNatTax - iNatTax as fh_iNatTax, iNatSum - iNatSum as fh_iNatSum, iNatDiscount - iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum , iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax, iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax, iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetailfrom tempdb..tmp_saletrust where dDate < @chrStartDate/* 期初结算 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,- iQuantity as qc_iQuantity, - iNum as qc_iNum, - iMoney as qc_iMoney, - iTax as qc_iTax, - iSum as qc_iSum, - iDiscount as qc_iDiscount, - iNatMoney as qc_iNatMoney,- iNatTax as qc_iNatTax, - iNatSum as qc_iNatSum, - iNatDiscount as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum , 0 as fh_iMoney, 0 as fh_iTax, 0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax, 0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax, 0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where dDate < @chrStartDateend /*计算本期发货 */ if ltrim(rtrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/* 没有输入期初日期的情况 */Select autoid, dDate,iQuantity - iQuantity as qc_iQuantity, iNum - iNum as qc_iNum, iMoney - iMoney as qc_iMoney, iTax - iTax as qc_iTax,iSum - iSum as qc_iSum, iDiscount - iDiscount as qc_iDiscount, iNatMoney - iNatMoney as qc_iNatMoney,iNatTax - iNatTax as qc_iNatTax, iNatSum - iNatSum as qc_iNatSum, iNatDiscount - iNatDiscount as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax , iNatSum as fh_iNatSum , iNatDiscount as fh_iNatDiscount,iQuantity - iQuantity as js_iQuantity, iNum - iNum as js_iNum, iMoney - iMoney as js_iMoney, iTax - iTax as js_iTax,iSum - iSum as js_iSum, iDiscount - iDiscount as js_iDiscount, iNatMoney - iNatMoney as js_iNatMoney,iNatTax - iNatTax as js_iNatTax, iNatSum - iNatSum as js_iNatSum, iNatDiscount - iNatDiscount as js_iNatDiscount,iQuantity - iQuantity as wj_iQuantity, iNum - iNum as wj_iNum, iMoney - iMoney as wj_iMoney, iTax - iTax as wj_iTax,iSum - iSum as wj_iSum, iDiscount - iDiscount as wj_iDiscount, iNatMoney - iNatMoney as wj_iNatMoney,iNatTax - iNatTax as wj_iNatTax, iNatSum - iNatSum as wj_iNatSum, iNatDiscount - iNatDiscount as wj_iNatDiscountinto tempdb..tmp_trustDetail from tempdb..tmp_saletrustendelse begin/*有期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,iQuantity as fh_iQuantity, iNum as fh_iNum, iMoney as fh_iMoney, iTax as fh_iTax,iSum as fh_iSum, iDiscount as fh_iDiscount, iNatMoney as fh_iNatMoney,iNatTax as fh_iNatTax, iNatSum as fh_iNatSum, iNatDiscount as fh_iNatDiscount,0 as js_iQuantity, 0 as js_iNum, 0 as js_iMoney, 0 as js_iTax,0 as js_iSum, 0 as js_iDiscount, 0 as js_iNatMoney,0 as js_iNatTax, 0 as js_iNatSum, 0 as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_saletrust where dDate >= @chrStartDateend /*计算本期结算 */if rtrim(ltrim(@chrStartDate)) = '' or @chrStartDate is nullbegin/*没有输入期初日期的情况 */insert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount , 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrustendelse/*输入期初日期的情况 */begininsert into tempdb..tmp_trustDetailSelect autoid, dDate,0 as qc_iQuantity, 0 as qc_iNum, 0 as qc_iMoney, 0 as qc_iTax,0 as qc_iSum, 0 as qc_iDiscount, 0 as qc_iNatMoney,0 as qc_iNatTax, 0 as qc_iNatSum, 0 as qc_iNatDiscount,0 as fh_iQuantity, 0 as fh_iNum, 0 as fh_iMoney, 0 as fh_iTax,0 as fh_iSum, 0 as fh_iDiscount, 0 as fh_iNatMoney,0 as fh_iNatTax, 0 as fh_iNatSum, 0 as fh_iNatDiscount,iQuantity as js_iQuantity, iNum as js_iNum, iMoney as js_iMoney, iTax as js_iTax,iSum as js_iSum, iDiscount as js_iDiscount, iNatMoney as js_iNatMoney,iNatTax as js_iNatTax, iNatSum as js_iNatSum, iNatDiscount as js_iNatDiscount,0 as wj_iQuantity, 0 as wj_iNum, 0 as wj_iMoney, 0 as wj_iTax,0 as wj_iSum, 0 as wj_iDiscount, 0 as wj_iNatMoney,0 as wj_iNatTax, 0 as wj_iNatSum, 0 as wj_iNatDiscountfrom tempdb..tmp_resulttrust where ddate >= @chrStartDateend/*组织最后的数据源临时表 *//*初始化临时表 */if exists(select name from tempdb..sysobjects where name = @chrTableName ) exec ('drop table tempdb..'+ @chrTableName)/*生成临时表 *//*数据源输出列:仓库, 销售类型, 部门,业务员,客户名称,存货名称,规格型号,主计量单位, 辅助计量单位,存货供应商,币种,客户自定义项(1-3),存货自定义项(1-3)单据体自定义项(1-6),单据头自定义项(1-10),期初(数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣)本期发货(数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣),本期结算(数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣),期末结存 (数量,件数,金额,税额,价税合计,折扣,本币金额,本币税额,本币价税合计,本币折扣)*/set @chrSQL = 'Select a.*, warehouse.cwhname,saletype.cstname, department.cDepname,person.cPersonname, customer.cCusname,customer.cCusDefine1, customer.cCusDefine2,customer.cCusDefine3, inventory.cinvName,inventory.cinvstd, inventory.cInvM_Unit,inventory.cInvA_Unit, vendor.cVenName,inventory.cInvDefine1, inventory.cInvDefine2,inventory.cInvDefine3, c.cexch_name,c.cDefine1, c.cDefine2, c.cDefine3, c.cDefine4, c.cDefine5,c.cDefine6, c.cDefine7, c.cDefine8, c.cDefine9, c.cDefine10,b.cDefine22, b.cDefine23, b.cDefine24,b.cDefine25, b.cDefine26, b.cDefine27into tempdb..'+ @chrTableName +'from tempdb..tmp_trustdetail ainner join endispatchs b on a.autoid = b.autoidinner join endispatch c on b.EDID = c.EDIDleft join inventory on b.cInvCode = inventory.cInvCodeleft join warehouse on b.cWhCode = warehouse.cWhcodeleft join department on c.cDepCode = department.cDepcodeleft join person on c.cPersoncode = person.cpersoncodeleft join customer on c.cCuscode = customer.cCuscodeleft join vendor on inventory.cVencode = vendor.cVencodeleft join saletype on c.cstcode = saletype.cstcode'exec (@chrSQL)GO
www.kuaiji66.com 天龙瑞德
- 年结的时候出现,本机已经运行【系统控制台程序】,请退出再运行
- 填制凭证类别时显示互斥站点
- 用友软件访问数据库是要通过SA来访问的,是否可以用其他的用户名
- 12.0普及版,盘点单保存报“计量单位2必须为空”。经检查是某个存货单计量,在盘点单带出了计量单位2,在别的单据不会带出单位2.怎么解决,有补丁解决么?
- 更新了最新补丁提示微信结算方式与其他结算方式冲突是什么原因
- 产成品入库单删除报错, 查询联查没有任何单据
- 版本号-12.100.001.0076.0514 票据类型无法记忆,设置单据中已经打开票据类型记忆功能,同客户无法实现记忆,升级到新版之后,出现的问题!
- 为啥客户端老是提示这个
- 我的标准版 安装包 按setup都是卸载的?卸了按第二次也是卸载 不能安装
- T3 卸载不了,怎么解决
UFO报表只读UFO报表只读
|
求一个T1商贸宝服装鞋帽版11.1.1.45补丁,我不要下载最新的,只要这个版本的,在产品更新那好像不是这个版本的 求一个T1商贸宝服装鞋帽版11.1.1.45补丁,我不要下载最新的,只要这个版本的,在产品更新那好像不是这个版本的[]
点进去后有历史版本的,你可以看一下只有最新的,在服务社区--产品线--产品更新T1中进行下载。
http://service.chanjet.com/chanjet/T1@王国栋wgd:T+才有这个历史补丁,其他版本都没有@服务社区李珊:没有历史版本,这就有点过分了啊[/擦汗]@IU_:T1补丁是覆盖式的。不存在历史版本。请直接备份好数据,更新最新版本补丁 [/微笑]
t1手工备份失败
用友软件提供两种备份方式:手工备份和自动备份,下面我们讲解这两种方式的备份账套数据操作步骤(T6和U8与T3备份恢复方法相同,此处以T3为例):
㈠、手工备份
1、先在硬盘上建立一个空文件夹
打开我的电脑(双击)D(或E、F)盘,(空白处右击右键)新建文件夹,把这个新建的文件夹,改名为如用友数据手工备份。(双击)打开用友数据手工备份,(右击)出现新建文件夹,把所新建的文件夹改名为当天的备份日期如2016-12-16后退出
用友在进行下年结转时,没有按顺序结转,在以后的使用中会有问题吗在进行下年结转时,没有按顺序结转,在以后的使用中会有问题吗
|
使用技巧
热点文章
问题解答
-
“营改增”后支付境外商标使用费应代扣增值税
“营改增”后支付境外商标使用费应代扣增值税 “营改增”后支付境外商标使用费应代扣增值税 甲公司是一家位于“营改增”试点地区的药品生产企业,属于一般人。几天前,该公司与一家境外企业签订了一份商标使用权转让合同,即境外企业将商标提供给甲公司使用,在合同期内甲公司每年向其支付一定数额的商标使用费,涉及的相费由转让方承担。 现在,甲公司作为“营改增”试点企业,企业不知道支付商标使用费需要扣缴还是增值税,所以打电话向12366纳税服务热线咨询。 坐席员答复,《部、国家总局关于在上海市开展交通运输业和部分现代服务业营业税改征增值税试点的通知》(财税〔2011〕111号)附件1《交通运输业和部分现代服务业营业税改征增值税试点实施办法》(以下简称试点实施办法)规定,本办法适用于试点地区的单位和个人,以及向试点地区的单位和个人提供应税服务的境外单位和个人。试点实施办法所附的《应税服务范围注释》规定,文化创意服务,包括设计服务、商标著作权转让服务、知识产权服务、广告服务和会议展览服务。商标著作权转让服务,指转让商标、商誉和著作权的业务活动。 因此,境外企业给试点地区的甲公司提供商标使用权,属于应税服务范围,甲公司应按“现代服务业——文化创意服务——商标著作权转让服务”扣缴增值税,税率为6%,应扣缴税额=接受方支付的价款÷(1+税率)×税率。 另外,甲公司凭通用缴款书可以抵扣增值税进项税额。试点实施办定,纳税人接受境外单位或者个人提供的应税服务,从税务机关或者境内代理人取得的解缴税款的中华人民共和国税收通用缴款书上注明的增值税额,准予从销项税额中抵扣。要注意的是,纳税人凭通用缴款书抵扣进项税额的,应当具备书面合同、付款证明和境外单位的对账单或者发票。资料不全的,其进项税额不得从销项税额中抵扣。 坐席员提醒纳税人,上述境外企业转让商标使用权收入,属于特许权使用费范畴,为法第三条第三项规定的所得,所以支付人甲公司在扣缴增值税的同时要扣缴企业所得税,在计算缴纳企业所得税时,应以不含增值税的收入全额作为应纳税所得额。为此,甲公司应将合同价款换算成不含增值税价格计算应扣缴的所得税。
-
用友t6怎么反结账
用友t6怎么反结账
【用友软件U8/T6/T3反结账反记账方法】U8/T6/T3如何取消结账、取消记账(限于篇幅,此处仅以T3为例,U8/T6步骤相同);
一、反结账步骤:
①点击总账下面的期末,选择“结账”
用友热销产品
解决方案
-
用友U8 仓库(A、B)计价方式:移动平均 存货X在仓库A的结存单价为0 存货X在仓库B的结存单价为5 操作如下:做调拨单从A到B,记账后,其他出库单单价为0,而其他入库单单价为5,不是为0 补充:存货选项中的入库金额和零出库金额选择为结存成本
用友U8 仓库(A、B)计价方式:移动平均 存货X在仓库A的结存单价为0 存货X在仓库B的结存单价为5 操作如下:做调拨单从A到B,记账后,其他出库单单价为0,而其他入库单单价为5,不是为0 补充:存货选项中的入库金额和零出库金额选择为结存成本
用友U8 仓库(A、B)计价方式:移动平均 存货X在仓库A的结存单价为0 存货X在仓库B的结存单价为5 操作如下:做调拨单从A到B,记账后,其他出库单单价为0,而其他入库单单价为5,不是为0 补充:存货选项中的入库金额和零出库金额选择为结存成本问题原因:同解决方案 解决方法:客户调拨的存货X是赠品,出入库金额应该是0。如果采用特殊单据记账,则即使在调拨单上录入金额0,记账时入库金额仍然为5,无法使入库金额为0。所以,对于这种赠品存货,您可以先在调拨单上录入金额0,并使用正常单据记账,这样其他入库单的入库金额就会取它单据上录入的金额0。
解决方案:
问题原因:同解决方案 解决方法:客户调拨的存货X是赠品,出入库金额应该是0。如果采用特殊单据记账,则即使在调拨单上录入金额0,记账时入库金额仍然为5,无法使入库金额为0。所以,对于这种赠品存货,您可以先在调拨单上录入金额0,并使用正常单据记账,这样其他入库单的入库金额就会取它单据上录入的金额0。
www.kuaiji66.com 天龙瑞德 -
用友U8 软件无法登陆,在管理工具的服务中发现SQL无法启动,提示可能是WINDOWS错误
用友U8 软件无法登陆,在管理工具的服务中发现SQL无法启动,提示可能是WINDOWS错误用友U8 软件无法登陆,在管理工具的服务中发现SQL无法启动,提示可能是WINDOWS错误问题原因:环境问题 解决方法:将用友软件的文件夹拷贝出来,卸载软件和数据库并重新安装,将以前备份导入,然后把以前文件夹帐套文件夹里05年的数据库文件替换新产生的文件,登陆就可以了
解决方案:
问题原因:环境问题 解决方法:将用友软件的文件夹拷贝出来,卸载软件和数据库并重新安装,将以前备份导入,然后把以前文件夹帐套文件夹里05年的数据库文件替换新产生的文件,登陆就可以了
- 最新文章排行
- 热门文章排行
- T6软件如何处理形态转换业务
- T6形态转换单单据流程
- T3软件中库存管理中可以处理形态转换业务
- 出库调整单记账时提示“调整之后会造成负单价,不允许调整”
- 用友软件无法正常安装软件,提示ccpstartor-.net, unable to find a version of the runtime to run this application
- 产品结构中的定额数量只能到小数点后2位吗?如何能改变为小数点后4位?
- 餐饮行业,调拨给其他门店物品,已计提了9个月摊销,还有15个月没摊,按原值调拨,怎么样做账务处理?谢谢
- 餐厅的装潢费用摊销怎么做账?
- 顶尖POS收款机怎样往里录入供应商还有库存管理,是不是不录入供应商信息就无法使用库存呢?希望高手解答。
- 阿里怎么设置付款减库存
产品介绍
产品资讯
-
T3标准版,在打开“系统管理”的时候提示运行时错误-2147319779 automation错误
T3标准版,在打开“系统管理”的时候提示如图错误,请各位老师帮忙解决一下。
检查计算机名称是否含有特殊字符像‘-’等,如果有,请修改为纯英文名称,修改完成之后请重启电脑;或者更改系统环境变量中用户变量的Tmp变量值。具体方法:首先在C盘下建立一个空文件夹,更名为temp,然后在‘我的电脑处’单击鼠标右键,属性里点高级页签,然后点‘环境变量’,将temp和tmp的值都修改为c:\temp(通过点‘编辑’按钮进行修改;还有检查系统日期格式是否符合下面的要求:短日期格式:yyyy-MM-dd,长日期格式:yyyy'年'M'月'd'日'。(检查方法:点击”开始菜单“-”控制面板“,依次找到”时钟、语言和区域“-”设置时间和日期“-”更改日期和时间“-”更改日历设置“-”日历设置“-【日期】页签中进行查看和修改。)
然后再登录操作
你好,按您的回复进行操作,还是一样的提示。
--按您的回复进行操作,还是一样的提示。
把账套的物理文件拷贝出来保存好,卸载软件,然后重新安装。账套物理文件恢复数据的方式请参照文档中的方法二或方法三:
http://www.kuaiji66.com/t3/yongyout3/dVP5Lgy86944.html -
t3固定资产制单删除
t3固定资产制单删除
用友T3软件固定资产生成的凭证如何删除?
固定资产生成的凭证如何删除?
问题模块: 固定资产
关键字:删除凭证
问题版本:用友T3-用友通标准版10.8plus2
原因分析: 进入固定资产模块,找到对应的凭证点击删除即可。
适用产品:T3系列