When running an AP Open Payables Report (Summary or Detail) with Source and Home currency selected, there are columns called UEGL and REGL. What are those?

They are the unrealized and realized exchange gain/loss that occur with fluctuations in exchange rates. Unrealized until the transactions are settled. I'll let an accountant fill in the details.

Bob:

As an accountant, I couldn't have said it better myself.

Susan

As an example

$1000 USD @ 1.3 = $1300 CAD
At month end you revalue it at 1.28 = $1280. Now you have an unrealized gain of $20 (you will have to pay $20 fewer CAD to settle the account)
Then the vendor gives you a credit note for $100 USD @ 1.27. Now you have a realized gain of $3 plus an unrealized of $18
You pay the balance owed at 1.27. Now you have an additional realized of $27 and no more unrealized

I see a problem in AP Open Payables with Prepayments when backdating the AP report.

Using: AP 9.3A (190513)

1. Sept 22 2020 - Prepayment for $93,632 USD with 1.32 exchange.
CAD Equivalent = $123,594.24.

2. Jan 27 2021 - Invoice for $19,162 USD with 1.30 exchange.
CAD Equivalent = $24,910.60.

3. Feb 10 2021 - Invoice for $19,162 USD was matched up to $93,632 USD prepayment,
leaving a Prepayment balance of $74,470 USD.
CAD Equivalent = $96,811.

4. Feb 16 2021 - Open Payables Report as of Jan 26, 2021
(Jan 26 is our month end due to a corporate reorganization)
See details of the Open Payables report in the screen shot attached to this post.

5. Source Current Amount on the PP is actually correct as of Jan 26.
It is still the full amount of $93,632 as it should be.
Home Original Amount on the PP is also correct.

6. Things go wrong when you get to the UEGL.
UEGL should be $1,872.64 which is the difference between the original amount @ 1.32 and 1.30.
Rather it is reporting $26,783.24 which is the $1,872.64 + $24,910.60 (the future dated invoice that was applied in Feb).

7. Home Current Amount should be reporting $121,721.60 which is the original amount @ 1.30.
Rather it is reporting $96,811 which is the home current amount including the future invoice being applied.

This inaccurate reporting causes a large discrepancy between the AP Open Payables Report and Ledger. Ledger is actually correct. AP Open Payables is not reporting Canadian Equivalency correctly.

I notice that the AP Open Payables report indicates with an "I" to the far right of the affected row, although the legend at the bottom doesn't say what "I" means. It seems the rows flagged with the "I" are the rows with the issue.

Susan:

This has been an issue for a very long time. Though I seriously disagree, Softrak has told me several times that this isn't fixable.

No idea why this isn't fixable as this wasn't an issue in ACCPAC Plus and Softrak already has code that correctly calculates the transactions that need to be revalued.

But then I'm not a programmer, so maybe there is some issue that I'm not aware of.

Hi Susan,

The 'I' should have been in the legend at the bottom of the report.

I: Indicates transaction partially settled by post-dated transaction
C: Indicated transaction completely settled by post-dated transaction

Hello Susan and Doug,

The Open Payables report has been updated for the example provided in the Payables 9.3C (2021.07.06) Upgrade released today.