Skip to main content
Solved

User Defined Field

  • December 28, 2023
  • 3 replies
  • 202 views
ngerst
Freshman II
Forum|alt.badge.img

I created a new user defined field on Sales Orders, how can I find this within SQL? Does it exist in a EXT table? 
 

Also assuming the answer is yes to the EXT tables, can you run a Generic Inquiry off of User Defined Fields and have it generate emails, notifications, etc. using automation schedule. 

 

 

Best answer by Laura02

Hello @ngerst ,

User Defined fields are available in GI’s within normal tables. For example, User Defined Fields shown below on the PO Header are immediately available for addition to the Purchase Orders GI.

Attributes add themselves to tables, for use in Generic Inquiries

Atrributes are also automatically available for use in emails & notification templates.

Laura

View original
Kandy Beatty
Laura02
J
3 people like this
  • Kandy Beatty
    Kandy Beatty
  • Laura02
    Laura02
  • J
    johnh3
Did this topic help you find an answer to your question?

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Kandy Beatty
  • Captain II
  • 2209 replies
  • December 28, 2023

HI @ngerst 

Here is an older post that may help you:

https://community.acumatica.com/develop-integrations-with-web-services-apis-289/view-change-stockitem-user-defined-fields-rest-20315?tid=20315&fid=289

Also, this may help you: 

https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=ec199ee5-3238-415b-9318-78c4c03bc22b

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
jinin
Chris Hackett
2 people like this
  • jinin
    jinin
  • Chris Hackett
    Chris Hackett
G
Jr Varsity III
Forum|alt.badge.img
  • gbrazelton14
  • Jr Varsity III
  • 61 replies
  • December 28, 2023

@ngerst I am not sure about your questions on notifications, etc, but the attribute(s) you added as User Defined Fields should already be included in your SOOrder table. Something like SOOrder.AttributeXXXXXX which can be added to generic inquiries, reports, etc.

 

Laura02
Chris Hackett
2 people like this
  • Laura02
    Laura02
  • Chris Hackett
    Chris Hackett
Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • 3132 replies
  • Answer
  • December 28, 2023

Hello @ngerst ,

User Defined fields are available in GI’s within normal tables. For example, User Defined Fields shown below on the PO Header are immediately available for addition to the Purchase Orders GI.

Attributes add themselves to tables, for use in Generic Inquiries

Atrributes are also automatically available for use in emails & notification templates.

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
G
Kandy Beatty
jinin
5 people like this
  • G
    gbrazelton14
  • Kandy Beatty
    Kandy Beatty
  • jinin
    jinin
  • Chris Hackett
    Chris Hackett
  • ngerst
    ngerst

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved