#新手入门#我例指一个例子，我发工资是5000元，扣下他个人交的292.53保险，剩下的公司给交520元用银行存款发的，请问向这种分录怎么做，谢谢大家。 #新手入门#我例指一个例子，我发工资是5000元，扣下他个人交的292.53保险，剩下的公司给交520元用银行存款发的，请问向这种分录怎么做，谢谢大家。[]

计提公司缴纳的保险 借 成本费用类-保险费 贷 应付职工薪酬-公司保险 520
计提工资 成本费用-工资 5000 贷 应付职工薪酬-工资 5000
发放工资 借 应付职工薪酬-工资 5000 贷 银行存款 5000-292.53 其他应付款-个人保险 292.53 个税所得税自己核算
公司缴纳的 和个人缴纳的 借 应付职工薪酬-公司保险 520 其他应付款-保险 贷 银行存款 292.53+520
@星9527:谢谢您
@1231434201705:不客气
[/强]

怎么把打印模板设置为默认打印模板，打印的时候每次需要选择，T+12.1版本的 怎么把打印模板设置为默认打印模板，打印的时候每次需要选择，T+12.1版本的

12.1按客户记忆打印模板
楼上正解。12.1不设置默认模板了。
@服务社区刘小艳:哦，第一次打印之后就默认了吗？有12.1打印设置方面的资料么
@LRAR:文档正在更新中呢，目前社区还没有。
哦，什么时候能出来？现在新版本新的功能太多，和之前版本差别很大
这个星期会挂常用功能的文档。

我的易代账的界面变成这样了，怎么调成可以做账的界面呢 我的易代账的界面变成这样了，怎么调成可以做账的界面呢

旁边有个登录
我看看
右上角登录
右上角登陆
谢谢大家！
也解决了我的疑问

期初余额的资产负债表不平衡，对结帐会有影响么？ 期初余额的资产负债表不平衡，对结帐会有影响么？

当然有影响啊！说明你填错了
是平的啊，怎么填错了？

期初采购暂估的含义 期初采购暂估的含义

用友T3用友通存货期末处理不能取消 用友T3用友通存货期末处理不能取消

用友通10.2，存货期末处理不能取消，提示“运行是错误13，类型不匹配”。请执行语名update ia_subsidiary set iOutCost = ’0′ where iOutCost is null update ia_subsidiary set iAOutPrice = 0 where iAOutPrice is null 在重新恢复月末处理即可！如有其它问题，请联系在线客服咨询。用友云基地

T 6登录提示这个错误 T 6登录提示这个错误

您打开杀毒软件，找一下uftoolkit85.ocx这个文件是否被隔离，如果被隔离就恢复一下然后把这个文件注册一下，若找不到这个文件了可以从其他电脑上拷一个过来注册。
还是不行呢；
@服务社区刘明新:还是不行呢；
@胡伦:杀毒软件关闭掉再去登录
@服务社区刘明新:已经卸载了杀毒软件；
@胡伦:如果还不行，那就需要备份账套，重装软件了

对房地产行业入账建筑业发票稽查建议 对房地产行业入账建筑业发票稽查建议

　　对房地产行业开展专项检查，其入账建筑业发票存在问题应引起重视。首先是假建筑业发票入账。其中有发票号码相连的假发票及新版微机打印假发票，并且开票人和印章都和税务机关开具的发票相似，仿真程度较高，很难分辨真假。第二是开具外地建筑业发票。按照营业税条例规定，建筑营业税收在施工地交纳，因此建筑业发票应当在工程所在地开具，但在检查中发现外地建筑业发票多份。第三是预付账款中白条收据入账。在已检查的房地产开发企业中，普遍存在预付账款未开具发票以白条收据入账现象。白条收据的长期挂账，很有可能造成建筑企业少缴甚至偷逃税款。针对房地产行业入账建筑业发票存在的问题，提出如下建议：首先是要加强对税收管理人员、稽查人员以及企业财务会计人员发票知识的培训，提高辨别真假发票的能力，增强防范假发票意识；其次，建议开通外网发票查询系统，运用现代信息技术遏制假发票的流通，尤其是新版微机打印发票，一般人员很难辨别真伪，最有效可靠的办法就是通过网上数据进行比对。

董事能否兼任监事 董事能否兼任监事

　　公司法规定，股东可以成为公司的董事，但不能同时兼任监事，如果担任了监事，那么不能同时担任公司的董事，原因是监事会的监事的职责就是代替公司全体股东监督董事全全体成员是否适当履行了职责。所以，不能自己当了董事，再自己当监事来监督自己，法律是禁止的。

