Solved

User Defined Field

  • 28 December 2023
  • 3 replies
  • 59 views
ngerst
Rank
Userlevel 3
Badge

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. 

 

 

icon

Best answer by Laura02 28 December 2023, 20:56

View original

3 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

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*.
G
Rank
Userlevel 4
Badge

@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
Rank
Badge +18

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. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~

Reply


Terms & ConditionsCookie 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