auto create itemlookupcode when adding new items

Mar 25, 2005 5 Replies

Just like RMS assigns the next available # when adding a new customer, RMS should have a "next available #" for auto assigning the next Item Looup Code when adding inventory. At it's most basic, all you would do is give the starting number , say 10000.



You could always overwrite the number suggested with a manufacturer's 12 digit upc.



The implementation guide talks about "automation for numbering items", let's see it!


This can be done using an SQL Trigger. Talk to your RMS reseller about it.

Check the Managed newsgroups, there was an example of an SQL Trigger not too long ago (in the last month or so)

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required