We just had situation with a sales order integration. There were 5 sales orders to integrate. Prior to the start of the integration the next sales order number was 075050. The integration started and errored on the 4th sales order. The error was caused by an invalid address ID. However, other users were still entering sales orders.Sales orders 075050,075051,075052 are now in the system from the integration. A user goes to enter a new order and gets sales order number 075050, not 075053. If you look at sales order document setup, the next sales order number is 075053. I tested this with several users and the result was the same. I then had everyone exit GP, restarted the SQL service and users then went back to generate new sales orders and now they all started getting the correct sales order numbers.Has anyone else ever experiened this and, if so, how did correct the situation?
*This post is locked for comments
