AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica Generic I...
Using « start with ...
 
Notifications
Clear all

Questions Using « start with » unstead of « contrains »

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 5 years ago
2 Posts
2 Users
0 Reactions
765 Views
RSS
ericmeunier12
Posts: 1
 ericmeunier12
Topic starter
October 25, 2020 5:03 pm
(@ericmeunier12)
New Member
Joined: 6 years ago

Is there a way to setup my preference so that when we enter an invoice and we want to choose the gl account, the system propose only gl’s that stars with the Numbers enter

ex

if we key in 17, we dont want the gl 22217 and 33173

We only want the gl 17001, 17002...

thank you all

Eric


1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
January 19, 2021 12:52 am
(@timrodman)
Famed Member
Joined: 11 years ago

It's a contains search, not a "starts with" search unfortunately.

 

You could key in "170" instead of "17" to be more restrictive. Or, if you want to do something crazy, you could modify your Chart of Accounts and add a leading digit or character (eg. "A" for Asset, "L" for Liability, etc.). Then you'd key in "A17" and it would function as a "starts with" search.

 

Or, you could do a Starts With filter like this, it just takes a few clicks:

image

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 38 Online
  • 2,420 Members
Our newest member: Katerina Pawlowski
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
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

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×