特价活动:>>>> 畅云管家新购、续费7折优惠,畅捷通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
客服电话:400-665-0028
关键字:用友财务软件,畅捷通软件,财务软件,进销存软件,U9官网,用友U8,用友T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,用友培训服务售后公司,畅捷通运营培训服务公司
版权所有:用友畅捷通软件 Copyright © 2025 All rights reserved.