Skip to main content
Solved

Joinint to the AMMultiLevelBomData in Report Designer


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

 

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

2 replies

Forum|alt.badge.img
  • Jr Varsity II
  • 23 replies
  • 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
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 75 replies
  • 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

 


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