发布时间:2026-8-25
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品8折优惠,另有话费赠送。
【业务场景】:
总账--账簿打印,不勾选‘科目无期初余额,本年无发生也打印’,但是无数据的科目也被打印出来
【解决方案】:
请备份好账套数据,再执行脚本:
-- 修正语句
--删除journal
delete FROM GL_Journal where isPeriodBegin=1 and docid in(
select id from GL_AccountPeriodBegin
where id not in ( SELECT idAccountPeriodBeginDTO FROM GL_AccountPeriodBeginDetail)
and isnull(periodbeginbalanceorigamount,0)=0
and isnull(yearbeginbalanceorigamount,0)=0
and isnull(cumorigamountcr,0)=0
and isnull(cumamountdr,0)=0
and isnull(periodbeginbalancequantity,0) = 0
and isnull(yearbeginbalancequantity,0)=0
and isnull(cumquantitycr,0)=0
and isnull(cumquantitydr,0)=0
)
--删除科目期初
delete from GL_AccountPeriodBegin
where id not in ( SELECT idAccountPeriodBeginDTO FROM GL_AccountPeriodBeginDetail)
and isnull(periodbeginbalanceorigamount,0)=0
and isnull(yearbeginbalanceorigamount,0)=0
and isnull(cumorigamountcr,0)=0
and isnull(cumamountdr,0)=0
and isnull(periodbeginbalancequantity,0) = 0
and isnull(yearbeginbalancequantity,0)=0
and isnull(cumquantitycr,0)=0
and isnull(cumquantitydr,0)=0
【操作步骤】:
备份好账套数据,打开数据库,选择对应的账套库,执行脚本
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)