If a GP user opens the Purchasing Enter/Match window the next receipt number is assigned and GP writes to both POP10300 and PA01901 tables. If the user closes the window, GP removes the line from POP10300 but leaves the row in PA01901. Once this occurs, subsequent eConnect integrations will fail with the above error. This trigger deletes the row from PA01901.
- This is GP2015 so unsure if this is fix in later releases.
- Assumes Project Accounting is installed.
Thanks to Bob Callanan (BusinessReadySolutions.net) for the code.