Add order By the back door

[TheKnee]

I would like to add order in the sop table by SQL querry
what is the best way to get next order number available?

 

[bradth]

You could just run a "SELECT * FROM SOP----- ORDER BY SOPNUMBE" and take the highest SO Number and add +1 to it. That will create the most recent SO.

Brad

 

[TheKnee]

Is there any chance that someone could take the same number as me...

 

[bradth]

If you add your order right away, you should be ok. If you end up waiting for a little bit though, you might want to go back and check to see if the number has been used or not. What exactly are you trying to do or add to the tables?

 

[TheKnee]

I build a transcational web site and i whant to send the order directly to GP with out type it human action

 

[bradth]

Well, if you create a stored procedure, the procedure could then find the most current available SO number, add 1 to it, and create the SO right there. It would be done so quickly, the number could not be taken by someone else. I have a customization in GP that takes the transfer number and adds 1 to it to get the most recent and haven't had any troubles with it thus far.

Brad

 

[jazgeek]

make an algorythm for your SOP# selection.

ie

August 10, 2005 11:10am

SO-810051110



-----------
and they wonder why they call it Great Pains!

jaz