1. Home
  2. Point-Of-Sale Software
  3. New Item Wizard and 2.0 - Problem?

New Item Wizard and 2.0 - Problem?

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

Reply to
Kat Straub
Loading thread data ...

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:

Reply to
Akber Alwani

Akber,

The query worked great! I so very much appreciate it.......! That is exactly what I need it to do.......

S> HI Kat,

Reply to
Kat Straub

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!

Reply to
Alex

Hello

Well i took a guess on the Barcode format and it worked. Thanks Akber knowing about that trigger will come in handy

CREATE TRIGGER UPDQTY ON Item FOR INSERT AS

UPDATE Item SET Barcodeformat = 8 FROM Item INNER JOIN Inserted ON Item.ID= Inserted.ID

8 = Code128C

Aaron

Reply to
Aaron

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

Reply to
Glenn Adams [MVP - Retail Mgmt

whoops

thanks for the warnings. I thought i changed the trigger name

Aaron

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:%23v4h4g$ snipped-for-privacy@TK2MSFTNGP05.phx.gbl...

Reply to
Aaron

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

Reply to
Alex

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.