Solved

Generic Inquiry Parameters Defaulting to NEW Value?

  • 30 January 2021
  • 4 replies
  • 756 views

Userlevel 4
Badge +2

In version 2020r2 v205 (I know… :rolling_eyes: ) I have a couple of GIs that I’ve created that are using the InventoryCD value as my parameter with standard parameters allowing for the display of all items if the parameter is Null.  

When I open the Inquiry, either from the UI or using the View Inquiry action from the Generic Inquiries screen, Acumatica is inserting the <NEW> value, as though it’s expecting me to create a new record.  

 Has anyone seen this before?

icon

Best answer by ChandraM 29 September 2021, 18:18

View original

4 replies

Userlevel 7
Badge +9

Hi @freiter85 and @plmainard , Using =Null as the defualt value works for the Customer view that had the same issue.

Thanks

Userlevel 1

Try setting the Default Value of the paramter to =Null

Userlevel 4
Badge +2

Hi Naveen,

According to support, it’s because the GI is using InventoryItem.InventoryCD as the parameter filter while having auto-numbering enabled for the Inventory Item segmented key.  Seems a bit strange but I think it’s a bug.  I may need to use a different schema field for the query filter that’s not linked to the Inventory maintenance screen.  Doesn’t make much sense to me, but I will try to find another filter to make this work.  I think there’s one that can be used as a dashboard filter that may work.

 

Thanks for the response though.  

Userlevel 7
Badge +17

Hi @plmainard This is strange....Not seen this before…

Can you please export XML format of GI and share. We can dig into it and let you know if found anything

Reply


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