With migration mode off, we imported AP with retainage, then used journal entry to reverse the ledger impacts. However, when trying to release the retainage, it is failing due to the vendor ref. already being used on the bill. We do not want to allow duplicate vendor references, but not seeing how to release otherwise. Ideas?
Solved
Releasing Imported AP Retainage Getting Vendor Ref. Number Already Used
Best answer by dmzasdf
Found there used to be an option to change the vendor reference number on retainage releases, but not seeing that in 2021R1.
+20I don’t know how many migrated paid AP bills need to have retainage released; would it be feasible to temporarily un-check the AP Preferences setting?
With ‘raise an error on duplicate reference number’ OFF, Acumatica still provides a warning if/when a duplicate reference number is used.
Translate
I don’t know how many migrated paid AP bills need to have retainage released; would it be feasible to temporarily un-check the AP Preferences setting?
With ‘raise an error on duplicate reference number’ OFF, Acumatica still provides a warning if/when a duplicate reference number is used.
Thank you, Laura. While we know that will work, it is not reasonable for us to temporarily uncheck/check as this will be an ongoing need for many months. Sincerely, Dave Z
Translate
Found there used to be an option to change the vendor reference number on retainage releases, but not seeing that in 2021R1.
Translate
We are encountering this same issue in 2025. But I can see where there used to be an option to create a “Retainage Vendor Ref” number in previous versions.
See a little after the 7:40 mark in the link below:
https://www.youtube.com/watch?v=a6TZK0tnbko&t=442s&ab_channel=TheAnswerCompany%E2%80%94ERPExperts
That column named “Retainage Vendor Ref” no longer seems to exist.
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.