Opening Balance Setup

(0) Share

Report

Posted on by Krazzy4

1,710

Hello!! I am trying to create opening balance for a bank account and I was suggested to use bank account reconciliations for the option. I am having some issues as follows while posting the bank account reconciliation option:

And when I select the applied amount it shows nothing for bank account ledger entries though I have posted earlier:

What I want is to make effect for the opening balance while posting journal regarding the specific bank accounts. Any suggestion would be appreciated.

*This post is locked for comments

All responses (15)

Answers (9)

Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Opening Balance Setup

Perhaps, it's not the place where you hit the error. You go ahead by keying F5, when it throws the error (as mentioned above), you may check the code (which is the actual statement causing the error).
Krazzy4 1,710 on at

Like (0)

Report

RE: Opening Balance Setup

After debugging I got a number of alerts for posting journal specially invoice regarding opening balance. Here are some of them and could someone make me understand in brief what is actually happening if possible??

1st:

After debugging:
Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Opening Balance Setup

You may turn off the Code Coverage. Instead goto Tools -> Debugger - Active (ensure it has a check mark and Break Point on Triggers unchecked and try to post, you will be automatically directed to the error. From there you can identify the logic for the error.
Krazzy4 1,710 on at

Like (0)

Report

RE: Opening Balance Setup

OK. I am not sure I am doing it right. After debugging I get this:
Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Opening Balance Setup

It seems to be a customization. Could you debug?
Krazzy4 1,710 on at

Like (0)

Report

RE: Opening Balance Setup

If the (-) sign is put in amount field it adds the amount in opening balance like 1,20,000 after reconciliation (Opening Balance - 1,00,000 and Invoice - 20,000 but it should be vice-versa) as follows:

And as you said for putting (-) sign in amount field it alerts like this now:
Verified answer

mmv 11,465 on at

Like (1)

Report

RE: Opening Balance Setup

When you enter the value in Credit Amount or Debit Amount, it must be without any sign. Only in Amount column you can enter the sign.
Krazzy4 1,710 on at

Like (0)

Report

RE: Opening Balance Setup

MMV It worked. Thanks a lot. Your and others post are helping me a out in this case. Now the funny thing is I got another issue as follows:

It is asking for negative value. I think the amount should be positive as it is an invoice and when I reconcile it effects the opening balance as follows: Opening Balance is 1,00,000.
Verified answer

mmv 11,465 on at

Like (1)

Report

RE: Opening Balance Setup

As you have set a value to "Bal. Gen. Bus. Posting Group", you need to enter the "Bal. Gen. Posting Type" as well. Once it's entered, it will allow you to post.

1. But why do you need the "Bal. Gen. Bus. Posting Group" and "Bal. Gen. Prod. Posting Group" ?

2. If your above entry is the Opening Balance, your there must be a G/L Account, which is the Opening Balance control account and the other must a bank account. Please check whether you Journal entry contains these two.
Krazzy4 1,710 on at

Like (0)

Report

RE: Opening Balance Setup

Thanks MMV again. Seems like I am having more issues while setting up so. I did not face any problem earlier while posting journal for opening balance. Now what happened just like to show you the images as follows: