AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Referencing another...
 
Notifications
Clear all

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

#AcumaticaTnT Referencing another textbox/picturebox in a formula

Acumatica Report Designer
Last Post by Alec Axelblom 1 year ago
5 Posts
2 Users
1 Likes
875 Views
RSS
Alec Axelblom
Posts: 12
 Alec Axelblom
Topic starter
September 2, 2021 2:21 pm
(@alec-axelblom)
Member
Joined: 1 year ago

Hello,

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. 

 

4 Replies
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
September 2, 2021 3:15 pm
(@timrodman)
Member
Joined: 7 years ago

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.

=IIf([Branch.BranchOrOrganizationLogoNameReport]=Null,true,false)
image

 

When running the Invoice on a Branch that has a logo, the field is suppressed:

image

 

When running the Invoice on a Branch that does not have a logo, the field is displayed:

image

 

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? 😀 

Reply
Alec Axelblom
 Alec Axelblom
(@alec-axelblom)
Joined: 1 year ago

Member
Posts: 12
September 3, 2021 5:47 am
Reply toTim RodmanTim Rodman

@timrodman

Thanks Tim, but I can't get this to work for me. As you said it might have to do with the logo field not showing up as empty. However in this scenario we do not use branches, we just use individual companies. Perhaps there is a better formula I should use to reference the company logo that I am unaware of. 

Judging by how much you help here I am inclined to make you a honorary Swede!

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
September 3, 2021 8:45 am
(@timrodman)
Member
Joined: 7 years ago

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!

Reply
Alec Axelblom
Posts: 12
 Alec Axelblom
Topic starter
September 6, 2021 3:37 am
(@alec-axelblom)
Member
Joined: 1 year ago

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. 

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 7 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×