Select whether to use real-time prior day cash flow and overdue transactions balances or to use calculated balances by selecting No or Yes in the Use Calculated Prior Day Cash Flow and Overdue Transactions Balances field. In the Create Cash Position Worksheet page, enter a unique name for your worksheet.Įnter the number of columns that you want Cash Management to display in each page of your cash position results. Navigate to the Cash Position Worksheet Search and Results page. You can then generate a cash position and Cash Management automatically retrieves information available from the external sources you have defined. You define your worksheets to include the Open Interface Inflow and Open Interface Outflow source types. The External Cashflow Open Interface allows you to utilize external sources of cash inflow and outflow data for the Cash Positioning feature, providing you an enterprise-wide cash positioning solution on a distributed database environment. External Cashflow Open Interface and Distributed Database Integration This process gathers current source information from the selected Oracle Applications.
Once you have selected your cash position specifications, you can save your worksheet, and use it to generate your daily cash positions. For more information on source type specifications, refer to Cash Position Worksheet Page Reference You can include transaction source defaults or you can choose to manually set the parameters for the transaction source. You can specify the sources you want to include in the cash position to create custom cash position worksheets. Worksheets also include the following types of general information:Ĭash Management provides the following two seeded worksheets:ĭefault Cash Position Worksheet: This worksheet includes the default values for the Bank Account Balance section, Intra-Day Activities section and all transaction sources except for the User-Defined and Open Interface sources.ĭefault Treasury Cash Position Worksheet: This worksheet includes the default values for the Bank Account Balance section, Intra-Day Activities section, Treasury Inflow and Treasury Outflow sources. Worksheets determine the presentation of sources (rows) and bank accounts (columns) for your cash position. Generating Cash Positions from WorksheetsĮxporting Cash Positions to Your Spreadsheet ApplicationĪ worksheet contains cash position specifications.
#MINIMUM CASH BALANCE FORECASTING HOW TO#
Refer to the following sections in this chapter for details on how to accomplish various cash positioning tasks: You can generate a daily cash position for a single currency, multiple currencies, a single bank account, multiple bank accounts, a single Legal Entity, or multiple Legal Entities. The daily cash positions are based on actual cash flows from various Oracle Applications. Cash positioning allows you to project your cash needs, and evaluate your company's liquidity position.
This chapter tells you how to use Cash Positioning.
0 kommentar(er)
