[OFBIZ-10796] Check run payment(A/P) transactions not getting available for reconciliation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Release Branch 16.11, 16.11.05, Release Branch 18.12, Release Branch 17.12, Trunk
• Fix Version/s: 16.11.07, 17.12.01, 18.12.01
• Component/s: accounting
• Assignee: Pawan Verma
• Reporter: Chinmay Patidar
• Created: 12/Jan/19 05:47
• Updated: 03/Oct/19 12:09
• Resolved: 03/Oct/19 12:09

Description

Check run payment group transactions don't get available for Financial Account reconciliation. Though the financial account balance gets updated during the A/P check run process, the system must allow the user with an additional step of reconciling the transactions.

Steps to regenerate:

1. Create a Check Run type payment group by issuing checks for an invoice/ the invoices from the following screen: https://demo-trunk.ofbiz.apache.org/ap/control/FindPurchaseInvoices
2. (Additional Note)The balance of the financial account gets updated as soon as the payment group is created.
3. Visit to the "Find Transaction" screen of the company from which the check run was created.
4. Set 'Gl Reconciliation ID' field to value 'Not Assigned' and find the transaction. The newly created Financial account transaction won't be available to assign to a reconciliation.

The cause of this is that the financial account transaction doesn't get created in the 'Created' status and has an 'Approved' status. An approved status financial transaction directly updates the financial account balance and thus don't appear in the list of the transactions to be reconciled.