Description |
Steps to reproduce.
1. Open the DM (DM-4835) for IR-15570
2. Remove the payables for IR-15570, since it already has the voucher there should be no record in tblAPVoucherPayable.
To replicate the issue, use this script to remove the payable.
{noformat}DELETE A
FROM tblAPVoucherPayableTaxStaging A
WHERE A.intVoucherPayableId IN (
SELECT intVoucherPayableId FROM tblAPVoucherPayable A
WHERE strSourceNumber= 'IR-15570'
)
DELETE A
FROM tblAPVoucherPayable A
WHERE strSourceNumber= 'IR-15570'{noformat}
I suggest you should provide data fixes to regenerate and clean your payables after your changes on IC-8475 and IC-8651.
3. Delete the payment for DM
4. Unpost the DM
5. Delete the DM
This error should occur.
!pastedImage_d140939_0.png|height=316,width=551!
The error occurs on uspICUpdateBillQty.
Here's the information on the data passed on stored procedure.
!pastedImage_d140939_1.png|height=55,width=551!
The first record is the data we passed on uspICUpdateBillQty.
The second record, is the data inside the uspICUpdateBillQty.
This is where the error occurs.
!pastedImage_d140939_2.png|height=361,width=551!
|