PRQ/ RMT Report

The PRQ/ RMT report provides detailed information on payment requisitions and remittances issued to pay suppliers or repay customers. The information is taken from contracts, interfaces and manual transactions.

Purpose

The purpose of this report is as follows:

To display payment requisitions/remittances that were issued on specific dates.
To display payment requisitions/remittances that were issued to specific suppliers.
To display payment requisitions/remittances that were issued by specific users.

Output

The report has two system templates:

PRQ RMT: The PRQ/RMT report provides detailed information on payment requisitions and remittances issued to pay suppliers or repay customers. The information is taken from contracts, interfaces and manual transactions.
Detailed PRQ: The Detailed PRQ report provides detailed information on vouchers and refunds for which a payment requisitions was issued to pay suppliers or repay customers. The information is taken from contracts, interfaces and manual transactions.

This report has the following layouts:

CSV
DOCX
PDF
Text
XLSX

In addition, there is a Print option.

How to generate a report - see Reports.

Filters

The report has the following parameters which are shown on the left and enable you to filter the report output

Filters for PRQ/RMT report:

Parameter	Description
Type	Choose the document type: PRQ (payment requisitions) or RMT (remittances).
Display Currency	Choose between system and travel file currency.
Issue Date	Choose the date range in which the document was issued.
Value Date	Choose the date range of the document due date.
Document No.	Choose the range of document reference numbers.
Status	Choose the document status: Active or Cancelled.
Branch	Choose the branch where the document was issued.
Issuing User	Choose the user who issued the document.
T. File User	Choose the user of the travel file.
Doc. Currency	Choose the document currency.
Credit Account Type	Choose the type of the credit account.
Debit Account Type	Choose the type of the debit account.
Debit Account Name	Choose the name of the debit account.
T. File Number	Choose the travel file number.
Form of Payment	Choose the form of payment on the document.
Supplier Paid	Choose the supplier paid.
Cover	Choose whether the PMQ/RMT was covered or not covered.

Filters for Detailed PRQ report:

Parameter	Description
Display Currency	Choose between system and travel file currency.
Issue Date	Choose the date range in which the document was issued.
Value Date	Choose the date range of the document due date.
Document No.	Choose the range of document reference numbers.
Status	Choose the document status: Active or Cancelled.
Branch	Choose the branch where the document was issued.
Issuing User	Choose the user who issued the document.
T. File User	Choose the user of the travel file.
Doc. Currency	Choose the document currency.
Supplier Paid	Choose the supplier paid.
PRQ Type	Choose between No Supplier and Supplier.

Example

The generated PRQ/ RMT report displays payment requisitions and remittances issued to pay suppliers or repay customers. Each row in the table represents a requisition or remittance.

The following fields are displayed in the generated report:

Field	Description
Type	This field shows the type of document that is covered by the payment requisition.
Currency	This field shows the document currency.
Document No.	This field shows the reference number of the document that is covered by the payment requisition.
Status	This field shows the document status.
Issue Date	This field shows the issue date of the document.
Value Date	This field shows the document due date.
Branch	This field shows the branch where the document was issued.
Issuing User	This field shows the user who issued the document.
Supplier Paid	This field shows the supplier the document was issued for.
Credit Account Type	This field shows the type of the credit account.
Credit Account Name	This field shows the name of the credit account.
Debit Account Type	This field shows the type of the debit account.
Debit Account Name	This field shows the name of the debit account.
For Details	This field shows the details of the document recipient.
Cover RMT/PRQs	This field shows the remittance covering the payment requisition.
Payment method	This field shows the payment method used to cover the payment requisition.
Remark	This field shows the remark on the payment requisition.
Amount Doc. Curr.	This field shows the total amount on the document.
Doc. Currency	This field shows the document currency.
Amount	This field shows the total amount on the document in the travel file currency.
Currency	This field shows the document currency.
T. File	The travel file where the voucher covered by the payment requisition or remittance was issued

Example

The generated Detailed PRQ report displays the following columns for each payment requisition that matches the search criteria. Each row represents a single payment requisition.

The following fields are displayed in the generated report:

Field	Description
Status	This field shows the document status.
PRQ	This field shows the document reference number.
Doc. Type	This field shows the type of document.
Doc.#	This field shows the document number.
Issue Date	This field shows the issue date of the document.
Value Date	This field shows the document due date.
Branch	This field shows the branch where the document was issued.
Issuing User	This field shows the user who issued the document.
Supplier Paid	This field shows the supplier the document was issued for.
Income Type	This field shows the type of income.
For Details	This field shows the details of the document recipient.
Amount	This field shows the total amount on the document.
Currency	This field shows the document currency.
Amount T. File Curr.	This field shows the total amount on the document in the travel file currency.
T. File Curr.	This field shows the travel file currency.
Remark	This field shows the remark on the payment requisition.
Cover Doc.	This field shows the remittance covering the payment requisition.
T. File	This field shows the travel file where the voucher covered by the payment requisition or remittance was issued.