百科问答

百科问答 国内资讯 公司资讯 政策法规 培训资料 产品下载

金坛溧阳用友T+结账2024年12月,选择覆盖下年度期初,报错【输入字符串的格式不正确】

发布时间:2024-12-24 

特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品8折优惠,另有话费赠送。

 

【问题原因】

有科目设置了辅助核算,但有凭证没有录入辅助核算。


【解决方案】

备份账套,执行下面脚本修复。


select idaccount,idauxAccDepartment,*from GL Journal where idaccount in(selectia trom.
AA Account where isauxaccdepartment=1)and idauxAccDepartment is null
select idaccount from GL_Journal where idaccount in (select id from AA Account where

isauxaccinventory=1)and idauxAccInventory is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isauxacccustomer=1)and idauxAccCustomer is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isauxaccsupplier=1)and idauxAccSupplier is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isauxaccperson=1)and idauxAccPerson is nullselect idaccount from GL Journal where

idaccount in (select id from AA Account where
isauxaccproject=1)and idauxAccProject is nullselect idaccount from GL Journal where

idaccount in (select id from AA Account whereisexauxacc1=1)and idexauxacc1 is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isexauxacc2=1)and idexauxacc2 is null
select idaccount from GL_Journal where idaccount in (select id from AA_Account where
isexauxacc3=1)and idexauxacc3 is null
select idaccount from GL_Journal where idaccount in (select id from AA Account where
isexauxacc4=1)and idexauxacc4 is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isexauxacc5=1)and idexauxacc5 is null
select idaccount from GL Journal where idaccount in (select id from AA Account wherei sexauxacc6=1)and idexauxacc6 is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isexauxacc7=1)and idexauxacc7 is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isexauxacc8=1)and idexauxacc8 is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isexauxacc9=1)and idexauxacc9 is null
select idaccount from GL Journal where idaccount in (select id from AA Account where
isexauxacc10=1)and idexauxacc10 is null

X畅捷通软件官方正版.用友软件.企业云服务

截屏,微信识别二维码

客服QQ:5151867

(点击QQ号复制,添加好友)