By using this website, you agree to our Terms of Use (click here)
Hi All,
I'm having trouble with a simple equation in a GI I am working on.
=IIf([AMBatch.DocType] = 'Move' , [AMBatch.BatNbr], Null )
I just get a blank column, it does not appear to be evaluating.
See the full GI attached below.
Thanks,
Matt
Often times, the value you are using within a condition is not always the same as the value you would use in a filter on the same column. For instance, you are building a condition with the value 'Move'. However, the condition is applied before much of the Acumatica formating and data normalization processes occur. Therefore, you need to use the value contained within the database source itself.
I am unfamiliar with the AMBatch DAC. Where is it used? If we know that, we can try to determine where the actual data is stored in SQL and see what is stored within it. I suspect it to be something like 'M' rather than the user-friendly term 'Move'.
Thank you! I didn't even think about that.
When you create a filter, it shows a different letter when you save - turns out that is the SQL value I should be using in my filter.
In this case, it was O for the move step.
Thanks,
Matt