Exporting sources and multiple overrides

Use this procedure to view the details of allocation sources and multiple overrides. A report can be exported to a CSV file to review and analyze allocation scenarios and allocation results. Use Excel functions to format, filter, copy, and manage your allocation results for your review and reconciliation requirements.

To generate the report, select the Generate Reports check box in the Run Options section during the allocation run. To include the allocation period, source balance, source currency, and allocable amount, select the Include Source Details check box.

See Calculating allocations.

  1. Select Allocation Control.
  2. On the Actuals tab or on the Budgets tab, open an allocation control record.
  3. On the Runs tab, open a failed or completed allocation run record.
  4. To view all allocation sources and multiple overrides of your allocation run, select the Sources And Multiple Overrides tab.

    Use the search row to filter on a specific allocation source and the corresponding overrides.

  5. To export the contents, select Actions > Options menu. If you select Export to CSV, these options are available:
    • Select Header List With Details to export the source details and the corresponding multiple overrides data
    • Select Header List Only to export only the source details
    • Select Detail List Only to export the multiple overrides data