An Item has multiple Vendors assigned, including one identified as Primary. I want to remove one of the other Vendor Assignments. I verified that here are no open orders or requisitions for this Item / Vendor combination, but when I attempt to unassign the vendor, I get a message that the action can't be completed because there are open documents.
Any suggestions what cause this error message to appear and how to correct it?
If you pull up this item then then go to Vendors is there any quantity under Qty on Order for this vendor? If not, try running check links on the Inventory and Purchase Order tables. Perform a backup first. If this does not help try running a text search in SQL for the part number in question to see if any orphaned records remain.
hi micheal,
If there are any PO for the item / vendor combination exists with Open Status, you cannot delete the item vendor assignment. First you have to move the Open POs to history by running the "Remove Completed Purchase Orders" routines (Purchasing --> Routines --> Remove Completed Purchase Orders). Then you can be able to delete the item vendor assignment.
Regards,
Ramanan
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148