Skip to main content
Question

GI - filter GL journal detail by date and Batch number

  • January 22, 2026
  • 3 replies
  • 18 views
G
Jr Varsity I

Hi All, 

I have created a GI on GL journal detail but my filtering doesn’t work on the batch number ( from and to) and journal date ( from and to) can someone please give me a lead on what I have missed? 

None of these filters work.

Thank you 

 

 

3 replies

lauraj46
Captain II
Forum|alt.badge.img+9
  • lauraj46
  • Captain II
  • January 22, 2026

Hi ​@GhazalSh ,

I would suggest adding brackets around the OR operations to define the order of operations. 

Laura 

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • January 22, 2026

    ​@GhazalSh When you are making your conditions and specifying an ‘Or’ clause, you need to make sure you put brackets on it or it will end up just disregarding what you’re trying to capture. As it reads now it’s saying the first line needs to be met OR the second line, OR the third line AND the rest of it. So it doesn’t really seem like it’s going to work without the correct brackets.

    Edit: Just saw ​@lauraj46’s response, in agreement!

      G
      Jr Varsity I
      • GhazalSh
      • Author
      • Jr Varsity I
      • January 23, 2026

      Hi ​@lauraj46 ​@BenjaminCrisman , 

      Thanks so much for taking the time to respond. This GI is the expansion from the Original GI of Acumatica , I have now added the brackets but it still doesn’t show my desired results. 

      I need to filter by date or by Batch number ,

      Thank you 

      Ghazal 

      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