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
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
