Language:


Liquidity Report Info

This page describes the Liquidity Report Info setting in the Nominal Ledger.

---

The Liquidity Forecast report is a forecast of future incoming and outgoing payments that will be useful for cash flow prediction purposes. The forecast will include open (unpaid) Purchase and Sales Invoices that it will predict will be paid on their Due Dates.

The Liquidity Report Info setting allows you to change the Due Date of an Invoice solely for the Liquidity Forecast report (i.e. without changing the Invoice itself).The information in the Liquidity Report Info setting will be included in the Liquidity Forecast report if you product it using the Detailed incl. Liq. Info. option.

Illustrated below is an example Liquidity Forecast report (Detailed version):

If it seems likely that Invoice 980160 will be paid one month later than its Due Date, we can create a record in the Liquidity Report Info setting to this effect. We will not change the Due Date in the Invoice itself because we do not want the later Due Date to be used in statements and other documents that we might send to the Customer. The change is only for our internal cash flow prediction.

At this stage, fill in the following fields:
No.
A unique identifying number will be assigned to the record automatically.

Trans. Date
Paste Special    Choose date
The Trans. Date will default to the current date and so will show when the record was first saved. You can change this date if necessary.

Sales Invoice, Purchase Invoice
Select one of these options to specify whether the record you are entering refers to a Sales Invoice or a Purchase Invoice.

Rec. No.
Enter the Invoice Number or the Purchase Invoice Number of the Invoice whose Due Date you are changing. When you leave the field, the Due Date, outstanding amount and Contact Number and Name will be brought in to the fields below.

New Pay Date
Paste Special    Choose date
Enter the new Due Date in this field. When you specify a Record Number in the field above, the Due Date from the relevant Invoice or Purchase Invoice will be copied here as a reminder.

Sum, Base Sum
When you specify a Record Number in the field above, the amount that is outstanding against the relevant Invoice or Purchase Invoice will be copied to these fields. The Sum is the outstanding amount in the Invoice Currency, while the Base Sum is the outstanding amount in your home Currency (Base Currency 1).

Comment
Enter a comment such as the reason why you are changing the Due Date. This Comment will be shown in the 'Liquidity Info: Browse' window and in the Liquidity Forecast report. The Comment from the Invoice or Purchase Invoice will be brought in as a default.
After saving the record, the new Due Date will be shown in the Liquidity Forecast report when we produce it using the Detailed incl. Liq. Info. option:

When the Invoice is paid or credited, the Liquidity Report Info record will be marked as Closed. If the Invoice is partially paid or credited, the Liquidity Report Info record will be marked as Closed and a new one created for the remaining outstanding amount. This new record will contain the same New Pay Date as the original one, but you can change it if necessary.

You can also use the Liquidity Report Info setting to schedule payment in instalments. Enter a record as described above with the date of the first instalment in the New Pay Date field and the first instalment amount in the Sum and Base Sum fields. Then enter separate records for the subsequent instalments. In each case, when you enter the Record Number, the outstanding amount less the sum of the previous instalments will be brought in to the Sum and Base Sum fields.

The instalments will be listed separately in the Liquidity Forecast report:

If an Invoice was originally payable in Instalments (i.e. it uses a Payment Term that is connected to a record in the Instalments setting in the Sales Ledger), those Instalments will be listed individually in the Liquidity Forecast report. If you enter a Liquidity Forecast Info record for such an Invoice, that record will replace all the Instalments in the report. Depending on the circumstances, you may need to enter separate Liquidity Forecast Info records for each Instalment (e.g. when each Instalment will be one month later than originally scheduled).

---

Settings in the Nominal Ledger:

Go back to: