When building customizations in Acumatica, it’s common to need a summary value—like the total invoiced goods for a customer during the current year. While it may sound straightforward, using Business Query Language (BQL) to retrieve and aggregate data requires careful handling. One common pitfall...