Running Financials and SCM Reports


In this topic, you will learn how to run a closing trial balance.


Steps:

  1. Begin by navigating to the Closing Trial Balance page.

     

    Click the Main Menu button.

    Step 1

  2. Click the General Ledger menu.

    Step 2

  3. Click the Close Ledgers menu.

    Step 3

  4. Click the Closing Trial Balance menu.

    Step 4

  5. You can run this report by searching for an existing Run Control ID or you can add a new value. Creating a Run Control ID that is relevant to the report may help you remember it for future use.

    Step 5

  6. Click the Add a New Value tab.

    Step 6

  7. A Run Control ID is an identifier that uniquely identifies and defines parameters that are used when a process is run.

     

    Enter the desired information into the Run Control ID field. Enter

     a valid value
     e.g.
     "RUN_CLS_TB0"
    .

    Step 7

  8. Click the Add button.

    Step 8

  9. Enter the desired information into the Fiscal Year field.

     

    Enter "2015".

    Step 9

  10. Click the Run button.

    Step 10

  11. Use the Process Scheduler Request page to enter or update parameters, such as server name and process output format.

    Step 11

  12. Click the Server Name list.

    Step 12

  13. Click the PSUNX list item.

    Step 13

  14. Use the Run Date field to specify the date you want the process to run. This gives you the ability to set a report to run on a future date.

    Step 14

  15. Use the Run Time field to specify the time you want the process to run. This gives you the ability to set a report to run at a future time.

    Step 15

  16. Use the Reset to Current Date/Time button to reset the Run Date and Run Time to the present date and time.

    Step 16

  17. Use the Type list to select the type of output you want to generate for this job.

     

    Your four choices are:

     

        *File: This enables you to write the output to a file that will appear in the output destination.

        *Printer: You can enter a custom printer location if you have the appropriate security access.

        *Email: You can enter the destination information to send to a particular email recipient(s). Note that Email is available only for SQR and PS/nVision.

        *Web: Sends all output of the process to the report repository, including log and trace files.

    Step 17

  18. Use the Format list to define the output format for the report.

    Step 18

  19. Click the OK button.

    Step 19

  20. Notice that this process has been assigned a Process Instance number. This number can be used to track this process.

    Step 20

  21. Now that you have used the process scheduler to run your report, you will use Process Monitor to monitor the status of your report.

     

    You use the Process Monitor to:

    • Check the status of your submitted process requests.

    • Cancel process requests that have been initiated.

    • Hold process requests that are queued.

    • Queue process requests you have put on hold.

     

    Step 21

  22. Click the Process Monitor link.

    Step 22

  23. Use the Process List page to view the status of submitted report/process requests.

    Step 23

  24. Currently, our report has a Run Status of "Queued".

     

    Click the Refresh button to view the updated status.

    Step 24

  25. Clicking the Details link in the opens the Process Detail page where you can view details such as request parameters and message logs.

     

    Click the Details link.

    Step 25

  26. Click the Parameters link to view additional information about the process parameters, such as runtime variables, the path used to run the process request, the location of the completed output, etc.

    Step 26

  27. Click the Message Log link to view messages that are inserted by the process request.

    Step 27

  28. Click the OK button.

    Step 28

  29. Click the Go back to Closing Trial Balance link.

    Step 29

  30. The Report Manager is like your own personal inbox of reports and process output. It provides a secured means to view report content, check the posting status, and see content detail messages.

    Step 30

  31.  

    Click the Report Manager link.

    Step 31

  32. The List page displays the reports from multiple databases to which you have access. This page lists reports when the distribution agent has posted the report to the repository and the report folder table.

    Step 32

  33. The Explorer page displays a hierarchical view of folders and reports. This page lists reports when the distribution agent has posted the report to the repository and the report folder table.

    Step 33

  34. You use the Administration page to view the report, view details about the report, and delete unwanted reports from the system. New reports that have been scheduled or are in the process of being posted to the report repository can be viewed only through the Administration page.

    Step 34

  35. Click the Administration tab.

    Step 35

  36. The Closing Trial Balance Report with the instance number 20868 is at the top of the list, and the Status is "Posted".

    Step 36

  37. Because the Status is "Posted", the report can be viewed.

     

    Click the Details link.

    Step 37

  38. The filename contains the process name followed by the process instance number.

     

    Once you click the link, the report will be displayed in an additional browser window. From there, you can review and even print the report.

    Step 38

  39. Click the OK button.

    Step 39

  40. If you are authorized to delete a report, the Select check box will be active. This enables you to select the report and then click the Delete button to remove the report from the list.

    Step 40

  41. Click the Save button.

    Step 41

  42. Click the Home link.

    Step 42

Congratulations, you successfully learned how to run financials and SCM reports.

Table of Contents  Start Topic