automize itemlookupcode

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: 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: 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