Hi
Client had an issue with a PO match where they were getting the error "You cannot open this purchase order". I found some other posts that talked about the status in POP10500 and ensuring the status was "1".
When I went to this table, I found two receipt transactions - the original goods receipt that was done and posted and an additional one that turned out to be a corrupted invoice match transaction. That transaction had a status of 0 against it.
When I then looked in other tables (POP10300 and others), we saw the Invoice Match transaction but with no values. This transaction could not be seen anywhere in GP.
We deleted all reference to the invoice match transaction through all the POP1xxxx tables. Checked the history tables and can't see any reference to the invoice match.
PO Status is showing as received in POP10100, POP10110 and can be looked at in Edit Purchase Order Status window. The PO and Goods receipt can be drilled into correctly in the system.
Going to the Invoice Match screen, we cannot see the PO in the Auto Invoice button and if we try and do it line by line, the Match to Shipment window shows blank.
It feels like there is a flag somewhere that we have missed updating - any ideas on what table needs to be updated?
Note: we have done a reconcile on the PO but have not done a Check Links - will do that if we have to.
Much appreciate any insight on this one.
Cheers
Heather
