Summary

The GL Account Summary Report displays the General Ledger accounts and any changes to those accounts over a filtered period of time or for a specific inventory item or location. The report will display the original transaction as well as any reversals or replacement transactions. This report allows you to view all general ledger activity from the Inventory Control module.

When printing Inventory Control module reports, be aware that inventory counts and the transactions that affect those counts are date and time specific. In order to generate an accurate inventory report, confirm that both the date and time specified are correct.

Step by Step

1     Open the GL Account Summary Report window (IC> Reports> GL Account Summary Report).

2     Configure the report. 

• Check the toggle next to each Location that should be used to determine which inventory items are included in the report.
  • Check the toggle in the header to select all the displayed locations.
  • At least one location must be specified in order to run the report.
  • Locations are created and maintained on the Location Maintenance window (IC> Maintenance> Location).
• Enter an Item ID or click the field search button to select an inventory item from a list and limit the report to a single inventory item.
  • Inventory Items are created and maintained on the Item Maintenance window (IC> Maintenance> Item).
• Enter a Description to filter the items included in the report to those items that contain the specified terms in their description fields.
• The six fields below the Description field are miscellaneous character fields. The displayed labels for these fields are set up on the Miscellaneous Field Label Maintenance window (SS> Utilities> Miscellaneous Field Labels).
• Specify a Fiscal Year to limit the included transactions by fiscal year.
• Enter a period range in the Period From and Period To fields.
• Click the GL Account field search button and select an account to limit the report to a single account.
• Check the Exclude Committed Reversals toggle to exclude any committed reversal transactions from the report.
• Check the Include Selected Fiscal Year Only toggle to limit the transactions included in the report to those that fall in the year specified in the Fiscal Year field above.
• Check the Print Archived Only toggle to limit the transactions included in the report to transactions that have been archived through the Archive Transactions process (IC> Utilities> Archive Transactions).
• Check the Print Item Detail toggle to include the Item Number and Item Description in the report.
  • Checking this toggle will enable the two toggles below.
  • Check the Print Items With No Current Activity toggle to include inventory items with no transaction activity during the specified date range.
  • Check the Print Transaction Detail toggle to include the Journal Entry, Date/Time, Action Type, and Transaction Description in the report. The Beginning Balance, Debit Amount, Credit Amount, and End Balance for each journal entry will also be provided. The report will be sorted by GL Account Number and Inventory Item Number.
• The basic report will display the GL Account Number, GL Account Description, Beginning Balance, Debit Amount, Credit Amount, and Ending Balance. Balance Total for each GL Account will also be provided. The report will also provide journal entry and report totals for the Beginning Balance, Debit Amount, Credit Amount, and End Balance columns.

3     Print the report.

• Once the required report settings have been specified, click the Print button   to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select PDF to print the report in the default Springbrook PDF format.
  • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button   will be displayed by default.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button   on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last ten times the report was generated.