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;
}
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.
ReplyDeleteMicrosoft Dynamics AX Training | VMware Virtualization Online Training
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.
ReplyDeleteHello. 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 .
ReplyDeleteThis is one of the awesome and Important post.I like your blog description.
ReplyDeleteMicrosoft certification in mumbai
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
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteVery helpful indeed, you just saved me from 1 week headache trying to resolve this
ReplyDeleteGreat 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.
ReplyDeletehttp://www.thinkittraining.in
Hi,
ReplyDeleteyour 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
Subscribe to learn this new technique in Ax . Give like comments and share
ReplyDeletehttps://youtu.be/8dXjRzSk910
Local Packers and Movers Bangalore List, Get Best Price Quotes, Compare Movers and packers Charges, Top, Local Household Shifting Services.Packers And Movers Bangalore
ReplyDeleteLocal Packers and Movers Bangalore List, Get Best Price Quotes, Compare Movers and packers Charges, Top, Local Household Shifting Services.Packers And Movers Bangalore
ReplyDeletevery useful information, the post shared was very nice.
ReplyDeleteMicrosoft Dynamics AX Online Training
The Best of the Blogs You have Mentioned here.
ReplyDeleteMS Dynamics AX Online Training
Good blog information provided
ReplyDeleteSanjary Academy is the best Piping Design institute in Hyderabad, Telangana. It is the best Piping design Course in India and we have offer professional Engineering Courses like Piping design Course, QA/QC Course, document controller course, Pressure Vessel Design Course, Welding Inspector Course, Quality Management Course and Safety Officer Course.
Piping Design Course in India
I like this topic.This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting this again.
ReplyDeleteBCOM 1st Year TimeTable 2020
Very nice post..After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic.
ReplyDeleteoracle training in chennai
oracle training institute in chennai
oracle training in bangalore
oracle training in hyderabad
oracle training
hadoop training in chennai
hadoop training in bangalore
Exploring in Yahoo I at last stumbled upon this website.
ReplyDeleteVU BA second year
This site helps to clear your all query.mp bhoj ba 3rd year result
ReplyDeletedbrau ba 3rd year result This is really worth reading. nice informative article.
Amazing or I can say this is a remarkable article.
ReplyDeleteB Com Part 2nd Admit card
Thanks for sharing the info. keep up the good work going.
ReplyDeletemjpru bsc 3rd year result.
mjpru bsc 2nd year result
ReplyDeletemjpru bsc 3rd year result
goyard outlet
ReplyDeletekyrie 5 spongebob
steph curry shoes
air jordan
supreme new york
supreme
off white
supreme new york
Jordan Travis Scott
kyrie 8