1. Bilateral Loans
  2. Processing Repayments
  3. Pay Receivable Upload

7.5 Pay Receivable Upload

Specify the User ID and Password, and login to Homepage.
  1. On the homepage, type OLDPRUPL and click next arrow.
    The Payable Receivable Upload screen is displayed.

    Figure 7-3 Payable Receivable Upload


    Description of Figure 7-3 follows
    Description of "Figure 7-3 Payable Receivable Upload"

  2. For payable receivable upload, you should enter the below fields in the .csv file to be uploaded.
    • Contract Reference Number
    • Component
    • Payable/Receivable Amount
    • Due Date
  3. Click New and select the .csv file name using the LOV in the search block field XL File to be uploaded and upload the file.
  4. You should key in negative amount for payable and positive amount for receivable amount in the Excel spreadsheet. After uploading the file, you should click the save button.
  5. The system performs the below validations during the save of payable receivable upload and appropriate error messages are displayed if any validation is failed.
    • Header format of the uploaded .csv file should be in accordance with the upload template.
    • Format of the individual line items must be in accordance with the upload template.
  6. Records are saved upon successful validation and the system displays a message saying the upload is successful; the uploaded records are updated in the detailed block and enabled for authorization.
  7. Once the records are populated in the detailed block, you are not allowed to delete any record individually. In cases where you want to delete some of the records, you should delete the upload and perform a new upload.
    This topic contains the following sub-topics:

Parent topic: Processing Repayments