If you have changed classifications in some of your assets in AssetAccountant, e.g. location, multiple times, you may find an asset export lists multiple Classifications/Locations and not necessarily the current one.


Unfortunately with changes made like this, it is not possible to show only one and the last Classification/Location the asset was transferred to.


The Asset Export report will report on all Classifications/Locations that an asset belonged to in the date range you selected in the AssetAccountant interface prior to running this report.


You might like to try either:


  • Selecting a shorter date range for the Asset Export report to only capture the last Classification/Location
  • Running a formula in the Excel or CSV report download (eg: TEXTAFTER(A1,",",-1) - where A1 is the cell reference