Sales Order Revision Shenanigans

Have you ever wondered what happens when you reach 100 revisions of a Sales Order? No? Me neither, but it happened to us last week.

My current employer has long term contracts and the sales orders can stay open for 5 years or more. Items are added, changed, or removed all the time so 100 revisions isn’t as outlandish as it sounds.

Well, when you hit revision 100, the screen displays ** and that value is written to the database. There are no revisions after that.

Made2Manage created a Change Request for it, number 163578b and their workaround is to add and carry the sales order into a new one for a fresh set of revisions. However, there’s no way to actually tie the orders together so you lose your history anyway.

Oh well, you learn something new everyday.

5 comments to Sales Order Revision Shenanigans

  • Wow, that’s a lot of revisions. I don’t even know what to add in there for that one. Constantly revising a single order seems a bit less than optimal approach to me, but maybe I’m missing something.

    I haven’t done any work in M2M in relation to sales orders, so I don’t have any suggests for you on work arounds either. Surely there’s at least some kind of Notes field to point you to the previous order though.

  • Fred Crawford


    This comment is not in regard to this issue, but are you aware that when you upgrade to version 6.0 that you lose the part number information on customer service inquiries for inquiries which do not have an RMA assigned to them? Sort of like saying that we had 20,000 customers call and complain about our parts, but we don’t have any idea of exactly which part numbers they called about. Hopefully I’m not missing something, but I believe this to be true.


  • roleki

    Wow, that’s awesome. They actually have to do more work to limit the number of revisions to 99 than they would to make them unlimited, or even, 3-wide instead of 2.

    BTW, where you been? M2Mentor has been strangely silent of late.

  • Roleki, I’m sorry I’ve been so preoccupied. I’ll make more time in the future as I have a huge backlog of topics to write about.

    Stay Tuned! ๐Ÿ™‚

  • roleki

    Just glad to hear all is well; you’re entitled to take a break!

    Emphasis on ‘a’ ๐Ÿ™‚

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>