Hi everyone, I'm new to RMS, but I'm looking for a way to automate the itemlookupcode (trigger?) so when a new item is entered it suggest a (unique) new lookupcode.... Tnx, peter.
automize itemlookupcode
Apr 10, 2007
7 Replies
Hi Pampers
I may have read > Hi everyone,
Hi Pampers, Last time the same question came from other site and I given one solution here is what you are looking you need to create the trigger at the database level here is the code: CREATE TRIGGER CreateLoookupCode ON Item FOR INSERT AS
UPDATE Item SET ItemLookupcode=(Select Max(B.ItemLookupcode)+1 from item As B) FROM Item INNER JOIN Inserted ON Item.ID= Inserted.ID
The above code will generate the no base on the last ItemLookupcode +1 remember one thing that at initial when you setup the item you have to give item lookupcode to anything i.e. "9" or "0" then system automtiaclly generate the new no. why we are doing this because system has UI validation for itemlookupcode and this is the technique to generate the automatic itemlookupcode. Hope it will work for you.
"Pampers" wrote:
Check out Digital Retail Solutions Power Ops module...it's fantastic! Todd Jensen NitroSell
Option A: Try our AutoGen add-in.
30 day trial:
formatting link
password: ag103107See Help file for instructions on setting up a format for autogenerated ItemLookup Codes (ILC).
Option B: If you want more control over the ILC, try our Power Ops add-in.
30 day trial:
formatting link
password: po103107See Help file for instructions (Help, Configuration, Setup, Custom ILCs).Power Ops also provides a faster way to create/edit all items includingstandard, serialized, matrix, and parent/child entries.Plus you can find items faster with a power search that allows you totag and sell, generate quick Purchase Orders, and much more. For more information contact your RMS reseller.
Greg Digital Retail Solutions
formatting link
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required