Topic: Supplier Payment With Bank Charges

Hi to all,

I noticed a slight error in the GL postings for a supplier payment with bank charges (before applying against invoice).

It could be a rounding error.

It only happens for a specific combination of exchange rate, settlement amount and bank charges.

The issue is consistently replicable in version 2.3.16. 

The scenario is as follows.

Base / Home Currency: SGD
Vendor's Foreign Currency: EUR
Made a payment of EUR 7150.91 to vendor.
The bank converted amount is SGD 12139.22.
Over and above this, the bank charges are SGD 35.18.

The GL posting should be as follows:
Debit Accounts Payable 12139.22
Debit Bank Charges 35.18
Credit Bank Account 12174.40

Instead, what I get is as follows:
Debit Accounts Payable 12139.22
Debit Bank Charges 35.17
Credit Bank Account 12174.39

I will glad to give more clarification to resolve this.

Cheers,

Kanay

Re: Supplier Payment With Bank Charges

Probably, the posting should be rounded off and stored in the debits and then summed up from the debits to obtain the contra credit sum instead of computing the credit with rounding off errors such as this.
Make 2 individual journal entries and see if the values come in correctly?

Re: Supplier Payment With Bank Charges

Hi apmuthu,

Thank you for your input.  Taking out the bank charges and posting it as a separate journal does solve the problem.

I am concerned that an unaware user could unknowingly commit inaccurate GL posting by using the bank charges feature.

Re: Supplier Payment With Bank Charges

Please check if this issue has been sorted out using the latest patch.

Re: Supplier Payment With Bank Charges

Hi apmuthu,

Thank you for your input.

Should I try this patch on version 2.3.16 or the latest version 2.3.18?

Right now I am still running version 2.3.16.

Best regards,

Kanay

Re: Supplier Payment With Bank Charges

FA v2.3.16 to v2.3.17 patch is available here.

FA v2.3.17 to v2.3.18 patch is available here.

No database changes, but look for changes in the config.default.php and tweak your config.php as needed - all values backward compatible defaults - safe even if ignored.