PO Funds Depletion Report

This report produces data regarding funds depletion on purchase orders.

This report produces the following columns:
  • Budgeted Amount section
    • Manager
    • Operational Unit
    • Department
    • Worker
    • Supplier
    • Requisition #
    • Requisition Type
    • Start Date
    • Estimated End Date
    • End Date
    • Bill Rate
    • Currency
    • Initial Budget Amount
    • Estimated MSP Up Fee
    • Budget Adjustment
    • Total Budget Amount
    • Available Amount
    • Expires On
    • Billing to Date
    • Average Weekly Billing
    • Est. Wks Remaining
    • % of Funds Used
    • VAT to Date
    • Additional Fund Amount
  • PO section
    • PO # - Additional detail for the purchase order, broken down by PO Line #.
      • Requisition #
      • PO Line #
      • UOM
      • Manager
      • Operational Unit
      • Department
      • Worker
      • Supplier
      • Requisition Type
      • Start Date
      • Estimated End Date
      • End Date
      • Bill Rate
      • PO Amount
      • PO Available Amount
      • PO Billing to Date - Sum of Bill Client Amount for all processed billings.
      • Average Weekly Billing
      • PO Est. Wks Remaining
      • PO % Of Funds Used - All values used in this calculation are pulled from the individual PO # (this section). Calculated as PO Billings to Date / PO Amount + Additional Fund Amount * 100.
      • Additional Fund Amount - All values used in this calculation are pulled from the individual PO # (this section). Calculated as Available Amount + Billing Date - PO Amount. This value is calculated from processed billing items only.
      • PO Total Amount - All values used in this calculation are pulled from the individual PO # (this section). Calculated as Available Amount + Billing Date. This value is calculated from processed billing items only.
    • Currency
    • PO Amount
    • PO Available Amount
    • Billing to Date - Sum of Bill Client Amount for all processed billings.
    • Average Weekly Billing
    • Est. Wks Remaining
    • % Of Funds Used - Calculated as Billing to Date / PO Amount + Additional Fund Amount * 100.
    • VAT to Date
    • PO Start Date
    • PO End Date
    • Primary
    • Status
    • Additional Fund Amount - Calculated as (Available Amount + Billing to Date) - Initial Amount.
    • PO Total Amount
Field Description
Type of Funds Use the drop down to select the type of funds to report on.
WorkerEnter the name of the worker(s) whose data is included in the report. This field is set to 'All' by default.
ManagerSelect the client manager name associated with the engagement. This field is set to 'All' by default.
Supplier Filter the report output by the supplier/vendor. This field is set to 'All' by default.
Manager DelegateIf the report is being run by the client manager delegate, then the delegate can select additional client manager delegate assigned by the delegating client manager.
Requisition TypeSelect the engagement type. This field is set to 'All' by default.
Requisition StatusSelect the status of the engagement to report on.
Invoice OptionSelect the invoice option for the engagement. This field is set to 'All' by default. See Invoicing.
Percentage Used Greater thanUse the drop down to select the amount of the budget used (percentage).

You can only select increments of 10 (10%, 20%, and so on).

Operational UnitFilter the report output for billing items submitted for a specific operational unit (OpUnit). This field is set to 'All' by default.
Division Filter the report output by the division for the engagement. This field is set to 'All' by default.
Cost Center Filter the report output by cost center for the engagement. This field is set to 'All' by default.
Active PO's Only Select the check box to filter by active purchase orders only.
Primary PO's Only Select the check box to filter by primary purchase orders only.
Select ColumnsSelect the columns to include in the report.