Fixed Asset Management: Export the Asset Register Report

In Fixed Asset Management, it is important to track the asset's status and balances. There are instances that a readily available report is required especially for audit purposed. However, the ability to export Fixed Assets>Reports>Asset Register is currently filed as Enhancement# 203975. There are Saved Searches created within the Fixed Assets Management bundle like FAM – Asset Register (Saved Search) and FAM – Asset Register Movement (Saved Search) that users can access but this does not follow the same format as the current Asset Register Report. As an alternate solution, users can implement the following Saved Search.

Please note that this works on the following assumptions and definitions:

1.    This Saved Search is feasible for Assets that have been acquired through the Asset Proposal process as Acquisition transactions are used.

2.    The Saved Search is dynamic and uses 'Same Day Last Year' as the Beginning Period. Then, it accounts for 1 year as current transactions. If users need to narrow down the period then change the second parameter for the all ADD_MONTH() functions used. For example, if users want to run for 1 Quarter ago then use ADD_MONTH({today}, -3) since quarter is equal to 3 months.

Steps to create the Saved Search:

1.    Navigate to Transactions>Management>Saved Searches>New

2.    Select FAM – Depreciation History

3.    On the Criteria tab add the following fields:

·         Alternate Depreciation is –none-

·         Asset is not –none-

4.    On the Results tab add the following fields:

·         Asset: Asset Type where Summary Type = Group

·         Asset where Summary Type = Group

·         Asset: Name where Summary Type = Group

·         Asset: Subsidiary where Summary Type = Group

·         Formula (Date) = DECODE({custrecord_deprhisttype}, 'Acquisition', {custrecord_deprhistdate}) where Summary Type = Maximum with Custom Label = Acquisition Date

·         Formula (Currency) = CASE WHEN {custrecord_deprhistdate} - ADD_MONTHS({today}, -12) < 0 THEN (DECODE({custrecord_deprhisttype}, 'Depreciation', 0, 'Sale or Disposal', -1, 'Write-Down', -1, 1)*{custrecord_deprhistamount}) END where Summary Type = Sum with Custom Label = Previous Additions

·         Formula (Currency) = CASE WHEN {custrecord_deprhistdate} - ADD_MONTHS({today}, -12) > 0 THEN (DECODE({custrecord_deprhisttype}, 'Depreciation', 0, 'Sale or Disposal', -1, 'Write-Down', -1, 1)*{custrecord_deprhistamount}) END where Summary Type = Sum with Custom Label = Current Additions

·         Formula (Currency) = DECODE({custrecord_deprhisttype}, 'Depreciation', 0, 'Sale or Disposal', -1, 'Write-Down', -1, 1)*{custrecord_deprhistamount} where Summary Type = Sum with Custom Label = Ending Additions

·         Formula (Currency) = CASE WHEN {custrecord_deprhistdate} - ADD_MONTHS({today}, -12) < 0 THEN (DECODE({custrecord_deprhisttype}, 'Depreciation', 1, 0)*{custrecord_deprhistamount}) END where Summary Type = Sum with Custom Label = Previous Accumulated Depreciation

·         Formula (Currency) = CASE WHEN {custrecord_deprhistdate} - ADD_MONTHS({today}, -12) > 0 THEN (DECODE({custrecord_deprhisttype}, 'Depreciation', 1, 0)*{custrecord_deprhistamount}) END where Summary Type = Sum with Custom Label = Current Depreciation

·         Formula (Currency) = DECODE({custrecord_deprhisttype}, 'Depreciation', 1, 0)*{custrecord_deprhistamount} where Summary Type = Sum with Custom Label = Ending Accumulated Depreciation

·         Formula (Currency) = CASE WHEN {custrecord_deprhistdate} - ADD_MONTHS({today}, -12) < 0 THEN (DECODE({custrecord_deprhisttype}, 'Depreciation', -1, 'Sale or Disposal', -1, 'Write-Down', -1, 1)*{custrecord_deprhistamount}) END where Summary = Sum with Custom Label = Previous NBV

·         Formula (Currency) = DECODE({custrecord_deprhisttype}, 'Depreciation', -1, 'Sale or Disposal', -1, 'Write-Down', -1, 1)*{custrecord_deprhistamount} where Summary Type = Sum with Custom Label = Ending NBV

5.    Hit Preview or Save and Run