Solved

Nonexistent Tables

  • 28 February 2023
  • 5 replies
  • 220 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?

icon

Best answer by Naveen Boga 21 March 2023, 03:23

View original

5 replies

Userlevel 6
Badge +3

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

 

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

Userlevel 7
Badge

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

Userlevel 7
Badge +17

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.

 

Userlevel 1
Badge

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

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