I have a customer that has RMS 2.0 HQ & 5 stores. one of the stores crashed and I was able to recreate/export it through HQ. The purchase orders number sequence from the rebuild store started from the beginning again. Will it cause a conflict issue with HQ database and the other stores since these PO numbers where all ready in the used in the past. If so, can I the change the po sequence number in the rebuild store by running sql statement ?
Thanks
Dave
*This post is locked for comments
Yes this could cause problems for HQ. You need to go into the settings for the database and change the Identity Seed for the PurchaseOrder ID column.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156