发布时间: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
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)