Share via

Due Date Filter Field, Posted Payment Order Table

  • Article

You can enter in this field a due date filter for the documents included in this payment order. The program will only consider those documents with due dates on the date, or within the range of dates, specified in this field.

The fields in this table that are affected by this filter are: Amount, Amount Grouped, Remaining Amount, Amount (LCY), Amount Grouped (LCY) and Remaining Amount (LCY).

If the field contains the starting and ending dates of a period, then in the field Amount, for example, it will show the balance of the posted payment order within the specified date range.

A date or a range can be entered. The following rules must be followed:

Width1 Width3Width1560 Width3Width2126 Width3Width3969 Equal to RangeWidth1 Width3Width1560 Width3Width2126 Width3Width3969 Either/or

Width1 Width3Width1560 Width3Width2126 Width3Width3969 Meaning

Example:

Documents included:

Width1 Width3Width1560 Width3Width2126 Width3Width3969

15/12/96

Only those posted on 15/12/96.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

15/12/96 .. 15/01/97
..15/12/96

Those posted on or between 15/12/96 and 15/01/97.
Those posted 15/12/96 or earlier.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

15/12/96 16/12/96

Those posted 15/12/96 or 16/12/96.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

Different formats may also be combined.

Width1 Width3Width2835 Width3Width4820 15/12/96 01/12/96 .. 10/12/96Width1 Width3Width2835 Width3Width4820 ..14/12/96 30/12/96..

Entries posted on 15/12/96 or on or between 01/12/96 and 10/12/96.

Width1 Width3Width2835 Width3Width4820

Entries posted on or before 14/12/96, or entries posted 30/12/96 or later: this is, all postings except those posted on or between 15/12/96 and 29/12/96.

Width1 Width3Width2835 Width3Width4820

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Posted Payment Order Table Spain Local Functionality
Posted Payment Order Table Spain Local Functionality