General Ledger > Financial Reporting > GL XML Report Viewer

GL XML Report Viewer

You use this program to view any web page or XML document, but it is specifically designed to work with XML documents created from the GL Financial Report Writer.

If you created a XML report using the GL Financial Report Writer (GL Define Financial Reports) then you can view the report, execute the report, perform in-line editing and use the drill down features.

GL XML Report Browser

When you run the program, the GL XML Report Browser screen is displayed enabling you to select the report you want to view.

The screen displays XML reports created using the GL Define Financial Reports program and saved to the default ...\Base\FinancialReportsXml\ directory on the server.

You can close this screen and select the Open option from the File menu to enter the full path name of the report you want to view if it was not saved to the default ...\Base\FinancialReportsXml\ directory.

Once a report is selected, its details are displayed in the tri-pane GL XML Report Viewer screen.

The GL XML Report Browser window is also displayed when you select the GL XML Report Browser icon from the GL XML Report Viewer screen.

GL XML Report Viewer

Field Description
GL XML Report Browser Opens the GL XML Report Browser screen.
Open report

Indicate the xml report you want to view. The full pathname must be entered.

If you open an XML report you created using the GL Financial Report Writer, then the report is displayed in the left-hand pane. Additionally, if you selected the option to Drill down to the ledger accounts, transactions and source documents when you created the report, then these details can be displayed in the two right-hand panes.

Execute report Runs the report.
Print Prints the contents displayed in the left hand pane.

Notes and warnings

Restrictions and limits

  • The footer information included on the report (when printed) is not controlled by SYSPRO, but by the browser used to view the report. It can, therefore, not be removed by SYSPRO.

Drill down considerations

The following considerations apply to XML reports created using the GL Define Financial Reports program:

  • Only one drill down can be used for a report with more than one column.

    In this case, the drill down information is displayed for the lowest and highest range of all the columns requested.

    For example, if you requested movements for periods 1-6 in one column and movements for periods 7-12 in another column, then the drill down displays all movements for periods 1-12.

  • Drill down results displayed in the Details pane will always only be for a single Year as follows:

    • If the report has no run-time prompt for the Year, then the information displayed is always for the Current Year.

    • If the report has a single run-time prompt for the Year, then the information displayed is for the Year indicated at that run-time prompt.

    • If the report has multiple run-time prompts for the Year, then the information displayed is for the oldest Year indicated at the run-time prompts.

  • Drill downs are not related to the column details selected in the Browser pane (i.e. the same drill down details are displayed, irrespective of the column selected in the Browser pane).

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operators program.

Activity Description
SYSPRO Browser - Manual URL address entry

Controls whether an operator can use the File Open option to manually enter an URL address when using the SYSPRO browser or to enter a URL address by selecting the Browse icon.

When denied, the operator cannot access the Internet using:

  • the File Open option from the SYSPRO Main Menu (SYSPRO Online option)

  • the SYSPRO Help (SYSPRO on the Web option)

  • the RW XML Report Viewer program

  • the GL XML Report Viewer program

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.