Accounts Payable with Payment Management Report

Problem Statement

The Accounts Payable report in ERPNext provides a comprehensive overview of all outstanding payables to suppliers. Now out of these payable, the management or finance head may want to decide which invoices to be processed today. If action is based various factors including total payment that they can process based on bank balance.

Currently there is no easy way to give instructions to process specific outstanding payments to the accounts team from accounts payable report. This new report tries to solve this problem.

Introduction

This report is identical to Accounts Payable report, but it adds additional features of allowing user to choose payments to be processed, shows total amount of chosen payments to compare it with bank balance and process payments by creating draft payment entry or payment order directly from the report.

Access the report:

1. Search for "Accounts Payable with Payment Management Report" in ERPNext.

2. The report will load, displaying the relevant data

   

Using the Report Filters

All filters in this report function as standard filters in the ERPNext Accounts Payable report.

1. Group By Supplier: When this filter is applied, the data is displayed as grouped by supplier.

   

Creating Payment Entries:

1. Selecting Rows: Select the rows corresponding to the invoices you want to pay. The system adds the amount of each selected invoice to the number card, showing the total amount to be paid

   

2. Number Card: Displays the total amount of the selected invoices. Additionally, “Actions” Button will be visible at the upper right corner of the report.

   

3. Creating Payment Entries:

   1. Click on the Action button.

   2. Select Create Payment Entry.

   3. The system will create a payment entry for each selected supplier.

   4. Once the message appears following payment entry creation, clicking the payment entry link will take you to the relevant Payment Entry

   

Additional Features

1. Handling Multiple Documents: If you have both Purchase Invoices and Journal Entries in the system, you can select rows for both. The system will create a payment for each selected document.

2. Create Payment Request: There is a Create Payment Request option within the Action button to automatically generate payment requests.

   

Conclusion

The Accounts Payable with Payment Management report is an essential tool for financial management, providing a clear view of outstanding payables and facilitating eƯicient payment processing. By using this report, businesses can ensure timely payments and maintain good relationships with suppliers