How do i change the Purcase Order number sequence?


D

dave

My manually generated Purchase Orders run in sequence commencing with
100----. For example1007701, 1007702 etc. but my Auto Purchase orders
generated from restocking information run in sequence starting with 000----
For example 0008321, 0008322 etc. Ant idea how to get them both back to
commence with 000
 
Ad

Advertisements

A

Akber Alwani

hi dave, when you do manually it not run the code inside the bussiness logic
however when there is no no specify the following code is generated:
SELECT ISNULL(MAX(CAST(RIGHT(PONumber, 7) AS INT)), 0) + 1 AS NextPONumber
FROM PurchaseOrder WHERE ISNUMERIC(PONumber) <> 0

You can make trigger to do so but it is not easy task and require much R&D
to do so.
 
Ad

Advertisements

D

dave

I think i have not explained the problem properly. Both sets of numbers are
automatically generated by RMS. The set beginnig with 100.... auto generates
when i do purchase orders where i manually select items to order and the set
beginning 000.... auto generates when i do orders from restocking information.
i would love to get them all into one numbering sequence.
 

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