Purchase order reporting

Rebecca Case

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!

Acctd4

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:

😊