I've tried to reset the next purchase order number in RMS using the below sql query.
DECLARE @NewPO NVARCHAR(20), @OldPO NVARCHAR(20)
SET @NewPO = 'NewPONumberHere'
SET @OldPO = 'OldPONumberHere'
UPDATE PurchaseOrder SET PONumber = @NewPO WHERE PONumber = @OldPO
AND @NewPO NOT IN (SELECT PONumber FROM PurchaseOrder)
this works in changing the current purchase order number but the next purchase order number reverts back to 10000000 and then I get a message that this number has been entered for another purchase order or inventory transfer. How do I get the next purchase order number to reset to something that hasn't been used before
Many thanks in advance
*This post is locked for comments
I have the same question (0)
