1. Home
  2. Point-Of-Sale Software
  3. Maxtrix question

Maxtrix question

I have two questions regarding an Matrix item.

First is it possible to change an matrix item one it is created? For example. I have an matrix item with three fields. Hand, Length and Lbs. I want to delete the Lenght aspect of the item.

Second, How do I delete an entire matrix item? For example I use the lookup code BRSU and create the matrix but I made a mistake. I really want to use the same lookup code BRSU but it will not let me even after I deleted the individual items created with the matrix.

Thanks for all your help this past year. My annual buying show has never gone smother. Thanks to your help and RMS.

Lisa

Reply to
Lisa
Loading thread data ...

Hi Lisa.

  1. Yes it is possible to change the attribue remember it will effect on your report grouping and will not effect on items which are already created. i.e. from 3 dimension to 2 or 1 dimension can be done.

  1. Well regarding the system wide you do not have such thing to delete the whole group, however if you know little SQL language you can esaily delete this from backend query i..e delete from Item where itemlookupcode='BSRU'

Delete from Item

"Lisa" wrote:

Reply to
Akber Alwani

Reply to
Lisa

To handle your deletion problem go to Manager, select File, Configuration, Options, Item options. Make sure "Always display Find" is not enabled. Never enable this option if you create Matrix, Lot Matrix, or Assemblies or you won't be able to locate the class entries (in this case the M code). Now go to Database, Items and look for BRSU. From there you can delete the matrix class entry.

If you are interested in a much faster way to manage, view, and edit matrix items, download our RMS Toolkit trial and install Power Ops. For example, you can press Del on a matrix class item and automatically delete the class components (if they have no activity). RMS Toolkit 30 Day Trial:

formatting link
Ops Brochure:
formatting link
minute matrix tutorial:
formatting link
Greg Digital Retail Solutions
formatting link

Reply to
Greg [DRS]

You may want to have a look at the Retail Realm "Fashin Bundle"

Reply to
Afshin Alikhani

Lisa

Not sure of your facility with SQL but here is some background that may help you. Matrix items are stored in the itemclass table. That is where you specify the name and dimensions. Items are stored in the item table and that is primarily the info you see when you create an item in the Manager programme. Between the 2 tables is a bridge table called itemclasscomponent. It takes the id's from the itemclass table and adds rows for each item in the matrix class. The ids for the items come from the ID field (ie primary key) in the item table. Those are not the itemlookupcodes. However, if you find the itemlookup code just look for the ID field and that will give you the ID. Hope this helps

Jerry

Reply to
jph

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.