Skip to main content

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. 

 

 

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

@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.

 

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

Reply


Terms & ConditionsCookie settings