Solved

How to link custom table to existing screen?

  • 9 January 2024
  • 2 replies
  • 74 views
V
Rank

Hello,

 

Is it possible to link a custom table to an existing screen in Acumatica? I am aware of creating custom fields and adding to existing screens, but wondering if we can add fields from a custom table. I am trying to add a new tab item for the Inventory Maintenance screen and add new options that are in a custom table.

icon

Best answer by Leonardo Justiniano 9 January 2024, 17:05

View original

2 replies

Leonardo Justiniano
Rank
Userlevel 6
Badge +4

Hi @vineela95 

 

I suggest you take a look to the training course:

T220 Data Entry and Setup Forms 2023 R2 (acumatica.com)

 

In a nutshell you need:

  • DAC to map your table
  • Through the screen editor add a new screen. It will create a Graph in the code section.
  • Publish
  • Define a public view querying your table (BQL) in the graph
  • Specify the name of the view on the screen
  • Add fields and or a grid (what ever is your design)
  • Publish

Obviously is more than this and you need to go through the training.

Create a screen

 

Graph after saving new created screen
Once you code your BQL on the graph and have a public view.

 

Good luck!

Leo
Vignesh Ponnusamy
Rank
Userlevel 7
Badge +4

@vineela95,

Also, you can check the example by @Naveen Boga if in the following discussion,

Good Luck,

#VP

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