Notifications
Announcements
No record found.
I go to Transactions -> Enter / Match Invoices , key in the vendor ID, go to Auto-Invoice, I can't found my PO number there. Please advise...
*This post is locked for comments
Check the status of the PO. Is it still open and have items been received which have not been invoiced. Once all lines on a PO have been invoiced it will no longer appear.
Adding to Richard's correct statements....if the status of the PO is set to closed, even if the PO has not been invoiced, it will be removed from the received not invoiced list and thus not available for matching.
We have the issue of a PO that was received but not invoice being closed from Edit Purchase Orders screen in error, how do we go about tying up the loose ends? Do we just put journals to offset the outstanding amounts, or is there something else to do? I tried opening the PO but given that you can't open individual line items this has no effect.
Try to run Check Links(Tools-->Maintenance-->Check Links) for Purchasing History and Transactions, may this will fix your issue.
Hope this helps!!!
Hello Boris,
I've run into the same problem. Did you find a resolution to your issue? If so, can you share? Thanks!
Jim
Have you tried all the mentioned above suggestions?
Hi Jim, I actually forgot about that I had a question outstanding to our Microsoft Partner support on this. We are kind of stuck because the items had already been sold off by the time I was alerted to the issue. If that was not the case we could have just returned them and created a new PO and gone through the regular process. As it stands we can enter a journal to create a vendor balance for this amount however the smartlist our A/P department uses will still reflect this receipt in the "items received but not invoiced" smartlist. I'm checking to see if we can just update table pop10500 to change the qty matched field to match the qty received so that it disappears. I'm checking with support to make sure this will not create a database issue, they did say that it might get undone if the PO Doc reconcile tool is run on the particular document but that is not a concern to me. Sorry that I can't be of more help.
Thanks for the replies! I went ahead and re-opened the lines in the table (changed status to received). I've not received feedback from the user on invoicing yet. I'll update if they encounter issues. Thanks.
This goes along with Jim's reply below
Just an FYI, you would might run the following scripts against your company db table
as always Id recommend doing in test first
select * from pop10100 where ponumber = '@POnumber'
select * from pop10110 where ponumber = '@POnumber'
select * from pop10500 where ponumber = '@POnumber'
in 10100, check the postatus and statgroup
POstatus shouldn't be a '1' (closed). If it is a '1' update to a '4'
Statgroup should be a '1' as well
pop10110 will show the line item status, ensure those are accurate
If the line item has a POLNESTA (PO Line Status) of '5', you should change to '4' if it isnt supposed to be closed out
POP10500 is used for ref for matching only, no edits there
depending on your findings, update the tables
Finally, run a reconcile 'purchase order documents' against that PO, If any line items were incorrectly updated, they will revert back to the correct status of 'closed' or whatever
it should show up under auto-invoice match afterwards
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
