My manually generated Purchase Orders run in sequence commencing with
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.
"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.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required