【U+】U+通用财务结转损益的时候某些科目出现贷方一蓝一红分录

在这里插入图片描述
【问题描述】
友加畅捷U+通用财务产品,
总账结转损益的时候,某些科目当前期间没有发生额,但是结转的时候出现一蓝一红分录。

【解决方法】
T3转换过来的账套:

update t_voucher_tallyvoucherdetail set accountingsupplierid=0 where  accountingsupplierid=-1;
update t_voucher_tallyvoucherdetail set accountingclientid=0 where  accountingclientid=-1;
update t_voucher_tallyvoucherdetail set accountingemployeeid=0 where  accountingemployeeid=-1;
update t_voucher_tallyvoucherdetail set accountingdepartmentid=0 where accountingdepartmentid=-1;
update t_voucher_tallyvoucherdetail set accountingprojectid=0 where  accountingprojectid=-1;
update t_voucher_tallyvoucherdetail set accountinggoodsid=0 where  accountinggoodsid=-1;
update t_voucher_tallyvoucherdetail set salesmanid=0 where  salesmanid=-1 or salesmanid is null;
update t_voucher_tallyvoucherdetail set SalesBillNo='' where SalesBillNo<>'' or SalesBillNo is null;
update t_voucher_tallyvoucherdetail set SalesDate='' where SalesDate<>'' or  SalesDate is null;
update t_voucher_tallyvoucherdetail set ExpireDate='' where ExpireDate<>'' or ExpireDate is null;

软件直接建立的账套:

update t_voucher_tallyvoucherdetail set accountingsupplierid=0 where  accountingsupplierid=-1;
update t_voucher_tallyvoucherdetail set accountingclientid=0 where  accountingclientid=-1;
update t_voucher_tallyvoucherdetail set accountingemployeeid=0 where  accountingemployeeid=-1;
update t_voucher_tallyvoucherdetail set accountingdepartmentid=0 where accountingdepartmentid=-1;
update t_voucher_tallyvoucherdetail set accountingprojectid=0 where  accountingprojectid=-1;
update t_voucher_tallyvoucherdetail set accountinggoodsid=0 where  accountinggoodsid=-1;


本文来自互联网用户投稿,文章观点仅代表作者本人,不代表本站立场,不承担相关法律责任。如若转载,请注明出处。 如若内容造成侵权/违法违规/事实不符,请点击【内容举报】进行投诉反馈!

相关文章

立即
投稿

微信公众账号

微信扫一扫加关注

返回
顶部