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.
- Press CTRL+A to select all the displayed locations and then press SPACE to select or deselect all 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 label 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 label 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 Included 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.
- Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and 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 the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).