Home

AARO Training Manual for End-Users 2008-08

Contents

1. 4010 Cost of Goods Sold external 4060 Cost of Goods Sold internal 4080 Discounts received 6 208 4099 Costs of Goods Sold 6 208 4910 Change in inventory 6 208 4999 Costs of Materials 12416 4GP Gross Profit 63 1 063 1594 2720 7579 e Kea Fee 5010 Office expenses 5110 Property expenses 5210 Leased Equipment 5310 Energy 5410 Supplies 5510 Maintenance 2 Fein Tranamari E xl 2008 04 15 12 45 AARO AARO 13 Version 10 0 2 4 Reconciliation Report This section describes the use layout and content of a reconciliation report A reconciliation report is a compilation of the different totals in the input forms It is created to reconcile the financial information entered for a period in the Input window The report is used to secure that the entered information is correct If not the difference is displayed in the report 2 4 1 Report Contents The recon report summarizes the differences found in reported amounts If all financial data is entered correctly then the Reconciliation report will be empty Only one period is displayed at a time The report includes possible subcategories such as divisions etc A reconciliation report can be extracted at any time during the reporting flow 2 4 2 Report Layout The report is built up symmetrically To the left the first comparison value is displayed and to the rig
2. 2 Business Unit 3 Business Grea E 4 Customer E sS Market O 2 5 Complete The input window contains a function that should be used when the reporting for a period is done This function reports a selected package for a period as completed and closes the form in the package for further reporting The user reports a package as completed by clicking the Complete button at the top of the Input window The system administrator can then view in Validations Check Status which companies have reported the period as completed A package of forms cannot be reported as completed as long as there are any differences left between the reconciliation accounts 1n the reported financial information A reconciliation is started when the user clicks on the Complete button and if no differences are found the period and package are reported as completed for that company A confirmation note which says AARO 15 Version 10 0 Period complete is displayed on the list at the bottom of the window Period complete An information box is displayed if there still excist reconciliation errors The errors must be corrected before the period can be reported as completed x i Cannot complete the currently loaded Package Level in period 08034 due to reconciliation errors View the errors Ves Cancel 2 6 2 6 1 Step by step instruction Input Enter information in the input form Follow the instructions below 1 Select Input
3. 8 4 ABS Retrieve Formulas 8 4 1 Define a template After you have pasted information or by any other available source copied information into the excel template you can begin to create layouts for your own purposes The report content is entirely defined by the user The report layout and data to be included is defined in the excel template Note Formula parameters are explained briefly in the text below For more detailed descriptions please see the section Formula Parameters at the end of this chapter Follow the instructions below 1 Type heading names in the worksheet Type one heading for each piece of information you want to use 1n matrix such as company code period and currency 2 Type actual values for chosen categories for example under or beside the headings In the exercise chosen categories are Company PCHAL Period 0107A Currency EUR and Code IS3100 etc E4 Microsoft Excel Training in ABS Excel Retrieve_P xls File Edit View Insert Format Tools Data Window 465 Help Deb eleavl sae E Agli 2 rev B2 AB5GetNamet Company B3 Aloo BE Allesta 5A Period 0107A IS PCHAL Currency EUR 2 3 J meson l G Income Statement k 153100 z Net sales WMes EE 53150 10 11 12 ing i IS IS3300 13 ing Ji IS S3350 14 16 153500 17 York pert by the comp tor own use capitalized ISS600 18 IS3700 19 153800 20 153900 21 154000 22 154200 23 24 25 68
4. AARO Training Manual for End Users 2008 08 15 L GENERAL INFORMATION ABOUT AARO eessen 2 1 1 THE AARO MENU esesssescssesesesesccoccesesesoesesesesesesosseoesesesesoeses 2 1 2 INFORMATION AND HELP ccsscccssccsssccscsccssccssccccsscccssceees 3 1 3 THE MENU STRUCTURE OF AARO ccccccccccccccccccccecess 4 1 4 THE WINDOW LAYOUT IN AARO ccccssscccsscccssccscsccssceees 5 1 5 STARTING INSTRUCTIONS FOR AARO cccccccccccccecccces 7 1 6 THE HOME SCREEN cccccccccccccccccccccccccccccccccccccccccccccccccccess 8 2 Manual data CAY ares aicsecec a pest raat connec ENEE RRN ENEA ERER 10 2 1 OVERVIEW vo soe ccsacewscecavacseadecccecacesacucacsasesscasssanessdecscecaveasececeds 10 2 2 SHORT GUIDE TO THE FINANCIAL REPORTING PROCESS 11 2 3 DESCRIPTION OF THE INPUT WINDOW ccccccccccccccscccees 13 2 4 RECONCILIATION REPORT ccccccccccccscccccccccccccccccccccccees 14 2 5 COPLET oara 15 2 6 STEP BY STEP INSTRUCTION INPUT ccccossccssscccssccsscoeees 16 3 Excel Input and Send cccccccccseeeeeeeeeseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 19 3 1 THE EXCEL ADD IN ssesesesesescscesesesescscsesesesescsoesesesesesoeseo 19 3 2 EXCEL INPUT FORMS cccccccccscsccccccccscccccccccccccccccccscseces 21 3 3 ABS SEND FORMULAS cccccccscccccscccccsccccsccccsccccccssccceces 22 4 The analysis tool Drill down ccc ceeeeeeeeeeeeeseeeeessseeeessesseeeeeeees 25 4 1
5. Currency heg M EUR Frofit Center hs K No help available Period B Formula result 0 Period The period from which data is to be retrieved Code The account from which data is to be received Currency AcT Trnsl AccStd The currency that the report figures should be displayed in Optionally followed by a backslash and an accounting type and optionally followed by another backslash and a currency translation code and optionally followed by yet another backslash and an accounting standard a sum of accounting types these options are meaningful only if your AARO system is configured to work with multiple accounting types accounting standards and or multiple currency translations and even then these options can be left out in which case you get the figure for the default accounting type and the default currency translation Co The company from which data is to be received Use the company code Dimensions The specific dimension value such as Profit Center Product Customer Business Unit etc for which data is to be retrieved Dimensions available vary between AARO installations 6 Type the parameter value or click a cell in the worksheet from where the parameter value is to be retrieved that cell then becomes referenced in the ABS Retrieve dialogue box 7 Define whether the cell reference should be locked or not You can enter a dollar sign in front of the column letter to lock t
6. The Company for which data is to be received Use the company code The legal group for which data is to be received Used if you want to separate different types of transaction for example Input or JV 60 Version 10 0 ABS Retrieve Oper The following parameters are used in ABSRetrieveOper AB SRetrieveOper Period ify o107 4 zs Code a3 s 153100 Currency seg s EUR Profit Center Jas s No help available Period B Formula result 0 Period The period from which data is to be retrieved Code The account from which data is to be received Currency AcT Trnsl AccStd The currency that the report figures should be displayed in Optionally followed by a backslash and an accounting type and optionally followed by another backslash and a currency translation code and optionally followed by yet another backslash and an accounting standard a sum of accounting types these options are meaningful only if your AARO system is configured to work with multiple accounting types accounting standards and or multiple currency translations and even then these options can be left out in which case you get the figure for the default accounting type and the default currency translation Co The company from which data is to be received Use the company code Dimensions The specific dimension value such as Profit Center Product Customer Business Unit etc for which data is to be retrieved Dime
7. Athens5A P LEISURE LEISURE E EUR 100 TE COPENHAGEN COPENHAGEN Copenhagen alin MEDIA DKK 500 104 df GOTHENBURG 2 FINANC C f Hees COPENHAGEN Copenhagen i FINANCE FINANCE a 1 ae 1 an ABR PARENT Tiea Sera SS ES s _HOLD 4 WC_LASSETS AIC_LIAB AIC_REVENUE 2008 04 15 10 04 AARO The Match items window consists of two panes The left pane contains a tree structure that displays the companies which are allowed to report financial data on and the right pane consist of a working space 5 2 1 The tree structure The tree structure in the left pane displays the companies allowed to report on 1 e reporting companies for the selected period 5 2 2 The workspace At the top of the workspace the complete name of the reporting company the period and currency are displayed Valid forms in the package are displayed as tabs at the bottom of the workspace Before any information can be entered in a form a period and a package must be selected and a reporting company be selected in the tree The available periods and packages are displayed in drop down lists The counter companies for which information has been entered and any sub dimension details in case the particular form uses them are displayed as rows in the form 2 3 The match report A match report is created to match inter company transactions and to display possible differences between companies in a group The content of t
8. FLOW El SALES Sales Specification AARO 10 Version 10 0 2 2 1 1 1 K2 1 3 2 2d 2 2 2 3 3 4 1 4 4 1 5 5 1 Short guide to the financial reporting process Select Input from the Data Entry menu Select the reporting period and your company Open up an input package in the tree structure by clicking the boxed sign in front of it Select an input form in the package Click the Load button to load the input form Alternatively you can double click the form name Report the financial information in the form White cells are open for editing The operational input forms are often reported on sub dimensions such as per market customer product business unit division etc The detail level has been decided by the system administrator for each form Sub dimension values can be added to the input form by clicking the Add Column button The legal input forms are reported on company total level and no sub dimensions are therefore needed Click the Save button when you wish to save the information you have entered Possibility to comment input reporting There is a functionality to comment input data The comment may be mandatory given certain rules that are maintained by the administrator The comments are added per input grid cell by double clicking the cell and entering the comment The comments can then be viewed from the Input screen itself or via reports run from Drill Down see below It is also
9. ID C Adjustment Impact OB accounts z Ei f ID Date E Ivf Ascending Customer Product Business Unit Business Area Market F F F TF F Cancel AARO 46 Version 10 0 View Table AARO Data Entry Validations Reports Help a a a Load Save Save as Print Reports Period 07124 Ope DEE 1 255 1 263 1 271 0712A EUR 3 3555 9 4239 9 4755 07124 GBP O Tael 135254 120006 0712A SEF 1 1 1 OFT 24 USO 6 38 b 4712 6 4675 Period Currency 7 1 View table Reporting companies and translation rates valid for a period can be monitored in the View Table window This is only a monitoring tool 7 1 1 Rates The option rates are displayed for a selected period currency opening rate rate on the first day of the period average rate closing rate rate on the last day of the period 7 1 2 Companies The displayed option of a company for a selected period company company currency translation type method used to translate to group currency tax local tax 7 2 Step by step instructions View table Follow the instructions below 1 On the View Period Companies Rates menu select View table ma Select a period 3 Select Period Rates or Period Companies in the left hand pane 4 Click the Load button AARO 47 Version 10 0 10 0 Excel Drilldown and Retrieve The AARO Excel Add In allows you to fetch information from the AARO database to Microsoft Excel T
10. PCHAL Alesta No help available Code Formula result Allesta OK Cancel Type Either the word COMPANY or the name of a dimension in the system such as e g Profit Center Market Customer or Business Unit what is available depends entirely on the specific AARO installation Be sure to spell the dimension name exactly as it is defined Code Code of either a company or a dimension value the description of which is to be retrieved AARO 59 Version 10 0 ABS Retrieve Legal The following parameters are used in ABSRetrieveLegal ABSRetrievelegal Period 01074 J o1078 Code Pesia OOOO e ar Currency Pee SEK Company Peca 0 e a Group SCaGroup 7 SC AGrOUp No help available Period Formula result 0 Period Code Currency AcctType Translation Company Group Legal Type AARO The period from which data is to be retrieved The account from which data is to be received The currency that the report figures should be displayed in Optionally followed by a backslash and an accounting type and optionally followed by another backslash and a currency translation code these options are meaningful only if your AARO system is configured to work with multiple accounting types and or multiple currency translations and even then these options can be left out in which case you get the figure for the default accounting type and the default currency translation
11. Version 10 0 Other parts of the application let you mix capital and lower case letters freely For example the descriptions of accounts periods and companies allow a mixture capital and lower case letters and also most punctuation marks It is common in AARO to use capitals only for the codes of things but mix capitals and lower case letters in the descriptions of things Most entities in AARO accounts periods companies etc have a code and a description 1 4 The window layout in AARO Most windows in AARO follow the same pattern and structure The left pane of the window contains a tree structure displaying for example companies or packages The right pane consists of a working space where the user can register information The working space does also often contain different tabs This disposition and layout of windows are characteristic of the editable windows where the user can register information 1 4 1 Keys and mouse buttons To move from one cell to another you can always use the mouse pointer but it is also possible to use the tab button or the arrow keys The right mouse button is used to add details to accounts and forms to obtain information about an account or form or to edit accounts forms and menus The Delete button on your keyboard can only be used to delete an account in an input or output form or to remove information from a cell 1 4 2 Hot keys A list of hot keys used in the application follows below L
12. cells in your template in the example above Cell E8 to E25 and entered all actual values in the example Period Company Currency and Code you can retrieve the requested data The data is fetched refreshed from the AARO database only when you actually command it to be and you do that through the AARO menu in Excel Follow the instructions below 1 Select one of the items under ABS Retrieve Formulas gt on the AARO menu AARO Hj lp Log N Log OFF ABS Retrieve Formulas ABS Send Formulas d Retrieve Sheet Only Retrieve Multiple Sheets Create JY Bookings d Paste from AARO d AARO Drildown Report AARO Input Form Consolidation Settings AARO About The three menu items differ only in how much of Excel they recalculate Retrieve All refreshes AARO formulas throughout all open workbooks Retrieve Sheet Only refreshes only the current worksheet Retrieve Multiple Sheets lets you select a number of individual sheets to be refreshed 2 Excel calculates the workbook and the relevant information will be displayed in the workbook A4aRG Excel Retrieve Progress e o x Scanning Excel sheet 10 fou have requested figures from 1 periodie for 10 distinct account s Waiting for server to handle request OPER_FIGLEVEL Writing result to Excel Successtully completed AARO 57 Version 10 0 Note 1 If the calculation is not successful check defi
13. from the Data Entry menu 2 Select a Period and a Company from the drop down lists 3 Open a Package and select a Form in the pane to the left 4 Click the Load button to retrieve any already reported information for your selection 5 Continue to Step 8 if no sub categories are used A sub category can for example be a Business Unit or a Customer 6 Click the Add column button to select sub categories from the drop down lists in the Add column dialogue box Click OK and a column will be added to the input form Add column Do selection Busines Uri m O o a 7 Enter the information in the cells White cells are open for editing The total sum is displayed in the Total column 8 Click the Save button when you have finished 2 6 2 Fetch information from another period It is possible to fetch information from another period You can choose between two alternatives only fetching the grid headings from another period or fetching both grid headings and figures from another period AARO 16 Version 10 0 Follow the instructions below 1 Select Input from the Data Entry menu 2 Select a period and a company from the drop down lists 3 Open a Package and select a Form in the pane to the left 4 Click the Load button to load the form for the period selected 5 Click the Fetch button to retrieve information from another period 6 Select the source period in the Fetch Period dialogue box displayed Remember to check the Fe
14. header can be changed either temporarily by pressing the OK button in which case it reverts to its previous permanent value the next time you log on to AARO or it can be saved permanently to the database by pressing the Save button 1 1 2 Printer set up Printer set up is found on the AARO menu and is used to connect a printer to AARO 1 1 3 Help The online help can be called up through Help on the AARO menu or by pressing F1 The subject displayed in the online help depends on the active window AARO 2 Version 10 0 1 1 4 Links The Links menu contains links to various web sites A link to the Aaro website is typically included other links can be added by the system administrator 1 1 5 About About shows information about the AARO application for example version and date 1 1 6 Exit Exit exits the AARO application 1 2 Information and Help This section describes further sources of information and help in addition to the user manual 1 2 1 Online Help There are three different ways to open the online help the AARO menu the Help button in the upper right corner and the F1 key When the help function is opened a separate window is displayed on the screen It is possible to either read the information on screen or print it The help sections contain step by step instructions that give guidance through different functions in AARO as well as links to closely related subjects AARO also contains a further help func
15. may be repeated indefinitely Each new drill will produce a new unique report tab You can access an old report by pressing its tab 4 3 Edit Report For more advanced changes to the report press the Edit tab The organisation of the Edit tab can vary greatly but it always contains all the different entities that are available to build a report with A Aaro Drill Down b F 0 o x AARO DataEntry validations Reports Utilities Help ad S r ff yf mo G yf 5ss i i TETEA w i mw SLR i eR a i Z E e Fi ENAT Load Saye Save as _Print Reports w J Settings Copy Delete Rename Transpose Report Help Links Home Bu 2 A Reports Edit 4 E fa Basic o B Account Period Currency Company Report Layout Matrix Layout toes Business Unit E Operational 2 Company 2 Business Area E Business Unit n E Product E Customer n A Market S Legal JV Related Remainder s External DDD DDD The Edit tab 2008 04 15 16 10 AARO When the Edit tab is selected the row and column definition areas open up next to the report AARO 28 Version 10 0 A AAROdemo 9 0 Sa a pa b x daraa Suve l Sraa j Parke 2007 09 24 15 34 AAROdemo 9 0 In this state everything in the report is possible to change The report is defined by Fixed limitations Row definitions and Column definitions Fixed li
16. reporting specific documents for divisions business units etc AARO 8 Version 10 0 Legal Documents Document explorer Main menu typical AARO Data Entry Reports Validation Utilities Window AARO Documents that have been added in the acquisition register are possible to see in this folder Legal documents The legal tree is filtered according to user rights Only users that have access to a company can see this particular company in the tree Each user can in an easy way add documents for a specific company product etc Documents are added per reporting period and it is only possible to add documents according to user rights In the same way it is only possible to view attached documents that correspond with user rights The AARO menu the leftmost menu offers different functions depending on the chosen module Some items are always available Printer set up Page header Help About Links and Exit The Data Entry menu leads to the input screens Input Match also known as the Intercompany module Legal and Group Adjustments also known as JV bookings Sometimes an Import menu item 1s available here too Only a subset of these items may be available to you The Reports menu typically contains the Drill Down report tool The Validations menu usually contains a Match report and a Reconciliation report There may also be a Check Status report The Utilities menu often contains the Import func
17. to what the current user is authorized to see The only mandatory parameters that can never be left blank are Period Account Code and Currency AARO 55 Version 10 0 8 4 3 Copy cell definition After you have prepared one formula cell properly especially regarding the use of signs to lock references to rows columns intelligently that cell can be copied to other cells in the template Depending on the complexity of the matrix in your template this can be done in different ways Ed Microsoft Excel Training in ABS Excel Retrieve_P xls File Edit View Insert Format Tools Data Window ABS Help Dieas mtas SUM X v ABSRetrieveOper D 2 025 053 853 f i gt hw es 2 Tc NN _ 19 00 00 a Fito b Allesta SA Period OTO7A PCHAL Currency ee EE ee ee ee So 153100 Met sales Intra Group IS IS3150 al wl NET SALES TOTAL IS 183700 65 457 a ae Other operating income external IS S3500 I5 153350 TOTAL OPERATING INCOME eee 3600 Work per by the comp for own use capitalized S600 IS3700 53800 153900 54000 Other operating expenses 54200 Note 1 It is good practice to check the retrieve formulas in the cells you have defined so they are correct Note 2 Do not forget to save your template Choose File menu and click Save to save the active workbook AARO 56 Version 10 0 8 4 4 Retrieve Information When you have defined all
18. using the buttons in the top right corner of the workspace or by right clicking and selecting Cell Format from the menu displayed 4 6 10 Display statistics 1 Select several cells in the report 2 Right click and select Statistics from the menu displayed The statistics count sum max min average for the selected cells are displayed 4 6 11 Sort column in a report Select a column in the report and click right and select Sort column from the menu displayed 4 7 Excel Connectivity AARO is tightly linked with Excel Once you have made a report in AARO Drilldown it is easy to export that report to Excel 4 7 1 Copy to Excel When you want to move information to Excel press the Copy button Copy In the appearing Copy menu make your selections Live copy to Excel Select what to Copy and start Excel When in Excel paste the material Ctlr V AARO 36 Version 10 0 4 7 2 Live copy to Excel The Copy button also offers Live copy to Excel functionality Copy selection Copy all Live copy to Excel This command starts Excel automatically opens the AARO Excel Add In logs on to the AARO database from Excel and enters the Report content and functionality into a new Excel workbook or worksheet EJ Microsoft Excel Boki EAE Arkiv Redigera Visa Infoga Format Verktyg Data RoboPDF F nster BAAI BF 9 H 00 Br gt Snagit Ef window g B27 ie 3216095 219
19. 729 9 Note The retrieve function is case sensitive and you must therefore type the exact code or value name AARO 52 Version 8 4 2 Define cell references To be able to retrieve data from the AARO database into your own templates you need to define cell references This is done for each unique cell that you want to retrieve information to Follow the instructions below 1 Place the cursor in the top cell in the matrix where the data will be retrieved and displayed in this exercise cell E8 2 On the Insert menu select Function The Paste Function dialogue box will be displayed Paste Function H E Function category Function name SB SGebAccounkT ext SB SGecth arrie ABSRetrieveLegal ABSRetrieveQper 465 data send ba 46SRetrieveOper period code currency co Profit Center No help available Cancel 3 Select category ABS data retrieve from the drop down list The functions ABSGetAccountText ABSGetName ABSRetrieveOper and ABSRetrieveLegal will be displayed in the Function name list to the right 4 Select ABSRetreiveOper function and click on OK The ABS Retrieve dialogue box will be displayed 5 Select a field for a formula parameter to be used to retrieve data in the ABS Retrieve dialogue box AARO 53 Version 10 0 The following information categories are valid for ABSRetrieveOper ABSRethie Ee Ope 5 AA gt S Period fate hd 0107A E Codes O00 Afe sa
20. 8677 87 750 2 545 270 13 256 355 858 290 570033 58500 2545270 1894 316 q 2 952 763 T 346 339 2 357605 1 628 645 29 250 0 11 362 039 2 152409 705 945 466 632 3 326 983 y 12 218 235 302 155 793 1 103 314 ersi 1953 837 636 697 422 640 3 013 173 2 527 676 79864 561580 29250 0 3918 569 Live in this context means that it is now possible to continue to work with the figures E g change fixed limitations drill down into the figures etc For further details see the Excel Drilldown chapter AARO 37 Version 10 0 5 1 5 2 Intercompany Items Match Intercompany transactions are reported and reconciled in AARO s Match module This module is called Match on some installations and Intercompany on some other installations It is the exact same module in both cases It is accessed via Match on the Data Entry menu J Booking Short guide to intercompany reporting l Select Match from the Data Entry menu 1 4 Select a period and a package 1 5 Select the reporting company in the tree structure Figure data is loaded into the grid immediately when the reporting company is selected 2 Report your inter company data in the forms White cells are open for editing 1 1 Select a counter company by clicking on the Insert Row button 1 2 Click on the Save button to save the entered information 3 Extract a match report 1 1 Click on the Report button and select Match report 1 2 Select from the vari
21. ARD MEME Number of Board members and Key officers BS ALL Balance Sheet BSACI BS For acquisitions MO INPU CASHFLOW Cash Flow CF_ALL CASH FLOW EQUITOT EQUITY incl all CTA accounts EQUITY Specification of Equity EQUREPORT Equity Report GROUP BS Balance Sheet Group GROUP_I5 Income Statement Group IC_ASSETS Intercompany Assets IC_LIAB Intercompany Liabilities Tm REVENUE Revenues internal I5_ ALL Income Staternnent I5_ SHORT Short Income Statement OPER_IS Income Statement Group STAFFNUMBE Average number of employees The info will be pasted into the active sheet Paste c From the active cell down and to the right ae NB This operation cannot be undone It is also possible to paste information about periods companies dimensions and groups This is done by ticking the radio button Other Information to fetch is for example the company code and the company name Arastefomass o Info source f Input Layout f Report Layout fe other 1 Period co 4cc Standard Product Business Unit Business 4rea Customer Market The info will be pasted into the active sheet Paste c From the active cell down and to the right anus NB This operation cannot be undone Note 1 The information will be pasted into the active sheet from the active cell down and to the right Note 2 The information will be pasted into the active sheet without formulas and or formats AARO 51 Version 10 0 10 0
22. Applies a filter to the current view in order to show a shorter list of items Transpose Deletes all entered information from the view Deletes all information in a window or table Online Help Pastes the selected information Deletes a column from the input form Deletes a row from the view Fetches data from another period Marks the input package as completed thus disabling further reporting on it this period Displays a list of all available accounts Renames an item Disables all filters and displays all consolidations ever ordered Updates the account structure in the Edit Accounts window Transposes the current report i e causes the rows and the columns to change places Version 10 0 1 5 Starting instructions for AARO AARO can be started through a shortcut on your Windows desktop or Start menu or by directly opening the file ABS EXE 1 5 1 Add Remove database from client installation The very first time you start AARO you will have to add a database to your AARO installation This procedure is only necessary the first time you start AARO The last used database will subsequently be the default in the database field Follow the instructions below 1 Double click the AARO icon to start the application The login window is displayed 2 Click the Options button and select Add Remove databases 3 Select the database from the Available databases list and move it to the Installed
23. Fees 17 3990 Other Operating Income 18 3999 Total Income 4010 Cost of Goods Sold external 4060 Cost of Goods Sold internal 4080 Discounts received 4099 Costs of Goods Sold 24 4910 Change in inventory 25 4999 Costs of Materials 26 4GP Gross Profit 63 1 063 1594 2720 25 5010 Oce expenses O ilal rhs ALL J4 doo e Klar IES X 4 All white cells are open for input 5 Right click and choose Add column to add columns if necessary 6 Enter the data Save the form s data to the AARO database by choosing Save from the right click menu in the sheet AARO 21 Version 10 0 3 3 ABS Send Formulas The ABS send formulas are used to send information from an Excel workbook directly to the AARO database This may be used if a lot of information is stored in excel workbooks Then the user does not have to enter all information manually 3 3 1 1 AARO Short guide for sending data to database Open the AARO Excel Add In Define a template Define the cell references and copy them if needed Send information to database by selecting ABS Send Formulas gt Send to Database from the AARO menu in Excel ARO Hj lp Logon Log OFF ABS Retrieve Formulas ABS Send Formulas Send All to Database Send Sheet to Database Create JY Bookings Send Multiple Sheets Paste from AARO l Send to File AARG Drildown Repo
24. IONS VIEW TABLE esesssesesesesccoe 47 8 Excel Drilldown and Retrieve u cece eeccesecccseccscecscccescccseccnsecenses 48 8 1 THE EXCEL ADD IN ssssesesesescsoesesesescscsesesesescsoesesesesesoeseo 48 8 2 EXCEL DRILLDOWN REPORTS ccccccccsccccccccccccccccccccees 50 8 3 PASTE FROM AARO esesesesesescesesesescsoscoesccceoesesesesesesesoeseo 51 8 4 ABS RETRIEVE FORMULAS ccccccccccccccccccccccccccccccccccccccces 52 8 5 FORMULA PARAMETERG cccccccccccccccccccccccccccccccccccccccccees 59 AARO l Version 10 0 GENERAL INFORMATION ABOUT AARO 1 1 The AARO menu The leftmost menu on the main menu bar is referred to as the AARO menu in this document The actual name of the menu varies among installations The AARO menu contains a number of standard items such as page header printer setup etc The contents of the AARO menu change depending on which window is active specific functions of the active window such as Load Save etc are added to the AARO menu Data Entry Printer setup Page header AAR support 1 1 1 Page header A page header is printed at the top of most reports in AARO It 1s possible to disable the use of the page header The same header info is used for all reports The contents of the header are configured using Page Header on the AARO menu Page header i x Frepared Date Document Mo Test Person U06 04 30 a O E Header Disabled Gave Cancel The page
25. PREDEFINED REPORT ccsccocssccsssccsscccssccsssccscsccsscceeccoes 25 4 2 DRILL DOWN cccccccocccccccsccccccccccccccccccccccccccccsccccccccccsoseces 27 4 3 EDT REPOR DP iscsccccsssccccscactavscdsscessasossscccasaccusseasaececsencwsecacges 28 4 4 NEW REPORT wessssceactocceacedcecdescacadectecdecsessacadsosedieccsseadedscacess 31 4 5 SAVE REPORT ce decesccsccidcecsattackcdsatsescesstcecacecesceusesdcstedunbtecsaces 33 4 6 VARIOUS OPTIONS ccccccccccccccccccccccccccccccccccccccccccccccccccccceces 34 4 7 EXCEL CONNECTIVITY ctsssiac sescavadestaccctecscotoctiastovctandecctiacs 36 5 Intercompany Items Match cccccccccceeceeeeeeeeeeseeeeeeseeeeeeeeees 38 5 1 SHORT GUIDE TO INTERCOMPANY REPORTING cccceees 38 5 2 DESCRIPTION OF THE MATCH WINDOW ccccosssccsssccescoes 38 5 3 THE MATCH REPORT ccccccccccccccccccccccccccccccccccccccccccccccccess 39 5 4 CONTACT LIST vscsecacecesaccescseccacccsvsceceasanccsescacseadesscecacsaassoars 42 5 5 STEP BY STEP INSTRUCTIONS MATCH esesssesesesoesesesesesoe 42 6 JV BOOKINOS ss casereaqesaagasncoetessiedaseasneseensaaasasgensascasestansensdsboseeasecnoneeeenees 45 6 1 JOURNALS JV BOOKING ccccccccccccccccccccccccccccccccccccees 45 6 2 STEP BY STEP INSTRUCTIONS JV BOOKINGS ccccccccceees 45 7 I i EEEE EEEE EE EEEE EEEE EENET 47 7 1 VIEW TABLE vac ccceseececesesbencacedesaceeweatevanssnescesssescasecassseceneseces 47 7 2 STEP BY STEP INSTRUCT
26. Tools gt Macro gt Security in Excel 2000 and 2003 When using Excel 2007 a Windows administrator may need to import the Aaro Systems certificate and make it trusted before the AARO Excel Add In can be used AARO 48 Version 6 Anew menu is displayed in Excel AARO The right click menu of the sheet 1s also extended with some AARO menu items 7 On the AARO menu select Log On The Log in to database dialogue box will be displayed 8 Select a database and enter your user name and password You make the same choices as you normally do when you log in to AARO Click Login AARO ai N gt 3 abase AARC Options Iser Name Cancel AAU SSIES 9 You are now logged on to AARO database and can begin to use the Excel link Note The login from Excel is separate from the login to the main AARO application You can be logged in to both at the same time or to only one of them just as you wish AARO 49 Version 10 0 8 2 8 2 1 Excel Drilldown Reports Predefined Drill Down report To insert a report that 1s created and stored in AARO select AARO Drill down Report gt Predefined from the AARO menu or from the sheet s right click menu Look in the folders for the report that you want and open it by double clicking The report is inserted onto the current Excel sheet x Report SER Other s Personal Reports H Personal Reports H a company Reports Bey aroup Reports as z Balance Sheet G
27. Wednesday Thursday Frida Saturday Sunday Monday Tuesday Wednesday Thursday ocuments seo Legal documents ae Document explorer ews Communiqu comments will be available 23 April System maintenance 3 May 4 4M 6 AM Reporting instructions for Forecast have been updated please review IF you have any questions please ask Anita at HQ 76543 21 BBR STSIEMS l w sA Ayy ragg Ji ad p SLS TEMS Frida 2008 04 15 20 48 AARO The Home screen can always be reached from other screens by using the Home button on the top right visible on all screens except for the Home screen itself A short description of the Home screen and the main menu bar as it typically may appear the actual menus available and their wording depends on the installation and on the user logged in Home screen elements Calendar In the calendar the system administrator can put information about deadlines for reporting packages etc In addition to plain text the calendar can contain clickable links to the reporting packages To meet an increased demand for instructions and other files available directly through the AARO database the start page has a document manager It can contain three kinds of documents Documents Group Documents Itis possible to create Group specific folders In these folders you can put common files regarding instructions for budget and
28. d Accounting 1 i 7 _ Rows Report Layo Save Periods as Relative O Columns Currency C Indude report format setting Edit Relative mra This Save report dialogue has a number of options ES ave in f Personal Reports Global Other s Personal Reports Most users are only allowed to save the report in their own personal folder Administrators can save reports everywhere in the report structure AARO 33 Version 10 0 Report Cash Flow Valuta Heading Cash Flow Valuta The report name is the name shown in the Reports tree you may regard this as a kind of file name of the report while the heading 1s the text that will be written as the heading on the output report Check the fields that should be treated as parameters Currency LI Fixed CurrTranslat 7 Include Sort Settings Fixed Accounting 1 Bi Armini 9 W Save Periods as Relative Columns Period Indude report format settine Edit Relative Info If you want some of the choices to be parameters for the future report then tick mark them If you want the system to adjust the report as time goes by e g when it is May replace April with May and so on then tickmark Save Periods as Relative This works only if periods in the system are properly maintained by the system administrator If you have formatted the report and want to keep the format then tickmark Include report format settings Not all format information i
29. databases list by using the right directed arrow or by double clicking on it Click OK to return to the login window a gt tis atabase aaro Options Add Remove databases Ber Name Ct faa Change Password System Information Password if Note If the information in the srv file is incorrect the database is not displayed in the Available databases field In this case contact your system administrator for advice 1 5 2 Log in to AARO In everyday use the start procedure is as follows 1 Double click the AARO icon to start the application 2 Choose Database from the drop down list or just accept the default choice 3 Enter your User Name and Password and click Login 4 The application now works for a while downloading some lists from the database This can take some time the very first time you log in but next time you log in this will be much faster AARO T Version 10 0 1 6 The Home screen The following screen the Home screen is always displayed when you have logged in aaro Pj x AARO DataEntry Yalidations Reports Utilities Help low Calendar Date 2008 04 15 Show log alendar 2008 04 14 2008 04 21 2008 04 28 2008 05 05 2008 05 12 Monday Tuesday Wednesday Thursday Frida Saturday Sunday Monday Tuesday Wednesday Thursday Frida Saturday Sunday Monday Tuesday Wednesday Thursday Frida Saturday Sunday Monday Tuesday
30. e on the form that is reported on the most detailed level Example The account Net Sales may be included on a main Income Statement form which could be on company product level and also on a Sales specification form which could be on company product customer level In this case if both forms are activated the Net Sales account becomes reportable only on the Sales specification form since that is the more detailed one of the two The other form s containing the same account will show the account s value summed up from the more detailed form but will not allow editing reporting of the value Income Statement COSMETICS HOUSEHOLD H EQUITY Specification of Equity 0 ll Hy BS_ALL Balance Sheet 3010 Net sales extemal 200 100 300 BES_ALL Income Statement EN w EQ Extra Ordinary Income and 3060 Net sales internal AE COMMENTS Comments 3080 Discounts eee lEz CF_ALL CASH FLOW 3099 Net Sales Total a SALES Sales Specification 3510 Jae SA 360 Invoiced Costs intemal Sales Specification Ee ANNUAL COSMETICS COSMETICS HOUSEHOLD i fe BS_LINTANG Intangible ted az CUST_O1 CUST_O5 CUST_O5 fe ES_TANG Tangible tized asset ool EQUITY Specification of Equity 3070 Net sales extemal 100 EE BS_ALL Balance Sheet icine 10 5 25 H IS_ALL Income Statement ee Fi fA EO Extra Ordinary Income and AE COMMENTS Comments lB CFLALL CASH
31. elect a period and a package from the drop down lists 3 Select a reporting company in the left hand pane of the window 4 Click on a tab at the bottom of the window to load a form 5 Add a counter company by clicking on the Insert row button 6 Select counter company and sub level in case the form requires it from the drop down lists displayed in the Add row dialogue box Click on OK 7 Enter the financial information in the cells White cells are open for editing and white tabs are active 8 Click on the Save button to save information AARO 42 Version 10 0 5 5 2 Extract a match report Follow the instructions below 1 Select Match from the Data Entry menu 2 Select a period and a package 3 Select a company or All companies in the left hand pane 4 Click on the Reports button and select Match report to order a match report An Order Match Report dialogue box will be displayed 5 Select whether you want to see the report for all match rules or for one match rule only 6 Select what Figures to match Loc Transaction Amount or both Total Specification 7 Decide how detailed a report you want Tick the appropriate check boxes in the Report Layout area You may want to experiment a bit with this to get the feel of how it works 8 Select whether you want to sort the report by Rule or by Company and whether you want to save the report as a file or display it as a standard report or in a grid 9 Click on OK t
32. eports Reconcile to display the Reconciliation dialogue box 5 Select Settings and Rules for the reconciliation report and click on OK to order the report 6 Tick the check box Intra package 1f the report only should contain the differences for the active package 7 Click Close to return to the Input window Reconciliation Report Bey itdaererscs liens LOC Pernod OFIZAC Package MONTHLY Co VETU Daal ewe Rule s default Mrrchpeditey JV Recharge Form A Cede A ah A Dap iernenpt Value D Fom F Dede B D rtereroa bound for BS ITA TOTAL ASSETS o 4 4 BS ZTLE LIABILITIES amp E LET Egt Bs ITA TOTAL ASSETS Bet BaF 3h fe 2TLE LIABILITIES amp E WETU OTHERS 2 6 5 Report forms as completed When all financial information for a period is entered into the forms the package of forms should be reported as completed The Complete button does this Follow the instructions below l Select Input from the Data Entry menu Continue to step 5 if the forms and period already are in use Select the period and the company for the forms that should be reported as completed Select the package in the pane to the left Click the Load button to load the form for the period selected Click the Complete button to report the package of forms as completed A confirmation note Period complete which says Period complete is displayed on the list at the bottom of the workspace The period will not be completed if there are reconciliation er
33. escending amp No sum order Company description Restrictions Report for selected rules only Report for selected rules only limits the differences displayed in the report to specifically selected matching rule You can choose to see a report of all rules or just one rule Restrictions Limit Report Limit defines the lower limit of the differences to be displayed It is useful as a filter function in cases of many differences Report currency Currency refers to the currency in which the information 1s displayed It 1s possible to choose AARO 40 Version 10 0 between all currencies that have exchange rates defined for the selected period Figures to match You have the following options Loc The report will match Loc figures 1 e the figures reported in local currency by the two companies The Loc figures will be converted to the report currency and then compared Transaction Amount The report will match TransAmount figures 1 e the figures reported in transaction currency by the two companies This also implies that there will be one row in the report for each currency code Total Specification The report will match both Loc and TransAmount figures in a single broad report that also includes a specification of translation diffs Translation diffs appear when the Loc and TransAmount figures reported use some currency exchange rate other than the official one stored in the AARO system for the peri
34. from the Edit tab You can also remove parameters that you do not want by dragging them back to the Edit tab More than one item may be choosen The first will be the first sort order the second the second sort order and so on To set the values of the parameters press the actual parameter You will now get a selection window where you can make your choices The parameters in the Column area affect the columns of the report You can Add new parameters to the Column definition space by dragging in items from the Edit tab You can also remove parameters that you do not want by dragging them back to the Edit tab AARO 32 Version 10 0 More than one item may be choosen The first will be the first sort order the second the second sort order and so on To set the values of the parameters press the actual parameter You will now get a selection window where you can specify your settings Parameters may me moved between Rows Columns and Fixed Criterias by dragging them to the desired new location To see your new report press the Run Report button 4 5 Save report If you want to save your report for future use press Save The Save report dialog appears ry Save report o xj Save in Personal Reports C Global Other s Personal Reports a Cash Flow Legal Type i Cash Flow Valuta Cash Flow Valuta Flow Valuta _ Fixed Period L Fixed Company D Include Sort Settings _ Fixe
35. h a standard menu profile This standard menu profile is used in the screenshots throughout this manual The system administrator can alter existing menu profiles and create new menu profiles in the administrative section of the program and assign different menu profiles to different users and even name the same menu item differently for different users E g the menu item for the main report tool may be called Drill Down for some users and Report builder for other users even though it opens the exact same screen Other common name variations include JV Bookings vs Group Adjustments and Match vs Inter company All in all this means that your particular menu may differ from the ones seen here 1 3 1 Drop down lists and combo boxes A drop down list is a list that displays all available alternatives in the different windows The user must open the list Periods packages forms period types etc are examples of information displayed in drop down lists The drop down lists often contain both code and description 1 3 2 System related functions and characters AARO is a case sensitive program 1 e it is important to distinguish between capital letters and lower case letters The permissible characters for defining account codes are the capital letters A Z the figures 1 9 and the characters underscore _ and minus The same applies to several other entities such as periods and companies AARO 4
36. he Match report differs according to the predefined selections and can be displayed either on a company total level or on a sub dimension level The amounts entered by the companies are checked according to predefined match rules to secure that coherent amounts have been entered If not the difference is displayed in the report AARO 39 Version 10 0 5 3 1 Report Contents The match report summarizes all the reported amounts for the combination of a period and a package including all forms in the package The report includes the reporting company and all counter companies Possible differences between the companies are also included The Match report also gives information on period currency rates used dimension selected and rule or rules selected This information is displayed below the report header Click on the Heading button to adjust the report header The report contents are controlled by the selections made in the Order Match Report dialogue box Order Match Report E x eport type ATLANTA v All iqures bo match i Loc Transaction Amount estrictions Report For selected rules only Al 1320 2360 Total Specification eport currency JSD Y orting of Company f Rule With match on Specification of counterpart s F ownBU M Counteru estination 7 E Customer 5 Customer C Grid f Report File Invoice No Invoice No E Comment atch sum order C Sum ascending E a EE Sum d
37. he column or in front of the row number to lock the row If dollar signs are entered both in front of the column letter and the row number the unique cell is locked You can also press F4 repeatedly until the desired definition of dollar sign is displayed AARO 54 Version 10 0 Fd Microsoft Excel Training i i File Edit Yiew Insert Foie O ae bel E ie sm xvi A g in rei tiy 10 Allesta SA PCHAL eg Income Statement 7 a 2 i rs A Om is3100 i 3 6 3 Net sales Intra Group Po IS n DD NET SALES TOTA lt S _ 183700 65 457 1 O ee Cther operating income external IS IS33500 Other operating KES es ie a Period syne M Code D8 65457 07031 No help available Period Depr af tangible Formula result 65 457 1 Cancel 8 Select the next parameter to be used to retrieve data in the ABS Retrieve dialogue box Repeat until all parameter values have been defined 9 Click on OK when you have finished Note 1 The formula parameters differ depending on the set up of the system as well as on whether you want to retrieve legal or operational information Note 2 It is not mandatory to use all parameters Leaving a parameter blank means give me the sum of all of these for example leaving Company blank means give me the sum of all companies The sum retrieved will however always be limited
38. hecked and enter the wanted amount in the Limit field E g enter 1000 to see only differences gt 1000 In order to get a report on all rules even if 0 you uncheck the box which means no limit is applied Recon rules can have default limits attached to them by the administrator It 1s possible to choose to Override all individual rule limits by doing that you enforce your own choice of Limit and disregard the administrator s default choices AARO 14 Version 10 0 Rules The field Rules contains a window with the reconciliation rules One several or all rules can be selected for the report To see only the possible differences for the loaded package tick the check box Intra package The function Clear clears the selection made 10 x iteconethution Menor Details estrictions Package ANNUAL Co ATHENS Rules f Al of For complete Intra package restrict to Forms in current package all Clear Default Forrnc Coded Forme Code Package ANNUAL 7 7 Co ATHENS BS_ ALL 1T4 TOTAL 455ETS BS_4LL 2TLE LIABILITIES amp EQUITY CT IS_ALL ar10 Extraordinary Income EO EOe710 Extra ordinary income CT I5_ ALL 6750 Extraordinary Expen EO Eoe750 Extra ordinary expense Limit Currency f Loc T Override all individual rule limits IY Include J bookings ort by T Page breaks i Rue Company Detail level f Default Maximum detail i Company Total Other
39. here are two distinct ways to get figures from AARO into Excel 8 1 e AARO Drilldown Reports Live Drilldown reports on your Excel sheets with plenty of direct manipulation features available through right click menus You can either insert a predefined report one that has been created in Drill Down and saved in the report folder structure on the AARO database onto an Excel sheet or you can build a brand new report directly in Excel e ABS Retrieve Formulas A selection of formulas that work as ordinary Excel formulas but fetch data one figure per formula cell directly from the AARO database The Excel Add In Follow the instructions below l Open an empty workbook in Excel On the File menu select Open Browse to the ABSXL xIl file It is normally stored under C AARO the AARO installation folder If you cannot find the file contact your system administrator Open the file Depending on the security settings in your installation of Excel you may have to click the Enable macros button to activate AARO Excel Security Warning 2 x CH ABS absxl xl contains macros by Aaro Systems AB Details Macros may contain viruses It is always safe to disable macros but if the macros are legitimate you might lose some functionality I Always trust macros from this source Disable Macros Enable Macros More Info Note Security level settings in Excel are accessed via the menu
40. ht the second comparison value is displayed Any difference is displayed in the middle of the report Confidential Page 1 are Approved Time Reference 12 44 33 Reconciliation Report No difference limit LOC Period 0803A Package ANNUAL Co ATHENS Detail level Rule s default Including JY bookings of type Normal Opening Recurrent System Form A Code A Value A Difference Value B Form B Code B Difference found for BS_ALL 1TA TOTAL ASSETS 0 2 720 2720 BS_ALL 2TLE LIABILITIES amp E ATHENS IS_ALL 8710 Extraordinary 0 820 820 EO E08710 EO Income ATHENS There are several possibilities of refining the information that is about to be extracted For example it is both possible to extract a report where all reconciliation rules are included or to select only one or a few rules at a time The list of rules to choose from can be limited to all rules to intra package rules which means rules whose both sides lie within the current package or to for complete which shows exactly the rules that would be used in the Reconciliation check that is run automatically before a Complete attempt The report can only be viewed in local currency Settings The Settings field contains boxes for Period Package Company Limit and Include JV Booking A period must be selected to extract a reconciliation report If only differences above a certain amount should be displayed make sure Use Limit is c
41. ight click You will then get a menu from which you select Drilldown By and then the parameter that you want to drill down by In our example we are interested in the Total Income account 3999 for Business Area SUPER and want to drill it down by Company SMALL Sm AIRPORT OTH_BA ELIM Elimi ReportTotal 3216095 2198677 87750 2545270 13 256355 2 952 763 MBBS elena Period 7 346 339 Add Comment Nii Edit Gomment 5999 Operating e 2 152 409 Delete Row s Group Adjustment ID 6999 Expenses 712218 Delete Col 6 Group Adjustment Totals 7699 Personnel 1 953 837 Hide Rows Journal Type Legal Grou esd ae Unhide All A 4999 Costs of Materials 4GP Gross Profit 760P 2 527 876 Business amp rea Cell Format gt yusi 5 Market Operational Gro Pension Plans Counter Company AmGunt Type Owned Gompany From Company Buying Co The new drilled down report appears in a new tab The GrandTotal of the new report 10 299 103 is the same figure that we originally drilled down from 720 406 1 706 845 970 063 g 329 766 906 167 1436 625 1654 447 775928 301 218 i 471 306 AARO 27 Version 10 0 Drill down
42. in terms of periods You report financial data and extract reports per period AARO 3 Version 10 0 A Period is a defined space of time Any number of periods can be defined different in duration for example month and quarter or in type for example actual or budget It 1s the responsibility of the system administrator to create and define periods preferably using a well thought through naming scheme 1 2 4 Packages A Package is a set of forms and is a crucial selection in the Input screen To serve the information need for a period one or several packages are used Different packages are used for matching inter company transactions and for reconciling financial information The system administrator defines packages according to the group s demands on information flow as well as forms and periods Example A package named MONTHLY containing certain input forms is connected to the periods January February April May etc Another package named QUARTERLY containing a slightly different set of forms perhaps with more detail specifications is connected to the periods March June etc 1 2 5 Tool tip A tool tip is a pop up box which is displayed when you rest the cursor on a button or another object in the interface The tool tip displays a brief description of the object 1 3 The menu structure of AARO The menu structure in AARO is flexible and can be adjusted to fit the company s requirements AARO is delivered wit
43. k with forms the account s form still decides the detail level for reporting so you have to be aware of that If you leave a required dimension blank you will get a validation error when you attempt to send the data If you get a validation error correct the error and try to save again Nothing will be changed in the database until the data being sent is flawless AARO 23 Version 10 0 ABS Send Match ABSSendMatch is the send formula used for match data intercompany transactions 4655endMatch TransCurr 7 Trans4moaunt oOo LocValue CE 100 Periodas O00 Me ZO Code e 101520 No help available Code B Formula result 100 TransCurr The transaction currency Used 1f the form is to be reported in transaction currency TransAmount The amount that is reported in transaction currency LocValue The reported amount in local currency Period The period for which data is sent Code The account code to which data is sent Company The reporting company for which data is sent CounterCo The counter company for which data is sent Use the company code Own BU The reporting company s Business Unit or other dimension Used 1f the form is to be reported on a Business Unit or other dimension level Counter BU The counter company s Business Unit or other dimension Used if the form is to be reported on a Business Unit or other dimension level AARO 24 Version 10 0 4 The analysis tool D
44. low 1 Select JV Booking from the Data Entry menu 2 Click on the button New to add a new booking AARO 45 Version 10 0 Currency JY Tape R Normal Select period currency and JV Type from the drop down lists in the New JV dialogue box Currency can be specified as LOC which means that the amounts in this JV booking will be in the reporting currency of the company on each row respectively or as the group currency in which case all amounts in this JV booking are in the group currency Also write a short descriptive ID in the ID box unless the edit box for ID disabled in that case the system is configured to automatically generate JV IDs Click OK An empty row is displayed in the right pane 3 Enter information by using the drop down lists or typing in the fields for company code etc All white cells must be filled in The cell called Text is not mandatory though but can be used to comment individual rows 4 Click on the Save or Prepare button when finished The command Prepare saves the booking temporarily in the database and the command Save saves it to the database Note Reversing a sign in a saved JV Booking is done by clicking on the button Sign Clicking on the Filter button gives a possibilty to select wich existing JV bookings you wish to see Li x From Date Accounting Type E 2000 01 01 2008 04 15 Company Joumal type 7 wr Currency Recurrent CI System LI Correction User
45. mitations are limitations that affect the entire report In our example Currency USD Period Y112A Accounting Type IFRS and a business area named SUPER Currency Period E Accounting Type Business Area 9 ve t EUR 1124 IFRS SUPER E Epor The Fixed Criteria Space filled with Parameters You can change the fixed limitations for your report by clicking the icon on the right edge of the parameter tray in the fixed criteria space Currency a You can for example change the Currency from USD to EUR When you click the little icon you get a selection window where you specify what currency you want Row definitions define the rows of the report In our example it 1s the Report layout PNL RPT1 Column definitions define the columns of the report In our example it is Companies and All companies means that we have not specified any specific companies so our report will include all companies that have any data on them AARO 29 Version 10 0 For rows and columns more than one item can be chosen The first item is the first sort order the second item is the second sort order and so on You can change the report definition by dragging items from the Edit tab to the Fixed critera space or onto the Row or Column definition areas You can also move items between the three areas or rearrange items inside an area by dragging the items around By clicking an item that is located in the row or column area you get the p
46. nd select the companies to be included in the contact list 6 Click OK to display the report AARO 44 Version 10 0 JV Bookings Data Entry v Input Match Import Legal 3V Booking 6 1 Journals JV Booking When figures in the closing need to be changed by other users than the ones responsible for entering data for different companies entities the function JV Booking can be used It makes changes traceable and separated from Input JV bookings are sometimes called Group Adjustments although their use is not limited to group adjustments JV stands for Journal Voucher A AARD Group Adjustments 7 Bookings AARO DataEntry validations Reports Utilities Help TA E A OAE Izaga i a i Load Save Save as Print Reports Mew ea Filter Prepare Prep asi Sign Help Links Home Period External document lt no document J Bookings Jososa Attached file zno file gt Justera Sales t UG T Sales t UG 2008 02 27 Period User ID ID Currency Status Date Last user ustera Sales O2 osas ara ustera Sales t UG Loc Saved 2008 02 27 l l4i24 aaro Journal Type Accounting Type Normal Normal Description pasren of Sales Code Am GUnE Customer Product Business Unit Business Area Market Legalsroup Legally pe Text ATLANTA 3010 20 OOO cLOTHES ee ee S eee L 6 2 Step by step instructions JV bookings 6 2 1 Enter a journal JV booking Follow the instructions be
47. ned cells and values used in the template Depending of the setup of your Excel you can check defined cells in different ways One important checkpoint is always to validate that the reference cell is correct Clicking on the Paste Function dialogue box to check that data is found does this AB SRetrieveOper mh Period TAF 0107A E Code a3 s 153100 Currency seg s EUR Profit Center as s No help available Period B Formula result 0 Note 2 Recalculate by selecting Retrieve in the AARO menu again 8 4 5 To log off Follow the instructions below 1 Select Log off from the AARO menu to close the connection to the AARO database from Excel The connection is also closed automatically when you exit Excel AARO 58 Version 10 0 8 5 Formula Parameters The different AARO Excel formulas expect different parameter lists Note 1 The parameters also differ depending on the set up of the system Note 2 It is not mandatory to use all parameters ABSGetAccountText The following parameters are used in ABSGetAccountText ABS Set 4ccountText Code is3100 s 53100 Het sales external Mo help available Code Formula result Net sales external Cancel Code An account in the database the description of which is to be retrieved ABSGetName The following parameters are used in ABSGetName ABS Sethane Type Profit Center s Profit Center Code PCHAL s
48. nsions available vary between AARO installations AARO 61 Version 10 0
49. o Input Form gt Input Form s from the right click menu on an empty Excel Period Company ABS Help foao4a_t x 7 ARLANDA 7 Y Log On EES ANNUAL Annual package Only this subset Log Off EQUITY Specification of Equity of the input Form BS_ALL Balance Sheet 15_ALL Income Statement Business Unit CF_ALL CASH FLOW lt All gt X ABS Retrieve Formulas gt ABS Send Formulas gt Paste from 4B5 gt ABS Drilldown Report gt ABS Input Form Input Forms Consolidation Load Settings Edit ABS About S Settings Color Palette Visual Refresh Reconcile Protection Look and Feel Settings Save 3 One form or all forms in a package can be loaded into separate spreadsheets in an Excel workbook Arkiv Redigera Yisa Infoga Format Verktyg Data F nster AARO Hj lp l j xj JOSH AS6RAY SBRSlO o BEANE MB B Arial 10 F x U S BS ow 98 EE LA Bits 88 69 610 EEE E 1 Income Statement Period 3 0803A Company Accounting Type ATHENS Normal March 2008 Athens 5 4 EUR Total CLOTHES HOUSEHOLD MEDIA 8 3010 Net sales external 1 063 1 063 15941 3720 9 3060 Net sales internal _ 10 3080 Discounts 1 000 1000 11 3099 Net Sales Total 63 1063 1594 2720 13 13510 Invoiced Costs external 14 3560 Invoiced Costs internal 15 3599 Invoiced Costs 16 3920 Commissions amp
50. o display the Match report 10 Click on the Print button to print the report and use the Next and Prev buttons to move between the pages in the report It is also possible to adjust the size of the report on the screen by using the two sheet buttons 11 Close the report by clicking on the Close button Period 0803A Match report Exchange rates used Match on Company Own BU Counter BU Average 6 47 SEK USD Rule 1320 2360 Closing 6 47 SEK USD Company Match on Code Loc Match Rate Diff Counter co Code Loc Match Rate ATLANTA FINANCE FINANCE 2360 1571 USD 1571 USD 6 47 SEKUSD 1571USD COPENHAGEN 1320 0 DKK 0 USD 1 271 SEK DKK AARO 43 Version 10 0 5 5 3 Edit contact information Follow the instructions below 1 Select Match from the Data Entry menu 2 Select a period and a package 3 Select a company from the left hand pane 4 Click on the Contact button then click Edit and an Edit Company information dialogue box will be displayed 5 Enter company information such as Receivable and Payable contact 6 Click OK to save the information 5 5 4 Extract a contact list report Follow the instructions below 1 Select Match from the Data Entry menu 2 Select a period and a package 3 Select a company or All companies in the left hand pane 4 Click on the Reports button and select Contact List A dialogue box will be displayed 5 Select to display the Contact list sorted by Company Code or Company Description a
51. oad Ctrl L Save Ctrl S Find Ctrl F Cut Ctrl X Copy Ctrl C Paste Ctrl V Delete row Ctrl Delete Duplicate row Ctrl D 1 4 3 The toolbar buttons of the interface The standard toolbar buttons in the application are used to add remove find objects print out etc Each window can have a different number of buttons but there are some buttons that are common to all windows and thus always visible A description of the button is displayed if you move and hold the mouse cursor over the button A list of the most common buttons 1s displayed below Loads information from Saves the entered data to the database database Saves the information as for Prints or gives a preview of the example another period information in the view R _ Orders different reports a Searching function for companies in the legal structure Reports AARO 5 Version 10 0 Settings Fun Report o Refresh AARO Adds a new object to the il current view Delete Links to various sites Copies data from one or more cells Adds a column to the input form Inserts a row into the view Effectuates a data import Adds and updates company contact information Orders a consolidation Displays various options to edit settings for a Drill Down report Runs the selected report in the Drill Down window Refreshes the information in the current window
52. od This is not necessarily an error but something that one might want to be aware of and the Total Specification match report is an aid here Report Layout The Report Layout area lets you choose how much information to include in the report and also which entities to use in the matching This is done by ticking the check boxes below the texts Specification of and With match on counterpart s The check boxes represent the different report dimensions available for a match report What the available dimensions are depends on what has been defined by the system administrator The dimension could be e g a business unit customer or invoice number Company Description This check box is ticked if the whole company name should be displayed in the report layout Normally it is only the company code that is displayed in the report layout Sorting The report can be sorted and displayed by the company code or by the match rule Report Destination The report can either be displayed in a grid or as a standard report or be saved as a text file Match Sum Order In addition to the general sort order by company or by rule the report can further be sorted by diff size A typical use would be to have the largest diffs listed first to achieve that select the Sum descending option If No sum order is selected the report is simply sorted alphabetically 5 3 2 Report Layout Two identical parts build up the report The left side of
53. os button to activate AARO Excel Security Warning 2 x C ABS absxl xl contains macros by Aaro Systems AB Details Macros may contain viruses It is always safe to disable macros but if the macros are legitimate you might lose some functionality Always trust macros From this source Disable Macros Enable Macros More Info Note Security level settings in Excel are accessed via the menu Tools gt Macro gt Security in Excel 2000 and 2003 When using Excel 2007 a Windows administrator may need to import the Aaro Systems certificate and make it trusted before the AARO Excel Add In can be used AARO 19 Version 10 0 6 Anew menu is displayed in Excel AARO The right click menu of the sheet is also extended with some AARO menu items 7 On the AARO menu select Log On The Log in to database dialogue box will be displayed 8 Select a database and enter your user name and password You make the same choices as you normally do when you log in to AARO Click Login AARO a il ie abase aaro Options E 4 er Name Cancel ail ARRO SYSIENS 9 You are now logged on to AARO database and can begin to use the Excel link Note The login from Excel is separate from the login to the main AARO application You can be logged in to both at the same time or to only one of them just as you wish AARO 20 Version 10 0 3 2 Excel Input Forms 1 Open the AARO Excel Add In 2 Select Aar
54. ossibility to specify things like data range headers sort order totals etc in a dialogue such as as the one below Select Market Available items Selection Selected items AUSTRIA Austria Ail selected BELGIUM Belgium DENMARK Denmark FINLAND Finland FRANCE France GERMANY Germany GREECE Greece ITALY Italy LATVIA Latvia NORWAY Norway OTHER Other SPAIN Spain SWEDEN Sweden SWITZERL Switzerland UK United King USA USA Description C Report Total Show code C Grand Total Show description Sortorder Sequence number O Code Description When you want your changed report to be updated press the Run Report Button AARO 30 Version 10 0 4 4 New Report To make a New Report from scratch Press the New button sme mw ik em a IW Z e g Load Load fog Print Reports Settings Copy Delete i Rename Transpose Report You might get a dialogue where you have to select a datasource You always have access to the AARO database but it is also possible to link AARO to other sources of informations such as a Data Warehouse your ERP system or something else If this is done you have to choose where you want your report to be retrieved from CN x Choose datasource OF Cancel The Datasource dialogue if multiple Datasources You will now be in edit mode with an empty report on your screen Initially the Fixed Critera Space is filled with some default parameters These default can also var
55. ous options in the Order Match report dialogue box and click OK to display the match report Description of the Match window The inter company transactions can either be reported at overall company level or at some subdimension level Inter company transactions can be reported in both local currency and transaction currency Loc amp TransAmount or only local currency Loc The detail level and currencies available depend on how the form has been set up by the system administrator The result of the reconciliation between inter company transactions is displayed in a Match report The report can be extracted for all match rules or for a single rule and either on company total level or on a fine grained sub dimension level this option 1s available if the match forms involved are reported on such a finer level It is possible to match the transaction currency amount the local currency amount or both AARO 38 Version 10 0 Aaaro Intercompany AARO Data Entry validations Reports Utilities Help i bat f ot sm mw e R Aas a vl om Load Et Save l Seve as Print Reports Row Ema Fech d Contact Help Links Home ATLANTA Atlanta Inc March 2008 Period Package oao3a hal MATCH bi Intercompany Liabilities IS all companies Awe Eomeri ease 2460 E ARLANDA L T Loans gr Acc pay gro ifi ATHENS Countercompany TrangCur TransAmount Lor TransEur TransAmount Loc E ee ATHENS
56. possible to attach documents or hyperlinks to internal or external documents to input cells Input comments in Drill Down Show all comments in drill down by selecting Show comments in settings A comment for a certain input cell can be disclosed by double clicking on the cell In preview mode any comments are indicated by a footnote and can be found at the end of the report Extract a reconciliation report Click the Reports button and select Reconcile 5 2 The Rules area lists the reconciliation rules that have been set up by the 5 3 AARO administrator You can pick individual recon rules to check if you wish Selecting no rules has the same effect as selecting all rules A reconciliation rule is a comparison between two accounts that are supposed to have the same value reported The Settings area contains boxes for Package Company Limit and Include JV Bookings A period must be selected to extract a reconciliation report If only differences above a certain amount should be displayed enter the wanted amount in the Limit field Recon rules can have default limits attached to them by the 11 Version 10 0 administrator It is possible to choose to Override all individual rule limits by doing that you enforce your own choice of Limit and disregard the administrator s default choices 5 4 Click OK to display the reconciliation report 6 6 Report the period as completed This i
57. r F ARG Input Form d Consolidation Settings AARO About If the data you are trying to send contains validations errors e g unknown account codes misspelt company codes invalid combinations of dimension values etc you will be presented with a dialogue box showing these If you get a validation error correct the error and try to save again Nothing will be changed in the database until the data being sent is flawless 22 Version 10 0 3 3 2 Formula parameters The different AARO Excel formulas expect different parameter lists Note 1 The parameters also differ depending on the set up of the system ABS Send Oper ABSSendOper is the send formula used for the majority of input forms ABSSendoper Valve A 100 Periodas 00 euo Codes o e n Company jhe PEHAL Profit Center Jas PCHAL No help available Yalue BJ Formula result 100 Period The period for which data is sent Co The Company for which data is sent Use the company code Code The account to which data is sent Dimensions The specific dimension values such as Profit Center Product Customer Business Unit etc for which data is sent Dimensions vary between AARO installations When sending data you must make sure to fill in all required fields Which fields are required depends on the account code and which form s that account is reported through this period Although Excel Send itself does not wor
58. rill down This chapter is an introduction to AARO Drill Down After reading this you will understand how to order a Report how to adjust it and how to build new Reports Drill Down is the AARO report generator Basically it is an OLAP report generator containing your entire organization To start Drill Down select Drill Down from the Reports menu 4 1 Predefined Reports Predefined reports are reports that you or someone else has prepared and saved in AARO s report folder structure The report folders are stored in the AARO database so you will see the same folders regardless of which computer you log in from You access the predefined reports through the Reports tab A AAROdemo 9 0 Drill Down 0 x AARO90 DataEntry Validations Drill Down reports Utilities Help Sie ma ajj aljer aj wj Zee 2 ee Print Reports OA i x un Settings Copy Delete Rename Transpose Report E Group Reports C Legal Reports H 4 Operational Reports E Comments lEz Demo PPT lEz Demo PPT 2 lEz Top Co C7 Test Other s Personal Repor C Personal Reports The Predefined Reports folders tab ognan 2007 10 04 14 02 AAROdemo 9 0 The report folders are adjusted to your needs and might look different from our example You run the report you want by double clicking it or by selecting it and clicking the Run Report button Some reports require parameters and in tho
59. riod and a company must be selected The available periods and companies are displayed in drop down lists It is also possible to choose a comparison period The total figure from that period will then be shown in a yellowish read only column beside the total column The system administrator defines packages forms and periods 1n accordance with the group s demand for information flow AARO Input AARO DataEntry Validations Eanes Utilities rates Jj 2 En a Eel 7 alal Load 5 AT ed mi Belete a A nok ae Replace Help Links Home Period Company Compare with zE ATHENS Athens S A 7 os03A 7j ATHENS F 07124 March 2008 EUR Income Statement CLOTHES HOUSEHOLD MEDIA TOTAL 07124 E a R ANNUAL BS_INTANG Intangible BS_TANG Tangible fixe EE AF EQUITY Specification o BS_ALL Balance Sheet 3010 Net sales extemal 1 063 1 063 1594 3720 9998 t a a Stateme 3060 Net sales intemal 3080 Discounts 1 000 1 000 582 3099 Net Sales Total 1 063 1594 2720 E COSMETICS E FINANCE FOOD E HOUSEHOLD 3510 Invoiced Costs external LEISURE 3560 Invoiced Costs internal E MEDIA 3599 Invoiced Costs H 7 EO Extra Ordinary Incon 4999 Commissions amp Fees FS COMMENTS Comments f q 10579 ee CF_ALL CASH FLOW 3990 Other Operating Income H amp SALES Sales Specificat 3999 _Total Income 63 1063 1994 2720 19 995
60. rors If so correct the errors save and click the Complete button again AARO 18 Version 10 0 3 1 Excel Input and Send The AARO Excel Add In allows you to send information from Microsoft Excel workbooks to the AARO database There are two distinct ways to get figures from Excel into AARO e AARO Input Forms Live Input Forms on your Excel sheets with direct manipulation features available through right click menus You insert an input form onto an Excel sheet or a package of forms with one form per sheet and then enter the figures using Excel functionality and finally give a command to Save send the data to AARO Currently the Input Forms functionality in Excel is limited to simple Input forms Excel does not handle Match forms Matrix forms or Text forms e ABS Send Formulas A selection of formulas that work as ordinary Excel formulas but send data one figure per formula cell directly to the AARO database Using Send formulas data can be sent to any kind of input form in AARO with no restrictions The Excel Add In Follow the instructions below 1 Open an empty workbook in Excel 2 On the File menu select Open 3 Browse to the ABSXL xIl file It is normally stored under C AARO the AARO installation folder If you cannot find the file contact your system administrator 4 Open the file 5 Depending on the security settings in your installation of Excel you may have to click the Enable macr
61. roup Legal sore Es Income Statement Group Legal I Legal Reports E Operational Reports ay Wiebreporks B 2 P amp L by BL lEs PL by M 8 2 2 New Drill down report A brand new Drill Down report can be built directly in Excel This is done through AARO Drill down Reports gt New Report on the AARO menu or the sheet s right click menu A report order dialogue box is displayed when you choose the New Drill down function The way to build a report is conceptually similar to how it is done in the ordinary Drilldown tool however Fixed Rows Columns criteria are not handled as drag and drop trays here but rather as selections in drop down lists organised under three tabs in the same dialogue box lox r Report information My New Report AARO Standard datasource Grid Report Regular Dril down Matrix Heading Datasource Default page Report type Input Figures Fixed Rows Columns 10 0 Criteria 3 vr AARO MFixed Criteria 1 Cancel Currency al fa 1 selected EUR x Criteria 2 _ Sear Period ae Ty jososa v F 50 Version 8 3 Paste from AARO A convenient way to start creating your own retrieve templates in Excel is through Paste from AARO The Paste from AARO function is used to paste an Input Layout or a Report Layout from AARO onto an Excel sheet 5 x Info source amp Input Layout Report Layout i ther BO
62. s done when all information is entered 1 Click on the Complete button to report the input forms in the current package as completed The forms are then closed for any further reporting 6 2 An automatic Reconciliation check is performed when the Complete button is pressed AARO The package of forms cannot be reported as completed as long as there are any reconciliation errors 12 Version 10 0 2 3 Description of the Input window This section describes the contents and layout of the Input window which is used to enter and reconcile financial information for a period 2 3 1 The tree structure The tree structure in the left pane displays the forms that the user is allowed to report on for that specific period Sub categories are predefined and can for example be used for sub specification for different divisions business units product groups or customers 2 3 2 The workspace At the top of the workspace the period and the company are selected from the drop down lists Valid forms in the package are displayed by double clicking on the package in the tree or by clicking on the sign The columns in the workspace reflect the reporting level defined for the current form A form reported on company level has only one entering column and a total column while a form reported on a dimension can consist of several entering columns depending on how many items the dimension contains Before any information can be entered in a form a pe
63. s stored though For elaborate and persistent formatting we recommend Excel Press Save and your report 1s stored for future use 4 6 Various options 4 6 1 Calculated items Follow the instructions below 1 Enter the detail selection dialogue box for a Criteria in the report 2 Make sure the items needed for the calculation are entered in the Selected items field Click on Calculated Item 3 Enter a name for the calculated item in the Heading field 4 Enter the formula in the Expression field Click on the buttons for the items operands and numbers to include them in the calculation If needed use the Backspace button to delete the last character 5 Click OK to enter the calculated item into the Selected items field AARO 34 Version 10 0 al vallable items mSelection Selected items E All Period s bine 2005 ToN 2006 Current 2008 gt ioj x MInformation 4 Heading Change Expression 0803A 4 0712A Backspace rCalculator Items Selective Item gt 07124 OF 08034 V Show code V Show description a Long description Click on OK twice to view the report 4 6 2 Transpose rows and columns 1 Click the Transpose button to let the rows and columns switch places 2 Click again on the Transpose button to change back again 4 6 3 Delete zero columns or rows Click the Delete button and
64. se cases you will get one or more selection windows such as the one below where you have to specify for example what Period you want to see in the report AARO 25 Version 10 0 Select Period Available item a Selectio F All Periods Normal 002 i Top H 2001 E TEST E O H 1 F H 2 H Y3 E d 7 44 All altd for Calculated ltem gt Selective Item OF W Show code W Show description Long description Make your selection s and press the OK button When all selections are done the figures will be retrieved and the report shown as below A AAROde mo 9 0 Drill Down a pele SUPER Su SMALL Sm AIRPORT OTH BA ELIM Elimi ReportTotal 3999 Tota ineme 1259 103 3217095 2198677 877 2545270 13257355 4999 Costs of Materials 2952763 5830 570033 58500 2545270 1894316 E H H A f ma 4GP Gross Profit 738339 2358805 1628645 29250 0 11363039 S599 opeaingepenses 2152409 0543 06N 3 326 983 6999 Expenses 712218 2355302 15573 1 103314 7699 Personnel 1953837 635697 422640 3013 173 Jeo OperatingProft 2527875 780864 581580 29 250 0 3919569 2007 09 24 14 59 AAROdemo 9 0 AARO 26 Version 10 0 4 2 Drill Down If you are interested in a certain figure and want to see more details about it then you can drill down into it Select a Cell Row or Column and r
65. select Zero columns or Zero rows from the menu displayed to remove columns rows that contain zeroes only from the current report 4 6 4 Delete report sheets worksheets Click the Delete button and select Current sheet or All sheets from the menu displayed to delete either the currently active report sheet or all sheets This tidies up your workspace 4 6 5 Delete a predefined report permanently Click the Delete button and select Report from the menu displayed if you wish to delete a predefined report from the Reports tab The report will be permanently deleted from the database 4 6 6 Rename a sheet Click the Rename button and rename the report or select the current report tab and click right and select Rename from the menu displayed 4 6 7 Save an existing report with a new name Follow the instructions below 1 Open the report by selecting it in the tree structure and click the Run Report button 2 Click the Save as button or right click the report tab to save the report with a new name AARO 35 Version 10 0 3 After entering the new name click the Save button to save the information 4 6 8 Delete a row or a column in a drill down report Select the row or column that should be deleted in the report and right click and select Delete row s or column s from the menu displayed to remove a row or a column 4 6 9 Change Cell format 1 Select one or several cells in the report 2 Change the cell format either by
66. tch Data with figures check box if you want to retrieve both grid headings and figures for the period selected Leaving the checkbox unchecked will fetch only grid headings Click OK Fetch Period x eriod osora Fetch Data With Figures Fetch to 15 ALL All Forms 2 6 3 Input comments It is possible to comment input reporting The comment may be mandatory given certain rules that are maintained by the administrator e g notable deviation from some other period such as budget or previous year or otherwise remarkable figures Red cells indicate that the values need to be commented The cell colouring is updated only when the form is Loaded thus it is good practice to Save figures and then Load the form again to watch for any mandatory comments Follow the instructions below 1 Double click the red cell 2 A Comment dialogue is displayed where you can see the comment rule 3 Enter your comment and save it 4 After saving the comment the red cell becomes green AARO 17 Version 10 0 2 6 4 Extract a reconciliation report A reconciliation report displays the reconciled data entered for a period in the Input module Only one period is displayed at a time If all financial data is entered correctly the Reconciliation report will be empty Follow the instructions below 1 Select Input from the Data Entry menu 2 Select a period and a company 3 Select a package from the left hand pane 4 Choose R
67. the report displays information regarding the reporting company 1 e your own company and the right side what the counter company has reported as the counter company Any difference is displayed in the middle AARO 41 Version 10 0 There are several possibilities of refining the information that is about to be extracted For example it is possible to extract a report where all match rules are included or to extract a report that includes one rule at the time The report can also be viewed in either the transaction amount or in local currency or both Example Match report Period 0803A Match report Exchange rates used Match on Company Own BU Counter BU Average 6 47 SEK USD Rule 1320 2360 Closing 6 47 SEK USD Company Match on Code Loc Match Rate Diff Counter co Code Loc Match Rate ATLANTA FINANCE FINANCE 2360 1571 USD 1571 USD 6 47 SEK USD 1571USD COPENHAGEN 1320 0 DKK 0 USD 1 271 SEK DKK 5 4 Contact list The Contact list should be used to register contact information concerning the companies The contact information is entered in the Edit company information dialogue box displayed when clicking on the Contact button The Contact list report is accessed through the Reports button and the report can be sorted either by Company Code or Company Description D0 Step by step instructions Match 5 5 1 Enter information in a match form Follow the instructions below 1 Select Match from the Data Entry menu 2 S
68. tion and the tables displaying the period rates and companies View table System administators typically have a longer list of items on this menu including Edit Periods Edit Accounts Edit Input Administrative Tools etc The Window menu lists all windows screens that have been opened by the user so far and allows quick switching between them and also contains options to arrange cascade tile the windows visually 9 Version 10 0 2 1 Manual data entry Overview Data Entry Walbdatior Input Match The Input and Match screens are accessed from the Data Entry Import menu Information is reported in different packages for example Legal yearly quarterly and monthly Each of these packages contains the applicable forms for example balance sheet income statement and possibly additional detail specification forms J Booking Figures are entered in cells White cells are available for registration and blue cells are blocked You can navigate between cells using the Tab key the arrow buttons or the mouse pointer 2 1 1 Same account on more than one Form An account can be included in more than one form In this case the form actually used for reporting the account depends on what forms are activated by the system administrator for the period at hand If several forms containing the same account are activated in the same period then the account becomes reportable only on the most detailed one of these forms 1
69. tion which allows group staff to pass on instructions about accounts and forms to users who report in the DataEntry Input screen Right clicking a cell and selecting either Help on form or Help on code from the menu reaches that help function 1 2 2 Information fields in Data Entry In the upper right corner of the window there is a blue field in the shape of a rounded rectangle This field shows different kinds of information depending on the module you are using e g company period and currency Another help function is the text area in the middle below the buttons here the application shows an explanation if the form is not open for the chosen period or is read only for some other reason AARO Input AARO DataEntry Yalidations Reports Utilities Help me Le oe Ba Load Save f Save as Print f Reports Pli e Column Fetch Completef O x gaj e AB 71a a Insert Delete ms cea Tih Row Row Replace Help Links Home Period Company Compare with ATHENS Athens S A Income Statement CLOTHES COSMETICS FOOD HOUSEHOLD LEISURE TOTAL IFS ANNUAL BS_INTANG Intangible lf BS_TANG Tangible fixe WEE EQUITY Specification o RG BS_ALL Balance Sheet 3010 Net sales extemal 1063 2262 1063 2 262 1754 9 998 1 2 3 Periods The period is a crucial selection whatever task you perform in AARO All information in AARO is entered controlled and followed up
70. y between AARO installations A AAROdemo 9 0 Drill Down at 10 x AARO90 Data Entry Validations Drill Down reports Help SIBU a l Ai f i Sm m SE a i A KAT Load Save Save as Print Reports New a Grid B 7 Report B _ The empty Column Space i Basic T ia Period NI settings Copy Delete Rename hil I i gt i The Default Criteria Parameter set H E Legal Legal Group Legal Type The empty 3 From The em Report Space jaata Row Space Py ee P Temporary tab 2007 09 25 08 39 AAROdemo 9 0 The parameters in the Fixed Criteria space affect the entire report AARO 31 Version 10 0 You can Add new parameters to the Fixed criteria space by dragging in items from the Edit tab You can also remove parameters that you do not want by dragging them back to the Edit tab To set the values of a parameter click the little icon on that parameter tray s right edge Currency all EUR You will now get a selection window as below where you can specify your criteria l gt iz oa FF 44 Calculated ltem gt Selective Item W Show code W Show description P Long description When satisfied with the Fixed Criteria Space content proceed with Rows and Columns in the same way The parameters in the Row area affect the rows of the report You can Add new parameters to the Row definition space by dragging in items

Download Pdf Manuals

Related Search

Related Contents

OST21&TS01-IM 1(IROX)1215-10 Ger.ai  Getting Started Guide  Simpson Strong-Tie TSBR2-24 Instructions / Assembly  User Manual SAR100 and SAR150 EVP  Manuel d`entretien Modèle S 962-2    サプライ情報  User Manual - Hope Industrial Systems  RX-T302 HDMI1_3 2X1 SWITCHER  Thumbs Up Snap Remote  

Copyright © All rights reserved. Failed to retrieve file