Solved

Adding a User Defined Field that is on the Location form to the Customer form - Location Tab/Grid

  • 13 June 2022
  • 5 replies
  • 353 views

Can someone point me in the direction of adding a user defined field to the location tab of the customer form. I added a user defined field to the location form, but it is not available to add to the location grid on the customer form.

icon

Best answer by markusray17 13 June 2022, 20:55

View original

5 replies

Userlevel 3
Badge

Hi Steve,

Can you provide more details like the DAC you have added the custom field to and how you are trying to add the field on to the Customer form - Locations grid? I do have some similar custom fields added to Location DAC and they are available on the Customer form as well. If your custom field is added to a different DAC on the Customer Locations form, then the corresponding Locations view on the Customer form may need to be modified. 

 

 

I created an Attribute for Salesperson and added it to the Customer Locations for as a user defined field.
 

Add the Attribute/UDF to this grid I added to the locations screen.

 

Userlevel 3
Badge

Ok I see you have added the custom field as a User-Defined Fields, the limitation of which is it can be added only to the header of the form and it gets added as a tab and you don’t have an option to reposition it or add it to grids. In this case, I’d advise you to add the custom field to the DAC using Customization. UDFs are based on Attributes and the values get stored in a different place.

Thank You!, can you point me in the direction of adding it to the DAC?

Userlevel 6
Badge +5

T190 Training covers how to create a custom field. The customization editor makes it fairly easy if you add a DAC under the Data Access section you can click the Create New Field button and it will add both the cache extension and the Database Script to create the column. Once you publish that you can add it to screen using the screen editor. 

Reply


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