Check for duplicate reference#'s while processing an AP payment correction.
While processing a payment correction in AP the software doesn't seem to check for existing reference#'s and can post a duplicate in the data. This duplicate causes various issues and has to be fixed manually using the SQL Mgmt studio utility.
Thanks for the idea1
This feature was by intentional design. We have received a very large number of requests from customers that wanted to be able to re-use the same reference number for a check or invoice.
Thus, the validation for duplicates was removed from the programming in this field.
-
Michael Britt commented
In the fund version, we have a customer that duplicated the reference#. The payment correction showed up on the AP aging report, but when the customer tried to create a vendor balance adjustment decrease they received an error while trying to save the transaction. (Something like - Invoice total cannot be different from the Total payment.) The only way we could get the transaction to save was to use the SQL Mgmt studio utility to change the reference# slightly by adding characters to the end. I had opened a support ticket and was advised that this was how to get it to save. We are advising our customer to NOT duplicate the reference#.