160
I have a PO in my System which has the Purchase Order Status drop-down absolutely empty when I access the PO from "Edit Purchase Orders". I am not sure how we created this PO but I need some help in sorting out the status. How can I get it back to "released"?
*This post is locked for comments
Thanks for the information Bron. It definitely helped me understand some functionality.
Thanks! a bunch Richard, it worked.
Neither reconcile nor check links will help here. You will need to edit the PO header in MS-SQL Management Studio. The table is POP10100. Locate the status field (POSTSTUS) and set it to the value for Released POs (2)
There are two types of data integrity checks.........I would recommend a Reconcile process first and see if it works for you.
Here is the exact verbage from the Dynamics Help File..........
Caveats..........Normally I would do the reconcile only if I knew I had a good database backup and I normally do this while there are no users or very few users in GP.
In your case - you might limit the reconcile to only one record (the po document in question). This would minimize the possible altering of data to that 1 record.
Use the Reconcile Purchasing Documents window to reconcile your purchasing records. You can reconcile all records or a selected range of records.
When you reconcile purchase orders, the following information will be recalculated and adjusted, if needed:
|
If you’re creating a range, you must enter at least one value in the restriction fields. If you enter a value in only one of the restriction fields, purchase orders will be reconciled from the value you enter to either the beginning or end of the records. For example, if you enter a starting value and the ending value is blank, all purchase orders from the starting value to the end of the records will be reconciled. |
Select Print Report Only to print the Reconcile Purchasing Documents Report without reconciling. If you select the Print Report Only option before you reconcile and print, you can verify which documents in the range will be reconciled before you actually reconcile the documents.
|
If the Reconcile Purchasing Documents Report indicates that an amount has been adjusted for a specific purchasing document, review the document to verify the accuracy of the changes that were made. |
Edit Purchase Orders --> All the other information exists and the PO lines are all released.
Purchase Order Transaction Entry Screen --> The PO does not show up from there.
How do I go about executing the data integrity routine?
Thanks!!
Bhushan
When you choose the PO Record and bring it into the Edit PO Status Screen - is there any other data elements such as items, Vendor ID, times printed, etc, displayed or is screen blank?
I'm think you might have an orphan or incomplete record which would normally be handled via File Maintenance (data integrity routine).
If the screen does contain data elements - just no status - I would also try to bring the PO into the Purchase Order Transaction Entry Screen and see if the system will retrieve it.
Report back at your convenience and we can determine next step.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (