Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

问题描述:借款单生成凭证,记账后反记账,反审核,修改,再审核记账就报错:凭证明细科目余额表方向异常,不能记账,请确认!

问题现象:借款科目勾选了核算往来就不报错,不勾选就报错。

处理方法:
执行下面对应版本的脚本后,删除有问题的借款单凭证后,再重新生成借款单凭证就对了。
https://share.weiyun.com/Jh3EARz6     ---995GP_BatchCreateVoucher_BorrowBill.sql
https://share.weiyun.com/YhUZPftD     ---994GP_BatchCreateVoucher_BorrowBill.sql

注意:如果客户不愿意删除有问题的借款单凭证重新生成的话,且客户没有手动修改过凭证,可以再执行下面语句修复有问题的凭证,已经修改过的凭证只能删除重新生成。
UPDATE a SET a.Fdc=b.Fdc FROM dbo.Ac_Voucher_Bill a ,Ac_Account b
WHERE a.ATypeId = b.TypeId
AND a.STypeId = b.StypeId
AND a.BillNumberId IN(
SELECT c.VourchBillId FROM dbo.Ac_GoodsBill_VoucherBill c
INNER JOIN (SELECT BillNumberId FROM dbo.BillIndex WHERE BillType IN (452, 453,455 )) d ON c.GoodsBillId = d.BillNumberId)
AND A.Fdc IS NULL

  • No labels