Purchase Order automatic number sequence


B

blueindian

Somehow one of my employees has inadvertantly change the sequence of the
automated purchase order numbers. The sequence matches too closely with
another locations number sequence. How can I alter or set a new number
sequence to stop this.
 
Ad

Advertisements

J

Jeff @ Check Point Software

Blueindian,

You will have to change it with a SQL script.

Make a note of the PO number you wish to change.

Make a backup!

Instructions for a Single store operation;

Go into SO Administrator | File | Connect | put in your password | Query | New and type the following;

UPDATE PurchaseOrder SET PONumber = xxx WHERE PONumber = yyy AND POType = 0
xxx is the new number yyy is the old one




Somehow one of my employees has inadvertantly change the sequence of the
automated purchase order numbers. The sequence matches too closely with
another locations number sequence. How can I alter or set a new number
sequence to stop this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top