IC> Reports> GL Account Summary Report

GL Account Summary Report

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.

Click here for information on Item Maintenance.

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). Click here for information on Location Maintenance.
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). Click here for information on Item Maintenance.
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). Click here for information on Miscellaneous Field Label Maintenance.
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). Click here for information on archiving 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.