Disbursement Selection: Error in Disbursement - Amount Doubled

Issue:
User receives error when performing Disbursement Selection. He is unable to generate screenshot of the error but upon checking again in Disbursement Selection, the amounts got doubled.


Cause:
One of the table that holds the amount paid in disbursement process was already updated after the error appeared. Upon performing disbursement process again, it summed up the value currently on the second disbursement batch created.

Solution:
Run script below to fix issue:
declare @doc_no  as char(8),
@supplier as char(8),
@trans_apv as char(3)
set @doc_no  = ’11AB3SK1′
set @supplier = ‘P11042A’
set @trans_apv = ‘APV’
– Update a_open_inv_hdr table
update a_open_inv_hdr
set amt_allocated = 0.00
where doc_no  = @doc_no
and supplier = @supplier
and trans_code = @trans_amt
Note: Run this for all document numbers affected.