New Item Wizard and 2.0 - Problem?

Question

Hello Out There,

Upgrade to 2.0....I was content with the fact that I knew all the bugs in

1.2....so now when using New Item Wizard to create a new Matrix item, RMS automatically puts a quantity of 1 in each. So yes, you can go to Quantity Component to set the quantity to 0, but that is a lot of extra time and work. This is going to wreak absolute havoc with our inventory. Is there some way to configure RMS so that the quantity is automatically 0 until the item is received (i.e. the item should be 0 when it is created, and 1 or 2 or 3 when it is received in the store)? I am going to guess that I will have to run SQL code to fix it; I have no experience with that, so if anyone knows a way to walk me through this that would be great.

I am feeling pretty frustrated with RMS right at the moment and will keep my eyes open for other bugs that are being found.......

Thanks, Kat

Akber Alwani · Accepted Answer

HI Kat, you can create the database level trigger to accomplish this, following code run in SO Administrator > Query

CREATE TRIGGER UPDQTY ON Item FOR INSERT AS

UPDATE Item SET Quantity = 0 FROM Item INNER JOIN Inserted ON Item.ID= Inserted.ID

Please rate if you like it this will only works with newly created item, mean when you create the item it set the quantity to zero automatically.

"Kat Straub" wrote:

Kat Straub · Answer

Akber,The query worked great! I so very much appreciate it.......! That is exactly what I need it to do.......Sincerely,Kat"Akber Alwani" wrote:

Alex · Answer

Akber (or anybody),Can you provide me with the triggers to automatically copy Matrix dimension 1, 2, and 3 attributes to Subdescription 1, Subdecription 2, Subdescription 3 field(s) automatically after updating or creating Matrix dimensions/attributes? (Item SubDescription 1 = Matrix Dimension 1 attribute etc).Also while we're at it how about a trigger that automatically sets the barcode to barcode ID 8 (Code128C)?I think we should have the ability to configure RMS to do this automatically without having to do this for every item or Matrix item (like we had in RMS 1.x).Thank you!

Aaron · Answer

HelloWell i took a guess on the Barcode format and it worked.  Thanks Akber knowing about that trigger will come in handyCREATE TRIGGER UPDQTY ON ItemFOR INSERTASUPDATE Item SET Barcodeformat = 8FROM Item INNER JOIN Inserted ON  8 = Code128CAaron

Glenn Adams [MVP - Retail Mgmt · Answer

If this is the only trigger you ever create it won't matter, but all trigger names need to be unique...

"UPDQTY" is the Name of the trigger, so if you were to create another one you would need to use something different. THis looks like you have a trigger named "Update Quantity" that is actually updating the Barcode Format...

Also, triggers can have a very negative performance impact on a database application. You need to use care when implementing them.

Your insert trigger will probably not be a problem in and of itself, but it would be very unfortunate for retailers with no SQL background to start going crazy with triggers like this. Just wanted to point out that once you start making changes of this nature, you are taking your data in your hands. It's akin to putting knock-off parts on your new car - they will probably function the same, but there's a good chance you just voided your warranty.

Glenn Adams Tiber Creek C> Hello

Aaron · Answer

whoopsthanks for the warnings.  I thought i changed the trigger nameAaron"Glenn Adams [MVP - Retail Mgmt]"  wrote in message news:%23v4h4g$

Alex · Answer

How about the first part of the post to create the SubDescription triggers?

New Item Wizard and 2.0 - Problem?

Join the Discussion

Didn't find your answer?