Report(s) that show After the Fact (ATF) Purchase Orders

[Marcus_Raisch]

I am looking for some guidance on how to run a report or set of reports that will show After-The-Fact (ATF) purchase orders. Specifically, I want to identify purchase orders that were created after the invoice was received. My initial thought was to compare Invoice date to purchase order date, as if the invoice date is before the PO date this would indicate an after the fact PO. However, it appears there is no way to easily connect or run a report that shows invoices with invoice date AND the corresponding PO number. Any help or guidance would be greatly appreciated. 

[LucyLu · Accepted solution]

Hi Marcus, Please help to clarify what's your purchase order date mean? For the purchasing order, I would like to explain it first, based on the sort key setting with purchase order no. in the GR/IR account, you will get the purchasing order no. in the line item level after posting the invoice verification. Kind Regards, Lucy

[Marcus_Raisch · Accepted solution]

Thank you so much! This was super helpful. Using the GR/IR data in the general ledger I was able to pull this information.