Filter on combobox in kinetic

Kinetic ERP
1

Hello Guys,
i added a combobox in ap invoice entry.
and try to filter by Vendor ID.
it doesn’t work.
i tried a lot of combination.
UD10_key1=??‘{VendorID}’
UD10_Key1 =?‘{VendorID}’
all of them not working.
can you please help what is the syntax to add the filter.

thanks,

Eddy

image
image1828×847 72.4 KB

2

I think question mark goes inside the single quotes.

UD10_Key1 ='?{VendorID}'

3

image
tried and not working.
it return empty. it should return one record.

4

Try moving that down to the Search Filter instead of the Row Filter… I saw that work for someone else on here… can’t find the post now, to link it.

5

now, i have to add a button and put baq in dataview and click button to load baq with filter
and then it worked.
exhausted!

Frankly speaking, Kinetic application studio is not an ideal place to do the customization.
Before I use one hour to finish such task in classic and now, i have to double/triple time to do the similar output with extra click. user may not like the extra click.

but thanks for the help.

regards,
Eddy

1 Like
6

I’m assuming you could set up your event for your BAQ to run automatically anytime the APInvHed.VendorNumVendorID changes. Shouldn’t need a “button”… if you want to get rid of that extra click.

1 Like
7

This :point_up_2:

You could set up your event trigger like this:
Type = DataView
Hook = Row Changing
Target = relevant data view … in this case, APInvHed

There is definitely a learning curve … but it gets better!

As @timshuwy likes to say, Kinetic is developed using Application Studio … it’s a very powerful tool, just lacking in documentation and consistency. As you keep learn the quirks and hidden gems, you can churn out better customizations faster

8

Hello David,
I tried already but the event did not fire. that’s why I put button.

regards,

Eddy

9

Thanks for the tips. I already tried that and it is not fired.
only button is working so far.

1 Like