1. Home
  2. Point-Of-Sale Software
  3. Problems with Aliases and Suppliers

Problems with Aliases and Suppliers

One of our clients is running RMS 2 with the latest service packs and she has issues when modifying items in her database. Sometimes she will try to add an alias to an item but it will say the alias is already in use as an ILC or an alias for a different item. A quick query will show that it is in use, but for an item with itemid = 0. I have already deleted these aliases from the item but they keep getting re-added and the issue keeps reoccuring. Another issue she has is sometimes she will add a supplier to an item and then go to add it to a purchase order and it won't show up under the supplier. She will then check the item and the supplier link won't be there.

I have tried checking and re-indexing the database but it doesn't seem to help.

Reply to
Arthur
Loading thread data ...

An entry in the alias table that references and itemid of zero means the original item was deleted, possibly through a delete query, instead of through the application. All these will need to be flushed out from the alias table.

Backup the db - then run - delete from alias where itemid = 0

The system should not add these on its own - are you running any third party applications or queries that may be doing this?

If the OS is XP Pro Service Pack 3 or Vista SP1, make sure you have applied the RMS fix for this service pack as it has been documented that the db may drop or not record entries done thru the RMS application when this patch is not in place.

H> One of our clients is running RMS 2 with the latest service packs and

Reply to
convoluted

I have been deleting the entries for the 0 itemid but they keep getting re-added.

They do have SP3 for Windows as well as SP3 for RMS. Where can I get this other hotfix? I don't see it available for download from partnersource.

Reply to
Arthur

I have been deleting the entries for the 0 itemid but they keep getting re-added.

They do have SP3 for Windows as well as SP3 for RMS. Where can I get this other hotfix? I don't see it available for download from partnersource.

Reply to
cptsoft

Another one of our clients has a similar issue with a similar setup. Their issue is that items frequently "disappear" from the item list when they try to add them to a purchase order. A reindex solves it but the problem occurs quite frequently and constantly reindexing the DB is annoying at best. Could this solution fix that as well?

Reply to
Arthur

Was that fix included in RMS 2 SP3 or does it have to be applied separately ?

"Jeff @ Check Po> Arthur,

Reply to
Robert
Reply to
cptsoft

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.