8/29/2017 by Thomas Michael Posted in SAP

SAP Asset History Sheet Report

The SAP Asset History Sheet report (AHS) is the most powerful report available in the SAP Asset Accounting component. The report shows all asset activity (i.e., asset acquisitions, retirements, transfers, etc.) as well as asset balances (beginning acquisition cost, accumulated depreciation, net book value, etc.) in an easy-to-read roll-forward layout – which is why this report is so unique and useful. Most other reports on asset accounting in SAP’s fixed assets module show either transactions or asset balances – but not both.

Asset History Sheet Version

To run this report correctly, one must understand the unique selection screen of this report. Specifically, the screen includes a field called Asset History Sheet Version. It is critical to select the correct version to get accurate and reliable values from the report.

The AHS version controls not only the entire layout of the report (i.e., how many columns & rows, what values to show in what column, etc.) but also the values that appear (or are omitted) on your report.

SAP delivers several examples of this AHS Version – but that’s what they are, just examples and not meant for you to use in your production system. It is essential that you create your own AHS Version in the asset accounting configuration (transaction code OA79) to meet your company’s unique reporting requirements.

If you do not select the correct AHS Version when running the report (or select a version that has not been configured correctly), your report output will not be useful, reliable, or even intelligible. Also, if your own AHS version is not configured correctly, it will indicate this on the report output in the header (you will see the word ‘incomplete’ on top of your report – and so will your auditors).

Creating a custom AHS version is not a difficult thing to do, although it is a bit tedious. It takes about a day or two to design, configure, and test a new version. And, of course, you can (and should) have multiple versions for different reporting requirements (i.e., book vs. tax valuation or different valuation principles for different countries).

 

Asset History Sheet Report Enhancements

As good as this report is, however, it has a few drawbacks. For one, you can run this report only on a year-to-date basis. That makes it challenging to use the report to reconcile the asset sub-ledger with the general ledger (or you would have to run the report twice with different dates and then manually subtract one report from the other in Excel – ugh, who wants to do that?).

The other issue with the report is that you can’t run it for specific periods in already closed fiscal years (i.e., let’s say your auditor asks for this report for September of last year), but there’s a solution! We have developed an enhancement to the Asset History Sheet report that addresses these issues. With our report version, you can run it for any period (or range of periods) in open and closed fiscal years!

You can learn much more about this report in this previously recorded Webinar.

 

If you are interested in discussing our SAP Asset History Sheet report enhancement, please reach out to us to schedule a call. Also, please note that our enhancement is available for SAP ERP / ECC 6.0 only.

 

 

 


Author Photo

Thomas Michael has been involved in SAP consulting and development since 1993. As the CEO of the Michael Management Corporation he speaks and writes widely about SAP training and implementation issues. Tom has authored numerous books, articles and white papers covering a variety of topics. He is a regular speaker at national SAP conferences and other venues.
More Blogs by Thomas Michael:
happy birthday, mmc
Happy 20th Birthday, MMC That’s right, folks, this month we’re celebrating our 20th year in business – woohoo! While we look back at all the things we’ve achieved and lean forward to see all the things ...
a list of all sap transaction codes
Download all SAP transaction codes Our customer service team was just asked if we had an SAP transaction codes reference list…hmmm, that made me think a little. I have been in the SAP world for over 20 years now and I admit, ...
sap tables
How to download all SAP tables A few months ago, I wrote a blog about how to download all SAP transaction codes. We received a chat on our website from a student asking if we had a list of all SAP tcodes…and frankly, ...