Asset ERP VS eFam

Report Module Guide: Asset ERP VS eFAM (Reconciliation Report)

Module Location

Fixed Asset > Reports > Asset ERP VS eFAM Report

Module Objective

The Asset ERP VS eFAM Report module is a specialized reconciliation tool. Its purpose is to generate a complete list of fixed assets recorded in the ERP system. This list is then used to be compared or matched with data from another system called "eFAM" (likely an external fixed asset management system) to ensure the data in both systems is synchronized and consistent.

1. Report Parameters (Filter)

The main page of this module is a simple form for selecting the assets to be displayed.

• Asset:

  • Select All to extract data for all assets, or select Selected to compare one or more specific assets.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Decide whether you want to see all assets or only selected assets.

Step 2: Generate the Report

After the parameter is set, click the [Display Report] button.

3. Reading and Using the Report

The generated report is a complete list of fixed assets in the ERP system, formatted for comparison purposes.

Purpose of Use: This report is generally not for being read directly, but rather for being exported to Excel. The data from this Excel file is then compared with similar data exported from the eFAM system to find differences, such as:

• Assets that exist in the ERP but not in eFAM (or vice versa).

• Data differences for the same asset (e.g., a different serial number, acquisition date, or value).

Note that columns such as eFAM Asset Code and eFAM Asset Name indicate that this data is specifically intended to be matched with another system.

Tips & Important Notes

• This is a technical reconciliation report, not a financial report for analysis.

• The process of comparing the data in Excel (for example, using the VLOOKUP function) is the next step after you generate this report.

• The ultimate goal of using this report is to ensure that the asset registers in the ERP system and the eFAM system are 100% aligned. This is a crucial task for maintaining asset data integrity.