Summary
The Transactions Outside Period Report displays a list of transactions that have transaction dates outside the fiscal period they have been posted to. This report allows you to find differences between the Inventory GL Account amounts and the Inventory Item values. Only committed transactions will display on the report.
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 Transactions Outside Period report window (IC> Reports> Transactions Outside Period).
2 Configure the report.
- Specify a Fiscal Year and Fiscal Period for the report.
- Only IC inventory items with a journal entry date that falls within the specified fiscal year and period are eligible to be included in the report. Any transactions on those inventory items that fall outside of the specified fiscal year and period will be displayed in the report.
- Check the Print future transactions only toggle to limit the report to transactions that have a transaction date that falls in a fiscal year or period following the original journal entry year or period.
- The report will display the Item code, Item Description, Date and Time, Action Type, Description, Batch Number, Journal Entry, Change in Quantity, and Change in Value for each included transaction. The report will also provide transaction, item, and report totals.
- The transactions will be sorted by Date/Time and grouped by Item.
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).