General Discussion Topics

[Ralph]

v7.30.2.

I know there is no way to do this in the front-end, but I just wanted to ask if anyone had encountered a situation in which they wanted to prevent a Unit Of Measure from being used again, and had found some way to do it.   The UOM I'd like to kill was only used in two non-inventory transactions.  If it's possible I'd just like to make sure it's not used again.  Anyone?

TIA.

[DGill]

Depending on what tables it found its way into from those 2 transactions, it might be possible to delete the record in tciUnitMeasure and tciUnitMeasConvert but I'm guessing you will not be able to because of the referential integrity from the triggers.  You will want to look at the delete triggers on those tables to confirm.   You may just be left with renaming the ID value by appending '-NO' or something like that (kind of limited here because it is a varchar(6)).

This area is 1 of my major gripes with LOV (list of values) tables in MAS500.  All such tables should have an active status column. 

I'm pretty sure I added this issue to the enhancement site so you are welcome to vote on it.  :-)

[Ralph]

Thanks for the reply, Dan.  As expected, trying to delete the row from tciUnitMeasure results in...

Error Message:  Unable to delete the tciUnitMeasure record because it is being referenced by tsoShipLine. Reference ID: (R_1522).

And it's already a 5 character uom, so all I could do would be to add an 'N' to it, which wouldn't make much sense.   I guess there is probably nothing that can be done.

I just voted though.  Now I need one of those little "I Voted" lapel stickers so when anyone asked about it I could say, "oh, I was just at the v1ideas.com site and I voted for Dan's great suggestion to add a status column to all MAS 500 LOVs, of course." 

[SHulme]

Here you go...

[Ralph]

Perfect!  Just what I needed.  Thank you, sir.