Added a field to grid in UI but values not populating

Hi,

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.

Thanks

priya

Parents
  • 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
    SUM(PostedQty),
    SUM(PostedValue),
    SUM(PhysicalValue),
    SUM(Deducted),
    SUM(Registered),
    SUM(Received),
    SUM(Picked),
    SUM(ReservPhysical),
    SUM(ReservOrdered),
    SUM(OnOrder),
    SUM(Ordered),
    SUM(Arrived),
    SUM(QuotationReceipt),
    SUM(QuotationIssue),
    SUM(PhysicalInvent),
    SUM(AvailPhysical),
    SUM(AvailOrdered)
    FROM InventSum(InventSum)
    
    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.

Reply Children
Related
Recommended