4Site
Support Request System
View Patch #50.001.009
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
01874 -
3 way match bug - can't delete voline if poline has multiple versions
Symptoms:
The PO was setup as a 3 way match - vouchers had to match receipts. There were several receipts and reverse receipts to several different versions of the PO - it had been reversioned 12 times. When the user tried to delete one of the vouchers they got the error "Error attempting to update the Voucher by Receipt for Voucher 00002197. The statement has been termininated. Subquery returned more than 1 value......".
Solution:
I changed the UpdateReceipt subroutine in vo2.bas to include the PO version in the sql (po.vers = vohdr.povers). This eliminated the multiple receipts returned.
Browse Patches
Find a Patch
Return to Request System Menu
