Skip to main content
Answer

Nonexistent Tables

  • February 28, 2023
  • 6 replies
  • 553 views

Is there any way I can use data from a Nonexistent table into my GI? for example In the Inventory Allocation Details screen there is a field called Reference Nbr. which is the document number of the source for this allocation.

how can I get the data within this field into my own made GI?

Best answer by Naveen Boga

Hi @Pinny  

Unfortunately, it's not possible to retrieve values from an Unbound DAC in the Inventory Allocation Details screen. However, you can review the graph code to determine which table Acumatica is using to retrieve the details that are dynamically loaded on the screen. Once you have identified the relevant table, you can use that information to fetch the details you need from that table in the appropriate pages.

I hope this explanation is helpful to you.

 

6 replies

estebanperalta54
Captain II
Forum|alt.badge.img+4

Hi @Pinny have you tried doing join with the table InventoryAllocDetEnqResult

 


  • Author
  • February 28, 2023

@estebanperalta54 

I don't think we can use that table as a source for your GI, it doesn't have any data in it, its just a view of other tables in the database, you’ll get an error saying “Invalid object name”


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • March 20, 2023

Hi @Pinny  were you able to find a solution? Thank you!


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • March 21, 2023

Hi @Pinny  

Unfortunately, it's not possible to retrieve values from an Unbound DAC in the Inventory Allocation Details screen. However, you can review the graph code to determine which table Acumatica is using to retrieve the details that are dynamically loaded on the screen. Once you have identified the relevant table, you can use that information to fetch the details you need from that table in the appropriate pages.

I hope this explanation is helpful to you.

 


NickCerri4
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • June 20, 2023

@Naveen Boga - Can you elaborate on the “Graph Code” you reference?  How does one go about finding this?  It may be understood under a different name so forgive me if this is more obviously represented in Acumatica.  Thanks!


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • July 3, 2024

@Pinny  - see this explanation this may help you too.