Поделиться через

Due Date Filter Field, Payment Order Table

  • Статья

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 calculated fields in this table that are affected by this filter are: Amount and Amount (LCY).

You can enter a date or a range of dates. Special rules must be followed when entering them:

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 documents with due date 15/12/96.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

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

Those with due dates on or between 15/12/96 and 15/01/97.
Those with due dates prior or equal to 15/12/96.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

15/12/96 16/12/96

Those with due dates on 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

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

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
Payment Order Table Spain Local Functionality
Payment Order Table Spain Local Functionality