SB Enterprise Help Center

IC Transactions Outside Period Report

Updated on

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.

  • 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.
Previous Article IC Transactions by Category Report
Next Article IC Usage Report
Still Need Help? Contact Us