You’re offline. This is a read only version of the page.
Announcements
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
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
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.
Jim
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.
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.
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.
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.
#1
André Arnaud de Cal...
293,382
Super User 2025 Season 1
#2
Martin Dráb
232,534
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (