Skip to main content
Solved

IIF() function giving unexpected results

M
Varsity I
Forum|alt.badge.img

I have a function in a report that is not working as expected. 

 

It should only show an inventory code if the type is “Finished Good”:

=IIf(([InventoryItem.ItemType]='Finished Good'),[InventoryItem.InventoryID],'') 

This is only returning blanks for all Item types, but if I show the value in the ItemType field, it is displaying “Finished Good”.

 

I’m wondering if the underlying data in this field is actually something other than what displays on the screen, like maybe FG or something.  But I have no access to the DB to find out.

Best answer by Freeman Helmuth

To add to the above answers, anytime you want to filter or use a formula on a dropdown in Acumatica(not to be confused with a selector) you have to examine the dropdown to get the actual field values.

  1. Click Customization>Inspect Element(Or press Ctrl+Alt)

     

  2. Click on the dropdown you wish to examine

     

  3. Click on “Dropdown Values” to see the ID values of the dropdown

     

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

    4 replies

    Dioris Aguilar
    Jr Varsity I
    Forum|alt.badge.img+2

    @MarciaW You should be checking against the value stored in database instead of the one displayed in the screen. Try the following:

    =IIf(([InventoryItem.ItemType]='F'),[InventoryItem.InventoryID],'')

     

    Naveen Boga
    Chris Hackett
    M
    3 people like this
    • Naveen Boga
      Naveen Boga
    • Chris Hackett
      Chris Hackett
    • M
      MarciaW
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3407 replies
    • April 5, 2022

    @MarciaW  Try this!! 

    =IIf(([InventoryItem.ItemType]='F'),[InventoryItem.InventoryID],'') 

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    M
    2 people like this
    • Chris Hackett
      Chris Hackett
    • M
      MarciaW
    Freeman Helmuth
    Varsity III
    Forum|alt.badge.img

    To add to the above answers, anytime you want to filter or use a formula on a dropdown in Acumatica(not to be confused with a selector) you have to examine the dropdown to get the actual field values.

    1. Click Customization>Inspect Element(Or press Ctrl+Alt)

       

    2. Click on the dropdown you wish to examine

       

    3. Click on “Dropdown Values” to see the ID values of the dropdown

       

    darylbowman
    PatrickSchlenker90
    Chris Hackett
    4 people like this
    • darylbowman
      darylbowman
    • PatrickSchlenker90
      PatrickSchlenker90
    • Chris Hackett
      Chris Hackett
    • coriel
      coriel
    M
    Varsity I
    Forum|alt.badge.img
    • MarciaW
    • Author
    • Varsity I
    • 67 replies
    • April 5, 2022

    Thank you all very much, this is super helpful!  I don’t have access to our database as we are using the SAAS model, so at the moment I use inquiry screens to investigate data.

    Really very much appreciated!

    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