This appendix contains this topic:
The time it takes to locate vouchers on Supplier Ledger Inquiry grows in proportion to the number of records in the system. Supplier Ledger Inquiry uses logical files whenever possible to speed processing time. You can, however, set up the selection criteria to use IBM's Structured Query Language (SQL).
The following table states which combinations are supported by the use of a logical file. The combination of Fields Entered, Paid Value and Sequence will determine which logical files can be used for your search. Combinations other than what is presented below will automatically use SQL to retrieve the information, if SQL processing has not been prevented by the processing option.
| Fields Entered | Paid Value (0, 1, 2) | Advised Sequence |
|---|---|---|
| Address Number | 0 | 1, 2, B |
| Address Number | 0, 1, 2 | 4, 5, 6, 7, 8, A |
| Address Number, Invoice Number | 0, 1, 2 | 4 |
| Document Number | 0, 1, 2 | 1 |
| Document Number, Document Type | 0, 1, 2 | 1 |
| Address Number, Document Number | 0, 1, 2 | 1, 7 |
| Address Number, Document Type | 0, 1, 2 | 6, A |
| Address Number, Document Number, Document Type | 0, 1, 2 | 1, 6, 7, A |
| Address Number, P.O. Number | 0, 1, 2 | 5 |
Note:
If the processing option has been set to sequence by Net Due Date, Invoice Date or G/L date (2, 3 or 8) in descending order, SQL will be automatically used for these searches.