Skip to main content
Answer

Lookups with segments

  • November 14, 2022
  • 4 replies
  • 255 views

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?

4 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • November 14, 2022

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • November 14, 2022

I have not but I will.  Thanks.


  • Freshman I
  • April 18, 2023

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?

 


JTang
Jr Varsity II
  • September 12, 2023

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.