Consolidated WIP report

The WIP Report consolidates all WIP accounts by a range of periods. A combination of budget, commitment, actual or variances for budget commitments, actuals in a user defined sequence can be displayed. 

This report is used to balance Book Production totals with the General Ledger totals.

  1. In the menu, expand Publishing Modules Book Publishing > Project Report > EOM Analysis Reports and double-click BP Consolidated WIP Report BPR640 Consolidated WIP Report panel appears. 
  2. Click function Accounts selection. This allows you to select up to 6 detailed accounts and column headings which should appear in the report.
  3. Click OK.
  4. Click Page down.
  5. Enter the selection fields as required.
  6. Click OK to produce the report.

The report lists the following information.

  • Project
  • Description
  • Project levels
  • Actual
  • Commitment
  • Variance between commitment and actual
  • Variance between budget and commitment
  • Variance between budget and actual
  • Budget
  • Stock account
  • Stock variance