Create a Cash Forecast Stream

Security Note: You need the Allow the user to edit Cash Forecast reports security right in the Intelligent Reporting domain security rights group for this activity.

Activity Steps

1. Select the Reporting panel in the Solution Explorer.
2. Expand the Cash Forecast Categories node.
3. Right-click the cash forecast category and select New » Cash Forecast Stream from the menu.

   The Cash Forecast Stream displays.

4. Select the Contract Type from Sales Contract and Purchase Contract. If both contract types are selected, the report displays the net quantity; that is, sales minus purchase.
5. Select the Currency in which to display monetary values. Select from the currencies defined in the Currency/Exchange Editor.
6. If any currency conversions are required, complete the following fields.
   • Exchange Rate Source—Used to determine the exchange rate from the invoice currencies to the currency of the cash forecast reports. Select from the exchange rate sources defined in the Currency/Exchange Editor.
   • Exchange Rate Method—Method used to determine the exchange rate from the Exchange Rate Source if the applicable exchange rate from the contract terms is not available. Select from:
   • Last Day of Previous Month—Uses the last business day of the previous month if a calendar is specified for the Exchange Rate Source. If multiple calendars are specified, the last business day common to all calendars is used.
   • Last Known Exchange Rate
   • Previous Month Average
7. Complete the following fields as required to limit the applicability of the reports.
   • Material Types—Select from the material types defined on the Material panel of the Solution Explorer.
   • Products—Select from the products and brands defined on the Material panel of the Solution Explorer.
   • Companies—Select from the companies defined on the Organisations panel of the Solution Explorer.
   • Districts—Select from the districts defined on the Organisations panel of the Solution Explorer.
   • Customers—Buyers associated with sales contracts or sellers associated with purchase contracts. Select from the organisations and companies defined on the Organisations panel of the Solution Explorer and that have the Organisation Role of Customers.
   • End Users—End users associated with contracts. Select from the organisations and companies defined on the Organisations panel of the Solution Explorer.
   • Contract Status—Select from the statuses defined in the Sales Contract and Purchase Contract status definitions. See Status Definitions.
   • Despatch Order Status—Select from the statuses defined in the Despatch Order and status definition.
8. Select whether to Include Overdue Invoices.
9. Select whether to Include Freight/Service Costs. If checked, the following costs are included in the report.
   • Existing freight, freight commission, freight demurrage, freight demurrage commission, service, and service demurrage invoices
   • Costs in despatch order snapshots

   If checked, and if Include Quota Snapshots is checked, cost items from quota balance snapshots are also included.

   If unchecked, only revenue items are included in the report.

10. Select whether to Include Quota Snapshots. The contract quota balance is calculated as:

    Quota Required Quantity – Sum of Despatch Order Quantities

    However, if the sum of despatch order quantities is greater than the minimum quantity of the quota, the balance is considered to be zero. If no minimum quantity is specified for the quota, the balance is zero once the sum of despatch order quantities exceeds the required quantity of the quota.

    If checked, and if Include Freight/Service Costs is checked, both revenue and cost items from the quota balance snapshot are included in the report.

    If checked, but Include Freight/Service Costs is unchecked, only revenue items from the quota balance snapshot are included.

11. Click Save.