Finance | Project Operations, Human Resources, ...

Account balance is $0.00 in Checkbook Balance Inquiry screen.

(0) Share

Report

Posted on by Cheryl Yancey

I recently performed yearend closing for 2019 and since then, my Current Cash Account Balance is $0.00 in my Checkbook Balance Inquiry Screen. I have run Check Links and no errors were found for the bank.

My GL account balance is correct and it does reconcile with my checkbook balance. Does anyone have any idea on how to get the correct cash account balance to display correctly? I have 4 active bank accounts and they all display $0.00 for the Current Cash Account Balance.

I have checked the GL10110 file and it has the correct balances for each period in the current year.

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (0)

Lucas Boewood on at

Like (0)

Report

RE: Account balance is $0.00 in Checkbook Balance Inquiry screen.

Hi Cheryl,

You could certainly test deletion of the GL10110 table as it is summary data that reconcile either updates or recreates based on the detailed transaction data. I'd recommend backing up your LIVE company into a TEST company though, just in case. But I had no issues with that process during my testing, and I did it multiple times. I'm not sure it would make a difference though as you already ran the reconcile (which should sync the summary data up to the detailed data) and that did not resolve the issue.

Please keep us posted.
Cheryl Yancey 5 on at

Like (0)

Report

RE: Account balance is $0.00 in Checkbook Balance Inquiry screen.

Hi Lucas,

What if I did another backup and then deleted the records in the GL10110 table for just one of the cash accounts and then run the reconcile program? That's the only thing I didn't do based on your comments above and that might resolve the problem. At the very least, I could remove the records and then add them back if it didn't work.

I didn't know that the reconcile program would add back records.
Suggested answer

Lucas Boewood on at

Like (0)

Report

RE: Account balance is $0.00 in Checkbook Balance Inquiry screen.

Hi Cheryl,

Thank you for the update. I removed the checkbook screenshot since there was bank account information present.

The only other thing I can think of would be to check if the windows are modified in any way, or if there is a customization in the environment that could be changing how the code runs. If that isn't it, we'd really have to take a look at the underlying data across all the tables to verify everything.

Without actually digging in and reviewing the data, we might not be able to determine the cause here. I'd recommend submitting a support ticket if there are no modifications/customizations coming into play. We'd be happy to get connected and take a look with you!
Cheryl Yancey 5 on at

Like (0)

Report

RE: Account balance is $0.00 in Checkbook Balance Inquiry screen.

I checked in Checkbook Maintenance and the account

The cash account is set up correctly. I also checked the GL10110 file and the period records are in the file.

dbo_GL10110

ACTINDX YEAR1 PERIODID Ledger_ID PERDBLNC

5251 2020 0 1 8481477.4625

5251 2020 1 1 -3321551.9725

5251 2020 2 1 3720488.91327

5251 2020 3 1 2990723.52403

I also ran the reconcile routine and nothing changed.

Any other ideas that I can try?

Thank you for your input.
Lucas Boewood on at

Like (0)

Report
RE: Account balance is $0.00 in Checkbook Balance Inquiry screen.

Hi Cheryl!

There are a couple of potential causes for this issue.

No valid Cash Account selected on the Checkbook Maintenance window.

Data missing or inaccurate in the GL10110 table.

First, here is my Checkbook Balance Inquiry showing the same issue.

Here is a description of the field for reference.

In this example, there is an issue with the previous cash account that this checkbook was using, and we can see that when looking at the Checkbook Maintenance window.

Once I select a proper cash account, the balance is calculated as expected.

And it shows properly in each window.

This value is confirmed by querying the SQL data for the cash account selected.

select sum (PERDBLNC) from GL10110 where actindx in (select actindx from GL00105 where ACTNUMST = 'xxx-xxxx-xx')

--Be sure to modify the script above to enter your GL cash account for the 'xxx-xxxx-xx' placeholder

I tested deleting the entire GL10110 table, which set the cash account balance to zero:

Then ran reconcile on all years. This successfully recreated the summary data in the GL10110 table, and the appropriate value was again calculated in each GP window.

I’d recommend the following (backup your databases and perform this in a Test company first to verify the results).

Review that a valid Cash Account is assigned to the checkbooks in question in the Checkbook Maintenance window.

Use the SQL query to confirm the cash account calculation by summing the GL10110 data for that account.

If detailed GL transactions exists for that cash account, but the sum of the GL10110 data is zero, use the Reconcile Financial Information utility to reconcile all years (start with the oldest Historical year and continue up to the most recent Open year).

Verify everything looks correct.

My assumption is that your GL10110 (Account Current Summary Master) data is simply out of sync with the detailed transaction data. I hope this helps to resolve everything! Please let me know if there are any questions here.