Victoria Yudin is back with a SQL view for asset account numbers in Dynamics GP. I love seeing Fixed Asset related posts in blogs and this one is no exception. It will go in the SQL Scripts area as well.
SQL view for asset account numbers in Dynamics GP
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.