1 / 28

Tom Michael Michael Management Corporation

Tom Michael Michael Management Corporation. Advanced Fixed Asset Reporting. Overview. Advanced reporting features Mid-Quarter Alert Asset History Sheet Report Secret Reports Other Reporting Tools Reporting Cheat Sheet. Advanced Reporting Features. Selection criteria upload

guido
Download Presentation

Tom Michael Michael Management Corporation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Tom MichaelMichael Management Corporation Advanced Fixed Asset Reporting

  2. Overview • Advanced reporting features • Mid-Quarter Alert • Asset History Sheet Report • Secret Reports • Other Reporting Tools • Reporting Cheat Sheet

  3. Advanced Reporting Features • Selection criteria upload • Adding fields via ALV catalog • Excel download

  4. Selection Criteria Upload I Available in all standard AA reports

  5. Selection Criteria Upload II Upload selection criteria

  6. Selection Criteria Upload III Upload selection criteria

  7. Selection Criteria Upload IV Selection criteria, i.e. asset numbers, cost centers, etc. Save as *.txt file

  8. Selection Criteria Upload V Selection criteria uploaded

  9. ALV Adding Fields to Report I

  10. Adding Fields to Report II Select hidden fields to be added and specify location of fields

  11. Adding Fields to Report III Can’t find what you are looking for? Add fields to the field catalog! Read OSS note # 335065

  12. Exceldownload Adding Fields to Report IV No coding required!

  13. Excel Download I Raw data only

  14. Excel Download II 1 row per data record!

  15. Mid-Quarter Alert I Standard selection screen

  16. Mid-Quarter Alert II Mid-Quarter?

  17. Mid-Quarter Alert III Transaction OAVI – set Statistics flag for sort version

  18. Mid-Quarter Alert IV Acquisition percentages by quarter!

  19. Acquisition vs. transfer amounts Version 0001 – according to European GAAP - incomplete! What happened to AuC? Asset History Sheet I

  20. Asset History Sheet II Configuration

  21. MSA custom history sheet version – complete! New acquisition amount New AuC column shows amounts capitalized/settled in/out of CIP Asset History Sheet III

  22. Secret Reports I RAANALYZE01 – Not on reporting tree! Start via SA38

  23. Secret Reports II Report will list all cost centers/internal orders that are blocked for direct postings yet have depreciation planned.

  24. Secret Reports III RAAEND02 – not on reporting tree, start via SA38 Report will show all changes to asset class settings w/ change date, user, before/after value, etc.

  25. Other Reporting Tools • ABAP Query • very powerful, drag-and-drop, no coding required • Simulation Versions • What-if scenarios • Sort Versions • Sort, sub-total, off-set, statistics • Translation Versions • Currency translation

  26. Reporting Cheat Sheet

  27. Q&A • Comments • Questions Download this presentation at: www.michaelmanagement.com

More Related