Home

AARO OFFICE CONNECTIVITY 15.0 USER MANUAL

1. AARO OFFICE CONNECTIVITY 15 0 USER MANUAL AARO SYSTEMS AB ee AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL ee a Soh Last updated 2014 07 10 STS TEMS Table of Contents AARO Office Add in Installing the AARO Office Add in Uninstalling the AARO Office Add in Folders and files for the AARO Office Add in Open AARO Office add in Log on Log off About oe Fe NOQOUARWNEF Excel drill down reports Insert a drill down report into Excel Live copy to Excel from the AARO Web client Delete a drill down report from Excel Drill down in Excel Expand Delete row column Cut copy paste report Run report Refresh report QO Redraw report NNNNNNNNNN N BFMOONOUAWNE AARO SYSTEMS AB OUODADAAAW W 1 1 a DVN te AARO OFFICE CONNECTIVITY 15 0 USER MANUAL SYSTEMS AARO Office Add in AARO Office Add in The AARO Office add in integrates the AARO Web client with Excel and provides the user with the following functionality e Copy AARO Web reports into Excel with active drill down functionality e Open a predefined AARO drill down report in Excel e Perform drill down and expand reports in Excel e Locate several AARO reports on one Excel work sheet e Move a report to a new location AARO Office add in is not integrated with AARO Excel add in It can be installed and work in parallel with AARO Excel add in AARO Office add in is supported with Excel 2007 and higher Installing the AARO Office Add i
2. 3 STS TEMS To remove a selected value select the value in the right pane and click the Remove button or double click the value To clear the selection click the Clear button Repeat the step for each parameter tab Click OK when done The report is then loaded in the selected cell i Fe Balance Sheet Group Legal Balance Sheet Group Legal 1 2 3 Currency SEK A 5 Acct Standard NORMAL Legal Group MainGroup F Period 0912A Dec 2009 GOLD ORIGINAL DO NOT MODIFY amp ASSETS 9 1099 Immaterial assets 1 324 664 10 1199 Land and buildings 1 244 787 11 1299 Tangible fixed assets 2981045 12 1399 Financial fixed assets 2 061 686 13 1499 Inventories and prod work in progress 1373 889 14 1599 Accounts receivable 1 323 738 15 1699 Other current receivables 1160529 16 1799 Prepaid expenses and accrued income 6 603 448 17 1899 Short term investments 403 757 18 1999 Cash and bank 3 270 761 19 1TA TOTAL ASSETS 20 503 747 Figure 2 2 4 Predefined AARO report loaded in Excel Live copy to Excel from the AARO Web client This section describes how to copy a drill down report from the AARO Web client to Excel keeping all drill down functionality active To perform live copy to Excel from the AARO Web client 1 In the AARO Web client open or create the drill down report of your choice 2 On the Export menu click Excel Live AARO SYSTEMS AB 12 AARO OFFICE CONNECTIVITY 15 0 USER MANUAL Excel w
3. 6 1 Expanding a row by parameter Company New rows columns appear under the expanded row column AARO SYSTEMS AB t ee 3 AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL n m amh Excel web client drill down reports SYSTEMS A B Balance Sheet Group Legal 1 2 Balance Sheet Group Legal 3 Currency Acct Standard 5 Legal Group 6 Period 0912A Dec 2009 GOLD ORIGINAL DO NOT MODIFY 9 1099 Immaterial assets 10 ARLANDA Sthim Arlanda 11 ATHENS Athens S A 12 ATLANTA Atlanta Inc 13 COPENHAGEN Copenhagen 14 EL Elimination company 15 GOTHENBURG Gothenburg 16 HELSINKI Helsinki 17 KALIX KALIX AB 18 PARENT Training Parent company 19 RIGA Riga 20 SV_HOLD Sweden Holding AB 21 TALLINN Tallinn Report Total Repor Total 23 1199 Land and buildings 1244787 Figure 2 6 2 Row expanded by parameter Company To collapse the expanded row or column select an expanded cell right click and select Collapse AARO SYSTEMS AB t Kg AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL fan N 2 7 D e pe CV OTEMS Excel web client drill down reports ng an ASSETS 1099 Immaterial assets ARLANDA Sthim Arlanda am UT a Copy Paste Options ATHENS Athens 5 A ATLANTA Atlanta Inc COPENHAGEN Copenhager EL Elimination company 5l GOTHENBURG Gothenburg Paste Special HELSINKI Helsinki KALIX KALIX AB PARENT Training Parent col RIGA Riga Clear Contents SV_HO
4. drill down reports STS TEMS 2 10 Refresh report To refresh report data if for example reported values were changed select a report cell and click the Refresh button ar dy Cut if Copy Insert Delete Login Logout About Paste Pi Redraw Undo Reports Connection Other Figure 2 10 1 Refresh button 2 11 Redraw report To redraw a report for example if encountering report errors from using Excel functions within a report on a worksheet which has been changed to unprotected select a report cell and click the Redraw button Bi f dy Cut gt Run pss Delete Row F Co ea Refresh elete Column D Aa E py EH Delete Col Insert Delete Login Logout About SLE Reports Connection Other Figure 2 11 1 Redraw button AARO SYSTEMS AB 23
5. new location select a report cell and click one of the following buttons e Click Copy to leave the original report in place and copy it to a new location e Click Cut to remove the original report and place it in a new destination The report can be pasted by clicking the Paste button gt fil A Cut gt Run Delete Row r Copy aa Refresh Column F D E Delete Co Insert Delete gt my PEE E EEE Paste q Redraw Undo eports connection Other Figure 2 8 1 Cut Copy and Paste buttons The same options are also available from the right mouse menu AARO AARO SYSTEMS AB 20 ay tee 3 AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL m mame Excel web client drill down reports fo j Copy g Paste Options t 7 A ASSETS Paste Special 1099 Immaterial assets o 318 1199 Land and buildings 336 1299 Tangible fixed assets aii 682 1399 Financial fixed assets oe O78 1499 Inventories and prod Filter t 1800 1599 Accounts receivable Sort 7952 1699 Other current receiva E ormat Cells 494 1799 Prepaid expenses ani 785 1899 Short term investme 548 1999 Cash and bank 662 1TA TOTAL ASSETS waj E 260 LIABILITIES Run 2081 Share capital AARO Insert Report fat 2085 Revaluation reserve 2086 Statutory reserve 20RE Restricted equity 2091 Retained profit 12 ioe 2099 Net income 1i Figure 2 8 2 Cut Copy and Paste options on the right mouse button menu 2 9 Run report To rerun the
6. report with new parameter values select a report cell and click the Run button ES Copy 4 Refresh Login Logout About Inset Delete Paste g Redraw Undo Reports Connection Other Figure 2 9 1 Run button Alternatively right click the report and choose Run from the AARO menu AARO SYSTEMS AB 21 72 n m lt n ASSETS 1099 Immaterial ass 1199 Land and build 1299 Tangible fixed 1399 Financial fixed 1499 Inventories an 1599 Accounts recel 1699 Other current s 1799 Prepaid expen 1899 Short term inv 1999 Cash and bank 1TA TOTAL ASSETS LIABILITIES 2081 Share capital AARO OFFICE CONNECTIVITY 15 0 USER MANUAL Excel web client drill down reports Cut Copy Paste Options z S Faste Special Clear Contents Filter AARO Insert Report khh E i sie Os mb ees Se ea NORMAL LEGGROUP 111 318 271336 6 71 682 215 078 19 600 338 952 12 494 190 785 10 546 23 662 Cut Figure 2 9 2 Run option on the right mouse button menu AARO Default period value a Dec 2009 Check Jan 20 10 ra If the report has parameters the parameter selection box will be displayed Dec 2009 GOLD ORIGI Figure 2 9 3 Parameter selection dialog AARO SYSTEMS AB Select the new parameter value s and click OK 22 t ee AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL aoe Excel web client
7. title AARO SYSTEMS AB 13 t ae AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL e Souk Excel web client drill down reports S73 EMS f A B C 1 2 New Report gt 3 5 6 ri B Feriod 0912A Dec 2009 GOLD ORIGINAL DO NOT MODIFY 9 ASSETS 10 1099 Immaterial assets 1 324 564 11 1199 Land and buildings 1 244 787 12 1299 Tangible fixed assets 2981045 13 1399 Financial fixed assets 2 061 686 14 1499 Inventories and prod work in progress 1373 889 15 1599 Accounts receivable 1323 738 16 1699 Other current receivables 1160529 17 1799 Prepaid expenses and accrued income 6603 448 18 1899 Short term investments 403 787 19 1999 Cash and bank 3270761 20 1TA TOTAL ASSETS 20 503 747 Figure 2 3 3 Report exported into Excel from AARO web client menu panel 2 4 Delete a drill down report from Excel To remove a drill down report from Excel select a report cell and click the Delete button dy Cut gt Run b Delete Row F Copy aa Refresh il Delete Column D Login Logout About inseri Delete Paste a Redraw Unda Reports Connection Other Figure 2 4 1 Deleting a drill down report from Excel using the Delete button Alternatively right click a report cell and click Delete from the AARO menu AARO SYSTEMS AB t tee 3 AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL e i N 2 5 D e pe CV OTEMS Excel web client drill down reports ng an Balance Sheet Group Legal 5a Copy P
8. AARO Office add in version and database click the About button ei fi oo E Delete Row Q H j Copy gH Refresh fj Delete Column D Inset Delete i Te Logout About 7 a Redraw iT Reports Connection Other Figure 1 7 1 About button AARO SYSTEMS AB t ee AA Ye AARO OFFICE CONNECTIVITY 15 0 USER MANUAL vs Excel web client drill down reports STS TEMS mp Y 2 Excel web client drill down reports This chapter describes Excel web client drill down reports including e how to insert a predefined AARO drill down report into Excel or paste it from the Web client e how to drill down or expand the Excel report by parameter e how to delete report rows and columns and how to copy paste the report to a different location 2 1 Protected worksheets Note that the Excel sheet is protected when a drill down report is inserted from the web client or Office Add in Therefore it is not possible to edit cells on the Same worksheet as an Excel web client drill down report It is not advised to unprotect and make changes to the worksheet as this may break the inserted report rendering the report unusable 2 2 Insert a drill down report into Excel To insert a predefined AARO drill down report into Excel 1 Select the cell where the report will be started 2 Click the Insert button Logout About Reports Connection Other Figure 2 2 1 Insert button on the AARO Reports menu Alternatively right click
9. LD Sweden Holding Filter i TALLINN Tallinn Sort j Re 1199 Land and buildings 1299 Tangible fixed assets 1399 Financial fixed assets 1499 Inventories and prod w 1599 Accounts receivable AARO d 1699 Other current receivabl AARO Insert Report 1799 Prepaid expenses and Drilldown y 1899 Short term investment Expand 1999 Cash and bank 1TA TOTAL ASSETS Figure 2 6 3 Collapsing expanded rows Expand can be done several times on already expanded rows columns Note The expand by functionality cannot be applied to Report Total Grand Total and Other columns Delete row column To delete a report row or column select the row column to be deleted and click the Delete Row or Delete Column button To undo the operation click the Undo button AARO SYSTEMS AB 19 t tee 3 AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL a Excel web client drill down reports AWA oN SYSTEMS A Cut j gt Run Delete Row ai f Copy g Refresh fj Delete Column Inset Delete Login Logout About Paste gt Redraw k7 Undo Reports Connection Other i J 1001A A B D E F C Balance Sheet Group Legal Balance Sheet Group Legal Acct Standard NORMAL Legal Group Period 0912A 1001A 1002A ASSETS 1099 1 307 209 1420996 1 589 625 oon w h e We ca Figure 2 7 1 Delete Row Delete Column and Undo buttons Cut copy paste report To copy or cut a report to a
10. OM Add in Ready to Install Setup is now ready to begin installing AARO Excel COM Add in on your computer Click Install to continue with the installation or dick Back if you want to review or change any settings Destination location C AARO Figure 1 1 3 Installing AARO Office add in 5 Click Finish when installation is done Completing the AARO Excel COM Add in Setup Wizard Setup has finished installing AARO Excel COM Addn on your computer Click Finish to exit Setup Figure 1 1 4 Finishing AARO Office add in installation AARO SYSTEMS AB AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL ea AARO Office Add in Es 1 2 Uninstalling the AARO Office Add in To uninstall the AARO Office add in Go into the AAROOfficeAddIn uninst folder in your AARO directory Double click the unins000 exe file to remove the AARO Office Add in from your computer 1 3 Folders and files for the AARO Office Add in The following folders and files are created in the AARO directory when the AARO Office Add in has been installed e OfficeAddIn folder contains main add in files To upgrade to the latest version replace the AaroOfficeAddIn dll file with the latest version e AAROOfficeAddIn folder contains the uninst subdirectory and the executable file for uninstalling the AARO Office Add in 1 4 Open AARO Office Add in When AARO Office add in has been installed a new menu named AARO Reports appears on the Excel main menu ba
11. a cell and click AARO Insert Report AARO SYSTEMS AB 10 t ae AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL ai Di a m m SYSTEMS Excel web client drill down reports L_ Cut Sa Copy H Paste Options pi A Paste Special Clear Contents Filter d Sort d Figure 2 2 2 Right mouse button menu AARO Insert Report 3 Select the report in the report tree If the report has parameters the parameter selection dialog will be displayed in the right pane Each parameter is presented on a separate tab with the list of parameter values available for selection T All Reports Period Legal Group H E Notes Fl Group Reports Balance Sheet Group Legal Income Statement Group Legal 7PERI Default period value a Add fg Analysis Reports seal ae H 9 Closing Check Reports iA Jan 2010 Remove H 0 Personal Reports S 1001150 ag Data Entry Feb 2010 Clear BI Operational Reports ae a H Test Reports April 2010 H READ folder May 2010 Ee Company Reports June 2010 H I Others Personal Reports July 2010 iii Aug 2010 Sept 2010 Oct 2010 a oe Balance Sheet Group Legal Figure 2 2 3 Selecting a predefined report in the report tree 4 Select parameter values by moving them from the left to right pane by clicking the Add button or double clicking the value AARO SYSTEMS AB 11 t ee AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL ere Excel web client drill down reports 2
12. assets Balance Sheet Group Legal po urrency SEK Acct Standard NORMAL LegalGroup MainGroup Period 2009 GOLD ORIGINAL DO NO mmer ACCOUN ASSETS l wo an Blwnie S a O E by 1099 Immaterial assets 1 324 864 Period 2009 GOLD ORIGINAL DO NO 10 1199 Land and buildings 1 244 787 ARLANDA Sthlm Arlanda 30 605 11 1299 Tangible fixed assets 2981045 THENS Athens S A 458 262 12 1399 Financial fixed assets 2 061 686 NTA Atlanta Inc 125 140 13 1499 Inventories and prod we 1373 889 8854 14 1599 Accounts receivable 1323 738 23 485 15 1699 Other current receivable 1160529 1934 16 1799 Prepaid expenses and ac 6 603 448 HELSINKI Helsinki 565 767 17 1899 Short term investments 403 787 KALIX KALIX AB 6 18 1999 Cash and bank 3 270 761 PARENT Training Parent con 41114 19 1TATOTAL ASSETS 20 503 747 RIGA Riga 400 20 LIABILITIES SV_HOLD Sweden Holding A 68 786 21 2081 Share capital 7 241 TALLINN Tallinn 512 22 2085 Revaluation reserve 42 625 Report Total Report Total 1324 864 Figure 2 5 2 Report created by drill down AARO SYSTEMS AB 16 t ee 3 AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL aa Excel web client drill down reports STS TEMS 2 6 Expand To view details without creating a new report expand functionality can be used Select a row or column right click and select the menu Expand from which a choice of parameter is made A C D Balance Sheet Group Legal 1 2 Balance Shee
13. aste Options ASSETS 1099 Immaterial assets 1199 Land and buildings 1299 Tangible fixed assets Paste Special 1399 Financial fixed assets E E sates 1499 Inventories and prod work in Filter 1599 Accounts receivable Sort 1699 Other current receivables 1799 Prepaid expenses and accrued 1899 Short term investments 1999 Cash and bank 1TA TOTAL ASSETS bes LIABILITIES Run 2081 Share capital AARO Insert Report Cut 2085 Revaluation reserve 45 424 Copy 2086 Statutory reserve 4 245 20RE Restricted eguity 46 669 2091 Retained profit 126 241 2099 Net income 16 001 oa E o m ee e ae 12425 ah Figure 2 4 2 Deleting a drill down report from Excel using the right mouse button Drill down in Excel If a certain number is of interest and more details are required the drill down by functionality can be used Select a cell row or column right click and select the menu Drilldown from which a choice of parameter is available AARO SYSTEMS AB 15 AARO OFFICE CONNECTIVITY 15 0 USER MANUAL Excel web client drill down reports A C D Balance Sheet Group Legal Balance Sheet Group Legal D e pe mp8 E an NORMAL em in w l 7 Period amp ASSETS 9 1099 Immaterial assets 10 1199 Land and buildings 1324 364 ge Cut 1 244 787 11 1299 Tangible fixed assets Sa Copy 2981 045 12 1399 Financial fixed assets jet 2 061 686 13 1499 Inventories and prod work in prog
14. eb client drill down reports SYSTEMS Report Export F Balance Sheet Group Legal Untitled Excel REPORTS Balance Sheel Group Legal Favo fal Perpa Currency SEK Acct Standard NORMAL gt Legal Group MainGroup J Pdf Columns Period b Nole Rows GROUP BS Excellive v Grou Table Balance Sheet Group Legal Period 0912A Income Statement Group Leg ASSETS ASSETS 1099 Immaterial assets 1 307 229 Figure 2 3 1 Excel Live menu on the web client menu panel Alternatively in the report tree expand the report name menu and click Export gt Excel Live Group Reports Balance Sheet Group Legal Delete al Income Statement Group Legal 3 b oort bi ad Excel Analysis Reports E Powerpoint L_ l b Closing Check Reports E cas E ra Personal Reports F Excel Live iS Data Entry Figure 2 3 2 Excel Live menu from the web client report tree The AARO Office add in login window will appear if the user is not already logged in 3 Select the same database and user name as was used in the Web client and click Login The report is pasted onto the active Excel sheet next to existing reports if such exist A new Excel workbook will be created if an active worksheet is not already open The report exported using the Web client menu panel is pasted into Excel as a new report without a title A report exported from the report tree is pasted to Excel as a predefined report with
15. he password is required AARO SYSTEMS AB AARO OFFICE CONNECTIVITY 15 0 USER MANUAL AARO Office Add in n n an D gt pe mj v a an AARO Systems LE E E a Database user tame Password e Figure 1 5 4 Login window 4 Click Login 5 If the password has been expired or changed by the administrator the Change Password window appears Enter and retype new password Change Password You must change password due to security policy requirements new password equals to retyped password 3 at least 8 characters long 3 Contains only valid characters Contains both characters and numbers Figure 1 5 5 Change Password dialog AARO SYSTEMS AB DVN te AARO OFFICE CONNECTIVITY 15 0 USER MANUAL fe aha ay AARO Office Add in Es After logging on to the AARO database from Excel all the AARO Office add in features can be accessed 1 6 Log off When closing Excel there is no need to log off from AARO as AARO is automatically logged off when Excel is closed There is also be an automatic log off from AARO if there is no activity for 2 hours or another specific period of time that has been set up by the system administrator Alternatively click the Logout button from the AARO Reports menu in Excel to logoff from AARO without closing Excel Insert Reports Connection Other Figure 1 6 1 Logout button on the AARO Reports menu 1 7 About To view information about the
16. n AARO Office add in is installed using the setup program AARO_OfficeAddin exe It can be installed to any folder containing the srv file with the database reference Once installed it can be upgraded with the newer version by replacing the dll files in the installation folder To install AARO Office add in 1 Run AARO_OfficeAddin exe 2 Inthe Setup window click Next jB Setup AARO Excel COM Add in Welcome to the AARO Excel COM Add in Setup Wizard This will install AARO Excel COM Add in version 15 0 32 0 on your computer Itis recommended that you dose all other applications before Click Next to continue or Cancel to exit Setup Figure 1 1 1 AARO Office add in setup window AARO SYSTEMS AB D e pe t tee 3 AARO AARO OFFICE CONNECTIVITY 15 0 USER MANUAL m a AARO Office Add in S TEMS ng an 3 Select the folder where the add in will be installed using the Browse button and click Next j5 Setup AARO Excel COM Add in Select Destination Location Where should AARO Excel COM Add in be installed Setup will install AARO Excel COM Add in into the following folder To continue dick Next If you would like to select a different folder cick Browse At least 25 0 MB of free disk space is required Figure 1 1 2 Selecting an installation folder 4 Click Install AARO SYSTEMS AB DVN te AARO OFFICE CONNECTIVITY 15 0 USER MANUAL fe ay a AARO Office Add in jp Setup AARO Excel C
17. r mas ear Bookl Microsoft Excel Home Insert Page Layout Formulas Data Review View Add Ins Sn P poo CEE OU Login ut About Reports Connection Other Figure 1 4 1 AARO Reports tab in Excel All AARO Office add in functionality for the web client is located under this menu 1 5 Log on Logon is necessary before any data can be accessed in the AARO database To log on to AARO from Excel after opening the add in follow these steps 1 On the AARO Reports menu in Excel click the Login button Su Insert About Reports Connection Other Figure 1 5 1 Login button on the AARO Reports menu The logon dialog box will be displayed 2 If you are logging on for the first time you will need to choose which database to logon to by clicking the Databases button AARO SYSTEMS AB AARO OFFICE CONNECTIVITY 15 0 USER MANUAL AARO Office Add in Figure 1 5 2 Databases button in the login window The list of databases set up in the srv file will appear Select the relevant checkbox ex and click OK Select Databases Figure 1 5 3 Selecting the database the first time The selected database will now be available in the Database drop down list when logging on In the User Name and Password fields enter your user name and password If you are logging into the Office add in using a domain user only t
18. ress EY 1373 889 14 1599 Accounts receivable Paste Spedal 1323 738 15 1699 Other current receivables 1 160 529 16 1799 Prepaid expenses and accrued income 6 603 448 17 1899 Short term investments Dete 403 787 18 1999 Cash and bank Clear Contents 3270761 19 1TA TOTAL ASSETS Filter i 20 503 747 20 LIABILITIES Sort 21 2081 Share capital m o n 7241 22 2085 Revaluation reserve E F i E E l es 42 625 23 2086 Statutory reserve hice nena 15 924 24 2087 Equity share associated companies efine Name 7389 25 20RE Restricted equity sa WPENINK 43 918 26 2091 Retained profit AARO 1036 176 27 2099 Net income AARO Insert Report 4160 746 28 20UE Unrestricted equity 0O Drilldown gt imaia O BAA EQUITY Expand Period property 30 2299 Provisions 31 2399 Long term liabilities 32 2499 Current liabilities to cred inst cust and suppl aisle 33 2599 Income tax liability Legal i 34 2799 Employee withholding taxes etc Operational d 35 2899 Other current liabilities 3399 960 36 2999 Accrued expenses amp deferred income 2 702 144 37 ATLE EQUITY AND LIABILITIES 20 504 195 Figure 2 5 1 Drilling down a cell by parameter Company The new drilled down report appears next to the original report Note that the report total of the new report is the same as shown in the source report A B Erp Balance Sheet Group Legal Balance Sheet Group Legal Currency Acct Standard NORMAL Balance Sheet Group Legal by 1099 Immaterial
19. t Group Legal 3 Currency SEK 4 Acct Standard 5 Legal Group 5 i Period 0912A Dec 2009 GOLD ORIGINAL DO NOT MODIFY ASSETS 9 1099 Immaterial assets 1324 364 10 1199 Land and buildings mi Cut 1 244 787 11 1299 Tangible fixed assets Sa Copy 2981045 12 1399 Financial fixed assets Fet ES 2 061 686 13 1499 Inventories and prod work in p B 1373 889 14 1599 Accounts receivable Pt 1323 738 15 1699 Other current receivables 1160 529 16 1799 Prepaid expenses and accrued i eee 6603 448 17 1899 Short term investments DARE 403 787 18 1999 Cash and bank Clear Contents 3270761 19 1TA TOTAL ASSETS Filter 20 503 747 20 LIABILITIES Sort b 21 2081 Share capital tte insert Comment 7241 22 2085 Revaluation reserve 42 625 23 2086 Statutory reserve Ef Format Cells 15 924 24 2087 Equity share associated compa Pick From Drop down List 7389 25 20RE Restricted equity Define Name 43 918 26 2091 Retained profit a Hyperlink 1036 176 27 2099 Net income AARO 4160 746 28 20UE Unrestricted equity AARO Insert Report 2 196 921 29 205E EQUITY 9 153 003 ar Drilldown 30 2299 Provisions i zra nA 31 2399 Long term liabilities a ee 32 2499 Current liabilities to cred inst c Period property 33 2599 Income tax liability 34 2799 Employee withholding taxes et Other Account 35 2899 Other current liabilities Legal 36 2999 Accrued expenses amp deferred il Operational 37 2TLE EQUITY AND LIABILITIES 20504 195 Figure 2

AARO OFFICE CONNECTIVITY 15.0 USER MANUAL

Contents

Download Pdf Manuals

Related Search

Related Contents