Create a GL_Journal when reconciling posting manually

14 views
Skip to first unread message

Nicolas Micoud

unread,
Oct 21, 2025, 5:17:24 AM (yesterday) Oct 21
to iDempiere
Hi,

A customer ask for an improvement on the Reconciliation form and I think that would make sense to implement it in trunk.

ATM, when you are reconciling posting, the difference must be 0.
So, when there is a difference (even minor), you have to manually add a GL_Journal to set it to 0.
And then you have to refresh the content and re-select posting.

Idea would be to allow user to create this journal directly from the panel.
2 SysConfigs would be needed :
* Maximum Amount
* Maximum Percentage of the total

2025-10-21 11_15_28-_TEST_ iDempiere — Mozilla Firefox.png


In this case, the difference is $2 on a total of $100.
So the journal would be created if Maximum Amount is >= 2 and Percentage is >= 2

A checkbox could be added between Difference and Process and be enabled if conditions are met.
User can then tick it, and the Process button will then be enabled too.

And when pushing it, a panel will ask for :
* Organization (prefilled with the Organization field)
* Date (prefilled with the maximum date of selected posting)
* Description
* DocType
* Account

When accepting to create the journal, the program should check that posting is balanced (which should be the case) and then execute the generateReconciliation method.

wdyt?

Regards,

Nicolas
Reply all
Reply to author
Forward
0 new messages