Questions Daily Bank Balance Dashboard

Hi Fozzie,

Note: If you did want a trailing balance, a Pivot Table would probably be better suited for the task.

Since you only want today's balance, I think a Dashboard KPI would do the trick. Here are some examples of Dashboard KPIs:

A Dashboard KPI is fed by a Generic Inquiry. So you first have to create the Generic Inquiry, then you can make the Dashboard KPI based on that Generic Inquiry.

If you really need to get today's cash balance, without regard for future transactions, then you will need to make a Generic Inquiry based on the GLTran or CATran Data Access Classes (DACs). The problem with doing this is that there can be a lot of data in those DACs so it might make your Dashboard KPI run really slow.

You could try grouping in the Generic Inquiry, but I'm not sure how efficient it would be. It all depends on the SQL code that gets generated. If that's also too slow, then you might as well just create a SQL View that does all of the work and just returns the one value that you want. Then attach the SQL View to a Data Access Class (using Doug Johnson's instructions), drop it into a Generic Inquiry, then drop it onto a Dashboard KPI.

If you don't mind including future transactions in the Balance, then you could base it on the GLHistory Data Access Class. That is much more summarized than GLTran or CATran so it should run faster. But it only has one record for each Month. That's why it might have some future transactions that were dated later in the month, after today's date.

Hopefully that's enough information to point you in the right direction.

Hey Foz, did you ever put a Widget up for bank balance?  Do you reconcile your bank account in Acumatica?

Hi @russell-williams,
Sorry for the confusion here. The posts by muppets are actually posts by me. Click here for more on that.

And @kurtbauer,
Thanks for sharing your inquiry!