nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Supplier card balance difference between open purchases

PIP2

Hi, We have a number of suppliers that are showing amounts owing on the Supplier card but not in open purchases. Wondering why this and how it can be corrected. I have attached a copy of one of them for your reference. I have selected a wide date range in purchases in case the document had an incorrect date entered but still didn't show this amount as owing ?

MYOB query.docx

Find more posts tagged with

Accepted answers

Yanike_S

Hi @PIP2

You should have received an email inviting you to upload your file so the right team can have a look at your file. Please let me know if you have any issues.

Resolved via Datafile Repair ~YS

All comments

PIP2

Hi, Thank you for your email. I have done the checks you requested and the cards are still out of balance. I have found 7 suppliers that have values on the card but not on the Aged Payables Summary and 9 Suppliers that have a value on the card that is different to the Aged Payables summary. Due to the number of Suppliers found is there an email address I can send our Aged Payable Summary and the print out of the card List summary that I have highlighted the errors on for you to see.

Yanike_S

Hi @PIP2

Thanks for your post. Could you check the following:

Check if the card is definitely out of balance by running an Aged Receivables Detail or Summary dated 31/12/9999 and check if there is no out of balance in the report for that card.
If there is OOB in the report as well, it means you need to check the transactions which caused OOB like if there are any duplicates or incorrect ones
On the card drill into the arrow next to the balance on the card and see if there are any open transactions which equals the card balance, If Yes, then the card is not OOB
Sometimes, some incorrect credit notes added to the card can cause this issue too so check if there are any credit notes added incorrectly and closed instead of reversing the actual invoices

Once you have confirmed all the above scenarios and still the card is out of balance, please send me screenshots of the above and I will be able to escalate this for you as it is likely your file might need a repair.