Custom Kinetic Search

Kinetic ERP
1

After this (Updating Kinetic Dataviews with Event to Show Custom Field) headache-inducing ride with @hmwillett trying to learn how to customize a built-in form, I gave up and moved on to the next problem. I am hoping this one is easier than the last.

I have added myself a UD field to the WhseBin table. I would like to see this field in various places to make it actually useful. The most useful place to see this field would be in the PartBinSearch form (or sidebar, whatever).

Is there any way to customize the PartBinSearch to include a field for my bin fullness custom field? Thanks for your time!
Nate

2

Did you say you were SaaS?

3

Does that mean dedicated cloud tenancy? If so, then, yes.

4

Lemme ask it this way… do you have access to the server files?

5

No, not that I know of. I have to submit Epicor requests to get anything from the server.

6

The only way I have found to make custom searches to to modify the JSON on the server, then run Conversion 191 to move it into the XXXDef table.

Outside of that, you may want to go with a BAQ or Quick Search.

7

How do you always have the hardest approach?! HAH!

Can I create a BAQ or Quick search that works in Kinetic? I don’t see a place to choose it in the PartBinSearch pull out thingy.

8

To be fair, App Studio doesn’t exactly make it easy, hahaha.

You bet! It’s at the bottom of the Search Options on the show-search widget.

image
image393Ă—856 14.6 KB

1 Like
9

You should see what I did to build out a custom Kinetic screen that didn’t use one of the premade screens. :grimacing:

10

Aaron you are a saint for helping!
So, I copied all the event widgets for the locked event: InvTrans.ToBinNum. I pasted them into a new event with identical triggering. The only difference is that I navigated to search type/name and put in my new BAQ. I created a BAQ like this:

select 
	[WhseBin].[WarehouseCode] as [WhseBin_WarehouseCode],
	[WhseBin].[BinNum] as [WhseBin_BinNum],
	[WhseBin].[Fullness_c] as [WhseBin_Fullness_c],
	[WhseBin].[Company] as [WhseBin_Company]
from Erp.WhseBin as WhseBin

I also set the BAQ Search Like columns to include Company, Warehouse, and BinNum. I shared the BAQ and saved it.

Now When I click on the bin search icon, It brings up the sidebar in BAQ mode, with nothing else in it. No options or results or errors. I must have done something wrong here.

1 Like
11

Can you take a screenshot of the search options?

12

Do you mean the BO, method and parameters?

13

1

2
2381Ă—689 19.9 KB

14

It’s likely because you’re using the “Like PartBinSearch.PartBin” and your BAQ is using WhseBin.

Actually, you know what? This one is finicky. Let me try something. Hang tight.

1 Like
15

Change the “like” to PartBin.BinNum instead of PartBinSearch.PartBin.

2 Likes
16

That did do the trick! It is not exactly what I want. But for today, I am chalking this up as a win! Thank you my friend!

1 Like
17

Just for reference, adding a field to the original search (assuming server access) is as easy as adding the new field here:

image
image1123Ă—654 87.2 KB

image
image685Ă—921 32 KB

Save, then run conversion 191. Boom. New field in search.

**Note: upgrades may or may not break this. Haven’t had a chance to try. Patches don’t (so far).

4 Likes
18

Maybe I can ask Epicor support to do this…

19

How can I filter my BAQ results to include only those rows where the part number and warehouse match the selection on the Inventory Transfer form?

20

Was that “Preload Search Filter” not working for you?