Is there any specific reason that GP doesn't delete the records from EFT Bank Information (SY06000) table after we delete the Vendor master?
I created a new Vendor with the EFT Bank details and deleted the Vendor. But still, i could see the EFT information in SY06000 table.
Thanks,
Anvar
*This post is locked for comments
I wrote a Delete Trigger for this & the issue has been resolved.
There should be some solution from Microsoft on this :(
CREATE TRIGGER [dbo].[trgPM00200_D] ON [dbo].[PM00200]
AFTER Delete
AS
DELETE
[EFT Bank Information]
FROM
SY06000 AS [EFT Bank Information]
INNER JOIN
deleted
ON
deleted.VENDORID = [EFT Bank Information].VENDORID
GO
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (