Our management wants to compare the total open purchase invoices from a certain period to the actual period. So, how much money did we need to pay in for example 01-06-2008 until 30-06-2008 and how much money do we need to pay now from 01-06-2009 until 30-06-2009.
I found out that in table OPCH I can find the invoices, but can not select them based on a status (paid / unpaid) which was in the past.
Could somebody please give me a hint or maybe a solution to this?
Thank you in advance.