Report showing Receipts not invoiced

[johnhugh]

Hi,
I'm using Accpac 5.5.
Is there a report I can run which shows me the PO receipts that have not been invoiced yet?

 

[ettienne]

You need to create your own report.

 

[johnhugh]

Thank you.

 

[johnhugh]

Ok, I've done a report which lists all receipts from PORCPH1 WHERE
"PORCPH1"."ISINVOICED"=0 AND "PORCPH1"."ISCOMPLETE"=0.

I'm getting some really old receipts from 2009 showing in my report so I reckon they must have been invoiced through AP rather then PO.

Is there a better way of doing that report?
Or can I maybe just change these 2 fields to "1" manually in the database?

 

[ettienne]

Better still is invoice those receipts in PO, run IC day end and then delete the invoices from the AP invoice batch that is generated.

 

[johnhugh]

Thanks, I'll give that a try.