单位以自产产品发福利是否视同销售 单位以自产产品发福利是否视同销售

　　【问题】

　　单位在节日给职工发放福利，分别以自产产品、外购产品、购物券等形式发放，是否都需要视同销售处理，计提？

　　【解答】

　　贵公司在节日为员工发放不同形式的福利，应按规定做不同的处理：

　　1.以自产产品形式发放的，根据《中华人民共和国增值税暂行条例实施细则》（部、国家税务总局令2008年第50号）第四条规定：单位或者个体工商户的下列行为，视同销售货物：（五）将自产、委托加工的货物用于集体福利或者个人消费；

用友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 天龙瑞德

用友U8 在材料出库单上填写好货位后并保存，现在需要修改其中一行的货位数量，需要清除表体货位信息，关键是现在我的表体有20行，我只需要修改其中的一行货位数量，按清货按钮后将表体的所有货位信息全部清除，请问能不能只清除其中一行的货位信息而不影响整个表体用友U8 在材料出库单上填写好货位后并保存，现在需要修改其中一行的货位数量，需要清除表体货位信息，关键是现在我的表体有20行，我只需要修改其中的一行货位数量，按清货按钮后将表体的所有货位信息全部清除，请问能不能只清除其中一行的货位信息而不影响整个表体 问题原因:此问题是操作理解不同造成。 解决方法:系统的“清货”指的就是单据体上所有货位的清除，如果需要修改某记录的货物，可先选定该行记录，然后点击工具栏内的货位，此时可以先删行改货位记录然后再重新指定货位即可。
解决方案：
问题原因:此问题是操作理解不同造成。 解决方法:系统的“清货”指的就是单据体上所有货位的清除，如果需要修改某记录的货物，可先选定该行记录，然后点击工具栏内的货位，此时可以先删行改货位记录然后再重新指定货位即可。

比如A供应商有期初有预付5000，现在进货单金额15000，做了一个付款单10000，往来核销了10000，那期初这5000怎么预付冲应付？ _0比如A供应商有期初有预付5000，现在进货单金额15000，做了一个付款单10000，往来核销了10000，那期初这5000怎么预付冲应付？[]

往来现金模块有预付冲应付（普及版没有此功能）
如果是普及版，可以在付款单表头使用预付中选择预付款，并选择进货单冲销
如果在往来期初中做了该供应商的5000预付款，就可以用预付冲应付将该5000与应收冲销
预付冲应付，如何选取期初的预付款金额？在哪选择

UFPMP_110UFPMP

怎么用畅捷通商贸宝查询客户销量排名 怎么用畅捷通商贸宝查询客户销量排名''

凭证在审核后需不需要进行记账处理- 凭证在审核后需不需要进行记账处理?''

用友出纳通2005日记账进行制单时，制单按钮是灰色。用友出纳通2005日记账进行制单时，制单按钮是灰色。

没有与总账进行挂接或者没有设置总账科目。

用友T+ 11.5凭证科目有往来辅助核算，并且已经往来核销过了，怎么在填制凭证的界面查看核销明细？用友T+ 11.5凭证科目有往来辅助核算，并且已经往来核销过了，怎么在填制凭证的界面查看核销明细？

在“填制凭证”的界面，点击“联查”-“核销明细”按钮，软件自动跳转到“核销历史”界面，可以进行查看具体核销信息。如果没有核销那么核销历史界面是空白的，如果没有往来辅助核算，联查的时候会提示“当前科目未启用往来辅助核算，不能联查核销明细！”。

用友在填制采购入库单参照存货的时候，只能看见7项最简单的项目在填制采购入库单参照存货的时候，只能看见7项最简单的项目

现金日记账本年结转

一、操作流程：
1、先做数据备份
2、新建年度帐
3、结转上年数据

二、具体步骤：
1、数据备份：
系统管理→系统→注册→用户名admin 密码为空→确定→账套→备份→选择要备份的账套→确定→选择备份路径→完成备份
2、新建年度帐（以2016年结转到2017年为例）：
系统管理-系统-注册-用户名是您自己的名字如demo密码demo-选择帐套001-年度2016-确定-年度帐-建立-2017年年度帐-确定-关闭系统管理
3、结转上年数据：
系统管理-系统-注册-用户名是您自己的名字如demo密码demo-选择帐套-年度2017-确定-年度帐--结转上年数据-总账系统结转-选择结转方式-明细方式-错误结转科目为0说明结转成功