Re: [Axapta-Knowledge-Village] Re: Cleaning up Item Master records!?

2005-02-16 Thread Girish B
i would advise you to have an ItemId created which could be used as one time item. During transaction you could use the ItemName to identify the corresponding Item, like when creating the sales line the default item name would appear which you could overwrite with a different item name. If yo

[Axapta-Knowledge-Village] Re: Cleaning up Item Master records!?

2005-02-15 Thread anilsinha1968
Hi, If you only want your search to be improved then I will suggest, you mark all those One Time Items to Stopped and then use Record Level Security. But if you want to delete those items from Item Master also then, although this is not recommended, you can delete those items if you are sur

Re: [Axapta-Knowledge-Village] Re: Cleaning up Item Master records!?

2005-02-15 Thread Amit Jain
Yes i think Girish is correct. Ideally you should never delete any master data and moreover you have transactions (no and never !). If you don't want to select the records for one time item you can put some kind of validation, so that those records are not counted, a very ordinary example w

Re: [Axapta-Knowledge-Village] Re: Cleaning up Item Master records!?

2005-02-15 Thread Girish B
I am not sure if its a good idea to delete the Items from the Item master, when the transactions are there. you cannot delete directly as the validations would not allow to delete itm if the transactions are done. You could bypass the validations and delete but it would affect the data consis

[Axapta-Knowledge-Village] Re: Cleaning up Item Master records!?

2005-02-14 Thread von_hussa
Ok, thanks for the tips --- In Axapta-Knowledge-Village@yahoogroups.com, "Shruti" <[EMAIL PROTECTED]> wrote: > Hi > This cud be done by "delete_from inventTable" clause > U can also put some conditions using the where clause. > this code can be written inside a job also. > Regards:: > Shrut