50
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
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!
can you provide more details on accessing the purchase order table?
Greatly appreciated
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.
#1
André Arnaud de Cal...
292,575
Super User 2025 Season 1
#2
Martin Dráb
231,493
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
