Share via


Due Date Filter Field, Bill Group Table

In this field, you can enter a due date filter for the documents included in this bill group. This means that the program will only take into account those documents with a due date on the date or within the range of dates specified in this field.

The fields calculated and allocated in this table for this filter are: Amount and Amount (LCY).

You can enter a date or a time period. There are special rules for how to enter them:

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

Width1 Width3Width1560 Width3Width2126 Width3Width3969 Meaning

Example

Documents included:

Width1 Width3Width1560 Width3Width2126 Width3Width3969

12/15/96

Only those documents with a due date of 12/15/96.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

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

Those documents with a due date between 12/15/96 and 01/15/97 inclusive.
Those with a due date of 12/15/96 or before.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

12/15/96 12/16/96

Documents with a due date of 12/15/96 or 12/16/96.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

You can also combine the various format types:

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

Documents with a due date of 12/15/96 or in the period 12/01/96 and 12/10/96 inclusive.

Width1 Width3Width2835 Width3Width4820

Documents with a due date of 12/14/96 or before, or bills with a due date of 12/30/96 or late; i.e. all the due dates except those falling in the period 12/15/96 to 12/29/96 inclusive.

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
Bill Group Table Spain Local Functionality
Bill Group Table Spain Local Functionality