q General Ledger & Controlling Processing Release 7 May 2015
Unit 15: Period End Close Unit 15: Period End Close Unit Objectives: 1. Review Manual Journals 2. Run the SAP to Hyperion Interface …… …… -1 -2 -3 -4 4 3 2 1
Unit 15 – Period End Close Review all Manual Journals Run SAP to Hyperion Interface To close the period for your site, a number of tasks are carried out to upload data from SAP to Hyperion and check the uploaded data for correctness …… …… -1 -2 -3 -4 4 3 2 1
Review Manual Journals GL GL FAGLL03 Unit 15 – Period End Close Local Review all Manual Journals A report listing all manual journals posted at each site must be reviewed and manually signed off by the Site Financial Controller each month Choose the variant MANUAL JNL REP to default the correct line layout Run SAP to Hyperion Interface & COGS Split
Unit 15 – Period End Close: Running the ‘FAGLL03’ Report 1. Enter FAGLL03 & press enter 2. Enter ‘G/L Account’ range and ‘Company Code’ 3. Select the ‘All Items’ option 4. Select ‘/MAN JNL’ as the ‘Layout’ option 5. Click on the ‘Free Selections’ Icon in order to add further values 1 2
Unit 15 – Period End Close: Running the ‘FAGLL03’ Report 6. Double click on any values you wish to include in the report. Double click again to de- select 7. Your selections will appear under ‘Dynamic selections’ section where you can specify their values. 8. Click on the ‘Save’ icon in order to proceed 8. Click on the ‘Execute’ option to submit your selections and run the report 9. The report will then appear. From here you can export it to Excel etc. 3 4 5
Unit 15 – Demonstration & Exercise The instructor will now carry out a demonstration of the following: 15.1.1 Run the Manual Journal Report Please refer to your exercise notes and complete the exercise
Unit 15 – Financial Consolidation in Kerry Group Consolidated Management Reporting is produced from Hyperion to meet internal reporting requirements Consolidated Statutory Reporting is produced from Hyperion to meet external reporting requirements Period End Year End
Unit 15 – Working Day 3: Hyperion Interface Commence CO Close Produce Reports Run Internal Order (Opex) Settlements Close FI Run Cost Centre Assessments Close CO Hyperion Interface Central
Unit 15 – Hyperion Mapping Process Maintenance Request Approve Request Execute Maintenance Request Requestor (BU, RCoE) Approver (RCoE) Maintenance (GCoE) Maintain SAP to Hyperion Mapping Tables Maintenance (GCoE) FI FI FI FI Centralised Hyperion Mapping Central
Unit 15 – Hyperion Mapping Tables Maintain SAP to Hyperion Mapping Tables Maintenance (GCoE) Maintain Hyperion Entity Mapping FI FI Maintain Hyperion Account Mapping SAP to Hyperion Mapping involves two distinct mapping tables: 1.Hyperion Entity Mapping for Company Codes & Profit Centres 2.Hyperion Account Mapping for Cost Centres & GL Accounts Central
Unit 15 – Hyperion Mapping Key Concepts GL Profit & Loss Expense Account Codes Mapping of GL Accounts & Cost Centres
You've reached the end of your free preview.
Want to read all 36 pages?
- Fall '16
- Revenue, SAP AG, HYPERION