I'm trying to target open AP invoices in a Generic Inquiry, but no matter what I try, the formula always defaults to the else condition. =IIF([APInvoice.Status] = 'Open', 0, 1) =IIF([APInvoice.Status] = 'O', 0, 1) =IIF([APInvoice.Status] = 'o', 0, 1) =IIF([APInvoice.Status] = 1, 0, 1) =IIF([APRegister.Status] = 'Open', 0, 1) =IIF([APRegister.Status] = 'O', 0, 1) =IIF([APRegister.Status] = 'o', 0, 1) =IIF([APRegister.Status] = 1, 0, 1)I’ve also confirmed that my conditions are limited to open and closed invoices, yet the formula always returns the result for the else part.Any insight on how the status field is actually stored or how to get this to work would be appreciated Thanks!

Answer

Open AP Invoice Formula Not Working

Forum|Forum|4 months ago
July 16, 2025
4 replies
31 views

arodriguez1
Freshman I

I'm trying to target open AP invoices in a Generic Inquiry, but no matter what I try, the formula always defaults to the else condition.

=IIF([APInvoice.Status] = 'Open', 0, 1)
=IIF([APInvoice.Status] = 'O', 0, 1)
=IIF([APInvoice.Status] = 'o', 0, 1)
=IIF([APInvoice.Status] = 1, 0, 1)
=IIF([APRegister.Status] = 'Open', 0, 1)
=IIF([APRegister.Status] = 'O', 0, 1)
=IIF([APRegister.Status] = 'o', 0, 1)
=IIF([APRegister.Status] = 1, 0, 1)

I’ve also confirmed that my conditions are limited to open and closed invoices, yet the formula always returns the result for the else part.

Any insight on how the status field is actually stored or how to get this to work would be appreciated

Thanks!

Best answer by lauraj46

Hi @arodriguez1 ,

As @mblassingame35 suggests, you should use the code instead of the description. If you have permissions to ‘Inspect Element’ you can click ‘Drop-Down Values’ find the codes. Another way to find the codes is to add the field to your GI but instead of using the dropdown use a formula for the result: =[APInvoices.Status].

Hope this helps!

Laura

+3

mblassingame35
Semi-Pro II
Forum|Forum|4 months ago
July 16, 2025

These are the values for the statuses for AP Bills.

Melissa Blassingame

A

Like

+3

mblassingame35
Semi-Pro II
Forum|Forum|4 months ago
July 16, 2025

If you Inspect the Element, you will get this box, which then provides the values in the reply I have above.

Melissa Blassingame

A

Like

+8

lauraj46
Captain II
Answer
Forum|Forum|4 months ago
July 16, 2025

Hi @arodriguez1 ,

As @mblassingame35 suggests, you should use the code instead of the description. If you have permissions to ‘Inspect Element’ you can click ‘Drop-Down Values’ find the codes. Another way to find the codes is to add the field to your GI but instead of using the dropdown use a formula for the result: =[APInvoices.Status].

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*.

A