BAQs Calculated Fields - Ability to create a Global Variable

[John_Mitchell]

This might work by writing a Store Procedure and calling it as a custom function in the BAQ.

[ Good or Bad ] BAQ - SQL Procedure / Function Helpers by Martin Horton

Martin Horton posted an example on his Blog how to execute a SQL Procedure from a BAQ. I think this is promising, as long as you keep it on the dbo.* object and not Epicor! You can also do Cross-Database SELECTs and create a few nifty Procedures that you think you will re-use! How many times do you have to repeat in a BAQ “Get Default Plant Cost ID” But I am curious what @Bart_Elia and others alike @danbedwards @josecgomez @timshuwy @Edge @aidacra etc think of this? Bad, Good if Used Properl…