Summary

Follow this process to commit inventory transactions. The steps of this process will vary depending on which modules are set up to interact with the Inventory Control module.

This will also process a batch of Inventory Control items received in the Purchase Orders module.

Step by Step

1     Print the Proof List.

• Open the Print Proof List window (IC> Inventory Transactions> Proof List).
• Select the Sort Order you would like to report to print in.
  • Select Item Number to sort the report by item number.
  • Select Entry Order to sort the report entries by the order they were entered in the Enter Transactions step or the order they were imported in the Import Transactions step.
  • Select Location to group the items by location.
• The Proof List will display the Item, Description, Location, Action, Category, Transaction Description, Transaction Date/Time, Change in Quantity, Change in Value, Transaction Total, and the Report Total.
• If any of the transactions included in the batch will result in item recosting, the resulting reversals and new transactions will be included in the proof list.
• 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 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.
• 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.
• Review the Proof List.

2     Print the GL Distribution report.

• Open the Print GL Distribution window (IC> Inventory Transactions> GL Distribution).
• Enter a Journal Entry Date. The JE date will determine the fiscal year and period the inventory transactions will be posted in. The fiscal year and period the journal entries are posted to does not affect the inventory costing.
  • This is the date of the journal entry when it is posted to the general ledger.
• The Fiscal Period and Fiscal Year fields will automatically populate after you have selected a Journal Entry Date.
• Select a Report Type.
  • The Summary report will display the GL Account Number, GL Account Description, Debit amount, and Credit amount. The report will provide a Fund Total and a Report Total as well.
  • The Detail report displays everything included in the Summary report as well as the Inventory Item and Item Description.
• Check the Subtotal by Dept toggle to add department subtotals to 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 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.
• 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.

3     Print the PM Proof List.

• Open the PM Proof List window (IC> Inventory Transactions> PM Proof List).
• The PM Proof List displays the PM module transactions generated by the inventory transactions in the batch. This report will only display information if there are PM module task and type codes attached to inventory items in the batch.
  • The PM Proof List will display the Inventory Item, Date, PM Task, PM Type, LEMS code, Description, and Amount. The report will also provide a Task Total and a Report Total.
• The PM Proof List is a required step if you have enabled the PM Interface on the IC Setup window (IC> Utilities> Setup> PM Interface toggle).
• 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 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.
• 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.

4     Print the WO Proof List.

• Open the WO Proof List window (IC> Inventory Transactions> WO Proof List).
• The Report Type field is used to select the standard WO proof list or the WI Hwy report for Wisconsin agencies using Wisconsin Highway functionality.
• The WO Proof List will display the WO Number, Reference Number, WO Description, Item ID, Date, Transaction Description, Activity, Units, Value Per Unit, Overhead, and Total Value. The report will also provide WO Totals and a Report Total.
• 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 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.
• 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.

5     Print the WO module Distribution Report.

• Open the WO Distribution window (IC> Inventory Transactions> WO Distribution).
• This step will create any work order distribution records for each inventory item that is associated with a work order.
• This step will only be available if the Distribute values for IC toggle is checked on the WO Setup window (WO> Utilities> Setup).
• Use the Report Type drop-down to select the level of detail to include in the WO Distribution report.
  • The Summary report will display the Fund, Account Number, Account Description, Debit Amount, and Credit Amount. The report will provide totals by fund as well as a report total.
  • The Detail report will display everything included in the Summary report as well as Transaction Descriptions for each line item.
• 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 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.
• 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.

6     Commit the Inventory Transactions batch.

• Open the Commit Transactions window (IC> Inventory Transactions> Commit).
• Click the Continue button or press ENTER to commit the batch.  
  • If you click the Cancel button, you can still commit the batch via the Commit button  .
• The batch has now been committed. If there were return to vendor transactions in the batch that were set up to create credit memos, they have now been created.