https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/ Acumatica User Group Forums en-US Thu, 21 May 2026 12:06:45 +0000 wpForo 60 https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11574 Mon, 12 May 2025 11:44:35 +0000 Everything Else Justen Mccarter https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11574 https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11572 Mon, 12 May 2025 00:02:33 +0000 Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11572 https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11515 Fri, 15 Nov 2024 18:21:00 +0000 Nevermind, I figured this out. I didnt need to declare it. i just needed to add the top bom to every level then i can sort by this.

]]> Everything Else Justen Mccarter https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11515 https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11504 Fri, 08 Nov 2024 17:40:42 +0000 Is it possible to pass a sql view with an "emtpy" spot to be filled out by a report parameter to acumatica? We wanted to use the mutli level bom for verifying our boms but it is missing information that we need. So I am creating my own as a cte  that uses the recursive statement to blow through the boms and show information for every level. I want to pass this as a view to acumatica. I think it should be done for 1 bom at a time because it would be too exhaustive on the system if it was trying to do all of them at once. How would I set it up so that I can do that? Screen shot of the section im talking about. The goal is to make a report and add it to the side panel of "Bill of Materials" , so that designers can print it out when they build the prototype and compare the Acumatica BOM to what they actually use. This would be a final checkoff before we deem it "Production Ready". I may be over thinking it, but I cant seem to think of a way to pass it over with the "blank" so that the paramater on the report will be the input for the parameter in the CTE. Or should i just pass it over without the "blank" and just make sure its only ever used in a report and or a GI that has a parameter. I also put this statement in AUGSql to double check that the output is the same.

 

3581]]> Everything Else Justen Mccarter https://www.augforums.com/forums/everything-else/passing-a-sql-view-with-a-parameter-to-acumatica/#post-11504