Supplier Transaction Report query

Jean_10862158
Jean_10862158 Member Posts: 138 Reckon Star Reckon Star
in Reckon One

I often use this report to see what is on an account, and to make sure something is not entered twice. Recently noticed something which looks odd. The total as per this example should be zero. A correct total would have been useful.

What's the point of providing a total and ignoring whether an entry is a debit or a credit?

image.png

Answers

  • Rav
    Rav Administrator, Reckon Staff Posts: 14,205 Reckon Community Manager Community Manager

    @Jean_10862158

    The Supplier Transactions does respect debits and credits and will provide an accurate total balance for the transactions pertaining to the selected suppliers.

    See example below where a supplier adjustment note transaction is listed separately in the report.

    image.png
  • Jean_10862158
    Jean_10862158 Member Posts: 138 Reckon Star Reckon Star

    But that wasn't the question. It is the total of my list that is incorrect. Yours, too, has the wrong total.
    If you add up my list with the Bills as plus, and Payments as minus, then the total comes to zero - not the $876.72 as shown.


    To be exact, each payment should be shown in red with a minus sign.
    I'm not sure why a "receipt" is there, unless it is a refund for the "adjustment note".
    If you show "bills" in black, then an "adjustment note" should be in red and with a minus sign.
    Then the receipt, if it is a refund from the supplier, should be in black.

    It is a matter of debits and credits. Supplier invoices are actually credit entries in the ledger, and Customer invoices are debits. That's why Accounts Payable was called Creditors and Accounts Receivable was called Debtors.
    It is probably clearer to show Supplier invoices as black but then the opposites should be in red.

  • Jean_10862158
    Jean_10862158 Member Posts: 138 Reckon Star Reckon Star

    @Rav

    Further to this. Today I did an "Aged Creditors" report. The total was $20,553.38
    Then I did an "Aged Creditors Transactions" report - it also is $20,553.38
    Then I did an "Unpaid Bills" report it only has $ 7,296.29
    So then I did a Balance Sheet and the "Accounts Payable" total is $ 7,240.74

    I spent most of my day working out what all the discrepancies are, because I expected these reports to give the same total. $7240.74 is the correct total.

    This indicates that something is wrong with the first 2 reports. They do not pick up all the outstanding transactions. In other words, they can't be relied upon.

    Is this going to be fixed? Any thoughts on this?

  • Rav
    Rav Administrator, Reckon Staff Posts: 14,205 Reckon Community Manager Community Manager
    https://community.reckon.com/discussion/comment/20660094#Comment_20660094

    Thanks for the additional information and clarification @Jean_10862158

    I've spoken to our product team in relation to your observations and they've opened a ticket to investigate. For transparency, the first chance they'll get to start will be mid-next week so I'll need to keep you posted on this.

  • Rav
    Rav Administrator, Reckon Staff Posts: 14,205 Reckon Community Manager Community Manager

    Hi Jean

    Just wanted to come back to you on this as we've made some adjustments to this report based on your feedback.

    The product team have removed the totals from the supplier transaction report (and customer transaction report). The intention of the report is to show a list of transactions associated with supplier contacts, its wasn't designed to show ins, outs and a running balance which admittedly the totals in the report gave the indication of.

    With that said, we're going to keep our ears open to feedback around this from our users as we've got a squad who are actively working on reporting enhancements at the moment.

    In addition to the recent enhancements to reports in the last couple of releases, we have more on the way next week along with early in the new year as well so stay tuned.

Categories