Product Configurator - GI Inventory Item List with Attributes as parameters - Acumatica Generic Inquiries & Pivot Tables

RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Dan Wilkins — Thu, 31 Dec 2020 15:02:49 +0000

Thanks Tim. My findings are taking me to these same results.

RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Tim Rodman — Thu, 31 Dec 2020 04:32:59 +0000

I think there are two hurdles to this:

1. Getting a Multi Select Combo attribute parameter to filter things correctly.

2. Having multiple parameters that behave like a product configurator selector.

I'm not sure how to get past hurdle #1.

If I have the following Multi Select Combo attribute:

2044

And an Item that is assigned to one of the options:

2045

And a Generic Inquiry where the Multi Select Combo attribute is a Parameter. Everything works fine if I only select one option:

2046

When I select multiple options, my brain thinks that I'm selecting one or the other, but I'm really selecting both so the Item doesn't appear because it's only assigned to one option, not both:

2047

The SQL that gets generated shows that it's not an either or, it's both:

2048

If I assign the Item to both options:

2049

Then the Item will appear when I select both options in the parameter:

2050

But that's probably not the behavior that you want.

For hurdle #2, the problem is that parameters are independent of each other. When I get to parameter #2, it doesn't know what I selected in parameter #1.

RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Dan Wilkins — Thu, 15 Oct 2020 13:55:41 +0000

OK, Thanks Daru. Any input is appreciated.

RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Daru — Thu, 15 Oct 2020 01:51:23 +0000

Ok,

So you have attributes with selector combo and want to use that as a filtering parameter in your GI?

The problem with attributes is they have their own table field that the ID isn't so clear.

Usually, for this case, my team and I did a custom field (add new field) with a new table and used it to filter the GI.

But, let me check with another option. \

Regards,

Daru

RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Dan Wilkins — Wed, 14 Oct 2020 13:55:59 +0000

Yes, but the attributes are not text but multi select combo boxes. I don't want these in the columns of the GI, just as parameters at the top of the GI for the user to select.

RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Daru — Wed, 14 Oct 2020 03:46:51 +0000

Hi Dan,

So you want to pull out information from the Attribute field? Is this your goal?

Thanks

Daru

Product Configurator - GI Inventory Item List with Attributes as parameters

Dan Wilkins — Fri, 09 Oct 2020 19:37:05 +0000

I want to make a GI that lists inventory items and use the attributes of the items for the parameters at the top where the user could select each attribute they want to narrow down the list of items. Similar to a product configurator or a filter list you would see on a website store of items. Does anyone have a working GI like this? IF so anything you recommend or and advice on getting started to achieve this?

An example of what I am trying to achieve here would be the following:

Attribute - Product Type: (Multi-Select Combo) CSAnswer: GAUGE

Attribute - Dial Size: (Multi-Select Combo) CSAnswer: 2.5"

Attribute - Connection Size: (Multi-Select Combo) CSAnswer: 1/4"NPT

So if a user wants to find available stock for the above, they would just select from the parameters of the GI to narrow down the inventory list.