Hi I thought there are no transactions for the inventDim that you are trying to delete.
Check if there are any corresponding records in InventTrans. If there are records then I do not think you can delete the records. (of course if this is a test system then you can remove the delete action, delete records and restore the delete action) but I do not think you should do this on live system. --dittor- for inventsum Regards harry This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm" The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of yunfeng.li2007 Sent: Thursday, January 24, 2008 9:25 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: delete record from InventDim table Hi Harry, Thank you for replying! 1) Clean up. I did the clean up manually, it did not help. 2) I noticed the InventDim uses "delete(true/false)" for delete method. So I deleted the records using "inventDim.delete(true);" this time. Here is the results: Contents before calling "inventDim.delete(true);": ----------- -------------- ---------------- InvendDimId InventSerialId InventLocationId ----------- -------------- ---------------- 12345 45678 GW 12346 45679 GW ..... ..... GW Contents after calling "inventDim.delete(true);": (all GW gone, but 12345, 12346 are still there) ----------- -------------- ---------------- InvendDimId InventSerialId InventLocationId ----------- -------------- ---------------- 12345 45678 12346 45679 ..... ..... As you can see, after deletion, all the records came back with only "GW" becoming empty. I want to delete the 12345, 12346, ... completely. Could you (or some other experts) please help on this? Thanks. YLi --- In Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com>, Harry Deshpande <[EMAIL PROTECTED]> wrote: > > Hi > > Check if you have a inventory - periodic job that cleans up unutilized dimension. > > For understanding your problem you will have to look at inventDim - delete method. > > Regards > > Harry > > > From: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com> > [mailto:Axapta- [EMAIL PROTECTED]<mailto:Knowledge-Village%40yahoogroups.com>] On Behalf Of yunfeng.li2007 > Sent: Thursday, January 24, 2008 6:44 AM > To: > Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village%40yahoogroups.com> > Subject: [Axapta-Knowledge-Village] delete record from InventDim table > > > Hi dear Axapta friends, > > I tried to delete a record from the InventDim table. I deleted it OK > (it disappeared from the table browser). Then I closed the table > browser and re-open the table browser to view InventDim table, the > deleted record appeared again. > > Please give me a direction on how to solve it. > > Thank you very much! > > YLi > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]