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

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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
5,082 Views
RSS
Peter John Sarador
Posts: 13
 Peter John Sarador
Topic starter
April 26, 2019 6: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: 3204
 Tim Rodman
Admin
June 4, 2019 10:10 pm
(@timrodman)
Famed Member
Joined: 11 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,533 Topics
  • 11 K Posts
  • 87 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

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.

‹›×

    ‹›×