280 likes | 448 Vues
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
E N D
Tom MichaelMichael 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 • Adding fields via ALV catalog • Excel download
Selection Criteria Upload I Available in all standard AA reports
Selection Criteria Upload II Upload selection criteria
Selection Criteria Upload III Upload selection criteria
Selection Criteria Upload IV Selection criteria, i.e. asset numbers, cost centers, etc. Save as *.txt file
Selection Criteria Upload V Selection criteria uploaded
ALV Adding Fields to Report I
Adding Fields to Report II Select hidden fields to be added and specify location of fields
Adding Fields to Report III Can’t find what you are looking for? Add fields to the field catalog! Read OSS note # 335065
Exceldownload Adding Fields to Report IV No coding required!
Excel Download I Raw data only
Excel Download II 1 row per data record!
Mid-Quarter Alert I Standard selection screen
Mid-Quarter Alert II Mid-Quarter?
Mid-Quarter Alert III Transaction OAVI – set Statistics flag for sort version
Mid-Quarter Alert IV Acquisition percentages by quarter!
Acquisition vs. transfer amounts Version 0001 – according to European GAAP - incomplete! What happened to AuC? Asset History Sheet I
Asset History Sheet II Configuration
MSA custom history sheet version – complete! New acquisition amount New AuC column shows amounts capitalized/settled in/out of CIP Asset History Sheet III
Secret Reports I RAANALYZE01 – Not on reporting tree! Start via SA38
Secret Reports II Report will list all cost centers/internal orders that are blocked for direct postings yet have depreciation planned.
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.
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
Q&A • Comments • Questions Download this presentation at: www.michaelmanagement.com