Tuesday, May 26, 2015

Over delivery of line is 100 percent, but the allowed over delivery is only 0 percent.

Q: I am getting the following error in AX 2009, how can I fix it?
"Over delivery of line is 100 percent, but the allowed over delivery is only 0 percent."

Use the following script
static void fixPurchaseOrders(Args _args)
   PurchParmTable purchParmTable;
   PurchParmLine purchParmLine;
   while select forupdate purchParmTable
       join forupdate purchParmLine
       where purchParmLine.ParmId == purchParmTable.ParmId
       && purchParmLine.TableRefId == purchParmTable.TableRefId
       && purchParmTable.PurchId == ""
       && purchParmTable.ParmJobStatus == ParmJobStatus::Waiting
       && purchParmTable.Ordering == DocumentStatus::Invoice
   if(purchParmTable.RecId || purchParmLine.RecId)



  1. Your blog is really awesome and I got some useful information from your blog. This is really useful for me. Thanks for sharing such a informative blog. Keep posting.
    Microsoft Dynamics AX Training | VMware Virtualization Online Training

  2. it's tough to put so much into something and not get the pass. But you have the right makeup to finish the job and go get that number. I have a ton of respect for you.

  3. Nice question. it will definitely enhance the knowledge related to microsoft dynamics ax erp solution and ms dynamics ax. Thanks for posting a good question blog. You can consult with MPG BIS for this type of errors.

  4. Hello. It is a really interesting case, very nice one. Generally speaking your blog is full of useful and interesting cases, so good work. Thank You for posting this and sharing Your knowledge about ms dynamics .

  5. This is one of the awesome and Important post.I like your blog description.

    Microsoft certification in mumbai

  6. Brilliant piece of information,I had come to know about your web-page from my friend Harish, Chennai. I have read atleast 9 posts of yours by now and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that I had been looking for and I would regularly watch out for the new posts! Thanx a million once again, Regards, AX consultant

  7. This comment has been removed by the author.

  8. Very helpful indeed, you just saved me from 1 week headache trying to resolve this

  9. Great post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.


  10. Hi,
    your blog has a wonderful resource for the AX community and for me, Thank you for blogging and sharing of your knowledge.
    Oracle EBS training
    Thank you

  11. Subscribe to learn this new technique in Ax . Give like comments and share

  12. Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.

    rpa Training in Chennai

    rpa Training in bangalore

    rpa Training in pune

    blueprism Training in Chennai

    blueprism Training in bangalore

    blueprism Training in pune

    rpa online training

  13. Nice blog..! I really loved reading through this article. Thanks for sharing such a
    amazing post with us and keep blogging... iot training in chennai | iot training in chennai quora | iot training and placement in chennai | iot training center in chennai | best iot training centre in chennai