Home

THE UNIVERSITY OF HULL

1. Used to interrogate the system by Account field Select either Kel Optlons Account Report from the menu bar or CtrlA d Account Report Xx Previous Settings I OK v Show settings created by other users jemove Cancel Transaction T ype ACT UAL h Ledger Ledger amp ccounts 2 to 2 Nominal Accounts 2 to 2 All Analysis Periods JJ _ to J U 2 Document Dats to J Due Dates to r uu Summary Only Show Currency for Each Detail v Combine In One Window Show Alternate Home Values Show Accounts With No Details Show Details For Ledger All Values Document Type all Custom Columns Select Accounts By Account Code Select Nominals By Account Code Sub Totals Second Account Show Only Items with Status all Items Selection Sort Order Date Document tupe Document number e Previous Settings If you have set up and run reports before you may have saved the settings for future use This drop down allows you to select from a list of previously run and saved report views e Show Settings Created by Other Users Include report views that have been set up by other users e Remove Remove the selected report view from the list You may only remove those you have set up e Transaction Type Enter the Transaction Type on which the report is to be based The Default is Actual and the remainder are all ty
2. An asterisk on a report indicates that there is acomment Left click on the appropriate report row and select Comments from the Reports menu Using Indices to Select Report Contents One use of a Dream Index is to group Nominals and Accounts together for reporting purposes Nominal and Account indices may be used on Nominal Detail Reports but only Nominal indices may be used on Trial Balance reports There is no limit to the number of Dream Indices that can be set up and used for reporting in Dream Saving Executed Reports You may wish to take a snapshot of a report at a given point in time and save this for historical purposes To save a report as it appears on screen you may select Save or Save As from the file menu Save as a HTML file Printing Reports You may print a report using the standard print function from the file menu DREAM Reporting Manual 4 Page 13 of 23 The University of Hull DREAM USER MANUAL Copying a Report into Excel Copy Window You may also copy the report Into Excel Run a report and select Edtt Copy Window from the menu bar and paste straight into the application Copy to Excel It is also possible to copy a report from Dream directly into a named Excel Run the required report in Dream DON T CLICK INTO THE REPORT and then select Edit Copy to Excel The following screen is displayed KP Excel Link Ed workbook Browse Data Sheet Cell Output Sheet Show Report Colour
3. OF x RINY POP Purchase Invoices Marminal amp ccaunt Tile Home Value Status Due Date Paid Invoice This invoice has been paid it has a status of P Document Report OF x GIN POP Purchase Invoices MominalvAccount Title Home Ss Status Note that the status of P will show against the Purchase or Sales Ledger account line only If you wish to see how and when the invoice was paid click on the line that shows the Paid status and select Document Show Allocation from the menu bar DREAM Reporting Manual 4 Page 15 of 23 The University of Hull DREAM USER MANUAL This report shows that QINV 28287 was paid with a number of other invoices on BACS 16014 Show Allocation Report al Vv 28287 ASDOOO DANOOOS Dac Type Doc Mo Moc Home Value Alloc Mom Curr Allac Acc Curr Alloc Status QINV 451 76 451 76 451 75 QINV 28287 1 276 05 1 276 05 1 27505 QINV 30317 294 56 294 56 94 56 QINV 32081 810 04 810 04 810 04 QINV 28018 311 26 311 26 311 26 QN 30880 450 30 4 5630 450 30 QN 30887 691 36 691 36 691 36 GUN 35261 307 99 307 99 307 99 GIN 31246 465 96 465 96 465 96 GINV 32444 585 585 62 505 62 GMY 33500 4543 83 1 843 83 1 843 83 GUM 32835 1 940 51 1 940 51 1 940 51 GUN 33541 1 168 84 1 168 84 1 168 84 GUN 33542 163 33 163 33 153 33 BACS 15014 5 380 38 5 380 38 5 380 38 0 00 0 00 0 00 JI I Ie Pee le To check when the invoice was paid double click
4. d Nominal Detail Report x Previous Settings a Show settings created by other users Cancel Transaction Type factual j Nominal Accounts to 2 All Analysis Ledger Accounts J 2 to oo 2 Periods 2 to sd Document Dates SY to Payment List As At Report Unallocated Items Only All Values Include Part Pay Values v Combine In One Window Brought Forward Balance Show Accounts With No Details Allocate Currency ALL Document Type all El Custom Columns Select Nominals By Account Code Select Accounts By Account Code Sub Totals Nore x Show Only Items With Status Al Items 7 Selection Sort Order Date Document type Document number v Most of the settings are the same as the Account Report screens so will not be repeated The additional settings are e Payment List Enter the Payment List on which you wish to base this Nominal Detail Report Leave blank to ignore this option e As At Report For Nominals and Accounts where the Dream Allocation process is used it is possible to run an Open item report retrospectively so that only items that had a status of Open at a particular date To run an As At Report include the As At Date in the Document Dates to Field and check the As At Report checkbox e Include Part Pay Values The check box becomes available when the As At Report Check box is checked e Brought Forwa
5. 11 2002 ADBODAED14 ROBO 200121142 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADB0DAED14 ROBOOS 200121145 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOO2 200121148 120004 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121151 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121161 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121167 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121171 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121178 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121178 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121180 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121183 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOO 200121184 120004 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOO2 200121185 120004 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOO 200121180 120004 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200128043 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200128044 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 RDBD002 200128046 120004 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200128047 120006 1 795 00 0
6. Fees 200121190 14 11 2002 ADBOODSEDN14 FDB uO02 120004 1 795 00 O2703 Session Tuition Fees 200128046 14 11 2002 ADBOOSAEOD14 FDB D2 120004 1 795 00 O2 03 Session Tuition Fees 200128053 14 11 2002 ADBOOSAEDN14 RDBOOF 120004 1 795 00 O2 03 Session Tuition Fees 2001258058 14 11 2007 ADBOOAED14 RDBOOF 120004 1 795 00 O2 03 Session Tuition Fees 200128254 14 11 2002 ADBOOSAEDN14 FDB O2 120004 1 795 00 O2f03 Session Tuition Fees 2001278255 14 11 2002 ADB nA amp En014 FrFDB uO2 120004 1 795 00 O2 f03 Session Tuition Fees 200128258 14 11 2002 ADBOODSEDN14 FDB uO0Z2 120004 1 795 00 Dz D3 Session Tuition Fees 200129002 14 11 2002 ADBOODSEDN14 FDB uO2 120004 1 795 00 O2703 Session Tuition Fees 200129003 14 11 2007 ADBOOAED14 RODBOOF 120004 1 795 00 O2 03 Session Tuition Fees 20012796249 14 11 2007 ADBOOSAED14 RODOBOOF 120004 1 795 00 O2 03 Session Tuition Fees 2001279660 14 11 2007 ADBOOSED014 RDBOOF 120004 1 795 00 O2 03 Session Tuition Fees 200129661 14 11 2002 ADBOOSEDN14 RDOBOOF 120004 1 795 00 O2f03 Session Tuition Fees 2001279662 14 11 2L 32 ADBOO0SE014 FDB uO2 120004 1 795 00 O2 03 Session Tuition Fees 200129765 10 12 2002 ADBOODSAEDN14 FDB uOZ2 120004 1 795 00 O2f03 Session Tuition Fees 200129664 10 12 2002 ADBOODAEDN14 FDB uO02 120004 1 795 00 O2703 Session Tuition Fees 200129764 14 11 2007 ADBOOSEDN14 RODOBOO4 120005 1 795 00 O2 03 Session Tuition Fees 200215622 1411 2 nn aMmAnnaenia RMOANNA 32nnns 1 7 amp hi A
7. I to Supplier amp ccounts aun 2 to 2 Authorised By j zj M Show Complete Full Descriptions Select Orders with Status e Order Type Select QORD if you wish to enquire on a Purchase Order and SORD if you wish to enquire on a Sales Order Only Invoices raised to SOIN No 30085 e Number Purchase Order If you want to look for a particular order enter the order number that can be obtained from the Purchasing Finance code displayed on an order header Sales Order The order number for a Sales Order is the same number as the Sales Invoice produced Only for used for Sales Invoices raised to SOIN No 30085 e Order Dates If you want to enquire on a particular date s then enter the date s in the format dd mm yyyy e Supplier Ledger amp Supplier Account If you want a wider search then in the Supplier Ledger field enter the appropriate CREDITOR for UK suppliers FORCRED for overseas suppliers DEBTOR for UK customers and FORDEBT for overseas customers Once you have selected your ledger you can enter the account s you require Enter the code or use the find facility to locate the supplier customer you wish to report on e Authorised By Enter the userid of the individual who raised the order from the drop down box If you wish to look at a range of individuals you will have to select AII in the authorised field This normally defaults to your username so if the order you are wish
8. on the line that shows the BACS document This shows that BACS 16014 was paid on 30 04 02 to Danwood Finance Ltd Document Heport 2 lx BACS BACS MominakAccount le Home value Status DREAM Reporting Manual 4 Page 16 of 23 The University of Hull DREAM USER MANUAL 5 TUITION FEE REPORTS Overview e There are two standard reports that analyse tuition fees by programme of study within a faculty or department e There are two standard reports that analyse tuition fees by student within a faculty or department Running report on Tuition Fees by Account 1 by Programme of Study Select the Account Report icon green on the toolbar Tick the box Show settings by other users Select SQS001 Tuition Fees by POS The following Account Report selection is the default The only fields that require amending are the ledger account period from and period to d Account Report Tuition Fees by POS Previous Settings Tuition Fees by POS Show settings created by other users Remove Transaction Type actua o Ledger IFL lt Ledger Accounts w H to Nominal Accounts lt wl T Periods 2003 00 enim d Document Dates on to select Due Dates Summary Only Enter a single Iw Combine In One window Account or a Show Accounts with No Details i Show Details For Ledger A select all Account ns ma Ur i E Is in a ledger Select Accounts Bu Account Code gt Select Nominals By Acco
9. the balance for that Nominal or by Period 2 Single Nominal Reports the Account Balances by Nominal The navigation arrows can be used to move between Accounts 3 Single Account Nominal Reports the Nominal Balance by Account The navigation arrows can be used to move between Accounts 4 Single Account Periods Reports the Nominal balance by Account The navigation arrows can be used to move between Accounts Double clicking on a period explodes to display a report by Nominal for that Account for the particular period 5 Single Nom Acc Periods Reports the Period balances for each Account Nominal combinations The navigation arrows can be used to move between Accounts and Nominals e Exclude None Excludes nothing No Details Excludes Accounts with no details Zero Balances Exclude Accounts with Zero Balances e Key Points on Ledger List Reports 1 Double click on an account line to display a context menu with the drill down options available from that line This will display different options depending on the selection criteria you have specified 2 Only reports on First Ledgers To report on Second Ledgers use the Account Report 3 This report does not report balances in Account Currency DREAM Reporting Manual 4 Page 9 of 23 The University of Hull DREAM USER MANUAL 2 3 Nominal Detail Report Used to interrogate the system by Nominal Select either BI Options Nominal Detail Report from the menu bar or CtrIN
10. 2 03 Session Tuition Fees DREAM Reporting Manual 4 Page 21 of 23 The University of Hull DREAM USER MANUAL Customising the Tuition Fee Reports for an Individual User It is recommended that once a user has run the standard report s and amended the selection criteria for their own faculty etc the report should be saved under the user s name This will simplify the running of the report on future occasions Standard functionality in Dream allows reports to be customised by each user This is achieved by right clicking in the body of the report once it has been run selecting Save Report Settings and giving the report a name Version 3 2 Release 2 has been enhanced to allow you to run saved reports settings via a new menu option see To run a Report using the Run Saved Reports functionality on page 5 DREAM Reporting Manual 4 Page 22 of 23 The University of Hull DREAM USER MANUAL Appendix I Amendments to Manual All Fa C C s DREAM Reportine Manual 4 Page 23 of 23
11. Custom Columns SSL Select Mominals Bu FACLILT Y Select Accounts By Account Code x Sub Totals Mane Show Only Items With Status Al Items Selection Sort Order Date Document type Document number X Change period range as reauired The report produced selects all TUIT Tuition Fee documents for the period and nominal code range by ledger selected The results are sub totalled by the entries in User Field 2 Programme of Study DO NOT CHANGE ANY OF THE OTHER REPORT SETTINGS BEFORE CLICKING ON OK DREAM Reporting Manual 4 Page 20 of 23 The University of Hull DREAM USER MANUAL Report produced is as displayed below SBQS001lTuttion Fees by POS OF gt ADBOOAEOT 4 IL C TUITh FEES HT Et PT PG Date Mominal Account Liser Field 2 Value Description LIser Field 1 EIE BOBDAEU 4 ILC TUITN FE HEU PT P E 14 11 2002 ADBOODSAEDN14 FDB uO2 120004 1 795 00 O1f02 Session Tuition Fees 200037510 14 11 2002 ADBOOSEON14 ROBOOF 120004 1 795 00 O2 03 Session Tuition Fees 200121133 14 11 2007 ADBOOSAED014 RDOBOOF 120004 1 795 00 O2 03 Session Tuition Fees 200121136 14 11 2002 ADBOOSED14 RDBOOF 120004 1 795 00 O2 03 Session Tuition Fees 200121146 14 11 2002 ADBOOSEDN14 FDB uO2 120004 1 795 00 O2f03 Session Tuition Fees 200121184 14 11 2002 ADBOODSEDN14 FrFDB uO2 120004 1 795 00 O2 f03 Session Tuition Fees 2001211985 14 11 2002 ADBOODSEDN14 rFDB uO2 120004 1 795 00 O2 f03 Session Tuition
12. EAM USER MANUAL The University of Hull Tuition Fees byPOS Te D l l Dl l l D D OOO IFL ROBOO CORE ILC MBA HULL Periods 2003 00 ta 2003 05 Subtotal by user field 1 All Values Doc Type Dnr Ma Value UserField 1 lserField 2 Description Nominal Period Date IFL Page 19 of 23 Manual 4 DREAM Reporting The University of Hull DREAM USER MANUAL Tuition Fees by Nominal Code by Programme of Study Select the Nominal Detail Report icon blue on the toolbar Tick the box Show settings by other users Select SQS001 Tuition Fees by POS The following Nominal Detail Report selection is the default The only fields that require amending are the nominal index item account period from and period to d Nominal Detail Report Tuition Fees by Student Previous Settings Tuition Fees bu Student UK Show settings created by other users Remove Cancel Transaction Type ACT UAL Nominal Index Items D to 2 All 3 mE Ledger Accounts Kin Change nominal index item to select your own faculty Perods Document D ates Payment List As At Report Unallocated Items Only All Values l l Select a single P Include Part Pay Values I Kombine In One Window a coi ore Brought Forward Balance Sow Accounts with No Details range Leave blank Allocate for all accounts Currency iL within thedomindl Document Type TUIT x
13. Manual 4 Page 12 of 23 3 The University of Hull DREAM USER MANUAL CUSTOMISING REPORTS Removing a column Left click on the column header and drag it off the report until you see a black X If you wish the column to be excluded from all subsequent new reports use the columns option on the report menu and save as default Rename a column Right click on the title of the column The rename dialogue displays showing the default name for the column and a field into which you should enter the new name you wish to display Type in the new name and click on OK to apply Right clicking again on the column header and deleting the changed name can reset the default The changed column names relate only to the user who has changed them Column Sorting To sort any column of the report in numeric or alpha order place the cursor on the grey column title and left click once You can choose to sort in either ascending or descending order by clicking a second time on the column title View Contacts You can view contact details for a row in a report that contains a Purchase or Sales Ledger Account Click on the row in the report Select View Contact Information from the menu bar The master data held on the Supplier or Customer will be displayed Add View Comment in Reports Dream can hold comments against Nominals Ledgers Accounts Document Types Document Numbers and Order Numbers and at the lowest level individual document detail lines
14. TNI Seeeinn Tiiitinn Fees nn31a778 Tuition Fees by Nominal Code by Student Select the Nominal Detail Report icon blue on the toolbar Tick the box Show settings by other users Select SQS001 Tuition Fees by POS The only fields that require amending are the nominal index item account period from and period to The report produced selects all TUIT Tuition Fee documents for the period and nominal code range by ledger selected The results are sub totalled by the entries in User Field 1 Student Number DO NOT CHANGE ANY OF THE OTHER REPORT SETTINGS BEFORE CLICKING ON OK The report produced is as displayed below S050DIITuition Fees by Student ADBOOAEOT 4 ILC TUITN FEES HTIEU PT PG Date Mominal Account User Field 1 User Field 2 Description ADB LDA 4 ILC TUITPN FEES HTI E dli 2002 ADBDDAED14 FDB003 188702743 120006 1 795 00 02 03 Session Tuition Fees 17 2002 ADBOOAED14 ROBOOS 200031488 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOO2 200037510 120004 1 795 00 01 02 Session Tuition Fees 14 11 2002 ADBOOAEOQ14 RDBO002 200121133 120004 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOO2 200121136 120004 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBOOAEO14 ROBOOS 200121138 120006 1 795 00 02 03 Session Tuition Fees 14 11 2002 ADBODAED14 ROBO 200121138 120006 1 795 00 02 03 Session Tuition Fees 14
15. The University of Hull DREAM USER MANUAL THE UNIVERSITY OF HULL DREAM USER MANUAL Manual 4 Dream Reporting DREAM Reporting Manual 4 Page 1 of 23 The University of Hull CONTENTS Section Description 2 1 2 3 2 4 4 5 App I DREAM Reporting Report Fundamentals Anatomy of a Report Report Navigation Drill down Reports Menu Change Selection Criteria Refresh Columns Recalculate Running Total Restore Default Column Order Save Report Settings Comments Close Descendants Close Report and Descendants Standard Reports Available Account Report Nominal Detail Report Ledger List Report Order Report Customising Reports Removing a Column Renaming a Column Multi Column Sorting View Contacts Add View Comment in Reports Using Indices to Select Report Contents Saving Executed Reports Printing Reports Copying a Report into Excel Status of Payments Tuition Reports in Dream Amendments to Manual Manual 4 DREAM USER MANUAL Page AAU 11 12 13 14 15 16 17 21 27 Page 2 of 23 The University of Hull 1 REPORT FUNDAMENTALS 1 1 Anatomy of a Report DREAM USER MANUAL The following describes the key elements of a report using examples of a Document Report and a Nominal Detail Report Example Document Report Il 2 3 4 E I I Document Report im Purchase Invoices Trapsaction Type ACTUAL Mominal ccount Description Due Date Home value Status UserField 1 Document su
16. Type Year Period Nominal Second Account or Userfield 1 2 or 3 Show Only Items with Status This option allows you to select the Status of the items you wish to include in the report Selection Sort Order Sorting defines the order in which the data in a report is listed Cancel Cancel the operation and return to the main menu and toolbar OK Confirm your selection criteria and produce the report DREAM Reporting Manual 4 Page 8 of 23 The University of Hull DREAM USER MANUAL 22 Ledger List Report Used to interrogate the system by Ledger Select either In or Options Ledger List Report from the menu bar JU Ledger List Previous Settings DK OK Cancel 3 3 4 Show settings created by other users Transaction T ype actua e Ledgers SPONSOR 2 to 2 Nominals ANJO50 2 to 2 All Analysis Accounts e260 2 to 2 2 2 Periods 2007 00 2 to 2008 14 Option Account Total custom Columns Exclude Zero Balances Most of the settings are the same as the Account Report Screens so will not be repeated The additional settings are e Options By clicking on the down arrow the following options are available 1 Account Total Reports the total balances for each Account across all Nominals that use the account The navigation arrows can be used to move between Ledgers Double clicking on an Account offers the option to view
17. evious Setting dropdown list To run a Report using the Run Saved Reports functionality From the Options menu select the Run Saved Report option or click the Run Saved Reports toolbar icon A dialog similar to the one below is displayed d Run Saved Report x o Cancel Account Report Nominal Detail Report Expand the Report hierarchy by clicking the next to the report type or double clicking the report type Click the required saved report setting Click the OK button The report is displayed with the specified saved settings Comments Add comments to the document from the comments dialogue Close Descendants Each time you drill down into a report a new window is opened showing the information for the drill down All of these windows known as descendants remain open to allow you to move between them Use this option to close down all descendants that have been opened and return to the original report display when you have finished Close Report and Descendants As Close Descendants except the Report is also closed DREAM Reporting Manual 4 Page 5 of 23 The University of Hull DREAM USER MANUAL 2 STANDARD REPORTS AVAILABLE The list below shows the standard reports available in Dream You may not have access to all the reports this depends upon the menu security that has been applied e Account report Document Report Ledger List Report Nominal Detail Report Order Report 2 1 Account Report
18. mited to your permissions fhange Selection Criteria Refresh F5 Colour Font Printer Fone Show Totals Columns Column Order Sort By Sort By Column k Recalculate Running Totals Restore Default Column Order Save Report Settings Comments Global Comments Close Descendants Close Report and Descendants Close Report and Antecedents e Change Selection Criteria Amend the report that you are using to create an amended report e Refresh Refresh the report to update the display to reflect changes to the content e Columns Allows selection of columns to include in the report Can save as a default setting DREAM Reporting Manual 4 Page 4 of 23 The University of Hull DREAM USER MANUAL Recalculate Running Total If you have sorted the report into another order after you have run it this will recalculate the running total to the new order Restore Default Column Order If you have changed the order of columns use this option to return the data to the default setting Save Report Settings You can save the settings with a name for later use Version 3 2 Release 2 has been enhanced to allow you to run saved reports settings via a new menu option Run Saved Report This functionality does not support running reports saved by other users If you wish to do this you must access the Report dialog tick the Show settings created by other users checkbox and select the saved setting from the Pr
19. mmary information Report title information Document type information and Transaction Type Column titles pb Example Nominal Detail Report 4 d omin Detail Report INO 1850001 158 S QUADROMA SOCIATION Transaction Type ACTUAL Period Doc Type Doc No Account Value Status Balance Description Account information for selected accounts Report title information Account information for first account and transaction type Column Titles Account document lines pg s DREAM Reporting Manual 4 ser Field 2 T x Acc Curr Transaction Type Biel E Llser Field 3 Page 3 of 23 The University of Hull DREAM USER MANUAL 1 2 Report Navigation You can navigate using the navigation icons if you choose not to combine in one window Go to the first last item on the report Move backward forwards several items in the report Go the previous next item in the report rie iit 1 3 Drill down Allows you to easily locate the underlying information that you are interested in Dream allows you to drill down into reports to the lowest level of sub analysis if you wish to investigate an item listed You drill down on a transaction by double clicking on the line on the report you require further information on 14 Reports Menu The Report menu is a standard list of options available in all reports and can be accessed from the menu bar or by right click of the mouse over the body of an open report Access will be li
20. n select codes by the Research Groups see indices manual 5 DREAM Reporting Manual 4 Page 7 of 23 The University of Hull DREAM USER MANUAL 6 b BS IIA Rel Nom You can select codes by either nominal code which are Balance Sheet Income in Advance by typing in 1 1A or Balance sheet Release nominal codes IE Nominal You can select to run I amp E nominal codes by putting in a K or Balance Sheet nominal codes only by putting in NO VALUE in the from Box Campus You can select codes by either Hull campus by selecting H or Scarborough by selecting S Reporting2006 You can select last years Reporting Area see indices manual 5 You can run each analysis code for a single code or a range of codes using the to and from boxes Unlike the indices you can use multiple analyses on each report this give you more flexibility If you use this option the title button becomes Analysis All Values This enables you to put restrictions on the balances on either total balance or individual transactions in the report If you use this option the title of button becomes Values If you want to run a new report or wonder why no information has appear on a report you will need to check that you have not got anything in these options from previous reports Document Type The default is for all document types but you can select a single document type of document type group Sub Totals Reports may be created with Sub Totals by Document
21. pes budget e Ledger Enter the Ledger on which the report is to be based DREAM Reporting Manual 4 Page 6 of 23 The University of Hull DREAM USER MANUAL NO Ledger Accounts to Enter the inclusive range of accounts you want to include in the report Entering an account in the first field produces a report for that account only Entering an account In the to field produces a report of all accounts up to and including that account Leave both fields blank for all Ledger accounts Nominal Accounts to Enter the inclusive range of nominals you want to include in the report Entering a nominal in the first field produces a report for that nominal only Entering a nominal in the to field produces a report of all nominals up to and including that nominal Leave both fields blank for all nominals Periods to Enter the inclusive range of periods you want to include in the report Entering a period in the first field produces a report for that period only Entering a period in the to field produces a report of all periods up to and including that period Leave both fields blank for all periods note that leaving them blank will include the Register periods ARCH and XFAC in your selection Document Date to Enter the inclusive range of document dates you want to include in the report Entering a document date in the first field produces a report for that document date only Entering a document date in the
22. rd Balance Check this box to show Brought Forward and Carried Forward totals when reporting on a single period or on a range of periods e Allocate Check this box to enable Allocation as soon as the report is displayed e Unallocated Items Only Check this box to report on Unallocated items only e Currency This field is used if you have a requirement to produce reports for Nominals and or Accounts in a specific currency e Select Nominals By Dream indices may be used to facilitate Nominal selection They will be listed in the drop down A range of index items can be entered in the Nominal box es e Select Accounts By Dream indices may be used to facilitate Account selection They will be listed in the drop down A range of index items can be entered In the Account box es e Dispute Items Items may be flagged as in Dispute from the Nominal Detail Report by selecting the line and choosing Account Dispute Item from the menu DREAM Reporting Manual 4 Page 10 of 23 The University of Hull DREAM USER MANUAL 24 Order Report Used to view an order Purchase Orders are transferred from the Purchasing system QORD and Sales Orders SORD were used prior to the Dream Upgrade SOIN SORD No 30085 Select either B Options Order Report from the menu bar or CtrIL rder Report x Previous Settings Oh Show settings created by other users Order Type GORD Number o Order Dates to Supplier Ledger
23. reporting on has being raised by someone else you will need to select their userid or AI e Show Complete Full Descriptions Ensure this is ticked will show the line descriptions that appear on the invoice e Select Orders with Status You can select either all order statuses or a particular status 1 e invoiced DREAM Reporting Manual 4 Page 11 of 23 The University of Hull DREAM USER MANUAL e Show Header Rows This will default to All we recommend you leave this as the default When you have the selection criteria you require press OK Order Report OF x1 Order Type QORD Authorised By All Mo 14101 Account GUIDODT UserField 1 Product Description Quantity Unit Price Total Price Total Grand Total Purchase Orders Once you have run the report you can customise it by adding and removing columns Right click and select columns Ensure that User Fieldl is in the report and the order number will also be displayed You will be able to see the status of the order authorised delivered invoiced etc and 1f you put your cursor on the order line and double click a pop up box will be displayed and you can look at the invoice details that relate to this order Sales Orders Once you have run the report you can customise it by adding and removing columns Right click select columns and ensure that User Field 2 delivery date amp User Field 3 VAT figure are in the report for information DREAM Reporting
24. s Cancel If you are copying into an existing spreadsheet Use the Browse button to find the file you have set up You can select the sheet you wish to place the data on Data Sheet and the cell Cell Press ok and Excel will open the pre named file and will copy the data in Do not touch the Excel file while it is copying in The last thing that is done is the fields re size once this is done the copy is complete If you are copying the data into a brand new blank spreadsheet just press ok and Excel will open with a new workbook and sheet and data will be copied in DREAM Reporting Manual 4 Page 14 of 23 The University of Hull DREAM USER MANUAL 4 STATUS OF PAYMENTS Dream enables you to check the status of payments to a Supplier or from a Customer Run a Nominal Detail Report or Account Report in the normal way Drill down on the Supplier or Customer invoice you wish to enquire on to view the Document Report The Document Report Status column will advise you whether the invoice has been paid Status O Open this invoice has not yet been paid Status P Paid this invoice has been paid Unpaid Invoice This invoice has not yet been paid it has a status of O Each Supplier Invoice has a due date on usually the last day of the month The invoice will be paid within 2 working days of the end of the month By seledting the Due date column in your report you can clarify when payment will be made Document Report
25. to field produces a report of all document dates up to and including that document date Leave both fields blank for all document dates Summary Only Check this box if you want to see a summary by account only Combine in One Window If checked the nominal account document sets will be combined in a single report If not you will need to use the navigation buttons detailed above Show Accounts with No Details Check this box to include all nominals accounts whether or not they have details attached Show Currency for Each Detail Check to show the currency symbol associated with the detail value in the report Show Alternative Home Values Not used at present Show Details For Ledger reports on standard ledgers and Second Ledger reports on a second ledger All Analysis This enables you to run reports using further analysis other than just the full Nominal code or Account Code There are 10 analyses available but we currently only use 9 They are Reporting Area You can specify a current year Reporting Area see indices manual 5 Ist five digits of nominal Codes You can select codes by the first five digits of the Nominal Sub Department e g AAAOO Last five digits of nominal Codes You can select codes by the last five digits of the Nominal category Eg FAQ31 6 and 7 digit of nominal codes You can select codes by the 6 and 7 digits of the nominal Category Grouping e g FA Office Costs Research Groups You ca
26. unt Code Change the period Sub Totals UseFied2 range as required Show Only Items with Status Alllems gt Selection Sort Order Date Document type Document number LK Cancel The report produced selects all TUIT Tuition Fee documents for the period ledger and account 1 s selected The results are sub totalled by the entries in User Field 2 Programme of Study DO DREAM Reporting Manual 4 Page 17 of 23 The University of Hull DREAM USER MANUAL NOT CHANGE ANY OF THE OTHER REPORT SETTINGS BEFORE CLICKING ON OK The report produced is as displayed below SQ05001 Tuition Fees by POS Oe x IFL ROBOO CORE ILC MBA HULL Periods 2003 00 to 2003 05 Subtotal by user field 2 All Values Date n LIES Doc Type Dor No Value LserField 1 User Field 2 FL ROBOO2 CORE IL Running Tuition Fees by Account 1 by Student Number Select the Account Report icon green on the toolbar Tick the box Show settings by other users Select SQSO001 Tuition Fees by Student The only fields that require amending are the ledger account period from and period to The report produced selects all TUIT Tuition Fee documents for the period ledger and account 1 s selected The results are sub totalled by the entries in User Field 1 Student Number DO NOT CHANGE ANY OF THE OTHER REPORT SETTINGS BEFORE CLICKING ON OK The report produced is as displayed below DREAM Reporting Manual 4 Page 18 of 23 DR

THE UNIVERSITY OF HULL

Contents

Download Pdf Manuals

Related Search

Related Contents