Open PO Report

I run an open PO report each week.  My problem is that it shows PO's that items have been received but just not invoiced.  For example, the part shows ordered and received but because it hasn't been invoiced yet, the PO is still open.  I am okay with that but it would be nice to figure out a way for those that have been received in full to not show on this report.  I looked for a check box or option to filter out but there doesn't seem to be one. 

I wish this report was able to be customized more as there is a lot of info that prints on it that I don't need.  I run the summary report and that helps filter out a lot of the verbiage but not a lot of others things.

  • 0

    This report can be customized as much as you want using Crystal Reports.  Filtering out lines that have been physically received and removing fields you don't can both be done by editing the Crystal report.  However, if you're not familiar with using Crystal, you'll need to get your reseller to help.  Crystal is not something easily picked up or understood without some training and time spent using it. And I would do this on a custom report setting of the Open PO Report, rather than the standard setting, so the original report is still easily accessed if needed.  

  • 0

    Have you tried the Open Orders by Item report -  PO Statues to print = OPEN