In "on-hand list" form under inventory management, tried to add a new field "Buyer group" in the grid through personalize this form. column is added but the values in that column are blank.
Tried to add same field in EcoResProductDetailsExtended form and its populating the values for that column.
Please suggest why its not populating.
Look at the query used by the form. It doesn't simply show table fields; it aggregates the. This is the default query:
SELECT FIRSTFAST FORUPDATE
JOIN FORUPDATE FROM InventDim(InventDim)
ON InventSum.InventDimId = InventDim.inventDimId
JOIN FORUPDATE FROM InventTable(InventTable_DS)
ON InventSum.ItemId = InventTable.ItemId
But you can also enable additional dimensions and get sums per warehouse, for example.
If you simply add a field but you neither aggregate it not group by it, it won't ever have any value.
Thanks, but it looks like they used display method for all these calculated columns, so what can i do to see these values for added column?
Should you add a column to InventSum in the first place? I doubt it... Can you please explain the business requirement you're trying to address?
User need to sort grid based on buyer group, functional people suggested to add them through personalize form so they are able to sort on buyer group after adding the field with filters field added on left of the form but user still want to see the values in the column to make sure that item is of that particular buyer group.
Aha, so that's something on item or product, right? In that case, you should group the result by the appropriate field.
Unfortunately this can't be done by personalization; it'll require a customization.
what does group on appropriate field means? please explain.
We are planning on doing this in Physical on hand inventory form.
For this i need to extend the form add Invent table datasource to the form and drag drop buyer group on to the form.
Then do i need to write code on queryexecuting() event to add values to the buyer group records?
if so, Can you also please tell me how do i code to add values aggregating the fields?
Aggregating? How do you want to aggregate buyer groups? I thought you would add it to GROUP BY clause of the select statement, by using addGroupByField() on the query datasource.
sorry, i am not getting you.
Standard code is onexecutequerey() of InventSum table to populate the grid, now i am adding buyer group from invent table in the same grid where and what code can i write to add values in that grid?