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).
#AcumaticaTnT Referencing another textbox/picturebox in a formula
In an invoice format in the report designer I want to edit a specific textbox to only be visible depending on whether another specific picturebox is visible.
What I am trying to do is having "textbox 25" with "=[CompanyContact.FullName]" not show up if there is a picture being loaded in "pictureBox 43" which consists of "=[Branch.BranchOrOrganizationLogoNameReport]".
This means that if a picture is not loaded in pictureBox 43, only then do I want textbox 25 to be visible.
I have tried IIF formulas and visible expression, to make the textbox with the company name be visible only if "=[Branch.BranchOrOrganizationLogoNameReport]=Null" - but Null does not seem to work in this scenario, even if there is no uploaded logo for the company it shows as Null always being false when I reference "BranchOrOrganizationLogoNameReport". Hence I am wondering if there is an easier way by just referencing the pictureBox directly and steer the visibility that way.
Practically, today the logo only loads if we have uploaded a logo in the company, which is good. But if the logo loads, we do not want to show the company name, which it does today. And if there is no logo in the company then we want the company name to show.
Thanks in advance and also I apologize for being possibly unclear about anything as I do not work in English and I work in the program Visma.net which is based on Acumatica.
Great practical scenario.
I was able to get an IIf formula to work with Null on the Invoice form in the SalesDemo database. I used the Invoice since it already had a logo on it.
When running the Invoice on a Branch that has a logo, the field is suppressed:
When running the Invoice on a Branch that does not have a logo, the field is displayed:
One thing I noticed, and this could be why it wasn't working for you, when the Branch does not have a logo, [Branch.BranchOrOrganizationLogoNameReport] still gets populated with the logo from the Company that the Branch belongs to so it's still not empty. In the previous screenshot, I had to create an entirely new Company, without a logo, to get it to work the way that I wanted.
Stellar English by the way. Even if it wasn't stellar, which it is, your English would still be 100% better than my Swedish which is non-existent. Well, almost non-existent. I can say "Ikea", is that a Swedish word? 😀
The company that I created for testing was a single company with no branches and it worked for me. I wonder if it might have to do with the version. I did this on Acumatica 2021 R1, but I know that most OEM solutions (like Visma) have to lag behind a few versions. Do you know what core version of Acumatica, the build number (click here), you are running?
Honorary Swede? Yes! Maybe that will help me this coming Winter in Ohio. I grew up in San Diego and I still haven't figured out how to survive Winters in Ohio. So many clouds, not enough sun!
Sadly I believe what you mention about lagging behind a few versions is very much correct. I checked all the way back to Acumatica 6.0, and only then did I recognize the new functions/windows in any of these versions. I assume since Acumatica 6.0 a lot has changed in the reports in regards to formula usage, therefore I will sadly have to be more passive on this forum, otherwise I will waste other users time by receiving help in the form of formulas that are not compatible with my version.