Supplier ledger open items report - Not tallying with the Supplier GL-Due currency gain/Loss

  • 21 March 2024
  • 1 reply

Userlevel 2
Badge +7

Hi All,

Expecting your valuable advice on this:

Supplier ledger open items report does not tally with the relevant suppliers GL accounts.

When we further investigated it is found that the difference is due to the exchange gain/Loss is updated in the GL accounts but not in the report.

The client need the exact GL balance to be reflected in the supplier ledger open items report. Please advice.

Unrealized Gain amount which tallies with the GL account balance difference


G/L A/C  GL balance  Supplier Ledger Open items Difference
1361005   225,551.69                                         241,386.54   (15,834.85)


 Supplier ledger open items report reflect the value before the revaluation.




1 reply

Userlevel 2
Badge +7

Hi , 

This might be helpful.