Inventory to General Ledger Reconciliation screen

Use the Inventory to General Ledger Reconciliation screen to create a report of the current value of the inventory through the selected period end date and purchase order transactions that may cause the inventory value to differ from the general ledger account balance. Purchase order transactions can include items received and not invoiced, items invoiced and not received, and items received and invoiced at difference amounts. You can print or save this report.

For more information on running the report, see Run and Print Reports.

Note: To open the Inventory to General Ledger Reconciliation screen, click Materials > Reports > Inventory to General Ledger Reconciliation in the All Tasks pane.

You can control the output of the Inventory to General Ledger Reconciliation report by entering details in one or more of the following fields on the Options tab:

  • Select Format - If you have modified the format and layout of this report on the Modify Reports screen, click to select the version to use for this report. If you haven't modified the report, this field doesn't appear.

Company - Click to select one or more companies for the report. If no companies are selected, all companies appear in the report.

Period End Date - Click to select the fiscal period and year for the report from a filtered list. If you know the period end date you want for the report, you can enter it, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. If you enter or select a date that is not a period end date, ProContractor clears the field. This field is required.

  • Last Reconciliation Date - Click to select the period end date of the last reconciliation between inventory and the general ledger from a filtered list. If you know the period end date you want for the report, you can enter it, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. If you enter or select a date that is not a period end date, ProContractor clear the field. This field is required.

  • Inventory Account - Click to select one or more inventory accounts for the report. If no inventory accounts are selected, all inventory accounts appear in the report.

  • Show Inventory Value Detail - Select the checkbox to show the inventory value in the report.

  • Show Open PO Inventory in Excess of GL Detail - Select the checkbox to show open purchase orders for inventory in excess of the general ledger.

  • Show Open PO GL in Excess of Inventory Detail - Select the checkbox to show open purchase orders recorded in the general ledger in excess of inventory.

  • Show Closed PO Cost Variance Detail - Select the checkbox to show closed purchase orders where the invoiced amount is not equal to the received amount.

  • Show Write-offs Due to Weighted Average - Select the checkbox to show write-offs that are caused by weighted average calculations.

  • Show Negative Lot Adjustments - Select the checkbox to show negative lot adjustments in the report.

    Tip: You can use the Modify Reports screen to customize the format and layout of this report.