SAP FICO Rescue: Your Guide to Solving Key FI/CO System Errors and Process Challenges
Atiq ur Rehman
SAP FICO | S/4hana | SAP System Analyst | SAP FICO Expert | x Manager Finance Information Systems | ERP | SAP Blogger
Blog#1 Asset Revaluation with Depreciation Write-Back
In the world of financial management, SAP FICO stands out as a powerful tool that helps businesses maintain accurate and efficient accounting processes. However, like any complex system, it’s not without its challenges. From configuration issues to unexpected errors during day-to-day operations, SAP FICO users often encounter problems that can disrupt workflows and affect business outcomes.
This blog series, SAP FICO Rescue: Your Guide to Solving Key FI/CO System Errors and Process Challenges, is designed to address those pain points head-on. Each post will explore specific issues that users might face within SAP FICO, offering practical solutions, tips, and best practices to overcome them. Whether you're dealing with reconciliation discrepancies, posting errors, or configuration headaches, this series will be your go-to resource for troubleshooting and optimizing your SAP FICO experience.
Let’s begin by tackling "Asset Revaluation with Depreciation Write-Back" process configuration requirement.
Blog#1 Asset Revaluation with Depreciation Write-Back
Asset Revaluation (Appreciation) Configuration
?
Business Requirement:
?
Revaluation (Appreciation) is required to be run at 30.06.2024 and as per requirement previous Acc Depreciation should be reversed (Write Back- Acc Dep will be Zero and APC will be Equal to New Revalued Amount on 30.06.2024 for all revalued Assets) and No depreciation should be calculated on additional revalued amount in June 2024 (30.06.2024) but Depreciation will start from July-2024.
Business Scenario with Required Financial Entries:
Configuration Steps:
?
Determine Depreciation Areas (OABW)
?
In this step, please activate checks for both APC and Depreciation
Financial Accounting > Asset Accounting > Special Valuations > Revaluation of Fixed Assets > Revaluation for the Balance Sheet > Determine Depreciation Areas
Create New Transaction Type for Revaluation (AO73)
?
Financial Accounting > Asset Accounting > Transactions > Acquisitions > Define Transaction Types for Acquisitions
A6 transaction Group is helpful because “Period Control Group” is revaluation and so we can use separate “Maintain Period Control” for Revaluation
GO to AO73 > Double Click New Transaction Created > Double Click Transaction Type Grp “A6”
Maintain Period Control Methods (AFAMP)
?
We will be using Period Control 11
Financial Accounting > Asset Accounting > Depreciation > Valuation Methods > Depreciation Key > Calculation Methods > Maintain Period Control Methods
Define Calendar Assignments (OAVH)
?
Financial Accounting > Asset Accounting > Depreciation > Valuation Methods > Period Control > Define Calendar Assignments
Please ensure calendar setting is as follows for “Period Control 11”
Limit Transaction Type (OAXJ)
?
In this step ensure to Limit transaction type to the relevant depreciation areas.
Select Transaction Type and double click on Depreciation area specification and create new entries for your relevant Depreciation Areas
领英推荐
Define Revaluation Measures (AUFW)
?
Financial Accounting > Asset Accounting > Special Valuations > Revaluation of Fixed Assets > Revaluation for the Balance Sheet > Define Revaluation Measures
Specify Date on which valuation is to be executed and include all relevant depreciation areas
Create New Entry
Click on Depreciation Areas
Click on New Entry to add Dep Area 31 as well
Assign G/L Accounts for Revaluation Reserves (AO90)
?
Financial Accounting > Asset Accounting > Integration with General Ledger Accounting > Assign G/L Accounts
?
Asset Revaluation Run (AR29N)
?
Prerequisites for AR29N
?
In order to run AR29N please ensure above configuration is complete and ensure activate “Negative Values Allowed” check in asset Master, can be achieved through LSMW Upload
?
AS02 > Depreciation Area Tab > Double Click on Dep Key > Under Additional Specification > Neg. Vals. Allowed
New Valuation on An Asset – Single Asset AR29N
?
Do Not Enter “Evaluation Group Number” as “1” as in multiple assets.
New Valuation Multiple Assets AR29N
?
Excel Upload Template for New Valuation Multiple Assets AR29N
?
Note: *Remove Header while uploading file and ensure to convert Data into Text format in Excel
**Convert all Data into TEXT except “Value Column” and enter amount without “,” (not like 120,000) but 120000.
Enter “Evaluation Group Number” as “1” because its mandatory field in multiple assets.
Upload in “TEST RUN” and validate values first.
Sequence of Revaluation Activities
Thank You for reading please like and share with your peers to spread the SAP FICO knowledge.
--
1 天前Thanks for sharing ?? ,i managed to perform the AR29N posting by referring to your Article.
Solutions Specialist at Fulcrum GT
1 天前Very informative, thanks for sharing! How do you handle the transaction types that are automatically generated when creating the revaluation measure?
Consultor SAP FI-CO, PS, CPM.
2 周Thank you so much Atik! Customizing of transaction type group solved a very big issue!
SAP S/4HANA Financials Architect
1 个月This is accurate stuff but asset revaluations are very infrequently required. They're usually triggered by mergers or acquisitions... they're not a routine process. If they were, the configuration wouldn't be date driven because there's no way to promptly roll this out every month. Secondly, the big trick is to ensure that those assets that aren't changing in value have the same go-forward depreciation as they did previously.
Confidential| SAP FICO Consultant, ECC & S4/HANA||Ex-TCSer|Ex-Accenture||
1 个月Very informative??