Skip to main content
Answer

Filter by Screen ID on report designer

  • July 28, 2025
  • 2 replies
  • 48 views
T
Freshman I

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.

    2 replies

    DrewNisley
    Pro I
    Forum|alt.badge.img+3
    • DrewNisley
    • Pro I
    • Answer
    • July 28, 2025

    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.

    Drew Nisley
    darylbowman
    Chris Hackett
    T
    Freshman I
    • thinkinkllc
    • Author
    • Freshman I
    • July 29, 2025

    Thanks Drew I will take a look at this.

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility 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