Hello,
Things I'm trying to achieve:
I'm trying to somehow display the list of Products inside the Quote entity.
1. I want to create some kind of a 'Product Catalog' which will have it's columns.
2. I want to be able to filter this list of Products. (I imagine there will be columns and I will have individual filtering for each one, I need this because there are a lot of products and I need to really narrow down the options)
3. I will choose specific products from the filtered list mentioned in the 2nd step.
4. Ability to modify some columns of the selected product(s) is desirable. Ability to see some kind of calculations based on chosen products is also desirable.
5. Finally I want to add this product to quote, meaning I want to add it to the 'Product Catalog' mentioned in the first step.
What I have tried:
I added two sub grids to the Quote main form, the first one would list all the products and give me the possibility to filter it and add it to the second subgrid with the ribbon button click. But I failed on this step because button wasn't showing up and also there was a problem with adding filters to the first subgrid. Also as I found later I couldn't use the editable subgrid in on prem v9.
Thing I could try:
I could make a web resource which would be a table listing all the products with paging and filtering, but I don't like this solution because of the vast number of products and I don't feel that filtering with js would be a good idea.
What I want to hear:
Have you dealt with such scenario ? What advice could you give me ?