Skip to main content
Solved

Lookups with segments

  • Nov 14, 2022 8:43 PM UTC
  • 5 replies
  • 361 views
  • Translate All

Forum|alt.badge.img

Our customer has segmented subaccount numbers. They wish to do a search on the account details screen with a partial segment that will pull all subaccounts with that partial. Is it possible to use a lookup field for segmented numbers?  See screenshot below.

 

Best answer by BenjaminCrisman

Hi @lori00! You should be able to press F3 to bring up a selector type window for segment values, have you already tried this?

View original

5 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • Nov 14, 2022 8:47 PM UTC

Hi @lori00! You should be able to press F3 to bring up a selector type window for segment values, have you already tried this?

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Nov 14, 2022 9:37 PM UTC

I have not but I will.  Thanks.

Translate

  • Freshman I
  • Apr 18, 2023 12:57 PM UTC

Hi, when we hit F3 to bring up the selector type window for the subaccount values, it is blank, despite having over 800 setup.  Any ideas as to why we can’t see them in the dropdown window?

 

Translate

JTang
Jr Varsity II
  • Sep 12, 2023 11:37 AM UTC

I would try Recalculate Account History, but also looking at the subaccount field, you might have an issue with how your subaccount segments are set up. As it’s supposed to already be segmented prior to entering/looking up a field. So that’s probably where your issue lies. Your lookup mode on Segmented Keys should be By Segment so the field should look like below.
 

 

Translate

Forum|alt.badge.img
  • Freshman I
  • Jun 1, 2026 7:20 PM UTC

Hi ​@BenjaminCrisman  ​@shelbyc  I was not able to get the lookup box with F3. How can I get this.

Translate