本文主要是介绍【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;
这篇关于【U+】U+通用财务结转损益的时候某些科目出现贷方一蓝一红分录的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!