Hi Acumatica community!
I have a column chart in a dashboard that shows sales by month for individual customers. The column chart only displays months with sales data, which is a problem as many of our customers order every second month or quarterly. See example below.
If there are no sales in a given month, I’d prefer that the chart showed zero (a blank space) for that month. This would make it much easier to see the relationship between sales and time.
Is that possible in Acumatica?
Best answer by BenjaminCrisman
Hi
“If some financial period does not have any transactions, the historical record will not be created for that period. In order to get the historical balance for such period you need to join the last historical record to the desired period. In reports, it is done with BaseARHistoryByPeriod, which is a business query language (BQL) projection.”
There is an example of joining to HistoryByPeriod table in the GL DAC overview:
+4Hi
“If some financial period does not have any transactions, the historical record will not be created for that period. In order to get the historical balance for such period you need to join the last historical record to the desired period. In reports, it is done with BaseARHistoryByPeriod, which is a business query language (BQL) projection.”
There is an example of joining to HistoryByPeriod table in the GL DAC overview:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
