Purchase order reporting

Rebecca Case
Rebecca Case Member Posts: 3 Novice Member Novice Member

Hi Community!

I am trying to accrue all purchase orders that were raised pre 30/06/2023.

I have already accrued all open PO's on the open purchase report. However, this report does not include PO's that have been billed since 30/06/2023. For example, a PO raised on 30/06/2023 does not show up on the open purchase order report if it has since been paid in the 23/24 FY - which means the expense is going to the wrong FY.

Is there some way I can build a report in Reckon that shows the PO#, PO Date, plus the date it was billed so I can pick these up?

Even better would be the ability to produce a transaction detail by account report, but be able to show the PO number and the PO date - that way when I produce the report from 01/07/2023 and I can easily see which transactions relate to commitments made in 22/23 FY. I have tried modifying the transaction detail by account report to no avail.

Any help would be most appreciated!

Answers

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,836 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited August 2023

    Hi Rebecca

    " ... a PO raised on 30/06/2023 does not show up on the open purchase order report if it has since been paid in the 23/24 FY - which means the expense is going to the wrong FY ..."

    POs are "non-posting" transactions, meaning they don't impact any financials. The expense will only show when either the Bill is entered for it (on Accrual basis) or the Bill Payment/Cheque (on Cash basis)

    However, you can Modify the Open Purchase Orders report to display ALL (or Closed) POs also:


    To answer your query specifically, I believe the Transaction List by Supplier can show you want you're requesting. You can also filter this further to just display POs & Bills:

    😊

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)