You run the Reports Schedule Of Fixed Assets and Financial Statements and get different values for Fixed Assets.
You expect that the same values are shown in both reports.
Reproducing the Issue
- Go to the Fixed Assets Work Center
- Run the Report Schedule of Fixed Assets
The result shows an amount of XXX
- Go to the General Ledger Work Center
- Run the report Financial Statements
The value for Fixed Assets is YYY
The reports select data from different sources.
While the report Financial Statements is selecting data from the consolidation accounts, the report Schedule of Fixed Assets selects the data based on the values in the actual Fixed Assets.
You purchase and create a new Fixed Asset with a Supplier Invoice. This creates a posting to the respective Consolidation Accounts and will be reflected in the report Financial Statements with value XXX.
Afterwards you deactivate the same Fixed Assset in the Work Center Fixeds Assets. There is no posting created to the respective Consolidation Accounts for this Business Transaction.
The report Schedule of Fixed Assets shows the amount of YYY.
This is the standard System Behaviour.
In regards to the example above you could either remove the Deactivation Date in the respective Fixed Asset or Scrap it with a Manual Posting.
If you run the Reports afterwards you will get the same value for Fixed Assets in both reports.
KBA , SRD-FIN-ERM , Travel and Expense Management , How To