Dear All,

We have lot of items in item master which are not currently used. Now we decide the reduce the size of Item Master.

We want to hide or delete those items which are not used at present. Is it possible. If yes, Please give me suggestion how to remove or hide that items.

Also we wants those items are not display in the item master.

Thanks in advance

Dksharma

Create a signal code which blocks the items from being used in any of the modules like sales, purchase, production etc..

If any of these items were used in any session earlier, deleting is quite a headache(as it writes them into history tables). Its better to block them with a signal code and they wont appear when the item master is being queried from other sessions...

sk

Dear S.K.,

thanks for your valuable suggestion, but we wants those items which are not used they also stay with the Item Master and not display or in the form of hide Items.

Can it possible.

Thanks

Dksharma

By using signal codes, the item codes exist in the Item Master but wont appear in any Item Master Subsessions. This will hide as well as block item codes from being used in other sessions without much of a drag(performance). However if one was to scroll through item codes using the Item Master main session (tiitm0101m000), you would be able to see it. But untill the signal codes are present and you define the signal code in such way that the item codes are blocked on all modules, they would be invisible for all the other modules.

Another way would be to create a new item group or selection code and put a user restriction(using Table Data Authorization) on these newly created group or selection code so that the users who are restricted, wont be able to see or use them in the sessions they have restrictions on. Does the same job as above, but there is a big performance drag on this and its tedious to maintain....

sk

Dear S.K.

Thanks a lot sir,

I try to setup the signal code and use for blocking the unusable items.


Dksharma

The best way I have found out over the years on dealing with items in tiitm0101m000 that cannot be delete because of history is as follow:

Define a Siganl code for Obsolete part, block for all transactions.
Define a new whse for Obsolete Items and asign this whse to all the items you no longer want to see.
Delete all items by whse in Mainatain Item by whse of the relevant items, only keep the record of the items/Obsolete whse

I do not suggest to change the item group as this could prevent retrieving historical info, however if you use product type, selection code, you can define a category for the obsolete items.
To aavoid seing them in the display, it all depend how you make your search but I mostly use the Query, this way you can eliminateby the obsolete whse.

We tackled this (in Baan Vc) by assigning the obsolete items to warehouse 999 and then blocked warehouse 999 from user access via the table authorisations

it worked a treat and we have 'hidden' about 5000 items

Hi David,

Please what is the steps are to be taken in Baan V for hide the unused Item Master, write briefly.

Thanks in advance.

regards

dksharma

As recommended by others, 1st create item signal that blocks all transactions
For items that are to be flagged as Obsolete:
Ensure NO inventory, planned Sales, Purchase or Transfer orders

Create new warehouse for sole purpose of taking 'ownership' of obsolete items
Enter the Item signal and warehouse code in tcibd001
Enter the warehouse code in tdisa001 and tdpur001

In table authorisations, mark these three tables for cwar = xxx (whatever code you use) to be 'Not Authorised'

Item will now be 'invisible' to normal users in General Item Data, Sales & Purchasing data - you will not have lost this item's history, but it will not clutter up users screens.

A previous post made mention of deleting Item / Warehouse data - we did not go this far, but it sounds sensible to me

Lots of luck

D'Oh!! You might want to cancel any open production orders and replace the obsolete items in BOM's while your at it

Hi,
David,

Thanks for sharing the information regarding the Item master, I try to setup it in our system, after that I give information for this process is work or not.

Thanks again

Regards

Dksharma

Based on a special signal code, I have defined a job that uses the session tiitm0203m000 to (try to) delete items. That job gets started on weekends and holidays. However, deleting an item might last some hours, so be careful; I manually add some items to my job and I keep the log files.

Günther

Hi,
David,

Thanks for sharing the information regarding the Item master, I try to setup it in our system, after that I give information for this process is work or not.

Thanks again

Regards

Dksharma

Oh yea of little faith - of course it works!!

Good luck - will help if you need it