By using this website, you agree to our Terms of Use (click here)
Is there a report that we can run that will show the detail of the Received not invoiced PO's that is date sensitive? At the end of say April my GL shows $xxx,xxx for the balance in that account is there a report that will show what the detail of that account is?
Not that I know of unfortunately. The Purchase Receipt Accrual Summary (PO630500) and Purchase Receipt Accrual Details (PO631000) reports are not date sensitive.
I did something a while back though where I used Power BI to compare the GL and the POs by day, looking for the days were they did not reconcile. It seemed to work well, but now I can't find that report 🙁
Good morning
If you had to create a report in Acumatica for PO Receipt Accruals that is date sensitive, how would you go about it? Which tables can be used ?
POReceipt and POReceiptline tables do not contain tracking of Bills and dates against the GRN's so one would need to join in another table ?
You need to join the AP Tran table.
It wouldn't be cummulative, but you could at least group the GL Entry and PO Receipt transactions by date and look for the dates that have problems.
Online Members
