When Cash Management collects the source data for a forecast, it includes source transactions whose cash activity date falls within the days or period ranges you defined. Cash Management searches for a valid date in the sequence indicated, using the first date it finds. Cash Management adds the lead time to dates, except for GL Budgets and GL Encumbrances.
The following table explains which date is used as the expected cash activity date.
| Type | Expected Cash Activity Date or Time |
|---|---|
| Supplier Payments (Future) | 1. Value Date (Actual then Anticipated), 2. Maturity Date, or 3. Payment Date |
| Expense Reports | 1. Period Ending Date |
| Customer Receipts (Future) | 1. Value Date (Actual then Anticipated), 2. Maturity Date, or 3. Latest Receipt Transaction Date |
| Supplier Invoices | Discount Deadline if Discount field is Maximum or Minimum; or Due Date if Discount field is None |
| Supplier Payments (Historical) | Cleared Date or Value Date (your choice), rolled forward by amount specified on cash forecast template |
| Customer Invoices | Due Date or Invoice Date plus Average Payment Days |
| Customer Receipts (Historical) | Cleared Date or Value Date (your choice), rolled forward by amount specified on cash forecast template |
| GL Budgets | Forecast period type must be GL Period; corresponding periods included |
| GL Encumbrances | Forecast period type must be GL Period; corresponding periods included |
| Payroll Expenses (Historical) | Payment Date, rolled forward by amount specified on cash forecast template |
| Project Billing Events | Event Completion Date |
| Project Inflow Budgets | Calculated based on Start Date and End Date of budget period |
| Project Outflow Budgets | Calculated based on Start Date and End Date of budget period |
| Project Transactions | Expenditure Item Date |
| Purchase Orders | Releases: 1. Shipment Promised Date or Shipment Promised Date plus Payment Terms 2. Shipment Need By Date or Shipment Need By Date plus Payment Terms 3. Release Due Date or Release Due Date plus Payment Terms 4. Release Created Date or Release Created Date plus Payment Terms Standard POs: 1. Shipment Promised Date or Shipment Promised Date plus Payment Terms 2. Shipment Need By Date or Shipment Need By Date plus Payment Terms 3. Shipment Created Date or Shipment Created Date plus Payment Terms |
| Purchase Requisitions | 1. Requisition Line Need By Date, or 2. Requisition Line Created Date |
| Sales Opportunities | 1. Line Decision Date, 2. Header Decision Date |
| Sales Orders | Ordered Date, Requested Date, Ordered Date plus Payment Terms, or Requested Date plus Payment Terms (1. line level, 2. header level) |
| Treasury Inflow | Settlement Date |
| Treasury Outflow | Settlement Date |