AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • 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...
Generic inquiry of ...
 
Notifications
Clear all

Questions Generic inquiry of User Define Fields (UDF) in Customer Location

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 7 years ago
2 Posts
2 Users
0 Reactions
4,602 Views
RSS
Peter John Sarador
Posts: 13
 Peter John Sarador
Topic starter
April 26, 2019 5:06 am
(@peter-john-sarador)
Eminent Member
Joined: 4 years ago

Hi Tim,

I added a user define fields in customer location so I can track what project this location is. Now that I want to extract the data through generic inquiry I can't find the right tables for this inquiry. Acumatica suggest the tables LocationKvExt and Location but I can't find the LocationKvExt table. Thanks 


1 Reply
Tim Rodman
Posts: 3196
 Tim Rodman
Admin
June 4, 2019 9:10 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hey Peter,

What you are getting is just a warning that the query could run slow. I wouldn't worry about it unless it's taking a long time to run.

The old Attribute values used to get stored in the CSAnswers table, but I think the new User Defined Field values get stored in those KvExt tables.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 39 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Invoice subreport for line-level tax breakdown not tieing to taxes subtotal
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 © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×