Notifications
Announcements
No record found.
Hi Experts,
I am getting below warning when I am choosing a particular PO.
Can anyone help me regarding this warning?
*This post is locked for comments
Check the POP10500 table and see what the Status field is. If 0, it probably needs to be changed to 1.
You could also try running checklinks against the Purchasing Transactions. Either way I would make a backup first.
Thanks Matt,
I will check and update.
Hi Matt,
The table which you mentioned(POP10500) is Purchasing Receipt Line Quantities. Can you add some details about the status field? and what is the meaning if it is 0 also what will happen if I change that into 1.
A status of 0 in the POP10500 means that receipt (POPRCTNM) is unposted where 1 means the receipt was posted.
victoriayudin.com/.../pop-tables
Actually, the PO status of PO is released. It is needs to be received. Before this, is this recommended to change the status in POP10500 to 1?
You could try running reconcile against that one PO but you may need to change the status in POP10500 first. Since the PO status is not correct either there may be more that needs to be done.
1) Try running reconcile against the PO
2) If that doesn't do anything, update status to 1 in POP10500
3) Run reconcile again against the PO to see if it updates the status from Released to Received
Let me know the results.
I did following in the test company,
1. Update the status to 1 in POP10500
2. Then, I was able to open the PO. But, even the PO status is released I could not receive the item since we updated that as received in POP10500.
3. So, As you said, I decided to do reconcile of the PO. Now, the status of PO updated as received. But, the item is not in the inventory.
4. Later, I decided to do reconcile of items. But, the on order qty of item changed to 0.
5. It seems to be PO table not updated properly while used tried to receive the item.
6. If anything wrong in my mentioned points, please correct me. If not, I will restore the DB and can I do the delete operation of entire record in POP10500 for particular PO? will it resolve this issue?
I delete the record in POP10500 for particular PO. Now, I can access, receive and Invoice the PO. Is there anything I missed to verify?
I'd check the POP30310 table to make sure there aren't existing receipts for that PO. If there are then there would probably be more work in SQL to do. It sounds like there aren't since you can now receive and invoice it but it'd still be good to check.
You could also try running Checklinks to see if it will remove any orphaned records for you.
I verified in POP303310 table and did the checklinks. I didn't find any records related to this. I think the issue is resolved. Thank again.
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.
Community Member 2
mtabor 1
Victoria Yudin 1
