Previous | Next | Contents | Index | Navigation | Glossary | Library |
Using sources from other Oracle Applications and from external systems, you can generate cash forecasts from previously-defined cash forecast templates. You can choose whether to forecast by days or periods, and choose how to organize each template with multiple GL sources and levels of detail. Automatic integration with Oracle Applications and other spreadsheet applications provides you with enterprise-wide cash information and management.
You create cash forecast templates, from which you can generate periodic cash forecasts projecting your cash flow and requirements. Once you have generated a cash forecast, you can modify, query, and report on it, and easily export it to Microsoft Excel or any spreadsheet application.
Oracle Cash Management lets you create an unlimited number of cash forecasts. A cash forecast is in a spreadsheet format, including rows (cash inflow or outflow) and columns (periods). Each row is a source type and each column a forecast period. At the intersection of each row and column are cells containing forecast amounts.
Cash Management lets you create forecasts using data across organizations, and in any currency. You can also use cash forecasting to help determine your degree of currency exposure.
You can submit cash forecasts with user currency exchange rates, minimizing exchange rate setup for what-if analysis.
You have the flexibility to include or exclude overdue transactions for all appropriate source transaction types in your forecasts.
Cash inflow information is immediately accessible to the cash forecast process in Oracle Cash Management from Oracle Receivables, Oracle Order Entry, and Oracle General Ledger. Cash outflow information comes from Oracle Payables, Oracle Purchasing, Oracle Payroll, and Oracle General Ledger. Using the Forecasting Open Interface, you can also include cash flows from external systems.
Oracle Applications Integration with Oracle Cash Management's Cash Forecasting | |||
---|---|---|---|
Cash | Source | Source Type | Description |
I N F L O W | Receivables | AR Invoices | Unpaid invoices |
AR Receipts (Historical) | Cleared cash receipts, excluding reversed receipts | ||
AR Receipts (Future) | Uncleared cash receipts, excluding reversed receipts | ||
Order Entry | Sales Orders | Uninvoiced sales orders that are projected to be paid by customer, excluding commitments | |
General Ledger | GL Cash Position | Cash balance to be used as the starting point of the projection | |
GL Budgets | Revenue account budget amounts | ||
External Source | Open Interface Inflow | External forecast source inflow transactions | |
User | User-defined Inflow | Manually entered cell amounts | |
O U T F L O W | Payables | AP Invoices | Unpaid invoices, excluding prepayments |
AP Payments (Historical) | Cleared disbursements, excluding void payments | ||
AP Payments (Future) | Uncleared disbursements, excluding void payments | ||
Payroll | Payroll (Historical) | Paid payroll | |
Purchasing | Purchase Orders | Uninvoiced purchase orders | |
Purchase Requisitions | Unordered requisitions | ||
General Ledger | GL Encumbrances | Unused portion of encumbered amounts for expenses and assets | |
GL Budgets | Expense account budget amounts | ||
External Source | Open Interface Outflow | External forecast source outflow transactions | |
User | User-defined Outflow | Manually entered forecast amounts |
You can generate a cash forecast that automatically includes cash flows from local and remote databases.
Previous | Next | Contents | Index | Navigation | Glossary | Library |