web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

How to resolve this problem (Cannot edit a record in Purchase order - update table (PurchParmTable) ?

(0) ShareShare
ReportReport
Posted on by 313

Hi Everyone,

I have a problem, when i am trying to cancel the PO I am getting the below error message. Please suggest me.

pastedimage1562235017989v1.png

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,119 Super User 2025 Season 2 on at

    Hi Prabakaran,

    Can you tell the steps you are performing to cancel the PO?

  • Prabakaran.R Profile Picture
    313 on at

    Hi Andre,

    In purchase order > Receive tab > Journal > Product receipt journal > Select the GRN and click on the Cancel option.

    Thanks,

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    301,119 Super User 2025 Season 2 on at

    Hi Prabakaran,

    So you are trying to cancel a receipt; not a purchase order. Have you checked if there is a pending invoice? If so, delete this one first.

    If this is not the issue, have you checked if you have a customization in this area? Also, you can look at LCS issue search for possible known issues for your exact AX 2012 version.

  • Suggested answer
    SouravDam Profile Picture
    11,730 on at

    Hi Prabakaran.R,

    In additional to what André said; can you also check below possibilities which could be the reason of this issue.

    1) If more than one user are trying to do the same action in this order?

    2) If answer to point 1 is Yes; then is that the other user has started the action to be performed but left it as incomplete?

    Above two reasons are the common cases we generally find in ERP.

    Best regards,
    Sourav Dam

  • Prabakaran.R Profile Picture
    313 on at

    Hi Andre,

    Thanks for your reply, No pending invoice on the PO.

    seems no customization in GRN.

    Thanks,

  • Prabakaran.R Profile Picture
    313 on at

    Hi Sourav,

    Thanks for your reply, I cleared the record in PurchParmTable after I tried to cancel the receipt getting same error.

    Thanks,

  • André Arnaud de Calavon Profile Picture
    301,119 Super User 2025 Season 2 on at

    Hi Prabakaran,

    You can search in LCS issue search for possible known issues and/or ask a developer to do some debugging to find the culprit.

  • Verified answer
    Prabakaran.R Profile Picture
    313 on at

    Hi,

    Thanks for you reply.

    I got the solution, after adjusting the item's on-hand quantity which was insufficient to cancel the GRN.

    Example: Actual PO GRN was done for Item A with 10 Quantity.

    When cancelling the GRN the item on-hand was 8, which was later adjusted to quantity 10. Finally the GRN has been cancelled by deducting the 10 quantity.

    Thanks,

  • SouravDam Profile Picture
    11,730 on at

    Hi Prabakaran.R,

    It's good that you have found the root cause and the solution.

    However, the error sound some different meaning which MS has to take care of in order to display the meaningful reason going ahead... hopefully

    Best regards,
    Sourav Dam

  • Suggested answer
    ahmed magdy ahmed Profile Picture
    5 on at

    you have to change on line details first and then change it on header details

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans