Skip to main content
Answer

Joinint to the AMMultiLevelBomData in Report Designer

  • October 31, 2022
  • 2 replies
  • 203 views
M
Jr Varsity II
Forum|alt.badge.img

Trying to enhance the AM613000 report to include our Legacy Part number on the report (this was implemented as a usr field on the InventoryItem table)

 

It won’t let me join InventoryItem to AMMultiLevelBomData as I gather that AMMultiLevelBomData is a dynamic “table” based upon the answers to the questions on the AM413000 screen

 

So how can I extend that to add a simple field?  I assumed it should be as simple as adding the InventoryItem table to the report and joining on the InventoryID columns, but that errors.

 

 

Best answer by lbarker

So I have managed to use a subreport but I pass the Inventory description as a parameter, and use that to get the data as the InventoryID did not work, so try that as should be workable as most dont have same description

 

2 replies

B
Jr Varsity II
Forum|alt.badge.img
  • bgreene87
  • Jr Varsity II
  • January 12, 2023

Did you ever get a response or resolution to this?  I have a client who would like a GI built to report the same data as the Multi Level Bom Costed report, but it’s largely based on the DAC you’re asking about and it won’t let me use it as a table in a DAC.  Thank you!

lbarker
Semi-Pro II
Forum|alt.badge.img+3
  • lbarker
  • Semi-Pro II
  • Answer
  • March 7, 2023

So I have managed to use a subreport but I pass the Inventory description as a parameter, and use that to get the data as the InventoryID did not work, so try that as should be workable as most dont have same description

 

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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