By using this website, you agree to our Terms of Use (click here)
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.
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.
@jmccarter Glad you found a solution without a parameter. I haven't been able to figure out how to populate parameters in SQL Views from the Acumatica Framework.
@timrodman what i did was just have the top level included on every line of my recursive view and then add a parameter to that.
