Skip to main content
Question

Tracking Report Changes

  • April 27, 2026
  • 3 replies
  • 38 views
J
Varsity I
Forum|alt.badge.img

I have a publicly traded customer who is looking to track any changes made in settings in Acumatica.  They have asked how to track the last modified date for any report in the system.  When you go to a report form in Acumatica like AR641000, there is no DAC schema provided and you know that the entries on the Report Versions tab must be stored somewhere.  I have two questions:

  1. What table in Acumatica is there a list of all the existing reports?
  2. What table are the Report Versions entries stored in?

Thank you,
John

 

3 replies

N
Jr Varsity I
Forum|alt.badge.img
  • nasir
  • Jr Varsity I
  • April 28, 2026

​@johnw51 

All reports in Acumatica are stored in the SiteMap table, where each report is identified by its ScreenID (e.g., AR641000).

The entries shown in the Report Versions tab are stored in the SMReportVersion table. This table contains version-level details such as ReportID, VersionNbr, CreatedDateTime, LastModifiedDateTime, and the user who made the changes.

Additionally, the SMReport table holds the base report definition and links to SMReportVersion.

In short:

Reports list → SiteMap
Report versions → SMReportVersion
Base report data → SMReport

    F
    Varsity III
    Forum|alt.badge.img+1
    • FarhanaM60
    • Varsity III
    • April 28, 2026

    Reports are stored in the SiteMap table, and the report definitions and versions are maintained in the Report and ReportHistory tables.

    Farhana Mohammad
      J
      Pro III
      Forum|alt.badge.img+2
      • jzhu
      • Pro III
      • April 28, 2026

      Hi ​@johnw51 

      UserReport DAC also stores information you are looking for!

        Terms & ConditionsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved