Share
ReportIt happened a few times that PM00203 table was emptied somehow when a user created or deleted the new vendors. Has anyone experienced this issue?
*This post is locked for comments
You’re offline. This is a read only version of the page.
325
It happened a few times that PM00203 table was emptied somehow when a user created or deleted the new vendors. Has anyone experienced this issue?
*This post is locked for comments
Thanks for all your help! Microsoft confirmed that this was a defect fixed in GP 2013
Hi Michelle,
Please try the following on vendor and vendor class master table.
Execute the following script against the company database to view triggers
SP_Helptrigger PM00100
SP_Helptrigger PM00200
Review all the triggers returned by the script above
disable each trigger, use the following script:
Alter table PM00200 disable trigger XXXX
Alter table PM00100 disable trigger XXXX
Note XXXX is a placeholder for the trigger name
After disable each trigger go to vendor and do the changes by selecting class ID and see whether you still getting the issue.
To enable each trigger, use the following script:
Alter table PM00200 enable trigger XXXX
Alter table PM00100 enable trigger XXXX
Note XXXX is a placeholder for the trigger name.
please take a backup before doing this.
Hi Victoria,
We are using GP10 SP5. We just tried it on GP2013 and was not able to reproducible there neither. Thanks!
Hi Michelle,
I cannot duplicate what you're describing. I opened the Vendor Maintenance window, there is no Vendor ID selected, I selected a Class ID, nothing happens to the data in the PM00203 table. It's still there.
Are there additional steps to duplicate this?
What version and build of GP are you using? (I am using GP 2013 SP 2, build 12.00.1482)
Do you have any 3rd party products or customizations?
We found that when the Vendor Maintenance window is opened, and without entering a Vendor ID, the user selects a Class ID, the data in PM00203 gets deleted.
Hi All,
My recommendation is create a SQL Trigger that will fire when a record is deleted from PM00203, and have that trigger insert records into a log file along with the current user and current date. Then you can hopefully identify a pattern based on the user and time (for example, you may find that the deletion take place at a certain time of the day, and therefore you should review any scheduled jobs/imports/etc... that take place during that time).
Below is an EXAMPLE of the sql to create the log table and trigger:
--Create the log table:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE PM00203LOG(
[VENDORID] [char](15) NOT NULL,
[DISTTYPE] [smallint] NOT NULL,
[SEQNUMBR] [int] NOT NULL,
[ACTINDX] [int] NOT NULL,
[Default_On_Trx] [tinyint] NOT NULL,
[DEX_ROW_ID] [int] NOT NULL,
[USERID] [CHAR](15) NOT NULL DEFAULT CURRENT_USER,
[DATEDELETED] [DATETIME] NOT NULL DEFAULT GETDATE()
)
--Create the trigger:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE TRIGGER DBO.PM20300DELETE
ON PM00203
FOR DELETE
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO PM00203LOG
(
VENDORID,
DISTTYPE,
SEQNUMBR,
ACTINDX,
Default_On_Trx,
DEX_ROW_ID,
USERID,
DATEDELETED
)
SELECT d.VENDORID,
d.DISTTYPE,
d.SEQNUMBR,
d.ACTINDX,
d.Default_On_Trx,
d.DEX_ROW_ID,
CURRENT_USER,
GETDATE()
FROM DELETED d
END
GO
===========================
Once the above is in place, all you need to do is run a select statement on the PM00203log table when you noticed the table has been deleted, and hopefully you can piece the rest of it together based on the user/datetime the deletion took place.
Thanks,
Justin
Dear
we are facing the same issue, has anyone found a solution to this problem
Regards
To add to Ian's request - do you know whether any database maintenance had been done - Check Links - anything like that?
Hi all, very strange behaviour. Can you let me know what versions of GP you are running [send the actual version number from the help menu].
Ian.
Hi,
I have just encountered the same problem, where all the additional purchases account codes are missing on all the vendors records. Has anyone encountered a solution for this problem or a reason why it happens?
Irasema Lujan
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
