create-cash-flow-entries
#Create Cash Flow Entries of the Receivables Plan under the Agreement
To create customer Contract Receivables Plan Entries, do the following:
- In the Agreement card, select Payment plan > For Agreement and determine whether it will be mandatory to fill in Contract Receivables Plan Entry in the sales documents by setting the corresponding value of the Contract Receivables Plan > Mandatory toggle.
- Go to the Home > Contract Receivables Plan Entries tab and fill in the fields of the page that opens:
| Field | Description |
|---|---|
| Customer No. | Specifies the number of the customer (filled automatically). |
| Agreement No. | Specifies the number of the agreement. (filled automatically when opening Contract Receivables Plan Entries from the Agreement Card). |
| Unique Entry No. | Specifies the number of the unique entry (filled automatically). |
| Planned Date | Specifies the planned date of payment. |
| Amount | Specifies the receivables amount. |
| Currency Code | Specifies the currency code for the amount on the line. |
| Cash Flow Forecast Entry No. | Specifies the number of the entry. |
| Sales Invoice No. | Specifies the number of the sales document. |
| Posted Sales Invoice No. | Specifies the number of the posted sales document. |
| Description | Specifies a description of the entry. |
| Responsible for Invoice | Specifies the person responsible for the invoice. |
| Modified At | Specifies the date and time of the changes. |
| Dimension code 1 | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes set up in the General Ledger Setup window. |
| Paid Amount | Specifies the amount which was paid. |
Contract Receivables Plan Entries in the Cash Flow Ledger Entries will be generated with Source Type = Sales Payment Plan. In case a Sales Order or a Sales Invoice has already been created under this contract, the created Contract Receivables Plan Entries can be linked to such documents by filling in the Contract Receivables Plan Entries field in the document. After the document is released, the amount of Contract Receivables Plan Entries will automatically change to the amount of the document.
Editing Contract Receivables Plan Entries is impossible. To make changes, you need to delete the record and create a new one with the correct data. If a sales document is attached to the Contract Receivables Plan Entries, you must open the sales document to delete the Contract Receivables Plan Entries and then delete the transaction. The creating process for Contract Payables Plan Entries of a vendor is similar to the procedure for creating Contract Receivables Plan Entries.
##Create a Schedule of Accounts Payable Settlements for Invoice To create a vendor Contract Payables Plan Entries, do the following:
- In the Vendor's card or Agreement, select Payment plan - For Invoice.
- In the Vendor's card, go to the Vendor > Payment Conditions tab. If you make settings from the Vendor's Agreement card - go to the Home > Payment Conditions tab and fill in the following fields of the page that opens:
| Field | Description |
|---|---|
| Account Type | Specifies the type of account (filled automatically). |
| Account No. | Specifies the code of vendor. |
| Agreement No. | Specifies the code of vendor agreement (is filled in automatically when opening Contract payables plan entries from the Agreement Card). |
| Payment Type | Specifies the type of payment. |
| Payment % | Specifies the percentage of the invoice amount for each payment. |
| Date Formula | Specifies the date formula for calculating the planned payment date. |
| Base for Date | Specifies the base for calculating the planned payment date. |
Having created a Purchase Order or Purchase Invoice, after the document is released, a Payables Schedule on the document will be formed. You can view it by going to the Prepare > Payables Schedule tab.
| Field | Description |
|---|---|
| Planned Date | Specifies the planned date of the payable. |
| Amount | Specifies the amount of the payable. |
| Currency Code | Specifies the code of the currency for the payable. |
| Cash Flow Forecast Entry No. | Specifies the number of the Cash Flow Forecast Entry. |
| Purchase Invoice No. | Specifies the number of the purchase document. |
| Posted Purchase Invoice No. | Specifies the number of the posted purchase document. |
| Paid Amount | Specifies the amount which was paid. |
You can change the entries of the created Payables Schedule by using the Edit Entries function, which opens the Edit Payables Schedule page. If the Paid Amount field is filled in, it cannot be deleted. The procedure for creating Receivables Schedule is similar to the procedure for creating Payables Schedule.
Register Cash Flow Ledger Entries
To register a transaction plan and Payables/Receivables schedule in the Cash Flow Ledger Entries:
- Go to
, which opens the Search function, enter Cash Flow Worksheet, select the appropriate link. - Go to the Home > Suggest Worksheet Lines tab.
- In the window that opens, fill in the following parameters:
| Field | Description |
|---|---|
| Cash Flow Forecast | Specifies the cash flow forecast for which you want to make the calculation. |
| Sales Contract Payment Plan | Specifies whether to include sales contract receivables plan entries in the cash flow forecast. |
| Purchase Contract Payment Plan | Specifies that entries of the purchase contract payment will be suggested. |
| Group by Document Type | Specifies if the information is grouped by sales orders, purchase orders, and service orders. Note To display information on the payment plan of sales or purchases in a collapsed form, this switch must be turned on. |
| Starting Date | Specifies the start period of the documents or related entities for which the cash flow entries will be generated. |
| Ending Date | Specifies the end period of the documents or related entities for which the cash flow entries will be generated. |
| Override Cash Flow Date | Specifies the new cash flow date for the entries which will be created. |
After completing the Suggest Worksheet Lines task in Cash Flow Worksheet, entries with Source Type = Sales Payment Plan and/or Purchase Payment Plan will be generated. Then you have to register the generated records in the Cash Flow Worksheet by clicking on the Home > Register.
Note If the orders, sales or purchase invoices specified in the Contract Receivables/Payables Plan Entries, such transactions will be generated with Source types Sales order or Purchase order (for unposted documents), Receivables or Payables (for posted documents).
To generate and register such records, make sure that the appropriate switches are turned on on the Suggest Worksheet Lines task page.
Edit Cash Flow Ledger Entries
The Cash Flow Ledger Entries allows manual editing of the following fields: Cash Flow Date, Amount, Amount (LCY) and Due Date. To edit, select the Edit List function on the Cash Flow Ledger Entries page and edit the entries you want. You can also edit operations on specified fields using the Edit function in Excel.
In addition, it is possible to update the data on the Cash Flow Ledger Entries after making changes to the Receivables/Payables Schedule or the released document, for the following source types Sales Payment Plan, Purchase Payment Plan, Sales Order and Purchase Order, for this use the Update button on the Cash Flow ledger Entries page.
For source types Sales Payment Plan and Purchase Payment Plan in the Cash Flow Ledger Entries, the following will be updated: Cash Flow Date, Amount, Amount (LCY) and Due Date.
For source types Purchase Order and Sales Order when actual Due Date is changed in the released document, the Cash Flow Ledger Entries will update Cash Flow Date and Due Date.
Cash Flow ledger Entries can be deleted as needed. You can only delete transactions that have not been paid and for which a line has not been created in the financial journal.
To delete, select the entries you want and click the Delete button on the Cash Flow Ledger Entries page.