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 000hi 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.
"dave" wrote:
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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.