Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

处理方法:
执行下面对应版本的脚本后,删除有问题的借款单凭证后,再重新生成借款单凭证就对了。执行下面对应版本的脚本后,删除有问题的借款单凭证后,再重新生成借款单凭证就对了。(费用报销单也适用)
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

...