Hello-
I have seen similar versions of this questions being asked, but no resolution. We are attempting to match invoice to a receiving shipment. There are about 12 items on the invoices. All 12 items have been received in a shipment. When we attempt to match, 10 of the 12 items are able to be pulled in from the shipment. However, 2 of the items are not. The RCT number does not appear when attempt to match. Is this an issue with the tables or is there another reason we can't find the shipment for those 2 items?
Any help would be great.
Thank you
Are the corresponding POs still open (anything but a status of canceled or closed) for those two line items?
Joe
Hi Joe,
Thank you for the response. Yes, they are all from the same PO and it is still open.
OK, great!
So trying to rule out any posting issues, on the two line items you can't match -- if you click the Auto Invoice button at the top of the screen, does the PO number show in the list on the left side?
Finally, if you go to PO Inquiry: open the PO, click on one of the lines that doesn't show up to match and click the "i" button in the column heading, what does it show in the three fields at the bottom?
Remaining to Ship
Remaining to Invoice
Remaining Posted Shipments to Match
Thanks.
The PO number does not show in the Auto Invoice option. In the PO inquiry, the 'i' field brings up the following:
Remaining to Ship - 0 for both items
Remaining to Invoice - 125 and 50 for each time respectively
Remaining Posted Shipments to Match - 0
I am wondering if the Remaining Posted Shipments to Match not be 0? I have never explored this field so I am not certain.
I appreciate your quick responses!
That is interesting.
The 125 and 50 should also be showing in the Remaining Posted Shipments to Match field.
Was there just one shipment transaction or multiple? Is there anything in the Unposted column for each of those line items on the "i" button screen you just looked at?
There were 2 shipments for the PO. The other shipment has already been matched. The unposted column for the 2 items is showing the qty amount next to 'Matched'. See below. The first screen shot is an example of the items we cannot match. The second is an example of another item in the same shipment that we are able to match. The match invoice document has not been posted. If I am reading the below correctly, it is indicating that the item was matched already somewhere?
Item we can't match
Item that was matched
Is there an unposted Enter/Match Invoices transaction or Purchasing Invoice Entry batch out there in Purchasing Batches? Or while entering the invoice match, did something happen to the computer or the network connection?
In your top screen shot, SOMETHING has matched the invoice with the shipment, which is why matched is showing 125, but invoiced is showing 0 in the Unposted column.
I would try these two things:
1) Delete the invoice transaction in Enter/Match Invoices -- since it is unposted, you can just delete it.
2) Run reconcile on the PO. Purchasing > Utilities > Reconcile Purchasing Documents. Just enter in the one PO number in the From and To fields.
Thank you Joe. I deleted the transaction and ran the reconcile. Nothing was found. I also ran the shipment/match activity and the items were not found to be matched to any invoice.
Do the same quantities show for the two items you can't match on the "i" screen?
Are you able to run a couple of SQL queries?
The quantities that appear in the 'i' screen are the quantities I need to match to the invoice but can't. I can't find where they are matched too, but it looks like they are being matched to an unposted invoice.
I am able to run SQL queries. Do you have specific ones I can run?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,029
André Arnaud de Cal... 871 Super User 2025 Season 2
Sohaib Cheema 582 User Group Leader
