Generating Remittance Advice Report

Select the “Remittance Advice Report” link under the “EDK Reports Payables Management” business component.

The “Remittance Advice Report” page appears.

Enter the following criteria to generate the Remittance Advice report.

Company Code	The identification code of the company for which you want to generate the Remittance Advice report.
Finance Book	Use the drop-down list box to select the finance book. The system displays the “All” option and other finance books as defined in the “Organization Setup” business component for the login organization unit).
Bank Account No	Use the drop-down list box to select the code identifying the bank account number for which the remittance advice report must be generated (Alphanumeric, 15).
Supplier Code From	The starting code in the range of supplier codes.
Supplier Code To	The ending code in the range of supplier codes.
Note: The “Supplier Code To” number must be greater than the “Supplier Code From” number.
Pay Currency	Use the drop-down list box to select the currency in which the payment is made to the supplier.
Pay Date From	The starting date, in the range of dates on which payment is made, Date Format). Mandatory. The system defaults this field to 01-01-2000, if you do not specify a value.
Pay Date To	The ending date, in the range of dates on which payment was made, (Date Format) Mandatory. The system defaults the field to the system date, if you do not specify a value.
Note: The “Pay Date To” date must be later than or the same as the” From Date”.
Supplier Name	The name of the supplier.
Voucher No From	The starting number in the range of voucher numbers.
Voucher No. To	The ending number in the range of voucher numbers.
Note: The “Voucher No. To” must be greater than or the same as the”Voucher No. From”.
Run #	A unique number identifying all the payment vouchers and check numbers issued
Check No. From	The starting number in the range of check numbers.
Check No. To	The ending number in the range of check numbers.
Note: The “Check No. To” must be greater than or the same as the”EFT No. From”.
Report Type	Use the drop-down list box to specify the type of the remittance advice report which you want to generate. You can select from the following options: Detail – Select this option if you want to generate a document level remittance report. Detail – Line Level – Select this option if you want to generate line level remittance report. The system displays “Detail” by default.
EFT No. From	The starting number in the range of EFT numbers.
EFT No. To	The ending number in the range of EFT numbers.

Note: The “EFT No. To” must be greater than or the same as the”EFT No. From”.

Enter the following in the “Adjustment Information”.

In case, for a Supplier(s) if some/all the Credit Documents are adjusted against Debit documents, those Credit documents won’t be available for payment and hence those adjustment details will not be displayed in the Remittance Advice. To include the details of fully adjusted Credit document in this report, ‘Adjustment Information’ must be specified as mentioned below.

Fully Adjusted Credit Docs.

Use the drop-down list box to specify whether you wish to include or exclude the credit documents that got fully adjusted, in the remittance advice report. More..

Exclude - If you select this option, the details of the credit documents that got fully adjusted against the debit documents, will not be displayed in the remittance advice repot.
Include - If you select this option, the details of the credit documents that got fully adjusted against the debit documents, will be displayed in the remittance advice report.

The system displays “Exclude” by default.

Adjustment Date From

The starting date, in the range of dates, from which the Fully Adjusted Credit Documents will be displayed in the remittance advice report. (Date Format).

Ensure that the date specified in this field must be earlier than or equal to the “Adjustment Date To” or the current system date.

Adjustment Date To

The ending date, in the range of dates, up to which the Fully Adjusted Credit Documents will be displayed in the remittance advice report (Date Format).

Ensure that the date specified in this field must be later than or equal to the “Adjustment Date From” or the current system date.

Note: The Adjustment Date ranges must be specified only when “Include” is specified in the “Fully Adjusted Credit Docs” drop-down list box. The details of fully adjusted Credit documents will be printed separately for each supplier for the given Adjustment Date range.

Click the “Print” pushbutton to print the Remittance Advice Report.

The system prints the details of the fully adjusted credit documents separately for each supplier for the specified Adjustment Date ranges.