web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Store Operations Manag...
Microsoft Dynamics RMS (Archived)

Store Operations Manager PO/Transfers automatic order number getting stuck

(0) ShareShare
ReportReport
Posted on by Kevin Bike Tech 52

At one of my stores, when creating a PO or transfer after leaving the order number blank (which we do the majority of time) the manager would generally generate an automatic number. Now after reaching number 1000000 at one particular location it keeps defaulting back to it giving us the error message that this number cannot be used again. How to I get the program to move on from this number and continue on?

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Store Operations Manager PO/Transfers automatic order number getting stuck

    Hey, Good Day i solved my issue but advice you should be cautious of this method

    I Run (2)two Queries


    First

    select * from PurchaseOrder
    where PONumber like '1000000%'

    To view all the possible PONumber in the range review them to see if they were important

    Now if you want to delete them which i had like 10

    You could change there number to something RMS will accept

    but i just delete them

    With this query

    delete from PurchaseOrder
    where PONumber like '1000000%'

    Problem Solved!

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: Store Operations Manager PO/Transfers automatic order number getting stuck

    select PONumber from PurchaseOrder where PONumber  like '1000000'

    it will give you all PO's and transfers order ordered by its number

  • Kevin Bike Tech Profile Picture
    Kevin Bike Tech 52 on at
    RE: Store Operations Manager PO/Transfers automatic order number getting stuck

    can you provide more details on accessing the purchase order table?

    Greatly appreciated

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: Store Operations Manager PO/Transfers automatic order number getting stuck

    Check PurchaseOrder Table if this value exist set next number manually 1000001.

    also this case may be occurred during database deadlock you can remove it by restart database engine in case of not exist in your PurchaseOrder table.

    Recheck your database and reindex from store operation administrator if second scenario not solve your issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans