Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Running Reports On Journal Entries

Your responsibilities may include examining a list of all consolidating and adjustment journal entries to check General Ledger numbers against those in the corporate system. If many changes have been made to the General Ledger numbers, you may find it useful to examine printed reports on the journal entries.

Types of journal entry reports

Journal entry reports fall into two categories and can provide differing levels of details:

JE report type Description
Standard Reports that are commonly used by most organizations in their journal entry reporting. These reports are predefined and allow for little modification.
Ad hoc Reports based on your current selections in the Results tab. You must first run a query and select the journal entries for your ad hoc report. You select the appropriate columns and headings.

You can select from the following levels of detail for your journal entry reports:

Level of detail for reports Description
Detailed To retrieve more detailed journal entry information, such as the entities and accounts associated with the journal entry.
Detailed with Schedule Details To retrieve more detailed journal entry information for journal entries associated with a schedule, such as schedule details, entities, and accounts associated with the journal entry.
Summary To retrieve the summary journal entry information, such as the JE ID and debit and credit amounts.
Transaction To retrieve all journal entry details involving specified accounts and entities.

Running standard journal entry reports

Standard reports are preconfigured reports commonly used by most organizations in their journal entry reporting. These reports are predefined and allow for little modification.

Running a standard detailed journal entry report

A standard detailed report is a report for a journal entry in which each page of the report contains all the accounts for the journal entry.

To run a standard detailed report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Detailed.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information if you want.

  4. In the Settings area, complete these fields:

    1. Category: Select one of the following:

      • All — To run a report for all types of journal entries.
      • Standard — To run a report for Standard journal entries only.
      • Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
      • System — To run a report for system journal entries only.
      • Any System subcategory — To run a report for System journal entries belonging to a subcategory.

    2. JE ID: Select one of the following:

      • All JEs by Time Period — To run a report on JEs in a specific time period symbol, select this field.
      • Specify JE ID — To run a report for a specific JE, type the JE ID in this field.
    3. Time Period: Select one of the following:
      • Creation Period — To run the report on JEs created in a certain time period. Select the time period symbol for the report.
      • Post Period — To run the report on JEs posted in a certain time period. Select the time period symbol for the report.
    4. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:
      • Do not include deleted JEs — To omit deleted JEs from the report.
      • Include deleted JEs — To include deleted JEs in the report.
      • Show only deleted JEs — To show only deleted JEs in the report.
  5. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  6. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    A screenshot of a computer Description automatically generated with medium confidence

    For viewing options, see Viewing and saving journal entry reports.

Running a standard detailed with schedule details journal entry report

A standard detailed with schedule details report is a report for a journal entry containing schedule details in which each page of the report contains all the accounts for the journal entry.

To run a standard summary report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Detailed with Schedule Details.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  4. In the Settings area, complete these fields:

    1. Category: Select one of the following:

      • All — To run a report for all types of journal entries.
      • Standard — To run a report for Standard journal entries only.
      • Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
      • System — To run a report for system journal entries only.
      • Any System subcategory — To run a report for System journal entries belonging to a subcategory.
    2. JE ID: Select one of the following:
      • All JEs by Time Period — To run a report on JEs in a specific time period symbol, select this field.
      • Specify JE ID — To run a report for a specific JE, type the JE ID in this field.
    3. Time Period: Select one of the following:
      • Creation Period — To run the report on JEs created in a certain time period. Select the time period symbol for the report.
      • Post Period — To run the report on JEs posted in a certain time period. Select the time period symbol for the report.
    4. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:
      • Do not include deleted JEs — To omit deleted JEs from the report.
      • Include deleted JEs — To include deleted JEs in the report.
      • Show only deleted JEs — To show only deleted JEs in the report.
  5. In the Schedule Detail Options area, clear the Include Base Details check box if you do not want base details included in the report.
  6. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  7. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    For viewing options, see Viewing and saving journal entry reports.

Running a standard summary journal entry report

A standard summary report is a report for an account in which each page of the report contains a leaf symbol for the account in a particular entity.

To run a standard summary report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Summary.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  4. In the Settings area, complete these fields:

    1. Category: Select one of the following:

      • All — To run a report for all types of journal entries.
      • Standard — To run a report for Standard journal entries only.
      • Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
      • System — To run a report for system journal entries only.
      • Any System subcategory — To run a report for System journal entries belonging to a subcategory.

    2. Entity Names: Select the entity symbol or symbols for the report. For more information, see step 5 and step 6.

    3. Account Names: Select the account symbol or symbols for the report. For more information, see step 7 and step 8.

    4. Time Period: Select one of the following:

      • Creation Period — To run the report on JEs created in a certain time period. Select the time period symbol for the report.
      • Post Period — To run the report on JEs posted in a certain time period. Select the time period symbol for the report.

    5. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:

      • Do not include deleted JEs — To omit deleted JEs from the report.
      • Include deleted JEs — To include deleted JEs in the report.
      • Show only deleted JEs — To show only deleted JEs in the report.

  5. To select an entity symbol, click Browse. The Symbol Selection dialog opens.

    Graphical user interface, text, application Description automatically generated

  6. To select a symbol for the report, navigate through the hierarchy.
    1. When you find the symbol or symbols for the report, double-click the symbol or use the arrow buttons to move the symbols to the Selected Symbols list.
    2. When you are done, click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
    3. Click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
  7. To select a symbol in the ACCOUNTS dimension, click Browse. The Symbol Selection dialog opens.
  8. Repeat step 6.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  10. Click Run Report. The JE Summary Report - Print Preview dialog opens, from which you can view, print, and save the report.

    Table Description automatically generated

    For viewing options, see Viewing and saving journal entry reports.

Running a standard transaction journal entry report

A standard transaction report is a report for an entity in which each page of the report contains each account symbol for an entity.

To run a standard transaction report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Transaction.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  4. In the Settings area, complete these fields:

    1. Use: To display the journal entry ID in the report, select JE ID. To display the app ID in the report, select App ID.

    2. Sub-Total By: To run the report to make sub-totals by accounts, select Account. To run the report to make sub-totals by JE ID, select JE ID.

    3. Category: Select one of the following:

    4. All — To run a report for all types of journal entries.
    5. Standard — To run a report for Standard journal entries only.
    6. Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
    7. System — To run a report for system journal entries only.
    8. Any System subcategory — To run a report for System journal entries belonging to a subcategory.

    9. Entity Names: Select the entity symbols for the report, delimited by a comma. The symbols may be parent symbols or leaf symbols. For more information, see step 5.

    10. Account Names: Select the account symbols for the report, delimited by a comma. The symbols may be parent symbols or leaf symbols. For more information, see step 7.

    11. Time Period: Select one of the following:

    12. Creation Period — To run the report on journal entries created for a certain time period. Select the time period symbol for the report.
    13. Post Period — To run the report on journal entries posted to a certain time period. Select the time period symbol for the report.

    14. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:

    15. Do not include deleted JEs — To omit deleted JEs from the report.
    16. Include deleted JEs — To include deleted JEs in the report.
    17. Show only deleted JEs — To show only deleted JEs in the report.

  5. To select an entity symbol, click Browse. The Symbol Selection dialog opens.

    Graphical user interface, text, application Description automatically generated

  6. To select a symbol for the report, navigate through the hierarchy.
    1. When you find the symbol or symbols for the report, double-click the symbol or use the arrow buttons to move the symbols to the Selected Symbols list.
    2. When you are done, click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
    3. Click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
  7. To select a symbol in the ACCOUNTS dimension, click Browse. The Symbol Selection dialog opens.
  8. Repeat step 6.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  10. Click Run Report. The JE Transaction Report - Print Preview dialog opens, from which you can view, print, and save the report.

    A screenshot of a computer Description automatically generated with low confidence

    For viewing options, see Viewing and saving journal entry reports.

Running ad hoc journal entry reports

An ad hoc report is a report based on your current journal entry selections in the Results tab. You can select the appropriate columns and headings.

Running an ad hoc detailed journal entry report

You may want to run a report for a particular set of journal entries based on your specific needs. To do so, run an ad hoc detailed report.

To run an ad hoc detailed report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Query tab.
  2. Retrieve the journal entry. For more information, see Retrieving all journal entries, or Retrieving selected journal entries. The Longview Journal Entries dialog opens with the Results tab in view.
  3. Select the journal entries to include in the report.
  4. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  5. Complete these fields:

    1. Report Type: Select Ad Hoc.

    2. Level of Detail: Select Detailed.

  6. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  7. In the Select Fields for Header of Detailed Report area, complete these fields. This information is retrieved from the Header tab of the Edit a JE dialog.

    1. Date/Time: Includes the date and time in the report.

    2. JE Type: Includes the type of journal entry in the report.

    3. Creator: Includes the name of the journal entry creator in the report.

    4. JE Attributes: Includes journal entry attributes in the report.

    5. Status: Includes the status of the journal entry in the report.

      Note: Status also filters the selected journal entries to include only those that match the selected status.

    6. User Name: Includes the username of the report creator in the report.

    7. Creation Period: Includes the creation period in the report.

    8. Description: Includes the description for the journal entry in the report.

    9. Created Date: Includes the created date for the journal entry in the report.

    10. Last Modified: Includes the last modified date in the report.

    11. User Description: Includes the user description for the username that created the journal entry in the report.

    12. Posting Period: Includes the posting period in the report.

    13. Notes: Includes notes in the report.

    14. Application ID: Includes the Application ID in the report.

    15. Subcategory: Includes the Subcategory in the report.

    16. All: Includes all information in the report.

  8. In the Select Fields for Columns of Detailed Report area, select the symbol names and descriptions for the dimensions in the report. Account Name and Account Description are selected by default, and at least one Account field must remain selected for the report to run.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Break Page By: Specifies page break rules for the report. Select one of the following:

    3. JE ID — To break pages by JE ID.
    4. Page — To use standard page breaks.

    5. Page Number: Includes page numbers in the report.

    6. Thousands Separators: Includes thousands separators in the report.

    7. Footer: Adds a footer to the report.

    Note: Your tab may look different. The available dimensions are dependent on your Longview database.

  10. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    Table Description automatically generated

    For viewing options, see Viewing and saving journal entry reports.

Running an ad hoc detailed with schedule details journal entry report

You may want to run a report for a particular set of journal entries containing schedule details based on your specific needs. To do so, run an ad hoc detailed with schedule details report.

To run an ad hoc detailed report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Query tab.
  2. Retrieve the journal entry. For more information, see Retrieving all journal entries, or Retrieving journal entries. The Longview Journal Entries dialog opens with the Results tab in view.
  3. Select the journal entries to include in the report.
  4. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  5. Complete these fields:

    1. Report Type: Select Ad Hoc.

    2. Level of Detail: Select Detailed with Schedule Details.

  6. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  7. In the Select Fields for Header of Detailed Report area, complete these fields. This information is retrieved from the Header tab of the Edit a JE dialog.

    1. Date/Time: Includes the date and time in the report.

    2. JE Type: Includes the type of journal entry in the report.

    3. Creator: Includes the name of the journal entry creator in the report.

    4. JE Attributes: Includes journal entry attributes in the report.

    5. Status: Includes the status of the journal entry in the report.

      Note: Status also filters the selected journal entries to include only those that match the selected status.

    6. User Name: Includes the username of the report creator in the report.

    7. Creation Period: Includes the creation period in the report.

    8. Description: Includes the description for the journal entry in the report.

    9. Created Date: Includes the created date for the journal entry in the report.

    10. Last Modified: Includes the last modified date in the report.

    11. User Description: Includes the user description for the username that created the journal entry in the report.

    12. Posting Period: Includes the posting period in the report.

    13. Notes: Includes notes in the report.

    14. Application ID: Includes the Application ID in the report.

    15. Subcategory: Includes the Subcategory in the report.

    16. All: Includes all information in the report.

  8. In the Select Fields for Columns of Detailed Report area, select the symbol names and descriptions for the dimensions in the report. Account Name and Account Description are selected by default, and at least one Account field must remain selected for the report to run.
  9. In the Schedule Detail Options area, complete these fields:

    1. Include Schedule Symbol Names: Includes symbol names for schedule details in the report.

    2. Include Schedule Symbol Descriptions: Includes symbol descriptions for schedule details in the report.

    3. Include Base Details: Includes base details in the report.

  10. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Break Page By: Specifies page break rules for the report. Select one of the following:

    3. JE ID — To break pages by JE ID.
    4. Page — To use standard page breaks.

    5. Page Number: Includes page numbers in the report.

    6. Thousands Separators: Includes thousands separators in the report.

    7. Footer: Adds a footer to the report.

    Note: Your tab may look different. The available dimensions are dependent on your Longview database.

  11. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    A screenshot of a computer Description automatically generated with low confidence

    For viewing options, see Viewing and saving journal entry reports.

Running an ad hoc summary journal entry report

An ad hoc summary report is a report for a particular journal entry in which each page of the report contains all the details of the journal entry.

To run an ad hoc summary report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Query tab.
  2. Retrieve the journal entry. For more information, see Retrieving all journal entries, or Retrieving journal entries. The Longview Journal Entries dialog opens with the Results tab in view.
  3. Select the journal entries to include in the report.
  4. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  5. Complete these fields:

    1. Report Type: Select Ad Hoc.

    2. Level of Detail: Select Summary.

  6. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  7. In the Select Fields for Header of Detailed Report area, complete these fields. This information is retrieved from the Header tab of the Edit a JE dialog.

    1. Date/Time: Includes the date and time in the report.

    2. JE Type: Includes the type of journal entry in the report.

    3. Creator: Includes the name of the journal entry creator in the report.

    4. JE Attributes: Includes journal entry attributes in the report.

    5. Status: Includes the status of the journal entry in the report.

      Note: Status also filters the selected journal entries to include only those that match the selected status.

    6. User Name: Includes the username of the report creator in the report.

    7. Creation Period: Includes the creation period in the report.

    8. Description: Includes the description for the journal entry in the report.

    9. Created Date: Includes the created date for the journal entry in the report.

    10. Last Modified: Includes the last modified date in the report.

    11. User Description: Includes the user description for the username that created the journal entry in the report.

    12. Posting Period: Includes the posting period in the report.

    13. Notes: Includes notes in the report.

    14. Application ID: Includes the Application ID in the report.

    15. Subcategory: Includes the Subcategory in the report.

    16. All: Includes all information in the report.

  8. In the Select Fields for Columns of Detailed Report area, select the symbol names and descriptions for the dimensions in the report. Account Name and Account Description are selected by default, and at least one Account field must remain selected for the report to run.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Break Page By: Specifies page break rules for the report. Select one of the following:

    3. JE ID — To break pages by JE ID.
    4. Page — To use standard page breaks.

    5. Page Number: Includes page numbers in the report.

    6. Thousands Separators: Includes thousands separators in the report.

    7. Footer: Adds a footer to the report.

    Note: Your tab may look different. The available dimensions are dependent on your Longview database.

  10. Click Run Report. The JE Summary Report - Print Preview dialog opens, from which you can view, print, and save the report.

    For viewing options, see Viewing and saving journal entry reports.

Viewing and saving journal entry reports

Once you’ve run a journal entry report, you can view it and save it.

Previewing a journal entry report

To preview a journal entry report, follow these steps.

  1. In the main Journal Entries dialog, do one of the of the following:
    • If you are running a standard report, continue to step 2.
    • If you are running an ad hoc report, retrieve the journal entries. The Longview Journal Entries dialog opens with the Results tab in view. Select the journal entries to include in the report. For more information. see Running ad hoc journal entry reports.
  2. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in step 3.

  3. Run the report, as described in Running standard journal entry reports. The Print Preview dialog opens.

    Note: In a report, deleted journal entries are identified with (Del) beside their JE ID.

  4. To make the report more legible, do any of the following:
    • Use the scroll bars to view the entire report.
    • Resize the dialog by clicking and dragging.
    • For View Mode, select Without Page Break to view the entire report on one screen, or select With Page Break to view the report on multiple pages.
  5. If the report contains multiple pages, click the arrow buttons in the upper-left corner of the report screen to view other pages.
  6. If you’re happy with the report, proceed to saving and printing it.

Saving a journal entry report

When you’re happy with the appearance and contents of a report, you can save it as a .txt, .png, or .pdf file.

To save a journal entry report, follow these steps.

  1. To save the report, choose File > Save. The Save dialog opens.

    Graphical user interface, text Description automatically generated

  2. Select a folder. By default, journal entry reports are saved to the following location: C:\ProgramData\Longview\SystemName\data\Longview Journal Entries
  3. Type a name for the report.
  4. Click Save. The report print preview dialog reappears.
  5. When you’re finished, click Close. The Longview Journal Entries dialog opens with the Reports tab in view.

Printing journal entry reports

When you’re happy with the appearance and contents of a report, you can print it.

Specifying print order

You may want to specify the order in which the pages of a report are printed — either from left to right, or top to bottom. Also, you can specify whether the entire contents of the report fit onto one page or not.

To specify the order in which the pages of a report are printed, follow these steps.

  1. Run the report, as described in Running standard journal entry reports or Running ad hoc journal entry reports. The report opens in print preview format.

  2. Choose File > Print Option. The Print Option dialog opens.

  3. Complete these fields:

    1. Print Order: Select the direction in which you want to print the report.

    2. Adjust to: Select the print size in the report as a percentage of the normal size.

    3. Fit to: Select this field to have the entire contents of the report fit into the number of pages you specify in the corresponding fields.

  4. To see what the report looks like when it is printed, click OK. The report view appears showing your changes.

Specifying printer options

You can specify printer settings for reports — page width, page orientation, printer tray to use, and so on. You specify printer options in the Page Setup dialog.

To specify your printer options, follow these steps.

  1. Run the report, as described in Running standard journal entry reports or Running ad hoc journal entry reports. The report opens in print preview format.

  2. In the Print Preview dialog, choose File > Page Setup. The Page Setup dialog opens.

  3. Complete these fields:

    1. Size: Select the paper size for the report.

    2. Source: Select the printer paper tray containing the correct paper for the report.

    3. Orientation: Select an orientation for the report.

    4. Margins (inches): Specify the top, bottom, left, and right margins for the report.

  4. When you are satisfied with the printer settings, click OK. The report view appears. Proceed to Printing a report.

Printing a report

Once you have prepared your report, you can print it. Before you do, make sure you have specified your printer options. For more information, see Specifying printer options.

To print a report, follow these steps.

  1. In the Print Preview dialog, choose File > Print. The Print dialog opens.

    Graphical user interface Description automatically generated

  2. Specify your printing options as required.
  3. Click OK. Your report is printed, and the report view appears.
Published:

Running Reports On Journal Entries

Your responsibilities may include examining a list of all consolidating and adjustment journal entries to check General Ledger numbers against those in the corporate system. If many changes have been made to the General Ledger numbers, you may find it useful to examine printed reports on the journal entries.

Types of journal entry reports

Journal entry reports fall into two categories and can provide differing levels of details:

JE report type Description
Standard Reports that are commonly used by most organizations in their journal entry reporting. These reports are predefined and allow for little modification.
Ad hoc Reports based on your current selections in the Results tab. You must first run a query and select the journal entries for your ad hoc report. You select the appropriate columns and headings.

You can select from the following levels of detail for your journal entry reports:

Level of detail for reports Description
Detailed To retrieve more detailed journal entry information, such as the entities and accounts associated with the journal entry.
Detailed with Schedule Details To retrieve more detailed journal entry information for journal entries associated with a schedule, such as schedule details, entities, and accounts associated with the journal entry.
Summary To retrieve the summary journal entry information, such as the JE ID and debit and credit amounts.
Transaction To retrieve all journal entry details involving specified accounts and entities.

Running standard journal entry reports

Standard reports are preconfigured reports commonly used by most organizations in their journal entry reporting. These reports are predefined and allow for little modification.

Running a standard detailed journal entry report

A standard detailed report is a report for a journal entry in which each page of the report contains all the accounts for the journal entry.

To run a standard detailed report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Detailed.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information if you want.

  4. In the Settings area, complete these fields:

    1. Category: Select one of the following:

      • All — To run a report for all types of journal entries.
      • Standard — To run a report for Standard journal entries only.
      • Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
      • System — To run a report for system journal entries only.
      • Any System subcategory — To run a report for System journal entries belonging to a subcategory.

    2. JE ID: Select one of the following:

      • All JEs by Time Period — To run a report on JEs in a specific time period symbol, select this field.
      • Specify JE ID — To run a report for a specific JE, type the JE ID in this field.
    3. Time Period: Select one of the following:
      • Creation Period — To run the report on JEs created in a certain time period. Select the time period symbol for the report.
      • Post Period — To run the report on JEs posted in a certain time period. Select the time period symbol for the report.
    4. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:
      • Do not include deleted JEs — To omit deleted JEs from the report.
      • Include deleted JEs — To include deleted JEs in the report.
      • Show only deleted JEs — To show only deleted JEs in the report.
  5. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  6. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    A screenshot of a computer Description automatically generated with medium confidence

    For viewing options, see Viewing and saving journal entry reports.

Running a standard detailed with schedule details journal entry report

A standard detailed with schedule details report is a report for a journal entry containing schedule details in which each page of the report contains all the accounts for the journal entry.

To run a standard summary report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Detailed with Schedule Details.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  4. In the Settings area, complete these fields:

    1. Category: Select one of the following:

      • All — To run a report for all types of journal entries.
      • Standard — To run a report for Standard journal entries only.
      • Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
      • System — To run a report for system journal entries only.
      • Any System subcategory — To run a report for System journal entries belonging to a subcategory.
    2. JE ID: Select one of the following:
      • All JEs by Time Period — To run a report on JEs in a specific time period symbol, select this field.
      • Specify JE ID — To run a report for a specific JE, type the JE ID in this field.
    3. Time Period: Select one of the following:
      • Creation Period — To run the report on JEs created in a certain time period. Select the time period symbol for the report.
      • Post Period — To run the report on JEs posted in a certain time period. Select the time period symbol for the report.
    4. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:
      • Do not include deleted JEs — To omit deleted JEs from the report.
      • Include deleted JEs — To include deleted JEs in the report.
      • Show only deleted JEs — To show only deleted JEs in the report.
  5. In the Schedule Detail Options area, clear the Include Base Details check box if you do not want base details included in the report.
  6. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  7. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    For viewing options, see Viewing and saving journal entry reports.

Running a standard summary journal entry report

A standard summary report is a report for an account in which each page of the report contains a leaf symbol for the account in a particular entity.

To run a standard summary report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Summary.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  4. In the Settings area, complete these fields:

    1. Category: Select one of the following:

      • All — To run a report for all types of journal entries.
      • Standard — To run a report for Standard journal entries only.
      • Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
      • System — To run a report for system journal entries only.
      • Any System subcategory — To run a report for System journal entries belonging to a subcategory.

    2. Entity Names: Select the entity symbol or symbols for the report. For more information, see step 5 and step 6.

    3. Account Names: Select the account symbol or symbols for the report. For more information, see step 7 and step 8.

    4. Time Period: Select one of the following:

      • Creation Period — To run the report on JEs created in a certain time period. Select the time period symbol for the report.
      • Post Period — To run the report on JEs posted in a certain time period. Select the time period symbol for the report.

    5. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:

      • Do not include deleted JEs — To omit deleted JEs from the report.
      • Include deleted JEs — To include deleted JEs in the report.
      • Show only deleted JEs — To show only deleted JEs in the report.

  5. To select an entity symbol, click Browse. The Symbol Selection dialog opens.

    Graphical user interface, text, application Description automatically generated

  6. To select a symbol for the report, navigate through the hierarchy.
    1. When you find the symbol or symbols for the report, double-click the symbol or use the arrow buttons to move the symbols to the Selected Symbols list.
    2. When you are done, click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
    3. Click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
  7. To select a symbol in the ACCOUNTS dimension, click Browse. The Symbol Selection dialog opens.
  8. Repeat step 6.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  10. Click Run Report. The JE Summary Report - Print Preview dialog opens, from which you can view, print, and save the report.

    Table Description automatically generated

    For viewing options, see Viewing and saving journal entry reports.

Running a standard transaction journal entry report

A standard transaction report is a report for an entity in which each page of the report contains each account symbol for an entity.

To run a standard transaction report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  2. Complete these fields:

    1. Report Type: Select Standard.

    2. Level of Detail: Select Transaction.

  3. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  4. In the Settings area, complete these fields:

    1. Use: To display the journal entry ID in the report, select JE ID. To display the app ID in the report, select App ID.

    2. Sub-Total By: To run the report to make sub-totals by accounts, select Account. To run the report to make sub-totals by JE ID, select JE ID.

    3. Category: Select one of the following:

    4. All — To run a report for all types of journal entries.
    5. Standard — To run a report for Standard journal entries only.
    6. Any Standard subcategory — To run a report for Standard journal entries belonging to a subcategory.
    7. System — To run a report for system journal entries only.
    8. Any System subcategory — To run a report for System journal entries belonging to a subcategory.

    9. Entity Names: Select the entity symbols for the report, delimited by a comma. The symbols may be parent symbols or leaf symbols. For more information, see step 5.

    10. Account Names: Select the account symbols for the report, delimited by a comma. The symbols may be parent symbols or leaf symbols. For more information, see step 7.

    11. Time Period: Select one of the following:

    12. Creation Period — To run the report on journal entries created for a certain time period. Select the time period symbol for the report.
    13. Post Period — To run the report on journal entries posted to a certain time period. Select the time period symbol for the report.

    14. Deleted JEs: This option is available only if your system is configured to retain deleted journal entries. Select one of the following:

    15. Do not include deleted JEs — To omit deleted JEs from the report.
    16. Include deleted JEs — To include deleted JEs in the report.
    17. Show only deleted JEs — To show only deleted JEs in the report.

  5. To select an entity symbol, click Browse. The Symbol Selection dialog opens.

    Graphical user interface, text, application Description automatically generated

  6. To select a symbol for the report, navigate through the hierarchy.
    1. When you find the symbol or symbols for the report, double-click the symbol or use the arrow buttons to move the symbols to the Selected Symbols list.
    2. When you are done, click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
    3. Click OK. The Longview Journal Entries dialog opens with the Reports tab in view.
  7. To select a symbol in the ACCOUNTS dimension, click Browse. The Symbol Selection dialog opens.
  8. Repeat step 6.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Page Number: Includes page numbers in the report.

    3. Thousands Separators: Includes thousands separators in the report.

    4. Footer: Adds a footer to the report.

  10. Click Run Report. The JE Transaction Report - Print Preview dialog opens, from which you can view, print, and save the report.

    A screenshot of a computer Description automatically generated with low confidence

    For viewing options, see Viewing and saving journal entry reports.

Running ad hoc journal entry reports

An ad hoc report is a report based on your current journal entry selections in the Results tab. You can select the appropriate columns and headings.

Running an ad hoc detailed journal entry report

You may want to run a report for a particular set of journal entries based on your specific needs. To do so, run an ad hoc detailed report.

To run an ad hoc detailed report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Query tab.
  2. Retrieve the journal entry. For more information, see Retrieving all journal entries, or Retrieving selected journal entries. The Longview Journal Entries dialog opens with the Results tab in view.
  3. Select the journal entries to include in the report.
  4. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  5. Complete these fields:

    1. Report Type: Select Ad Hoc.

    2. Level of Detail: Select Detailed.

  6. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  7. In the Select Fields for Header of Detailed Report area, complete these fields. This information is retrieved from the Header tab of the Edit a JE dialog.

    1. Date/Time: Includes the date and time in the report.

    2. JE Type: Includes the type of journal entry in the report.

    3. Creator: Includes the name of the journal entry creator in the report.

    4. JE Attributes: Includes journal entry attributes in the report.

    5. Status: Includes the status of the journal entry in the report.

      Note: Status also filters the selected journal entries to include only those that match the selected status.

    6. User Name: Includes the username of the report creator in the report.

    7. Creation Period: Includes the creation period in the report.

    8. Description: Includes the description for the journal entry in the report.

    9. Created Date: Includes the created date for the journal entry in the report.

    10. Last Modified: Includes the last modified date in the report.

    11. User Description: Includes the user description for the username that created the journal entry in the report.

    12. Posting Period: Includes the posting period in the report.

    13. Notes: Includes notes in the report.

    14. Application ID: Includes the Application ID in the report.

    15. Subcategory: Includes the Subcategory in the report.

    16. All: Includes all information in the report.

  8. In the Select Fields for Columns of Detailed Report area, select the symbol names and descriptions for the dimensions in the report. Account Name and Account Description are selected by default, and at least one Account field must remain selected for the report to run.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Break Page By: Specifies page break rules for the report. Select one of the following:

    3. JE ID — To break pages by JE ID.
    4. Page — To use standard page breaks.

    5. Page Number: Includes page numbers in the report.

    6. Thousands Separators: Includes thousands separators in the report.

    7. Footer: Adds a footer to the report.

    Note: Your tab may look different. The available dimensions are dependent on your Longview database.

  10. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    Table Description automatically generated

    For viewing options, see Viewing and saving journal entry reports.

