Showing posts with label SAP FI. Show all posts
Showing posts with label SAP FI. Show all posts

Saturday, 2 February 2013

Asset Transactions - Accounting Entries

Asset Acquisition: F-90 - With Vendor 
Dr. Fixed Asset – Acquisition Cost 
Cr. Vendor (Accounts payable) 
Posting date of the document will be copied into the asset master as the capitalization date. The depreciation start date of each depreciation area will also be determined and updated in the depreciation area data tab page. Asset acquisition posting could also be done without PO from the MM module. Posting could be done in FI posting only. 

Asset Disposal – Sales to a Customer: F-92 
With Customer Supposed an asset with historical cost $1,000 and accumulated depreciation of $100 is being sold to a customer at a price of $1,100, the posting entries will be as follows: 
Dr. Customer account (A/R) 1,100 
Cr. Revenue for asset disposal 1,100 
Cr. Fixed asset – acquisition cost 1,000 
Dr. Accumulated depreciation 100 
Dr. Clearing account for asset disposal 1,100 
Cr. Gain/loss of fixed asset disposal 200 
The posting date of the retirement posting will also be updated into the field "deactivation date" in the asset master as the retirement date. 

Asset Disposal – Scrap without Revenue ABAVN 
Asset Retirement by Scrapping Instead of selling, an asset could be disposed as a scrap. In this case, no revenue is expected and a loss will be realized in the P&L if the fixed asset being scrapped still carries a net book value. For the same asset with historical cost $1,000 and accumulated depreciation of $100, the posting of the scrapping will be as follows: 
Cr. Fixed asset – acquisition cost 1,000 
Dr. Accumulated depreciation 100 
Cr. Gain/loss of fixed asset disposal 900 

Asset Transfer within a Company  
Reclassification The NBV of an existing asset master record could be transferred to another asset within the same company. The transaction could be used in the following scenarios: Reclassify an existing asset to a new class or to correct an error Transfer an asset to a new one with the same class. This may be necessary to execute the change of the remaining useful life of an asset but still spread the net book value evenly throughout the remaining life without allowing the system to catch up the postings of the missing or extra depreciation of the past periods For an asset with historical cost $1,000 and accumulated depreciation of $100, the posting of the intra-company transfer posting will be follows: 
Cr. Fix asset – acquisition cost (old asset) 1,000
Dr. Accumulated depreciation (old asset) 100 
Dr. Fix asset – acquisition cost (new asset) 1,000 
Cr. Accumulated depreciation (new asset) 100 
The old asset being transferred will become a retired asset and the transfer posting date will be updated as the retirement date in the asset master record. For the new receiving asset, the transfer will be the same as if it is being acquired. The transfer posting date will be used as the capitalization date. 

Month End Processing – Depreciation Run AFAB 
Dr. Depreciation expense 
Cr. Accumulated depreciation 
Note that the above posting to G/L will be done in a summary level by G/L accounts and cost center levels because the depreciation expense has to be charged to cost center in CO. However, the detailed depreciation amount of each asset will also be stored in Asset Accounting such that each unique asset master record will also have its unique posted depreciation amount. Besides, after each depreciation run, the system will issue a report which list out the depreciation posting amount of each individual assets as a record. This is advised that this report should be kept as an additional audit trail. 


Asset Under Construction (AUC) Config & Process Steps: Internal Order as Investment Measure: 
Post the amounts to IO - FB01
Dr. Material supplied to Asset (Expenditure)
Cr. Cash account 
Settle the amounts to AuC from IO (Prcg type: Automatic) - KO88
Dr. Asset Under Construction account
Cr. Contra Capitalized 
Settle the amounts to Main Asset from AuC (Prcg type: Full) - KO88 
Dr. Final Asset account 
Cr. Asset Under Construction account 

Asset - Legacy Migration Guidelines

Asset Migration should be handled carefully, as real time integration does not exist with FI module. Generally, assets are classified into 2 -

Assets acquired/capitalized in the previous year
Assets acquired/capitalized in the current year
The latter is generally uploaded at item / transaction level, while the former at balance level.
AUC / CIP should be uploaded at transaction level. Else, settlement will not be possible
Pre-requisites:

