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...
Finding Fields in t...
 
Notifications
Clear all

Questions Finding Fields in the Database

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by gonzo 9 years ago
3 Posts
2 Users
1 Reactions
5,239 Views
RSS
gonzo
Posts: 18
 gonzo
Topic starter
June 17, 2017 12:40 am
(@gonzo)
Eminent Member
Joined: 9 years ago

Hi Everyone,

I want to create a report based on sales order data in the Sales Orders screen.

Is there an easy way to see what the fields are in the database for each field on the screen?


2 Replies
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3204
June 17, 2017 12:44 am
Reply togonzogonzo

Hi Gonzo,

Yes, there is actually an easy way to do this.

I recommend taking a look at this post to learn how:
http://www.augforums.com/inspect-element-best-friend/

Note: I would say that this works on 90% of the fields, but there are some fields that it doesn't work on. You'll know because the Data Field will be empty.


Reply
gonzo
Posts: 18
 gonzo
Topic starter
June 17, 2017 12:48 am
(@gonzo)
Eminent Member
Joined: 9 years ago

Sweet! That is so much nicer than having to hunt-and-peck in the database for fields.

This almost makes up for the fact that there is currently no Acumatica Schema Browser.


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 13 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
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

  • Johnny Tang
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×