x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 15 subscribers
  • Views 1111 views
  • Users 0 members are here
Browse Forums
Announcements
239
topics
27
replies
General Discussion
1k
topics
3k
replies
Intelligence Reporting
311
topics
790
replies
Karl Van Wyk

Supplier Age Analysis Current Column Showing Negative Amounts

SOLVED
Posted By

Good day,

Would anyone be able to assist, as mentioned we have the problem of creditors showing up on the age analysis though their accounts are not in arrears.

I have used the match open items function to allocate what I could but their are some still persisting it seems that the purchases amount has doubled from what it should be and so the payments that where made are not clearing them out.

Is this perhaps a journal error where we accidentally duplicated the purchase? how would you reverse such an error?

Kind regards,  

  • +1
    verified answer

    Good day Karl,

    We are unable to establish how the duplication occurred. You must examine all supplier reports for the entire year and determine whether there is any duplication or overpayment. A reversal will be required in any of the situations that have occurred.

    If the purchase involves an invoice, a return and debit if it is an invoice.

    Please see the link below for more information on how to reverse journal and cashbook transactions.

    How do I reverse incorrect transactions:

    za-kb.sage.com/.../viewsolution.jsp

    Please verify or reply and let us know if the advice/suggestion provided was helpful.
    To verify an answer, simply go to your post and click "More" > "Verify Answer"

    Kind Regards.

  • 0 in reply to Lolo

    Many thanks, it was indeed helpful. I still cannot find the reason for the duplication. I have found that creating a purchase return solves the problem of the duplication but since I am unable to find the original cause of the duplication I do not know what contra account to use.

    Will have to keep on digging, I should also not use purchase returns but just use a negate number in the purchases journal as nothing is actually being returned. 

    kind regards, 

*Community Hub is the new name for Sage City