Set next Work Order ID/Number

(0) Share

Report

Posted on by Stephen Schulz

Hi,

Thanks in advance for any help. I want to be able to adjust the Work Order ID, similar to the way in Store Operations Administrator you can 'Set Next Transaction Number'.

The reason is that we have a customer with multiple stores, however the Work Orders are sent to a 'workshop' where they machine the wood. When they have multiple orders appear with the same number things can get confusing. My thought was to increase one stores starting ID to 10000 and the others to 20000.

I did check the various tables in the RMS database without any luck. Such as the Order table. Can I just insert to that table a new entry and give it a larger ID?

Thanks,

Regards;

Stephen

Total POS Solutions

*This post is locked for comments

All responses (2)

Answers (1)

Suggested answer

Stephen Schulz 35 on at

Like (0)

Report

RE: Set next Work Order ID/Number

Thank you so much, that worked a treat!
Verified answer

Spencer McCandless 2,085 on at

Like (0)

Report

RE: Set next Work Order ID/Number

I'm not super familiar with the work order function, as we don't really use it, but I would start by backing up the db and attempting to reseed the identity column.

www.techrepublic.com/.../how-do-i-reseed-a-sql-server-identity-column