• About WordPress
    • WordPress.org
    • Documentation
    • Learn WordPress
    • Support
    • Feedback
  • Log In
  • Register
  • News Feed
  • Members
  • Groups
  • Forums

My Groups

  • Power of One (Member Only)
    Power of One (Member Only)
  • Web Client
    Web Client
  • B1 Technical Tips and Tricks
    B1 Technical Tips and Tricks
  • B1 Functional Tips and Tricks
    B1 Functional Tips and Tricks
  • SAP B1 Enhancements
    SAP B1 Enhancements
  • SAP B1 Community
    SAP B1 Community
SAP B1 Community
  • About
    • Committees
    • Sponsors
    • Contact
  • Membership
    • Partners
    • SSP Benefits
    • Customer Benefits
    • Join
  • The Power of One
    • Power of One 2025
  • Blog
  • Resources
    • News Feed
    • Groups
    • Forums
    • Register
Clear Search
Sign in Sign up
Clear Search
  • About
    • Committees
    • Sponsors
    • Contact
  • Membership
    • Partners
    • SSP Benefits
    • Customer Benefits
    • Join
  • The Power of One
    • Power of One 2025
  • Blog
  • Resources
    • News Feed
    • Groups
    • Forums
    • Register
  • News Feed
  • Members
  • Groups
  • Forums

My Groups

  • Power of One (Member Only)
    Power of One (Member Only)
  • Web Client
    Web Client
  • B1 Technical Tips and Tricks
    B1 Technical Tips and Tricks
  • B1 Functional Tips and Tricks
    B1 Functional Tips and Tricks
  • SAP B1 Enhancements
    SAP B1 Enhancements
  • SAP B1 Community
    SAP B1 Community
Profile photo of Frank

Frank

@falunni • Joined Sep 2025 • Active 11 months ago

Remove Connection

Are you sure you want to remove from your connections?

Cancel Confirm
  • Profile
  • Forums
  • Connections
  • Groups
  • Timeline
  • Photos
Show
  • Personal Posts
  • Reacted To
  • From Groups
  • From Connections
  • Mentioned In
by
  • New Posts
  • Recent Activity
  • Profile Photo
    Profile photo of Frank
    B1 Technical Tips and Tricks

    Frank started the discussion

    11 months ago

    Valid Values in Query

    Often when writing queries in SAP Business One, you’ll encounter user-defined fields (UDFs) that use valid values—essentially dropdowns with predefined options. The typical approach is to write a long CASE statement to translate the stored value into its display label. While this works, it quickly becomes unwieldy and hard to maintain. These CASE…

    Read more

  • Profile Photo
    Profile photo of Frank
    SAP B1 Community

    Frank joined the group

    11 months ago
    0 Comments
    • Profile photo of Frank Profile photo of Rona

      Frank & Rona are now connected

      11 months ago

      0 Comments
      • Profile Photo
        Profile photo of Frank
        B1 Technical Tips and Tricks

        Frank joined the group

        11 months ago
        0 Comments
        • Profile Photo
          Profile photo of Frank
          SAP B1 Enhancements

          Frank joined the group

          11 months ago
          0 Comments
          • Profile Photo
            Profile photo of Frank
            B1 Functional Tips and Tricks

            Frank joined the group

            11 months ago
            0 Comments
            • Profile Photo
              Profile photo of Frank
              Web Client

              Frank joined the group

              11 months ago
              0 Comments
              • Profile photo of Frank

                Frank changed their profile photo

                11 months ago

                Profile Photo
                0 Comments
                • Profile photo of Frank

                  Frank became a registered member

                  11 months ago

                  0 Comments

                  • Public
                  • All members
                  • My connections
                  • Only me

                  • Public
                  • All members
                  • My connections
                  • Only me

                  • Public
                  • All members
                  • My connections
                  • Only me

                    Profile photo of

                    Write a comment...

                    Details

                    First Name

                    Frank

                    Last Name

                    Alunni

                    Nickname

                    falunni

                    Phone

                    2893398712

                    Report

                    There was a problem reporting this post.

                    Harassment or bullying behavior
                    Contains mature or sensitive content
                    Contains misleading or false information
                    Contains abusive or derogatory content
                    Contains spam, fake content or potential malware

                    Block Member?

                    Please confirm you want to block this member.

                    You will no longer be able to:

                    • See blocked member's posts
                    • Mention this member in posts
                    • Invite this member to groups
                    • Message this member
                    • Add this member as a connection

                    Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

                    Report

                    You have already reported this .