I've been using Dynamics SL since 2007 and want to delete the INventory TRANsaction data/table. I've already set the retention period and year in inventory setup, and then run Integrity Check. But still I can't remove the inventory transaction data. Anybody knows how to do it? Thanks.
*This post is locked for comments
Select Convert(Char(40), O.Name) From SysObjects O, SysColumns C Where O.Id = C.Id And O.XType = 'U' And C.Name = 'Invtid'
Will give you every table in the app database with the field Invtid in it. Loop thru the results and execute a delete statement agains each table. Use at your own risk, in a test environment first!
DECLARE @delInvtid varchar(30)
SET @delInvtid = 'commodore_64'
DECLARE @tablename varchar(40)
DECLARE table_cursor CURSOR
FOR
Select Convert(Char(40), O.Name)
From SysObjects O, SysColumns C
Where O.Id = C.Id And O.XType = 'U' And C.Name = 'Invtid'
OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @tablename
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXECUTE ('DELETE from ' + @tablename + ' where Invtid = ''' + @delInvtid + '''');
FETCH NEXT FROM table_cursor INTO @tablename
END
DEALLOCATE table_cursor;
GO
Yup, they dropped the functionality it seems. the config options are still there but nothing to clean up intrans or the various itemhist tables. Being in the computer industry the invtid turn over is huge and 80 percent of our 1/4 million inventory items are inactive IDs. If we didn't have intrans on these obsolete items we would have no problem deleting them but right now we don't to preserve referential integrity.
I was prepared to tell you just to click the check box in the GL closing screen. Until I found that one did not exist!
We have intran for the last 12 years.
MS or gold partners?
Over 7 years I have not yet deleted the INventory TRANsactions...And now I keep getting problems with slow system response time....
Over 7 Years Later I have the same question. Anyone?
Share
Report
All responses (
Answers (
