PO Buyer ID's gone!

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Everyone,

This is my very first question here, even though i have benefited from hundreds of questions asked and answered by the community. (Thank you very much)

I have a puzzling situation that just cropped up, where when we are inputing PO's, the Buyer cannot put their ID in the BUYER ID window. We always just typed in a few characters and it autofils from detection of existing names. If they search for buyers the Buyer's list returns empty! And if they click the Buyer ID link to go to Buyer Maintenance, they can add their names from the list of GP users, but clicking on their names they get an error "The selected Record Has been deleted by another user."

This error doesn't stop them afterwards from typing their name directly which the PO takes and saves with. I did a system reconcile on all didn't help. Any suggestions welcome!

*This post is locked for comments

All responses (5)

Answers (2)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: PO Buyer ID's gone!

Update: The problem was fixed after My Solution Provider correctly identified that the Buyer IDM table POP00101 was being denied permission to access the Purchase Order Work (Header) Table POP10100, and suggested that I run a "Grant access script" to all tables against Company Database.

Now anyone can see their Buyer ID on the drop down.

Here's the script for those that would need it.

--*******************************

/*Count : 1
grants permission to all tables
*/

declare @cStatement varchar(255)

declare G_cursor CURSOR for select 'grant select,update,insert,delete on [' + convert(varchar(128),name) + '] to DYNGRP' from sysobjects
where (type = 'U' or type = 'V') and uid = 1

set nocount on
OPEN G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC (@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement
end
DEALLOCATE G_cursor

declare G_cursor CURSOR for select 'grant execute on [' + convert(varchar(128),name) + '] to DYNGRP' from sysobjects
where type = 'P'

set nocount on
OPEN G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC (@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement
end
DEALLOCATE G_cursor

--***************************

Leslie thanks again for your help and suggestions, highly appreciated!
Verified answer

L Vail 65,271 on at

Like (1)

Report

RE: PO Buyer ID's gone!

Perfect!

You or your consultant will be able to repopulate those fields from data in a backup file. I don't mean restoring a backup over your data, just use a backup to find the missing data. I'm glad this identified the issue. I was hoping check links would reveal the problem.

Kind regards,

Leslie
Community Member Microsoft Employee on at

Like (0)

Report

RE: PO Buyer ID's gone!

Hi Leslie,

I did like you told me and ran/or tried to run checklinks on the Purchase Buyer Logical files. Got the error below. Went ahead and inserted all Tables anyway. It specifically flagged me Table Not Found ERROR as seen in screenshot. Looks like a table, I am thinking Buyer ID table is missing/locked/unavailable . The checklinks ran and printed out no errors on the rest of logical files. I checked the tables with Buyer ID referenced , including what I think is the BUYER ID table itself POP00101 where I found that the Buyer ID column data is empty in some cases. Will probably have my Microsoft Solutions look at this. Wanna keep within a scope I am confortable with. Thanks for helping.
Community Member Microsoft Employee on at

Like (0)

Report

RE: PO Buyer ID's gone!

Thank you Leslie for your prompt answer. I will try that today and let you know how it goes.
Suggested answer

L Vail 65,271 on at

Like (1)

Report

RE: PO Buyer ID's gone!

Hi and welcome,

I don't think the system reconcile will do anything for you. I would try to run check links on the Purchasing Buyer logical files.

Kind regards,

Leslie