Advanced Outstanding Invoice & Bill Report
by TechUltra Solutions Private Limited https://www.techultrasolutions.com/$ 23.12
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 1300 |
| Technical Name |
pending_payment_report |
| License | OPL-1 |
| Website | https://www.techultrasolutions.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 1300 |
| Technical Name |
pending_payment_report |
| License | OPL-1 |
| Website | https://www.techultrasolutions.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
Advanced Outstanding Invoice & Bill Report
This accounting module helps businesses track and manage outstanding customer invoices and vendor bills. It allows users to generate a detailed Excel and Pdf report with filtering options such as date range and invoice type, grouping data by Customer or Vendor with totals, paid amounts, pending balances, and invoice counts. The report includes currency-wise totals and a grand total, and it also supports automatic email notifications for efficient payment follow-ups.
An advanced accounting module to track outstanding customer invoices and vendor bills with ease. Generate detailed Excel and PDF reports with smart filters, grouped totals, currency-wise summaries, and automatic email notifications for efficient payment follow-ups.
https://wa.me/message/VENRAJRHMSWEB1
OR
Features
Screenshots
Support
FAQs - User can generate Outstanding payment Excel report of invoice/bill from wizard.
- Pending payment Excel and Pdf report data group by customer/vendor.
- User can use multiple filters to generate Excel And Pdf report: start date, end date, due date and customer/vendor selections.
- User can generate Excel report for only invoice, only bill, or both at same time.
- Currency wise total and grand total available in report.
- Auto send pending payment detail (both invoice/bill) mail to configured user.
1. Accessing the Pending Payment Reports
After installing and activating the module, navigate to Invoicing > Reporting. At the bottom of the Reporting menu, you will find two newly added options: Pending Payment Report and Advance Pending Payment Report, as shown in the attached image. These menus provide access to the respective reporting wizards for generating detailed outstanding payment reports.
2. Pending Payment Report Wizard
Click on Pending Payment Report to open the wizard. Here, you can filter by Customer (optional), Invoice/Bill date range, Due date range, Salesperson (optional), Currency, and Invoice Type (Customer, Vendor, or Both). If any optional field is left empty, the report includes all records by default. The wizard provides options to View Report, Print PDF, Print Excel, and Send the report to a configured user via email for easy follow-up and reporting.
3. PDF Report Output
After clicking on Print Report, the system generates the PDF version of the Pending Payment Report. The report will be displayed in a structured and professional format, as shown in the attached image.
4. Excel Report Output
After clicking on Print Excel Report, the system generates the Excel version of the Pending Payment Report. The exported file will appear in a structured format with grouped data, totals, and pending amounts, as shown in the attached image.
15. Auto-Send Report Configuration
Under the Pending Payment Report menu, you can configure the partner who will automatically receive the report when "Send to Configured User" is clicked in the wizard.
6. Send Report to Configured User
By clicking on Send to Configured User in the wizard, the system automatically emails the generated report to the user configured earlier in the settings. The email includes the report details and attachment in a professional format, as shown in the attached image.
7. View Report (On-Screen Preview)
Click on View Report in the wizard to display the report directly on the screen. The report will show detailed information including Customer Name, Invoice Type, Currency, Total Amount, Paid Amount, Pending Amount, Total Number of Invoices, and Customer Email ID, as illustrated in the attached image. This option allows users to quickly review pending payment details without downloading the PDF or Excel file.
8. Vendor Bill Report Generation
To generate the Vendor Bill report, select Vendor in the wizard, configure the required date ranges, and choose Invoice Type as Vendor Bill. You may also choose to print only Invoiced records, if required. After applying the filters, click on Print Report to generate the PDF, which will appear as shown in the attached image. This allows you to analyze outstanding vendor bills based on the selected criteria.
9. Using the Advance Pending Payment Report
Navigate to Advance Pending Payment Report to access the advanced reporting wizard. Here, you can configure the required filters such as Date range, Company, and Invoice Type. If you leave the Partner and Salesperson fields blank, the system will automatically include all partners and all salespersons in the report. After setting the desired criteria, simply click on Print Report to generate the report as per the selected filters.
10. Advance Pending Payment Report Output
After clicking on Print Report, the Advance Pending Payment Report is generated based on the selected filters and displayed in a structured format, as shown in the attached image. The report includes all relevant pending payment details according to the configured criteria.
- We provide 90 days bug-free support related to our module.
- We provide 5 hours of free configuration support. Additional configuration or customization is billable.
- The support team is available from Monday to Friday 10:00 AM to 07:00 PM (IST).
- To create a ticket, send an email to support@techultra.in.
This module helps track and manage outstanding customer invoices and vendor bills through detailed PDF and Excel reports.
Yes, you can generate reports for Customer Invoices, Vendor Bills, or both, depending on the selected Invoice Type.
If left blank, the report will automatically include all Customers or Vendors.
Yes, you can send the report to a configured user via email directly from the wizard.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module