Hi everyone,

I'm encountering an issue with exchange rates in Sage X3.

• Problem Overview:

  • In the account balance inquiry, the amount is $1411.15.
  • In the AP sub-ledger balance, the amount is $1403.26.
  • The difference is $7.89.

• Investigation Findings:

  • Purchase invoice amount: $1364.24 (converted amount: $4180.84)
  • Credit memo amount: $127.77 (converted amount: $461.63)
  • Payment in the purchase invoice: $135.66 (converted amount: $461.63)

• Observations:

  • Purchase invoice is created in Dec '22, while credit memo is created in Nov '23 and both month have different exchange rates.
  • Payment converted at 3.40272, credit memo at 3.61284.

• Issue:

  • No exchange gain/loss generated despite different rates. 
  • No conversion was made even after running conversion variance

• Request for Assistance:

  • Seeking advice on resolving this issue and generating the expected exchange gain/loss.

Thanks in advance for your insights!