E10 Public Cloud Outage / Data Loss

[Mark_Wonsil]

@TommyD

I have noticed that some of our BAQ’s don’t work. These were ported over from E9 to our E10 cloud, and use the E9 Summary feature. I believe all of the data is still there, though. I’m going to open up a ticket about the BAQ issues.

No ticket required. Summary functions are done differently in E10.

Perform a calculation on BAQ Summary Fields

I think you might be able to do this with a window function query. You can see an example with the system BAQ named: zGSTR1-B2B_InvcDtl_IN . If you change the ICE.QueryHdr.CGCode to an empty string you can load the BAQ in the designer and see how Epicor created it. What you want is to sum it over the group something like: SELECT CustNum, OrderNum, PartNum, SUM(UnitPrice*OrderQty) OVER(PARTITION BY PartNum) AS SubTotal FROM ERP.OrderDtl; There is a ton of information on window functions here:…

(I got to use the same answer for two posts in a rowcount()=1)