Running an ad hoc detailed with schedule details journal entry report

You may want to run a report for a particular set of journal entries containing schedule details based on your specific needs. To do so, run an ad hoc detailed with schedule details report.

To run an ad hoc detailed report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Query tab.
  2. Retrieve the journal entry. For more information, see Retrieving all journal entries, or Retrieving journal entries. The Longview Journal Entries dialog opens with the Results tab in view.
  3. Select the journal entries to include in the report.
  4. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  5. Complete these fields:

    1. Report Type: Select Ad Hoc.

    2. Level of Detail: Select Detailed with Schedule Details.

  6. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  7. In the Select Fields for Header of Detailed Report area, complete these fields. This information is retrieved from the Header tab of the Edit a JE dialog.

    1. Date/Time: Includes the date and time in the report.

    2. JE Type: Includes the type of journal entry in the report.

    3. Creator: Includes the name of the journal entry creator in the report.

    4. JE Attributes: Includes journal entry attributes in the report.

    5. Status: Includes the status of the journal entry in the report.

      Note: Status also filters the selected journal entries to include only those that match the selected status.

    6. User Name: Includes the username of the report creator in the report.

    7. Creation Period: Includes the creation period in the report.

    8. Description: Includes the description for the journal entry in the report.

    9. Created Date: Includes the created date for the journal entry in the report.

    10. Last Modified: Includes the last modified date in the report.

    11. User Description: Includes the user description for the username that created the journal entry in the report.

    12. Posting Period: Includes the posting period in the report.

    13. Notes: Includes notes in the report.

    14. Application ID: Includes the Application ID in the report.

    15. Subcategory: Includes the Subcategory in the report.

    16. All: Includes all information in the report.

  8. In the Select Fields for Columns of Detailed Report area, select the symbol names and descriptions for the dimensions in the report. Account Name and Account Description are selected by default, and at least one Account field must remain selected for the report to run.
  9. In the Schedule Detail Options area, complete these fields:

    1. Include Schedule Symbol Names: Includes symbol names for schedule details in the report.

    2. Include Schedule Symbol Descriptions: Includes symbol descriptions for schedule details in the report.

    3. Include Base Details: Includes base details in the report.

  10. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Break Page By: Specifies page break rules for the report. Select one of the following:

    3. JE ID — To break pages by JE ID.
    4. Page — To use standard page breaks.

    5. Page Number: Includes page numbers in the report.

    6. Thousands Separators: Includes thousands separators in the report.

    7. Footer: Adds a footer to the report.

    Note: Your tab may look different. The available dimensions are dependent on your Longview database.

  11. Click Run Report. The JE Detail Report - Print Preview dialog opens, from which you can view, print, and save the report.

    A screenshot of a computer Description automatically generated with low confidence

    For viewing options, see Viewing and saving journal entry reports.

Running an ad hoc summary journal entry report

An ad hoc summary report is a report for a particular journal entry in which each page of the report contains all the details of the journal entry.

To run an ad hoc summary report, follow these steps.

  1. In the main Longview Journal Entries dialog, click the Query tab.
  2. Retrieve the journal entry. For more information, see Retrieving all journal entries, or Retrieving journal entries. The Longview Journal Entries dialog opens with the Results tab in view.
  3. Select the journal entries to include in the report.
  4. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in the next step.

  5. Complete these fields:

    1. Report Type: Select Ad Hoc.

    2. Level of Detail: Select Summary.

  6. In the Header area, complete these fields:

    1. Company Name: Depending on how your Longview system is configured, the name of your company may appear automatically. If not, type it here.

    2. Title: The default title appears. You may change this information, if you want.

  7. In the Select Fields for Header of Detailed Report area, complete these fields. This information is retrieved from the Header tab of the Edit a JE dialog.

    1. Date/Time: Includes the date and time in the report.

    2. JE Type: Includes the type of journal entry in the report.

    3. Creator: Includes the name of the journal entry creator in the report.

    4. JE Attributes: Includes journal entry attributes in the report.

    5. Status: Includes the status of the journal entry in the report.

      Note: Status also filters the selected journal entries to include only those that match the selected status.

    6. User Name: Includes the username of the report creator in the report.

    7. Creation Period: Includes the creation period in the report.

    8. Description: Includes the description for the journal entry in the report.

    9. Created Date: Includes the created date for the journal entry in the report.

    10. Last Modified: Includes the last modified date in the report.

    11. User Description: Includes the user description for the username that created the journal entry in the report.

    12. Posting Period: Includes the posting period in the report.

    13. Notes: Includes notes in the report.

    14. Application ID: Includes the Application ID in the report.

    15. Subcategory: Includes the Subcategory in the report.

    16. All: Includes all information in the report.

  8. In the Select Fields for Columns of Detailed Report area, select the symbol names and descriptions for the dimensions in the report. Account Name and Account Description are selected by default, and at least one Account field must remain selected for the report to run.
  9. In the Options area, complete these fields:

    1. Decimal Zero Padding: Aligns values with different decimal places.

    2. Break Page By: Specifies page break rules for the report. Select one of the following:

    3. JE ID — To break pages by JE ID.
    4. Page — To use standard page breaks.

    5. Page Number: Includes page numbers in the report.

    6. Thousands Separators: Includes thousands separators in the report.

    7. Footer: Adds a footer to the report.

    Note: Your tab may look different. The available dimensions are dependent on your Longview database.

  10. Click Run Report. The JE Summary Report - Print Preview dialog opens, from which you can view, print, and save the report.

    For viewing options, see Viewing and saving journal entry reports.

