Share via

Due Date Filter Field, Posted Bill Group Table

  • Article

You can enter a due date for the documents in this bill group in this field. This will cause the program to only consider the document with a due date falling on the date or in the range of dates specified in this field.

This filter in this table affects the following fields: Amount, Amount Grouped, Remaining Amount, Amount (LCY), Amount Grouped (LCY) and Remaining Amount (LCY).

If this field contains the start and end date for a period, the Amount field, for example, will show the balance corresponding to the amount of the bill group posted in the date range you specified.

You can enter either a date or an interval; however you must follow certain rules:

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

Width1 Width3Width1560 Width3Width2126 Width3Width3969

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

Documents with a due date in the period 12/15/96 to 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..

Entries posted on 12/15/96 or in the period 12/01/96 to 12/10/96 inclusive.

Width1 Width3Width2835 Width3Width4820

Entries posted on 12/14/96 or before, or entries posted on 12/30/96 or after: that is, all the entries excep those posted 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
Posted Bill Group Table Spain Local Functionality
Posted Bill Group Table Spain Local Functionality