I come out here to complain enough but today I am pretty thrilled. Navigating the new BAQ designer was super painful the first few times (why must everything be moved!!!) but after reading the documentation I get it. The “reference queries” function with the ability to run the results as a table variable or temp table is a massive game changer. Really can’t overstate it. Functionality that was simply not possible before (at least for cloud customers) is there now and actually works flawlessly. Good job epicor, been waiting a long time for this and am so happy it really works.
11 Likes
That was my idea!
17 Likes
How do you access the new BAQ designer? We are on 2024.1 in a new test environment.
It’s the same menu item as you normally use. If you open Kinetic in the browser, it will open the new designer
You can also open it directly at https://server/instance/Apps/ERP/Home/#/studio/baq/studio-core if you have the required permissions.
2 Likes
I have one complaint about it… I don’t know which company is active when I’m using it. I was going to create an ‘Idea’ about it, and it already exists but doesn’t have many votes.
Showing the current company in Kinetic | Epicor Kinetic Ideas Portal
3 Likes
I voted for that, and I have an old one out there - Form Options should be truly Global as well.
Didn’t someone else have one like this too?
@timshuwy - can you merge these and get the vote count combined?
1 Like
Voted for it. @MikeGross I can’t open your link 
1 Like
It’s missing the dash in the ‘epicor-manufacturing’ part of the URL.
3 Likes
I was poking Mike to fix his link but now you go and spill the beans and making it easy on him. 
2 Likes
Fixed!
1 Like
I did the merge, but it seems that after merging, the vote count didn’t change… that means the the people who voted for one, also voted for the second. BUT thank you, as merging the ideas does increase our awareness of the total scope of the idea.
5 Likes
Thanks, I’ll throw it into the last Frideas thread and try to remember to repost this Friday too.
2 Likes
Actually I have a bpm for that… Not sure if it came from here or not now. Will edit this tomorrow to point to the link.
1 Like
Thanks!
And the new URL is:
It’s the root for all products and not just Kinetic.
Do any of you get this bug?
You have to start typing for the combo to populate
3 Likes
Yes indeed.
But still, think about the fact that you can TYPE there. So much better.
In classic, you just had to memorize that Plant is the 14th field in PartTran that begins with P.
PPPPPPPPPPPPPP
That’s the quick way to get to it.
JobFirm was the 9th J in JobHead.
Yes I still have the scars.
6 Likes
IIIIIIIIIndeed, def a step forward!
2 Likes
All the time. There’s an even worse bug than that. If there are two fields that start the same way, you CANNOT type to the second one. It sticks on the first one it finds and refuses to accept even if you type in the full name of the field you are actually looking for. Then all you can do is scroll and scroll and hope you find it eventually.
3 Likes
In response to your global defaults query. I based my BPM off this post
https://www.epiusers.help/t/set-global-options-across-company/92794
Kudos to @mbayley
I think only thing I added was
{ "Date", "True"},
{ "Time", "True"}
essentially all you need to do is know the fields in the XML that is stored in the content field. Here is an example converted into a more readable format.
{
"AllForms": {
"version": "7/28/2014 11:39:15 AM",
"StatusBarProperties": {
"Status": "True",
"UserID": "False",
"Language": "False",
"Company": "True",
"Plant": "False",
"Server": "False",
"Date": "False",
"Time": "False",
"BorderPanelStyle": "Default",
"BorderStyle": "Default",
"DateFormat": "d",
"TimeFormat": "t"
},
"HotKeysProperties": {
"DeleteToolPosition": "Default",
"EnterpriseSearchHotKey": "CtrlShiftS",
"ZoneHotKey": "CtrlShiftI",
"SearchHotKey": "CtrlS",
"MaintHotKey": "CtrlM",
"CarriageReturnAsTab": "False",
"ClearHotKey": "None",
"DeleteHotKey": "None",
"ExitHotKey": "None",
"NewHotKey": "None",
"RefreshHotKey": "None",
"SaveHotKey": "None",
"UndoHotKey": "None",
"SearchIndicator": "True",
"MaintIndicator": "True",
"SearchColor": "LightSteelBlue",
"MaintColor": "DarkKhaki",
"ZoneIndicatorSuppressed": "False",
"ZoneIndicatorColor": "LightSteelBlue",
"RequiredIndicator": "False",
"RequiredIndicatorColor": "Salmon"
},
"DesignerGridProperties": {
"SnapToGrid": "False",
"GridWidth": "8",
"GridHeight": "8"
},
"CustomizationProperties": {
"TopMost": "True",
"DefaultCustomizationLanguage": "None",
"SuppressSaveCommentDialog": "False"
},
"CustomCodeEditorProperties": {
"UseTabs": "True",
"UseTabStops": "False",
"TabSize": "4",
"AutoIndentMode": "None"
}
}
}
as @mbayley explains.
It’s just an InTrans Data directive on the xxxdef table, and your set. Love these little improvements. With that being said it would be good to just have that capability either in company config or some other admin page that allowed you to easily configure this to ensure a consistent UI for the users and support team.
Although my plan did not go exactly the way I expected. Every time someone sends a screen shot they truncate the status bar, which is extremly annoying.
Of course Global options is there, but the user has to set it up with @mbayley s way… User does not have to remember, although I think it makes a good icebreaker for onboarding new users…for classic anyway…
3 Likes