The Budget vs forecast for Period 2017-XXX screen will open. Select ‘Alternate Layout’ The report will be returned in the following layout: 4. Add fields to your report Additional fields can now be drawn into the report. Available fields to add to the report are shown under the ‘Free characteristics’ heading on the left of the screen. Left-click on a variable you would like to bring into the report, and drag it between the appropriate columns, until you see a vertical black line appear. Then drop. 5. Drill down to actual line items If you would like to drill down into an amount on the report, right-click on the amount, then select ‘Goto’, followed by ‘Actual Transactions’. The Actual Transactions – Drill Through screen will open in a new tab. If there is more than one page, use the arrows at the bottom of the page to move to the next page. You can draw additional fields (‘Free characteristics’) into this report. To do this, see step 4. To remove unwanted columns (e.g. before printing) left-click on the column name (e.g. ‘cost centre’) and drag it into the ‘free characteristics’ section on the left-hand side of the screen.
Add fields to your report You can bring additional fields into your report. Available fields are shown under the Free characteristics heading on the left of the screen. Click and drag the item you would like included in your report, and drop the field between the appropriate columns (where you see a vertical black line appear). Drill through to accounting document From the actual transactions report, you can drill through to view the details of an individual accounting document. To do this, hover your cursor over the Document Ref Number of the line you would like to drill through on and click the right mouse button. A menu will be returned. Select Goto, followed by Accounting Document. Note: you cannot drill through to the accounting document for payroll or purchase order related postings i.e. document types WE (goods receipt) RN (supplier invoice prior IBC) ZN (supplier invoice IBC), AB (accounting doc). Drill through to purchase order details You can also drill through to view details of a purchase order. To do this, click the right mouse button over the PO Number you would like to drill down on. A menu will be returned. Select Goto, followed by PO Details. Drill through to purchasing history From the Purchase Order Line Items report (above) you can drill through further to view goods receipts and invoices against individual purchase lines. To do this, click the right mouse button on the PO Doc Number you would like to drill down on. Select Goto, followed by Purchasing History.
If there is more than one page on the report, use the arrow buttons at the bottom left of the window to scroll to the subsequent pages. Sorting You can now sort each cost element group into alphabetical order. Left click on ‘cost element group’ and drag the column to the left of the report until you see the black line appear before ‘cost centre‘ field, then drop. Left click on ‘name’ and drag the column to the left of the report until you see the black line appear before the ‘employee’ field. The headings on the report should then show as: Cost Element Group – Cost Centre – Name - Employee If you run the report on your cost centre group and sort the cost element group into alphabetical order, your report will return data for all cost centres under each cost element group. To sort employees into alphabetical order within the cost element groups, right click on the word ‘result’ then select ‘properties’ ‘characteristic’. The following screen will be returned: In the ‘Display Results’ drop down, select ‘Never’, then click OK.