I am trying to use Report Writer wizard to do report for assets as of 12/31/08.

The criteria I am using is

Location = xyz for the location I want and

Acitivity Code = A for active assets only

The issue is that we have disposed  and transferred assets since the beginning of the year so they are not showing on the report even though they were active at 12/31.

How can I generate a report that shows accurately the acquisition cost and accum depr of assets as of year end? Thanks

 When I have assets that were disposed or transferred during the year, I will run an end-of-year report showing all assets, but sorted by activity.

Activity=A will give an accurate count of my active assets.

Activity=D will show my disposed assets, with their activity during the year.

And the Net Grand Total will give me an accurate Accumulated Depreciation as of year-end.

Hope this helps.

 Thanks. :)

I've tried that before and its tedious. The thing is that particular location that I am running the report for has hundreds of assets that have been disposed so I was hoping there is a criteria I could use to eliminate the extra work of sorting and removing the assets you dont want. If not I guess I will have to go the extra step but there has to be easier way.

I would use some of the standard reports FAS has but they cut off the description or they're not on the same line as other info so its kind of annoying. Downoading them and formatting is annoying too so I hope there is a criteria I can use in Report Writer wizard.

 Nancy, are you still working on this?

If yes, I would suggest that, in order to not have to deal with all of the 2007 and earlier disposals and transfers, you create a group that includes active assets, disposed assets (that were only disposed during 2008, and transferred assets (that were transferred during 2008). You could then use the Report Wizard to run your report on that group. The group limitations should eliminate the extra sorting you want to avoid, and the Report Writer should give you the format you want.