Related topics
On this panel you select the documents you want to make an enquiry on. You can also use an already existing template, with predefined selections and sequences, to make the enquiry.
This is the first of three panels where you can make your selections and define your sequences. Scroll to view the following two panels, i.e. Selection part 2 and Sequence.
Function keys
| Print the selected transaction. | |
| Export | Export to an Excel or a CSV file. |
| Balances | Display balance information (for the current period as well as three periods backward and forward) for the selected supplier. |
Selection part 1
- Supplier number
- Supplier invoice no
- Division
- Cost centre
- Document type
- Document number
- Document date
- Due date
- Accounting period
- Transaction currency
- Original amount
You can enter a lower and upper limit for transaction currency amounts. If you do, only documents with original amount within the given range are included in the selection. - Remaining amount
You can enter a lower and upper limit for transaction currency amounts. If you do, only documents with remaining amount within the given range are included in the selection. - Open documents
Set to YES to include all open documents. Set to NO to display all settled documents. If you leave this field blank all documents will be presented.
Note: Original amount is used as the selection value for all document types except for redefinition documents (data type 5), where creation amount is used.
A/P transactions enquiry (FLR50512)
On this panel you can make further selections.
Function keys
| Print the selected transaction. | |
| Balances | Display balance information (for the current period as well as three periods backward and forward) for the selected supplier. |
| Statistics | Display payment statistics for twelve periods back for the payment statistics group to which the supplier belongs. |
Selection part 2
- Matched invoices
- Payment proposal
- Approved for payment
- Attestor
- Payment stop code
- A/P group
- Document data type
The value(s) that you may enter for this field are depending on the language defined for your user profile in Work with DC1 user profiles. Special panel value translation must be defined for this language in Work with languages.
Note: It is only possible to enter individual selections for this field, i.e. type 1 or 3.
A/P transactions enquiry (FLR50513)
On this panel you define the sequences for how the selected documents should be organised and displayed.
Function keys
| Print the selected transaction. | |
| Balances | Display balance information (for the current period as well as three periods backward and forward) for the selected supplier. |
| Statistics | Display payment statistics for twelve periods back for the payment statistics group to which the supplier belongs. |
Sequence
- Supplier number
- Division
- Cost centre
- Document type
- Document number
- Document date
- Due date
- Accounting period
- Transaction currency
- Original amount
Sequencing on Original amount is not possible if among selected documents, documents with data type = 5 (redefinition document) can be found. - Remaining amount
- Payment stop code
- A/P group
- Document data type
When you sequence by this parameter the order of the documents being displayed is determined by the order of the data base values for the document data type, which is the following: invoices, payments, difference documents, control adjustment documents and redefinition documents.
- A/D
Save as template (FLR50514)
In this pop-up window you can save the made selections and sequences, that you are currently working with on the A/P transactions enquiry panel, in a new or an existing template. You will be requested to click OK on this panel to either confirm the replacement or the new template.
- Template
- The system will automatically retrieve the ID of the template you are currently using. You can change the name to a new one, or use the name of an existing template.
When you enter the A/P transaction enquiry from another enquiry program where keys were selected, these keys will be passed to the A/P transaction enquiry by template *USERID. It is recommended not to save any selection values on templates under the name *USERID.
Note: Changing template will override the made selections and sequences of the old template with the new ones.
- Description
- For existing templates, the current description is suggested. This description may be changed. Note: The defaulted description is the description entered when the template was created, even if a translated description exists.
A/P transaction enquiry, Print (FLR50515)
On this panel you order a printout of the selected transaction.
- Template
- The system will automatically retrieve and display the ID and description of the template you are currently using.
A/P transactions enquiry, All documents (FLR50501)
This panel displays a listing of all documents (other than control account adjustment transactions as these have to be specifically selected to be displayed), that have been selected, sorted in ascending or descending order.
Shown for each document is the following information:
- Supplier invoice number
- Document date
- Due date for each document
- “Text” code (T). Indicates if there is complementary text connected to the document via the text editor. This text could, for example, be information to your supplier. Note: The name of this field may be different than above, depending on the language code for Text.
- Remaining amount to be settled in transaction, primary, system or reporting currency.
- Transaction currency
The following information is shown if the specific column has been activated through the Edit columns feature.
- Payment stop code, i.e. if a document has been stopped for payment. The codes are defined in Work with stop codes.
- Account group code (Ag)
- Payee
- Supplier number
- Cost centre (Cst cnt)
- Batch number
- Journal, i.e. the journal number which the journal received when the first attempt to update it was made.
- Accounting period (Per), i.e. the accounting period in which each document was entered
- Voucher date
- Voucher type and number
- Bank, i.e. the suppliers bank
- Bank account number
- Proposal number
- Update date
- Text, i.e. the document text retrieved from Work with document types or entered manually when the document was created.
- Country
- Transaction currency (Tran)
- Primary currency (Prim)
- Original amount of the document in transaction, primary, system, and reporting currency. For a redefinition document and a bill document the amount shown is the creation amount and not the actual original amount.
- Remaining amount of the document in transaction, primary, system, and reporting currency.
- Accumulated remaining amount in system or reporting currency.
- Exchange rate period (Ex Period) i.e. the exchange rate period of the main document.
- Exchange rate level and time
- Exchange rate
- Creation date and time i.e. the date and time when this document was created.
- Created by (User) i.e. the user ID of the person who created this document.
- Division code
- Turnover amount
- Import/export code (I/E)
- Payment mode
- “Approved” code (A), indicates if the transaction is approved for payment.
- Attestor. The initials of the person who approves the transaction for payment.
- Supplier invoice date
- Received date
- “Matched” code (M), indicates if there are matched purchase order lines against this A/P document.
- Bank reference number
- Terms of payment (TOP), i.e. the terms of payment of the document.
- Instalments, indicates if there are any instalment conditions for this document.
- Due date for cash discount 1
- Due date for cash discount 2
- Cash discount 1 percentage (% 1 CAD), i.e. the percentage of cash discount 1.
- Cash discount 2 percentage (% 2 CAD), i.e. the percentage of cash discount 1.
- Cash discount 1 days (Days 1 CAD), i.e. the number of days within which the document must be paid for cash discount 1 to be granted.
- Cash discount 2 days (Days 2 CAD), i.e. the number of days within which the document must be paid for cash discount 2 to be granted.
- Cash discount base, i.e. the amount on which the cash discount should be based.
- VAT amount
- VAT registration number
- Quarterly list account code (QL)
- Trader country
- Exchange rate for VAT
- VAT
- “Reconciled” code (R), indicates if the payment has been reconciled to a bank statement via the Work with cash book reconciliation routine.
- Supplier name
- Sundry supplier name
- Payee name
Options
| Settled | Select this option to view settlement information for the main document. |
| G/L trans | Select this option to view related G/L postings. |
| Matched PO lines | Select this option to view all purchase order lines that have been matched against this A/P document. |
| Text | Select this option to view/work with document text. |
Function keys
| Selections | Return to the previous panel where you can change the selection parameters. |
Selection fields
- Supplier no
- The number of the supplier for this transaction is shown with the internal name next to it.
- Cost centre
- Displays the cost centre entered for this transaction.
- Division
- Displays the entered division.
- Act balance
- The actual balance is indicated in system or reporting currency for any of the following valid selections:
- Division (when the Division concept is used)
- Cost centre (when Cost centre accounting is used)
- Division and supplier
- Cost centre and supplier
- Supplier no
- Tot selected
- This is the accumulated remaining amount for the selected documents in system or reporting currency.