Skip to main content
Solved

Nonexistent Tables


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.

 

View original
Did this topic help you find an answer to your question?

6 replies

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

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

 


  • Author
  • 44 replies
  • 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
  • 2525 replies
  • 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
  • 3375 replies
  • 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
Freshman II
Forum|alt.badge.img
  • Freshman II
  • 14 replies
  • 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
  • 454 replies
  • July 3, 2024

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings