run asset acquisitions report - university of cincinnati · web viewselect accounting financial...

Work InstructionFunctional Area: Asset Accounting Run Asset Acquisitions Report

Purpose

Use this procedure to display all acquisition documents in a fiscal year per asset.

Trigger

Perform this procedure when you want to show all asset acquisitions for a cost center(s), posting date, etc.

Prerequisites

None

Menu Path

Use the following menu path to begin this transaction:

Select Accounting Financial Accounting Fixed Assets Information System Reports on Asset Accounting Day-to-Day Activities International S_ALR_87012050 – Asset Acquisitions to go to the Asset Acquisitions screen.

Transaction Code

S_ALR_87012050

Business Process Information

The report displays all acquisition documents in a fiscal year per asset. The following is displayed for each document:

Acquired APC Acquired quantity

Planned ordinary and special depreciation for the acquisition

Helpful Hints

The R/O/C column in the field description tables below defines whether the field is required (R), optional (O), or conditional (C).

On certain screens you may have to scroll to view some data entry fields. For the report date on which the evaluation should take place, you can set this parameter

using the selection variable 'FIAA_REPORTING_DATE' Enter the date as a calendar date. If necessary, the system converts the date to a fiscal year,

according to the fiscal year version in use for the given company code. The system then uses this date to determine the fiscal year for which evaluation should take place. The following situations are possible:

The report date is in the past or in the current fiscal year:

In this case, you can request the report for the last day of any period, providing that period is still open. If the previous fiscal year is already closed, you can only run reports for the last day of that year. For evaluations in the past, the system uses the report date to determine whether it should access the online


database or an archive file.

The report date is in a future fiscal year:

In this case, you can only run a report for the last day of the fiscal year concerned.

Note

You should also consider the following in regard to the report date:

The current fiscal year is always the year which was opened during the last fiscal year change.

In order to make sure values are identical at the end of the old fiscal year and at the beginning of the new fiscal year, the system resets all values (transactions, depreciation) in the fiscal year when you request a report for the first day of the fiscal year; therefore only cumulative values are displayed.

You can only request a report based on depreciation posted in financial accounting with the last day of the last period in which depreciation was posted (or a following period) in the relevant fiscal year as the report date.


Procedure

1. Start the transaction using the menu path or transaction code.

Asset Acquisitions

2. Click to display all fields.

9/19/2017Ver:

AA_S_ALR_87012050_RunAssetAcqRept_0_FinProcAssets.udc© University of Cincinnati 3/13


Asset Acquisitions (2)

3. As required, complete/review the following fields:

Field R/O/C Description

Company code Required Organizational unit within Financial Accounting

Example:UC

Asset number Optional A unique identifier assigned to every asset in SAP

Example:21000125

Sub-number Optional Number used to track funding sources of an asset

Example:0

9/19/2017Ver:




Asset class Optional Each asset is categorized in an asset class which determines their useful life and depreciation schedule

Example:49001

Business area Optional Business Area is the campus to which the cost center is assigned

Example:U

Cost center Optional An area of responsibility for capturing costs

Example:1999999999

Plant Optional A place where materials are produced, or goods and services are provided

Example:UC

Location Optional The physical site where the asset is stored

Example:

This field is not used at this time.

Asset super number Optional Several assets can be assigned to one asset super number (for example, several WBS elements for one building)

Example:4870

Worklist Optional A group of assets that have been generated and saved; This list is available for use during further processing of these assets

Example:Worklist 123

9/19/2017Ver:




Report date Required Transaction date or planning date

Example:06/30/2005

Depreciation area Required Represents methods to depreciate and retire assets; Examples include book, tax, and cost accounting

Example:01

Sort version Required Code used to determine the sort and summation levels of the displayed data

Example:0003

Translation method Optional Method of translating asset values to other currencies

Example:

This field is not being used at this time.

4.Select to the left of List assets , or group totals only.

9/19/2017Ver:




5.Select to the left of Use ALV grid to display data in a tabular format.

This is a continuation of the previous screen after scrolling.

This provides a method for the user to download report data to a spreadsheet or a word document.


9/19/2017Ver:




Display variant Optional Indicates to the system to display the variant

Example:

This field is not being used at this time.

Balance sheet account Optional Indicator identifying if the new account is a balance sheet account; Balance sheet items include assets, liabilities, and equity accounts

Example:191001

Capitalization date Optional The value date of an asset; The system enters the asset value date of the first posting that results in the capitalization of the asset on that date

Example:01/31/2005

Transaction type Optional Computerized task or set of tasks performed using SAP; (Transactions allow associates to select, display, search for, and change records in the database.)

Example:100

Acquisition Transaction types are from 100 to 199.

Posting date Optional The date on which a transaction in SAP will be posted to the appropriate accounts; SAP will default this field to be the current date, but changes are allowed; For items to be posted in a future or past period, you must enter the posting date

Example:01/31/2005

9/19/2017Ver:






Additional heading Optional User defined custom header that will be presented on the report

Example:My Asset Acquisitions

This is a continuation of the previous screen after scrolling.

8.Deselect to the left of Print microfiche line.

This feature is not being implemented at UC.

9/19/2017Ver:



9.Click .


10. Review the displayed information.

11. Select List Export Local file... F9 to send Excel spreadsheet by e-mail to the department.

9/19/2017Ver:



Save list in file...

12.Select to the left of Spreadsheet.

13.Click .




Directory Required Name of Directory

Example:C:\Documents and Settings\SLuput\SapWorkDir\

9/19/2017Ver:




File Name Required Name of Excel file

Example:Asset Acquisitions.xls

15. Click .

16.Click .

17.Click until you return to the SAP Easy Access screen.

18. You have completed this transaction.

9/19/2017Ver:



Result

You have created the Asset Acquisition report and downloaded to Excel.

Comments

None

9/19/2017Ver:
