| Build Number | Database | OS |
|---|
| v8.8 3128 | MSSQL | WIN |
Standard Grid for a sales quote. Using SUM in the column summary section. Linking to Inventory master table. Columns that are Inventory shortcuts will return an empty summary value.
Shortcut totals should be populated
There was a thread in the old forum (from 2020) named “Summary of Shortcut field in a Query”. It seemed possible there.
Maybe there was a bug in this build that was later fixed.
You can see the numbers don’t even come back from aware correctly. I always figured these were calculated by Kendo in the browser, but Aware is doing the «SUM» math on the server.
NOTE: This is taken from the XML response - you can see this in the Network tab using the developer inspector.
<attr_summary attr_name "sc_PurchPrice" >0.0</attr_summary>
<attr_summary attr_name "sc_TotalLabor" >0.0</attr_summary>
<attr_summary attr_name "sc_TotalParts" >0.0</attr_summary>
<attr_summary attr_name "sc_TotalCost" >0</attr_summary>
<attr_summary attr_name "ItemTotalCost" >128</attr_summary>
<attr_summary attr_name "ItemSalePrice" >1,125.00</attr_summary>
<attr_summary attr_name "ItemProfit" >996.50</attr_summary>
<attr_summary attr_name "ItemOverhead" >150.00</attr_summary>
<attr_summary attr_name "ItemNetProfit" >846.50</attr_summary>
<junk ="ignore this line" ></junk>
