Incorrect creditor balances

[Tina1959]

I have an accounts payable reconcilliation amount that shows 2 creditors that have balances owing. These are both foreign currency amounts.

Example 1 shows a balance of 2c - but the card shows a balance of $45 AUD. The actual balance is nil. I clicked on the purchase that has 2c owing and the balance shows nil so there is nothing to corect - have no idea how the card shows a balance of $45 - how do I fix this.

The other card is for Euros with a similar issue. I have 3 amounts "owing" one of them is a credit but there is nothing showing in returns and debits so I can offset the credit of one against the outstanding balance of the other. Even if I could do that there would still be 4c Euro outstanding.

They are not large amounts but it is annoying to have them show up each month as payable in the aged payable summary

When I do pay creditors using pay bills the old purchases with the oustanding amounts do not appear so I cannot even enter as a discount to get rid of them.

Please advise

[Steven_M]

Hi @Tina1959 

Based on the information that you have provided, it sounds a bit like we may have to arrange for the card to come in for an investigation and possibly a card recalculation.

Just before we do arrange for that one, getting the following screenshots would be ideal so we can review the values to ensure that is the case.

• The Purchase Register>>Open Bills for that supplier for an extended date range 01/07/2000 -31/12/9998. 
• The Purchase Register>>Returns & Debits for that supplier
• The Aged Payables - Outstanding purchase analysis window (Open the supplier's card and select the Balance arrow - top right)
• The Payable reconciliation report with an as of date of 31/12/9998

[Tina1959]

Hi Stephen,

Thanks for the response.

There are no open bills for supplier 1 or supplier 2

There are no returns and debits for supplier 1 or supplier 2

The sreen shot shows the balance of AUD $45.54. For supplier 1. The oustanding is theroretically 2c. If you look into the invoice (2nd screen shot) the balance is nil - no idea how it can be showing $45.54?

3rd screen shot shows the 2 c outstanding in the reconcilliation report for supplier 1.

4th sreen shot shows card detail supplier 2. This is made of 3 invoices - screen shot 5 - but again if you look into the invoices the balances are nil.

I saved the reconcilliation for the second supplier but I cannot upload it onthis post so will add to a second post.

Let me know what you think.

It is not a big deal but I would like it to be correct going forward.

[Tina1959]

Hi Stephen - this is the second response with the last upload attached that did not fir on the previous response.

[Steven_M · Accepted solution]

Hi @Tina1959 

Thank you for providing those screenshots.

Just taking a look at them, I actually think you might have two issues that are almost masquerading as one. For example, Purchase order 00012672 is closed but is still showing a balance in the local currency and then you have the balance impact of that card, which is unrelated.

Either way, I've arranged for that company file to come in for an investigation and possible repair. You'll get an email soon with all the details in relation to that process. All the information required is included in the email but do let us know if you have any questions about the process.

[Tina1959]

Thanks Steve,

Yes I have just got the message so will upload it all shortly. As I use multi currency I will also upload our old Classic File. Just waiting for everyone to finish what they are doing first.

[Tina1959]

Hi Steve,

Have uploaded both bakc up files - one for Account Right that we are using now and the other for the old Classic MYOB.

If you need passwords to open the files let me know - I did not use a password on the back up of the new file but from memory whenever I have restored a file I have needed to put my password in for the old Classic version.

[Steven_M]

Hi @Tina1959 

Looks like our team has received that file and is in the pipeline for that investigation and possible repair.

We should be able to get around the company file passwords for v2020 and v19 company files. The ones we can't get around is the password when taking the backup file. For example, the password entered at the following window:

If you have added a password at the following backup stage on that uploaded file, do repeat that upload process without that backup password being added before re-uploading it to the secure Dropzone/FTP account. 

In any case, should our team encounter an error with retrieving or accessing that file, I'm sure that they will reach out to yourself with the next course of action.