Viewing and saving journal entry reports

Once you’ve run a journal entry report, you can view it and save it.

Previewing a journal entry report

To preview a journal entry report, follow these steps.

  1. In the main Journal Entries dialog, do one of the of the following:
    • If you are running a standard report, continue to step 2.
    • If you are running an ad hoc report, retrieve the journal entries. The Longview Journal Entries dialog opens with the Results tab in view. Select the journal entries to include in the report. For more information. see Running ad hoc journal entry reports.
  2. Click the Reports tab. The fields visible in the Reports tab depend on the selections you make in step 3.

  3. Run the report, as described in Running standard journal entry reports. The Print Preview dialog opens.

    Note: In a report, deleted journal entries are identified with (Del) beside their JE ID.

  4. To make the report more legible, do any of the following:
    • Use the scroll bars to view the entire report.
    • Resize the dialog by clicking and dragging.
    • For View Mode, select Without Page Break to view the entire report on one screen, or select With Page Break to view the report on multiple pages.
  5. If the report contains multiple pages, click the arrow buttons in the upper-left corner of the report screen to view other pages.
  6. If you’re happy with the report, proceed to saving and printing it.

Saving a journal entry report

When you’re happy with the appearance and contents of a report, you can save it as a .txt, .png, or .pdf file.

To save a journal entry report, follow these steps.

  1. To save the report, choose File > Save. The Save dialog opens.

    Graphical user interface, text Description automatically generated

  2. Select a folder. By default, journal entry reports are saved to the following location: C:\ProgramData\Longview\SystemName\data\Longview Journal Entries
  3. Type a name for the report.
  4. Click Save. The report print preview dialog reappears.
  5. When you’re finished, click Close. The Longview Journal Entries dialog opens with the Reports tab in view.

Printing journal entry reports

When you’re happy with the appearance and contents of a report, you can print it.

Specifying print order

You may want to specify the order in which the pages of a report are printed — either from left to right, or top to bottom. Also, you can specify whether the entire contents of the report fit onto one page or not.

To specify the order in which the pages of a report are printed, follow these steps.

  1. Run the report, as described in Running standard journal entry reports or Running ad hoc journal entry reports. The report opens in print preview format.

  2. Choose File > Print Option. The Print Option dialog opens.

  3. Complete these fields:

    1. Print Order: Select the direction in which you want to print the report.

    2. Adjust to: Select the print size in the report as a percentage of the normal size.

    3. Fit to: Select this field to have the entire contents of the report fit into the number of pages you specify in the corresponding fields.

  4. To see what the report looks like when it is printed, click OK. The report view appears showing your changes.

Specifying printer options

You can specify printer settings for reports — page width, page orientation, printer tray to use, and so on. You specify printer options in the Page Setup dialog.

To specify your printer options, follow these steps.

  1. Run the report, as described in Running standard journal entry reports or Running ad hoc journal entry reports. The report opens in print preview format.

  2. In the Print Preview dialog, choose File > Page Setup. The Page Setup dialog opens.

  3. Complete these fields:

    1. Size: Select the paper size for the report.

    2. Source: Select the printer paper tray containing the correct paper for the report.

    3. Orientation: Select an orientation for the report.

    4. Margins (inches): Specify the top, bottom, left, and right margins for the report.

  4. When you are satisfied with the printer settings, click OK. The report view appears. Proceed to Printing a report.

Printing a report

Once you have prepared your report, you can print it. Before you do, make sure you have specified your printer options. For more information, see Specifying printer options.

To print a report, follow these steps.

  1. In the Print Preview dialog, choose File > Print. The Print dialog opens.

    Graphical user interface Description automatically generated

  2. Specify your printing options as required.
  3. Click OK. Your report is printed, and the report view appears.
For an optimal Community experience, Please view on Desktop