Two issues with our AR/AP adjustment booking

[sweitmann]

Hi Armaghan,

Sometimes it happens that AR/AP transactions with certain exchange rates aren't balanced in debit and credit on AR/AP account. Here is an example of such a transaction:

We solved this together some time ago by adding an adjustment booking that is booked automatically when the payment transaction is re-booked in GUI. So when this booking that was booked by executor is opened and re-booked in GUI it's sorted out automatically accordingly and you can see the mentioned adjustment booking here:

We have three issues with this booking and I would appreciate your help to sort them out:

1.) This adjustment booking is currently done with the transaction date, but it should be done with the payment date, because if the transaction is in the previous year it will change the result of the previous year and it shouldn't.

2.) This adjustment booking is not made when the payment is booked over Cash module ('Cash--Recepit(s)' / 'Cash--Payment(s)'), so we need to add this feature in that module too.

Let me know if you have any questions.

Regards

[sweitmann]

Hi Armaghan,

One more thing in regard to this ticket. This additional 0,01 that fixes the difference between acc_trans table and AR/AP table is added when the payment is entered in an existing invoice and the transaction is re-posted.

We need to add this fix to payments that are added with payment module: 'Cash--Receipt(s)' and 'Cash--Payment(s)' which are the modules Run my Accounts uses to post payment to existing invoices from outside the SQL-Ledger software.

Regards