Share via


Honored/Rejtd. at Date Filter Field, Bank Account Table

A paid/rejected date filter may be enterd in this field for the documents delivered to this bank.

Then the program will only take into account those documents with a paid/rejected date within the range specified in this field.

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 with a date of 15/12/96 in the Payment/Rejection Date field.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

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

Those with a date on or between 15/12/96 and 15/01/97 in the Payment/Rejection Date Field.
Those with a date of 15/12/96 in the Payment/Rejection Date field.

Width1 Width3Width1560 Width3Width2126 Width3Width3969

15/12/96 16/12/96

Those with a date of 15/12/96 or 16/12/96 in the Payment/Rejection Date field.

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..

Documents with dates on 15/12/96 or on or between 01/12/96 and 10/12/96 in the Payment/Rejection Date Field.

Width1 Width3Width2835 Width3Width4820

Documents with dates of 14/12/96 or earlier, or bills with payment/rejection dates of 30/12/96 or later in the Payment/Rejection Date Field; i.e, all due dates except those 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
Bank Account Table General Ledger
Bank Account Table General Ledger