Skip to main content
Answer

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

  • March 1, 2023
  • 3 replies
  • 47 views
aborisova37
Semi-Pro I
Forum|alt.badge.img+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!

 

Best answer by Kandy Beatty

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?

~Anna
    Kandy Beatty

    3 replies

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+17
    • Kandy Beatty
    • Captain II
    • Answer
    • March 1, 2023

    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
    aborisova37
    Semi-Pro I
    Forum|alt.badge.img+1
    • aborisova37
    • Author
    • Semi-Pro I
    • March 1, 2023

    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
    Manikanta Dhulipudi
    Kandy Beatty
    Chris Hackett
    Kandy Beatty
    Captain II
    Forum|alt.badge.img+17
    • Kandy Beatty
    • Captain II
    • March 1, 2023

    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*.
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    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