Skip to main content
Solved

Filter by Screen ID on report designer

  • Jul 28, 2025 11:36 AM UTC
  • 2 replies
  • 105 views
  • Translate All
Freshman II
Forum|alt.badge.img

I am trying to create a printable report with  Service Contract information. I am specifically trying to filter the data in the FSContractPeriodDet table by CreatedScreenID. 

I am able to filter this data from EDIT REPORT after the report is open, but I can not get a filter to work for this directly in the report it’s self. The ScreenID I am trying to filter is FS.30.57.00. 

I am assuming there is a different ID value or something that is actually saved in the database and not the actuals ScreenID.

Does anyone have any insight they can share?

Best answer by DrewNisley

You should be able to filter by CreatedByScreenID. It is saved in the database as 8 characters, so no periods if you were using the periods.

View original

    2 replies

    DrewNisley
    Pro I
    Forum|alt.badge.img+4
    • DrewNisley
    • Pro I
    • Answer
    • Jul 28, 2025 11:50 AM UTC

    You should be able to filter by CreatedByScreenID. It is saved in the database as 8 characters, so no periods if you were using the periods.

    Translate
    Drew Nisley
      Freshman II
      Forum|alt.badge.img
      • thinkinkllc
      • Author
      • Freshman II
      • Jul 29, 2025 10:47 AM UTC

      Thanks Drew I will take a look at this.

      Translate
        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