List of Outstanding Items - Document and Payment Due

List of Outstanding Items - Document and Payment Due

The selection influences on the way partial payments of receivables and payables are displayed. It does not have an effect on balance of outstanding items (it stays the same). But it does influence on the distribution of the value of document as well as its subequent payment to specific date columns. 

It is wise to use Document choice, since by using it it displays summary open value of documents according to their maturity.

To illustrate both types of report let us look at the following example:

• Date of report: 18th April 2007
• invoice €1.000, document date 1st April 2007, due date on 9th April 2007 (on 18th April 2007 makes for 9 days of delay)
• payment  €800, date of payment due (value date of payment) 16th April 2007 
• remaining (outstanding) amount of €200

1. Payments  

If you select date of payment due, the amount of document for partially closed items is shown in that date column in which the payment belongs.

• Document shall be shown in the date column regarding the value date of document. Document has on 18th April 2007 a 9-day delay, and this is why the complete amount of document falls in the date column Overdue - from 1 to 6 days, as a positive amount (inflow).
• Payment shall be shown in the date column according to its value date. It has been received 3 days prior to the date of report so it falls in the date column Overdue - from 1 to 6 days as a negative amount.
• The remainig amount to be paid is equivalent to €200.

2. Documents

If you select date of document due, the amount of partial payment for partially closed items is shown in that date column where the document that is closed by payment belongs.

• Document shall in any case be shown in the date column according to the value date of document. The document has on 18th April 07 a 9-day delay, that is why the complete amount of document falls in the date column Overdue - from 7 - 14 days, as a positive amount (inflow).
• Payment shall be shown in the date column according to the value date of document. It relates to the document having a 9-day delay, and that is why its subsequant payment also falls in the same column (as a negative amount).
• The remaining amount to be paid is equivalent to €200.