SAP Knowledge Base Article - Public

3204193 - Missing Fixed Assets in the Fixed Assets - Line Items Report

Symptom

The Fixed Assets - Line Items report displays all the fixed asset transactions with posting date, source document type, journal entry ID, debit or credit posting, and amount, for each fixed asset and fixed asset class.

You have successfully capitalized fixed assets in the system. However, you have observed that the assets are missing when you execute the Fixed Assets - Line Items report.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Fixed Assets work center.
  2. Click on Fixed Assets view.
  3. You see the asset is capitalized. 
  4. Open the Asset and go to Values tab - Journal.
  5. Here the Journal entries do exist.

Now, 

  1. Go to Reports view. 
  2. Execute the Fixed Assets - Line Items report.
  3. Search for the Fixed Asset ID. 
  4. You cannot find the asset in this report. 

Cause

The Fixed Assets - Line Items report shows fixed assets based on the validity of the Org Assignement as on today. The assets will not display if the org assignment start date is in the future or if the org assignment is no longer valid.

You can see org assignment validity under master data.

  1. Go to Fixed Assets work center.
  2. Click on Fixed Assets view.
  3. Open the Fixed Asset.
  4. Go to Master Data tab.
  5. Under Basic Data you can find All Assignments Intervals.
  6. If the Start Date is in the future, or the Valid To is in the past, then you cannot see the asset in the Fixed Assets - Line Items - report.

Resolution

You can retrieve data for these types of assets from Schedule of Fixed Assets report, Fixed Assets - Trial Balance report and Depreciation report which don't have this reliance on the org assignment validity.

Keywords

Fixed Assets - Line Items - Report, Missing Fixed asset in the Fixed Assets - Line Items report, Missing assets in the report , KBA , fixed assets - line items - report , missing assets in the report , missing fixed asset fixed assets lineite , SRD-FIN-FA , Fixed Assets , Problem

Product

SAP Business ByDesign all versions