Boolean Field Values in Results Grid - Acumatica Generic Inquiries & Pivot Tables https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/ Acumatica User Group Forums en-US Thu, 13 Aug 2026 17:40:05 +0000 wpForo 60 RE: Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10434 Wed, 04 Jan 2023 23:47:26 +0000 Thanks @timrodman. Unfortunately, I don't remember how we got past this, but no issues have been reported yet.

]]> Acumatica Generic Inquiries & Pivot Tables dave.ziskind https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10434 RE: Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10423 Wed, 28 Dec 2022 04:42:39 +0000 Acumatica Generic Inquiries & Pivot Tables Tim Rodman https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10423 RE: Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10027 Thu, 23 Jun 2022 00:01:12 +0000 @tim-rodman The formula was used to make up for the data being off. Let me know if you are seeing something different. 

2845 2844

What I now see as even weirder is others that do not follow this pattern; I thought I saw that originally, but the formula worked on the need vendors. I've posted on the Acumatica Community, but not sure that will get it any attention.

]]> Acumatica Generic Inquiries & Pivot Tables dave.ziskind https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10027 RE: Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10024 Wed, 22 Jun 2022 22:30:54 +0000 Acumatica Generic Inquiries & Pivot Tables Tim Rodman https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10024 RE: Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10002 Thu, 16 Jun 2022 14:41:55 +0000 Acumatica Generic Inquiries & Pivot Tables dave.ziskind https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10002 RE: Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10001 Thu, 16 Jun 2022 10:51:14 +0000 Hello @dave-ziskind, looking at the Contact DAC, IsPrimary is a field that is calculated on the fly and isn't saved to the Database.  Because of this, when you try to use it, you'll only get NULL values.  You can get what you want by running the calculation though.  In this case, Left Join BAccount to Contact on Contact.ContactID = BAccount.DefContactID.  In your results grid, you can say IIF(BAccount.BAccountID = NULL, 0, 1).  This should get you the results you want.

]]> Acumatica Generic Inquiries & Pivot Tables Wyatt.ERP https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10001 RE: Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10000 Thu, 16 Jun 2022 02:55:22 +0000 Blank means false - are you certain there are Contacts where this property is true?

]]> Acumatica Generic Inquiries & Pivot Tables Royce Lithgo https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-10000 Boolean Field Values in Results Grid https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-9998 Wed, 15 Jun 2022 00:47:51 +0000 Hi!

When trying to return the value of IsPrimary from Contact, only blanks are returned. How do I get the true/false value?

Thank you,

Dave Z

]]> Acumatica Generic Inquiries & Pivot Tables dave.ziskind https://www.augforums.com/forums/acumatica-generic-inquiries/boolean-field-values-in-results-grid/#post-9998