You should never update docstatus directly through mysql query. As you have bypassed oncancel method, the reverse effect did not take place for calculating projected qty. There are some other methods as well, which did not called.
For now, only way is amending the Sales Order to change the item qty. And obviously you need to cancel Delivery Note and Sales invoice against it to cancel the Sales Order.
Thanks for the info. Do you foresee any problems in the future because of that, or will projections correct over time? I’ll take a look at this ‘oncancel’ thing, so next time I properly cancel without canceling - thanks for the tip.
This problem still stands and cancelling multiple documents just to resubmit them is unfortunately not really a solution.
BTW. There should really be some kind of erpnextnext package, for example costing 100 EUR/month. Each monthly payment would give you 100 EUR bounty power. This way such limitations would be a thing of the past, and I could do business instead of dancing around them - once bounty gets solved by someone, they get posted bounties minus something like 20% for erpnext foundation costs.
“There should really be some kind of erpnextnext package, for example costing 100 EUR/month. Each monthly payment would give you 100 EUR bounty power. This way such limitations would be a thing of the past, and I could do business instead of dancing around them - once bounty gets solved by someone, they get posted bounties minus something like 20% for erpnext foundation costs.”
Why not post and explain this idea in a new thread for others to comment?
Meh. This thread’s limited exposure is good for now – bear with me - If entry price point would be at around 100 EUR/month, I’m sure many sensible companies using ERPNext would sign up. You can figure out some perks for customers or not, but main point is: you give most money back to community in form of bounties, to be posted by your subscribers. Or – if you can and want – keep the money in-house by taking on bounties yourself. Think of it as a point system. You subscribe to erpnext+ for 100 EUR/month, or whatever. For that you get some nice donor badge in the forums for the warm fuzzy feeling you’ve helped a great, free and open project. Moreover, you get 1 point for each 1 EUR donated. You can then attach some of the points you have to your feature request/fundamental problem correction request threads. Or you can transfer them at your will to some other user as a thank you for answering your questions/helping in some other way. Then that user may convert the points back into EUR, obviously at lower rate to cover your costs, taxes and obviously leave some behind to push project forward. Or not – keep the points and then post another bounty/fail/feature request to solve.
If this is something you may want to invest in and try, I’ll gladly put in my time to make a separate thread about this. But other’s comments and my time will be wasted if at foremost YOU are not interested.