I have a client that needs to delete a large amount of fixed assets, but does 
not want to use Clear Data. I need to be able to delete a range of assets by 
Asset Class.

Has anyone written scripts or tried to do this in SQL?

you can try this:

Delete FAXXXXX where ASSETINDEX in (Select assetindex from FA00100 where 
assetclassid = 'enter class id here')

The FA00100 has the class id field which you can filter on. with that in 
mind, you can replace the FAXXXXX with the following tables first and run it 
agains the company db:

-- FA00200 (Asset Book Master)
-- FA00300 (Asset Book ITC/Cost Adjustment Master)
-- FA00902 (Asset Financial Detail Master)
-- FA41900 (Projections Report Master), in case you want to remove 
projection data for these assets too.

The last delete statement that you will run is:

Delete FA00100 where assetclassid = 'enter class id here'

try it out on their test environment and see if it'll work.

hope this helps.

rheiner

"DavidInterDyn" wrote:

> I have a client that needs to delete a large amount of fixed assets, but does 
> not want to use Clear Data. I need to be able to delete a range of assets by 
> Asset Class.
> 
> Has anyone written scripts or tried to do this in SQL?

Thanks, this worked well.

"Rheiner" wrote:

> you can try this:
> 
> Delete FAXXXXX where ASSETINDEX in (Select assetindex from FA00100 where 
> assetclassid = 'enter class id here')
> 
> The FA00100 has the class id field which you can filter on. with that in 
> mind, you can replace the FAXXXXX with the following tables first and run it 
> agains the company db:
> 
> -- FA00200 (Asset Book Master)
> -- FA00300 (Asset Book ITC/Cost Adjustment Master)
> -- FA00902 (Asset Financial Detail Master)
> -- FA41900 (Projections Report Master), in case you want to remove 
> projection data for these assets too.
> 
> The last delete statement that you will run is:
> 
> Delete FA00100 where assetclassid = 'enter class id here'
> 
> try it out on their test environment and see if it'll work.
> 
> hope this helps.
> 
> rheiner
> 
> "DavidInterDyn" wrote:
> 
> > I have a client that needs to delete a large amount of fixed assets, but does 
> > not want to use Clear Data. I need to be able to delete a range of assets by 
> > Asset Class.
> > 
> > Has anyone written scripts or tried to do this in SQL?