search

frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.06k stars 7.22k forks source link

Advance amount in Accounts Payable report is incorrect #43604

Open venkat102 opened 1 week ago

venkat102 commented 1 week ago

Information about bug

Advance amount in Accounts Payable report is not correct when the advances paid to suppliers are marked as assets and reconciled later.

https://github.com/user-attachments/assets/2eeb530c-34cd-4c8b-84d7-da7b18ad1e8d

Module

accounts

Version

ERPNext Version: 15+

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response

Swethadevi-D commented 4 days ago

The Accounts Payable Summary Report is functioning correctly, in the Payment Entry, when you pay an advance amount, it is posted to the creditors' account. However, when you create a Journal Entry, the amount is posted to the sales account, leaving no balance in the creditors' account. When using the Payment Reconciliation Tool, it fetches unreconciled data from the Payment Entry. After reconciling, the paid amount appears as a negative value because there is no balance in the creditors' account so only it shown negative amount in report