Solved

The INSERT statement conflicted with the FOREIGHN KEY error in Quick Checks (2022R2)

aborisova37
Rank
Userlevel 5
Badge +1

After the upgrade to 2022R2, we started having an issue with quick checks for one particular branch, the error appears when users save the checks.

Based on the error message, it looks like the issue is related to the Approval Map. Double checked the map, no visible issues with it. Any suggestions are highly appreciated. Thank you!

 

icon

Best answer by Kandy Beatty 1 March 2023, 16:05

View original
~Anna

3 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @aborisova37 

Can you share the Trace error? From just that it looks like an approval error. Is there approvals in place for Quick Checks?

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
aborisova37
Rank
Userlevel 5
Badge +1

Thanks, Kandy @kandybeatty49 . You know what, on the map itself, the employee list somehow got empty even though the employee was selected in the field.

I had to refresh the screen, change the approver type to the ‘workgroup’, change it back to the employee, and re-select the approver from the list that appeared after all these steps. Thanks for your help.

 

~Anna
Kandy Beatty
Rank
Userlevel 7
Badge +16

Thanks, Kandy @kandybeatty49 . You know what, on the map itself, the employee list somehow got empty even though the employee was selected in the fiel

I had to refresh the screen, change the approver type to the workgroup, change it back to the employee and and re-select the approver from the list that appeared after all these steps. Thanks for your help.

 

Happy to have helped 😁

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved