电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

EAS中途启用往来科目,历史凭证如何处理生成账龄分析?

来源:金蝶云社区作者:金蝶2024-09-1616

EAS中途启用往来科目,历史凭证如何处理生成账龄分析?

EAS中途启用会计科目的 往来科目属性,历史凭证不会自动生成往来账,需要根据凭证t_gl_voucherentry的fentrydc借方为1贷方为0,再根据不同的科目,分别挂账T_GL_AcctCussent和销账T_GL_ACCTVERIFY插入历史凭证,再去查看往来账,余额和科目余额表表就对得上了。 ```language 2202 应付账款 贷方0 写入 挂账凭证 insert T_GL_AcctCussent select newbosid('CE2D850A') as fid,t2.FCOMPANYID,t2.FACCOUNTID,t2.FPERIODID,t2.FCURRENCYID,t1.fid as FVOUCHERID,t2.fid as FENTRYID,t3.fid as FVCHASSISTRECORDID,t3.FASSGRPID,t3.FBIZDATE as FVARBIZDATE,t3.FENDDATE,t3.FBIZNUMBER,'0' as FISVIERIFIED,'0' as FISINIT,'0' as FISINITCLOSED,t3.FORIGINALAMOUNT as FUNVERIFIEDAMTFOR,t3.FORIGINALAMOUNT,now() as FLASTUPDATETIME,t1.FVOUCHERTYPEID,t1.fnumber as FVCHNUMBER,t1.fbookeddate,'1' as fispost,t1.FCreatorID,t1.FCreateTime,t1.FLastUpdateUserID,t1.FControlUnitID,t1.FNumber,t1.FBizDate,t1.FHandlerID,case when t3.FDescription is not null then t3.FDescription else t2.FDescription end as FDescription,'' as FHasEffected,'' as FAuditorID,'' as FSourceBillID,'' as FSourceFunction,0 as FUnVerifiedQty,0 as FUnHoldedQty,0 as FUnVerifiedStdQty,0 as FUnHoldedStdQty,t3.FORIGINALAMOUNT as FUnHoldedAmtFor,t3.FLOCALAMOUNT as FUnVerifiedAmtLocal,t3.FLOCALAMOUNT as FUnHoldedAmtLocal,0 as FUnVerifiedAmtRpt,0 a

EAS中途启用往来科目,历史凭证如何处理生成账龄分析?

EAS中途启用会计科目的 往来科目属性,历史凭证不会自动生成往来账,需要根据凭证t_gl_voucherentry的fentrydc借方为1贷方为0,再根据不同...
点击下载文档文档为doc格式

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

已经是第一篇
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信