Forum Discussion

fredmarzin's avatar
fredmarzin
Experienced Cover User
5 years ago
Solved

AGED PAYABLES OUTSTANDING PURCHASE ANALYSIS

I have checked out notes for  Payables Reconciliation Summary and problem still exists.

 

The out of Balance on the summary is exactly what the Difference is on the Balance of the Creditor.

The Purchase Register shows open Bills for $40000-00 but the Balance of the  Creditor Card is $49000.00

Doesn't matter what option I use to correct the issue, the Balance of the Creditor is always out.

I can fix the Aged Payables, and the Purchase Register for the Creditor, but not the Creditors Card Balance showing in the Outstanding Purchaase Analysis

  • Tracey_H's avatar
    Tracey_H
    5 years ago

    Hi fredmarzin 

     

    Can you please send me screenshots of the report(s) showing the out of balance and the supplier card showing the balance. You can send those screenshots by private message.

5 Replies

Replies have been turned off for this discussion
  • Hi fredmarzin 

     

    Thanks for your post. So that I can assist with this can you clarify if you have followed the steps in the help article, Receivables, Payables or inventory out of balance, to try and resolve this? Have you been able to work out which transaction(s) are causing the issue? If you run the Payables Reconciliation Summary with a future date is it still out of balance?

  • fredmarzin's avatar
    fredmarzin
    Experienced Cover User
    5 years ago

    Hi Tracey

     

    thank you for your quick response.

     

    Yes I have followed the help article and did not solve the issue.

    As stated in my quirie, I have found the culprit but I cannot adjust the Aged Payables Outstanding Purchase Analysis Balance.   I can amend the Account opening Balance to bring the error to Nil, but the above I cannot amend.

    I need help in understanding how the Balance is calculated within MYOB itself, so I can adjust the figure.

    I believe it is the Supplier Balances Pre conversion Purchase area.

    Doesn't matter what I do, the Balance is always out.

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    5 years ago

    Hi fredmarzin 

     

    Can you please send me screenshots of the report(s) showing the out of balance and the supplier card showing the balance. You can send those screenshots by private message.

  • fredmarzin's avatar
    fredmarzin
    Experienced Cover User
    5 years ago

    Hi Tacey

     

    Snapshots attached.

     

    On the Card Info, notice that the AVG DAYS TO PAY is -4217.

    This could be an issie with either the Account Opening Balances and Supplier Balance Dates

     

    regards

     

    Fred

     

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    4 years ago

    Hi fredmarzin 

     

    I had to remove your screenshots from your public post as they contained sensitive information relating to your supplier. I did have a look at them though and, unfortunately, the Aged payables outstanding purchase analysis screenshot doesn't show me an out of balance. Is there an out of balance in Payables reconciliation report?

     

    Can you send me a screenshot of the Payables reconciliation report and specific details of the out of balance amount? Please send me that information by private message.