By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
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
Blank means false - are you certain there are Contacts where this property is true?
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.
@wyatt-erp I am using =IIf( [Contact.ContactID]=[BAccount.DefContactID]+1, 'Y', 'N' ) which works with my joins. However, as you can see in the formula, my ID's are off by one. Have you seen that before?
@tim-rodman The formula was used to make up for the data being off. Let me know if you are seeing something different.
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.
@dave-ziskind That's weird. I haven't needed the +1 before. I wonder what's going on in your environment.
Thanks @timrodman. Unfortunately, I don't remember how we got past this, but no issues have been reported yet.
Online Members
