Show TOC

Object documentationCompany Overview Locate this document in the navigation structure

 

The upper area provides a time bar of two years from the current date for you to specify a time range or date.

  • To make the time range longer or shorter, drag to the required date.

  • To apply the same length of time range to a different period, drag the shaded time range to the required period.

The lower part is a chart with bars and a line showing the incoming, outgoing, and net cash amount in the required period. The three kinds of amounts are displayed accumulatively. For example, the incoming cash flow for today is $50, and the incoming cash flow for tomorrow is $30; therefore, the incoming amount displayed for tomorrow is $80.

Note Note

The following documents are split according to their installment settings:

  • Sales order documents and drafts

  • Purchase order documents and drafts

  • A/R down payment request documents, A/R down payment request drafts, and A/R down payment invoice drafts

  • A/P down payment request documents, A/P down payment request drafts, and A/P down payment invoice drafts

  • A/R invoice drafts

  • A/P invoice drafts

  • A/R correction invoice drafts

  • A/P correction invoice drafts

End of the note.

 

For most documents, the forecast date is the delivery date or due date of the document or installment. For the following documents, the forecast date is calculated according to a set of priorities:

  • Recurring transactions

  • Sales order documents and drafts

  • Purchase order documents and drafts

  • Delivery documents and drafts

The calculation priorities are as follows:

  1. The installment date setting if the document is listed in the previous note

    To set the installment date, on the Accounting tab of the document, choose the link button beside the Installments field. The Installments window appears, displaying the installment date setting from the selected payment terms. You can change the installment date if required. The forecast date of each installment will be set to the date you specified in the Installments window.

    If there is no such field named Installments on the Accounting tab, choose the link button beside the Payment Terms dropdown list, and in the Payment Terms - Setup window, choose the link button beside the No. of Installments field. In the Installments window, specify numbers in the Month and Days columns for a specific installment.

    Example Example

    The delivery date or due date of the document is 2012.08.15. If there is no such field named Installments on the Accounting tab, the forecast date will be calculated according to the numbers you specified in the Installments window by choosing the link button beside the No. of Installments field in the Payment Terms - Setup window. For the first installment, you entered 1 and 14 in the Month and Days columns. The forecast date of the first installment will be calculated as 2012.(08+1).(15+14), and thus set to 2012.09.29.

    End of the example.

  2. The Manually Recalculate Due Date setting of the document

    To define the Manually Recalculate Due Date setting, on the Accounting tab of the document, select the options in the Manually Recalculate Due Date dropdown list, and enter numbers in the Months and Days fields:

    • Month End: the last day of the current month

    • Half Month: the 15th of the current month

    • Month Start: the first day of the next month

    • <empty>

    Example Example

    The date after the previous round of calculation is 2012.09.29. You select Month End in the Manually Recalculate Due Date dropdown list, and enter 1 and 2 in the Months and Days fields, respectively. The forecast date will be calculated as 2012.(09+1).(30+2), and thus set to 2012.11.02.

    End of the example.

  3. The Payment Date setting of the business partner

    To define the Payment Date setting of the business partner, from the SAP Business One, version for SAP HANA Main Menu, choose   Business Partner Master Data   Payment Terms   Payment Dates  , and in the Payment Dates window, enter numbers between 1 and 31 inclusive.

    Example Example

    You enter the following numbers in the Payment Dates window respectively:10, 5, 25, 20, and 30.

    When you open the window again, the dates will be automatically sorted as: 5, 10, 20, 25 and 30.

    The date after the previous two rounds of calculation is 2012.11.02. The forecast date will be set to 2012.11.05, because the number 2 falls between 0 and 5.

    End of the example.

  4. The Holidays setting of the company or the business partner

    • If the document is in the Purchasing - A/P module, the forecast date is calculated according to the Holidays setting of the company.

      To define the Holidays setting of the company, choose   Administration   System Initialization   Company Details   Accounting Data   Holidays  . If the date after the previous three rounds of calculation falls on a holiday date, the forecast date will be set to the next working day.

    • If the document is in the Sales - A/R module, the forecast date is calculated according to the Holidays setting of the business partner.

      To define the Holidays setting of the business partner, on the Payment Terms tab of the business partner, choose the holidays in the Holidays dropdown list. If the date after the previous three rounds of calculation falls on a holiday date, the forecast date will be set to the next working day. If you do not select any holiday in the dropdown list, the forecast date will still be the date after the previous three rounds of calculation.

    Example Example

    The date after the previous three rounds of calculation is 2012.11.05, and the document is in the Purchasing - A/P module. According to the Holidays setting of the company, 2012.11.05 is a holiday date of year 2012, so the forecast date will be set to 2012.11.06.

    End of the example.

  5. The delays in payments if you select the Consider Delays in Payments checkbox in the Configuration area

    To define the delays in payments, from the SAP Business One, version for SAP HANA Main Menu, choose   Business Partners   Business Partner Master Data   Payment Terms  , and in the Average Delay field, enter a number.

    Example Example

    The date after the previous four rounds of calculation is 2012.11.06, and the value in the Average Delay field on the Payment Terms tab of the business partner is 5. The forecast date will be set to 2012.11.11.

    End of the example.