Asset master data configurations should have been completed like asset classes, depreciation area, depreciation key etc
Take over date (Transfer date) should be configured. 
The date is of importance from depreciation perspective.
It is NOT the actual data entry date. It represents the value date.
There are 2 types of take over date - End of last closed FY or during FY (Mid year take over)
Implementation:
Asset migration t-codes like AS91/92/93/94 and AS81/82/83/84 will be used extensively
There are two programs that can be utilized to automatically process legacy assets. They are RAALTD01 and RAALTD11.
RAALTD01: Uses dialog programming and hence will be slow, but predictable
RAALTD11: Users direct input and hence will be faster. Most of the implementation uses this option
BDC recording of AS91 t-code: This is done for current year acquisition and AuC Assets. The transaction level data are entered by clicking the 'Transactions' button in the application tool bar

Mandatory Fields:
All mandatory fields as defined in the screen layout rule - Asset class, cost center, description, Plant, quantity, depreciation key, useful life etc
Acquisition amount, Accumulated depreciation value till PY, Accumulated depreciation value in the CY till take over date for all depreciation areas.

From FI View
The migration programs will create Asset data only and no FI documents are generated.
FI postings are to be manually created using t-code OASV or ABF1
Former will be used normally, while latter will be used for uploading asset values in multiple currencies
The asset GL account properties should be changed to 'Non-reconciliation' account ('Set/Reset reconciliation account' option in IMG screen). The same should be changed after migration
GL accounts for Acquisition Production Cost( APC), accumulated depreciation GL accounts will be posted manually. The difference (Net Book Value) gets posted to the conversion account created for assets. This is later reverse posted during TB upload
After migration, asset values at Current book value should match with the FI values

SAP FI Assets: Configuration of Asset Accounting

Step 1 – COPY CHART OF DEPECIATION
T Code: EC08
IMG-->Financial Accounting ----> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organizational Structures and Master Data --> Copy reference chart of depreciation/depreciation area

Step 2 – ASSIGN COMPANY CODE TO CHART OF DEPRECIATION
T Code: OAOB
IMG --> Financial Accounting --> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organizational Structures and Master Data --> Assign chart of depreciation to company code

Step 3 – ASSIGN FINANCIAL STATEMENT VERSION TO EVERY DEPRECIATION AREAT Code: OAYN
IMG -->Financial Accounting --> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organizational Structures and Master Data --> Specify statemement version for asset reports

Step 4 – IDENTIFY YOUR ASSET CLASSES

Step 5 – IDENTIFY YOUR ACCOUNT DETERMINATION & SCREEN LAYOUT FOR YOUR ASSET CLASSESSPRO – IMG --> Financial Accounting --> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organizational Structures and Master Data --> Asset Classes --> Specify required entries for asset master data

Step 6 – IDENTIFY YOUR GL ACCOUNTS FOR YOUR ASSET CLASSES

Step 7 - DEFINE YOUR NUMBER RANGET Code: AS08
IMG --> Financial Accounting --> Asset Accounting --> Organizational Structures --> Asset Classes --> Define number range interval

Step 8 - DETERMINE DEPRECIATION AREAS IN ASSET CLASSES AND SCREEN LAYOUTT Code: A021
IMG --> Financial Accounting --> Asset Accounting --> Master Data --> Screen Layout --> Define screen layout for asset depreciation areas
T Code: OAYZ
IMG --> Financial Accounting --> Asset Accounting --> Valuation --> Determine depreciation areas in the asset class

Step 9 – GENERATE ASSET CLASSES FROM GL ACCOUNTST Code: ANKL
IMG – Financial Accounting --> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organizational Structures and Master Data --> Asset Classes --> Generate Asset Classes from G/L Accounts

Step 10 – COMPLETE DATA FOR ASSET CLASSES SETTING REQUIRED ENTRY FIELDSSPRO – IMG --> Financial Accounting --> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organization Structures and Master Data --> Asset Classes --> Specify requires entries for asset master data
T Code: OAYZ
IMG --> Financial Accounting --> asset Accounting --> FI-AA Implementation Guide (Simplified Version) Organizational Structures and Master Data --> Asset Classes --> Enter default values in asset classes
T Code: AO90
IMG --> Financial Accounting --> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organizational Structures and Master Data --> Assign additional G/L accounts for transactions/depreciation

Step 11 – SETTING UP SPECIAL ASSET CLASSEST Code: OAYK
IMG --> Financial Accounting --> Asset Accounting --> Valuation --> Specify max amount for LVA + asset classes --> Specify amount for low value assets
T Code: OAY2
IMG --> Financial Accounting --> Asset Accounting --> Valuation --> Specify max amount for LVA + asset classes --> Specify LVA asset classes

Step 12 – SPECIFY INTERVALS AND POSTING RULET Code: OAYR
IMG --> Financial Accounting --> Asset Accounting --> FI-AA Implementation Guide (Simplified Version) --> Organizational Structures and Master Data --> Specify intervals and posting rules