Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Purchasing Home page r...
Microsoft Dynamics GP (Archived)

Purchasing Home page reports not showing all reports

(1) ShareShare
ReportReport
Posted on by ZaraB

Good afternoon!

I have a customer who has a basic GP install.  When you go to Sales or Purchasing home pages and look at the reports list, there is no Trial Balance.  All other reports are in the list.  There is one under the Financial reports.  If you go into report writer, the reports are in the list for viewing/editting.  

We have uninstalled and reinstalled GP.  We have run check links on security.  We are in as 'sa' so we should be seeing everything.   I have found that the SY07140 holds the visibility on seeing the entire Report window, but cannot seem to find where the list of report types lives in the db.  

Has anyone seen this before?  Know of any options to get the list back?

Thank you in advance for your help.

Sincerely,

Zara

*This post is locked for comments

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Purchasing Home page reports not showing all reports

    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,

  • ZaraB Profile Picture
    ZaraB on at
    RE: Purchasing Home page reports not showing all reports

    Derek,

    Good afternoon!

    Unfortunately, they do not show in the reports list.  They do show when I go into Report Writer look at.  Which is why I am so confused.  It has to be in the dictionary.

    I am meeting with them tomorrow to review some more.

    Thank you,

    Zara

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Purchasing Home page reports not showing all reports

    Hello Zara,

    When you click on Purchasing, then click on Report List, it'll insert records into the SY07140 table, if they're not already there.

    For 'Purchasing', I'm seeing 8 records total, all with a CmdParentDictID value of 0, CmdParentFormID of 1568, CMdParentCmdID of 305 and CmdDictID of 0. The CmdSequence records are numbered 0 through 7 and the CmdFormID column has a value of 1566 for all but the first record which has a CmdSequence value of 0.

    Do you see this for your GP users?

    If you login to Dynamics GP as 'sa', do you see the Trial Balance reports in the list shown when clicking on Purchasing > Report List?

    Thanks

  • ZaraB Profile Picture
    ZaraB on at
    RE: Purchasing Home page reports not showing all reports

    Derek,

    Under the Reports section there are:

    History

    Analysis

    Check Information

    Posting Journals

    Set/Lists

    Groups

    Missing is the first line item of Trial Balance.  This is what I need help with identifying.

    Thanks,

    Zara

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Purchasing Home page reports not showing all reports

    Hello Zara,

    When I look in Dynamics GP 2015 R2, under Purchasing or Sales > Report List, I see the following 'Trial Balance' reports listed:

    --Aged Trial Balance

    --Aged Trial Balance w/Options

    --Historical Aged Trial Balance

    --Quick Aged Trial Balance

    Do you see these at all, or not?

    As far as the SY07140 table, only the records that have a CmdSequence, CmdDictID, CmdFormID and CmdID of 0 (zero) should have the 'Visible' column showing 0 (zero), otherwise, they should all be set to '1', by default.

    This table is populated when the users actually click on a series, for example, I logged onto a new install as 'sa' and went into Purchasing and Sales. Looking at the SY07140 now, I have two sets of records, one for CmdParentCmdID of 306 and CmdParentCmdID of 305.

    Thank you,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans