We are noting the following bugs with our system that have occured after the transition to foreign currency reporting on Tuesday the 25:
AR: Our AR now seems to be split between CAD and USD. Only the CAD balance is picking up on the home screen. All of our accounts receivable in denominated in CAD. Please correct all AR records to read CAD
AP: If I look at the AP Summary for Cdn it appears to pick up all the AP which currently stands at $279,374.64. However if I select USD it shows $270,042.94. It appears that all AP entered previous to the change still shows as USD. These records should be changed to Cdn.
If I create an AP payment (for example 5076) for Willing Plus, invoices that have already been paid populate again. In this case Inv 61583 ($1.309.82), Inv 61599 ($1047.85), Inv 61647 ($2603.75) and Inv 61663 (2357.62). Other vendors may be effected. We are still checking. The AP details in CAD appears to be correct (see below). However when I select USD it shows two of the invoices translated.
Finally we can not reopen vouchers to view them. For example if I go into the AP detail screen for Del Metals and click on ID 8595, we get the following error.
Can you let me know what screen you’re seeing the split AR? When I look at your AR aging by customer filtered on resale currency of USD then I see a single customer with AR.
If there’s a particular widget on your home screen that seems incorrect please share which one that is and highlight which amounts seem off.
Can you share a link to the AP Summary after submitting with your filters set? As far as I know the AP Summary doesn’t filter out AP by currency but you can convert values to display in a currency.. so the USD value will be less than the CAD value because of the exchange rate.
It looks like AP Details doesn’t have a currency filter.. so you can’t view invoices by their cost currency. However the Display Currency allows you to convert values into a given currency and the translated value will be based on the exchange rates you’ve configured.
I’ll take a look at your voucher and see why it can’t identify the currency.. usually if the currency is not set then it’s assumed to be the system default.
In regards to the AR. If I run an AR by Customer report (all customers) or an AR Aging summary I get a grand total of $357,989.96 Cdn. My trial balance is showing $624,980.39 Cdn. The $624,980 is the write number in terms of quantum. Why are the two subledger reports not agreeing to the GL by such as variance? Thanks
@ImperialController the AP Summary report you linked to doesn’t have a currency filter. The Display Currency selection allows you to convert the values over to a different currency based on the exchange rate.
On the AP Summary when Display Currency is set to CAD the total AP is 277,506.09 CAD.
Similarly on the AP by Vendor report which does have a currency filter.. total AP is 277,506.09 CAD when all currencies are selected and Display Currency is CAD.
If I filter the AP by Vendor report by currency CAD with Display Currency CAD.. the total AP is 268,880.91 CAD. If I then filter by currency USD with Display Currency of CAD.. the total AP is 8,625.18 CAD. The CAD AP total and USD AP total add up to the same combined total of 277,506.09 CAD.
I may not have explained the Willing Plus issue well. If we create an AP payment to this Vendor (for example 5091) Cetec ERP, the first 4 vouchers (7902,7929,8351,and 8386) have been paid. (see the attached AP detail) - Cetec ERP
Please investigate. We don’t want to be double paying vendors.
@ImperialController When I look at the first Voucher (7902) it’s on an AP Payment (4957) which is currently still open and unpaid. I don’t believe AP Payment will filter out vouchers that are still open and on a different unpaid AP Payment.
Once AP Payment 4957 is paid then Voucher 7902 should close and it would no longer be visible on AP Payment 5091.
Any luck in figuring out what happened to my Accounts Receivable. My general ledger shows $260k higher then the home screen, A/R by Customer report and the A/R Aging summary. I believe my general ledger to be correct. The home page, the A/R by Customer report and the A/R Aging summary all agree. This difference appears to have happened in or around the time when you made the change to allow us to process foreign currency, last week (Nov 28)
@ImperialController I forwarded your AR questions over to our accounting team. Please see their follow up questions below.
Tom,
When was the last date that the AR By Customer total agreed to the ledger balance? and what was that total in CAD ?
What account number(s) are you comparing the AR By Customer to?
Any and all information you can provide re your AR and AP variances would help us in providing answers to the questions
in your November 27, 2025, 6:36pm forum post.
AR was reconciled to the AR by Customer report, with-out deposits at both September 30 and October 30 and agreed to GL account 114100 (within pennies).
For example G/L account 114100 at 9/30/25 is $531,422.24 and reconciled to the AR by Customer report run at the time of reconciliation ($.04 out). This reconciliation was done on Oct 2nd.
When I run the A/R by Customer account as of 2025-9-30 as of today, the balance shows $311,988.12.
Interestingly enough, if I look at my home screen at the present month, the open AR shows $424,168.08, which is wrong.
However if I click on the balance total (highlighted above) , it pulls up an A/R aging screen. If I run that report it generates a report showing the Aged AR totaling $685,733.28. My current G/L value is $684,349.04, so this is much closer.
I need the AR by Customer report and the home screen to reflect the same total above ($685,733.28)
@ImperialController it looks like your images didn’t come across.. if you copied them from Gmail I think it will simply give you a secure link which isn’t visible to others. You’ll need to paste in the original image rather than copying it from gmail.
