Skip to main content
Answer

User Defined Field

  • December 28, 2023
  • 3 replies
  • 278 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 Laura03

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

Kandy Beatty
Laura03
J

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Kandy Beatty
  • Captain II
  • 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
G
Jr Varsity III
Forum|alt.badge.img
  • gbrazelton14
  • Jr Varsity III
  • 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.

 

Laura03
Chris Hackett
Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • 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 Barber, WM Synergy
G
Chris Hackett
ngerst
Terms & ConditionsCookie settingsAccessibility statement
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