Skip to main content
Solved

AP Bill and Adjustment GI issue - No records showing

  • February 19, 2025
  • 5 replies
  • 37 views
A
Freshman I

Hello! I am working on a GI to display all line items for bill/adjustment. The goals is to have the parameter and condition set to search by the reference number. With the parameter and conditions I currently have set below, I am experiencing an issue. 

When I view the GI and attempt to search by reference number, no records are showing for AP Bills or Adjustments. there are multiple records in the system.

If I search a specific reference number, the results do appear. How can I fix this issue to show all records and reference numbers when you click the magnifying glass? 

Thank you!

Best answer by lauraj46

Hi ​@aminerd ,

Maybe there’s a better way, but one approach would be to specify a default value for the parameter and include this in the criteria.  I couldn’t get it to work with <Select> but a different value such as ALL seems to work fine.

 

Hope this helps!

View original
    Did this topic help you find an answer to your question?

    5 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • 708 replies
    • February 19, 2025

    ​@aminerd The RefNbr field is dependent on the DocType field, similar to the printed form report AR641000. If you delete the DocType, the RefNbr is blank in the lookup.

    Try defining the DocType as a parameter first and then the RefNbr should be able to populate with options

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    lauraj46
    Captain II
    Forum|alt.badge.img+8
    • lauraj46
    • Captain II
    • 584 replies
    • February 19, 2025

    Hi ​@aminerd ,

    You need to add the Document Type as a parameter in order for the reference number lookup to populate.  You can set a Default Value if that’s helpful for the user experience.

    Hope this helps!

    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*.
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    A
    Freshman I
    • aminerd
    • Author
    • Freshman I
    • 9 replies
    • February 19, 2025

    ​@BenjaminCrisman and ​@lauraj46 Thank you both! I am now able to populate records. However, I am curious about something else. When I view the GI I get this result...

    If I clear the “<SELECT>” from the Reference Nbr field, then all records show up, like this...

    Is there anything I can do to have this view immediately upon running the GI instead of having to clear “<SELECT>” in the Reference Nbr field? The condition I have set is showed below. 

    Thank you!

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    lauraj46
    Captain II
    Forum|alt.badge.img+8
    • lauraj46
    • Captain II
    • 584 replies
    • Answer
    • February 19, 2025

    Hi ​@aminerd ,

    Maybe there’s a better way, but one approach would be to specify a default value for the parameter and include this in the criteria.  I couldn’t get it to work with <Select> but a different value such as ALL seems to work fine.

     

    Hope this helps!

    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*.
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    A
    Freshman I
    • aminerd
    • Author
    • Freshman I
    • 9 replies
    • February 19, 2025

    ​@lauraj46 That worked! Thank you for your help ​@BenjaminCrisman and ​@lauraj46 

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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