Hello Zara,
From what I can find, it appears that it isn't so much with the SY07140 table that we thought but it actually creates a temp table and then populates it with each of the reports that are returned by the Report List under Purchasing, as an example.
In my example, I see a ##1354811 table get created, then I see statements such as this populating this temp table:
BEGIN DECLARE @num int EXEC ##zDP_1354811SI 24, 0, 'Microsoft Dynamics GP', 0, 3, 'Purchasing', 2, 'Trial Balance', 4, 'Quick Aged Trial Balance', 308.00000, 'demo', 2, 'Original', 'Screen', 0, 7133, 0, '', '', -1, '', 0, '', 0, 0, @num OUT SELECT @num END
When I do a SELECT statement against this temp table in the company database, it gives a list of all of the default reports that are returned when I click on 'Report List' under the Purchasing (or Sales) menu.
Based on this, the issue may be more with the Dynamics GP code being damaged, such as the Dynamics.dic file, which would hold this information.
What you can try is to rename the Dynamics.dic as Dynamics.old, then run a Repair against that Dynamics GP install, which should re-create the Dynamics.dic anew and then see if that resolves the issue.
If not, then maybe see if you're getting the same issue with multiple installs of Dynamics GP, even logging in as 'sa' to determine whether the issue is a code issue, login/permissions issue or something else.
Thanks,
