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."

A:
Use the following script
static void fixPurchaseOrders(Args _args)
{
   PurchParmTable purchParmTable;
   PurchParmLine purchParmLine;
   ;
   ttsbegin;
   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)
   {
       purchParmTable.delete();
       purchParmLine.delete();
   }
   ttscommit;

}

10 comments:

  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

    ReplyDelete
  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.

    ReplyDelete
  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.

    ReplyDelete
  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 .

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

    Microsoft certification in mumbai

    ReplyDelete
  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

    ReplyDelete
  7. This comment has been removed by the author.

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

    ReplyDelete
  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.

    http://www.thinkittraining.in

    ReplyDelete
  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

    ReplyDelete