https://frontaccounting.com/fawiki/inde … nkAccounts

At the moment (FA v2.3), the GL Account should not have any transactions for it to be used as a Bank Account. Once assigned to a Bank account (or a Credit Card Account), the GL Account cannot be deleted within FrontAccounting.

read like this:

At the moment (FA v2.3) the following conditions are true:
1. you cannot create a bank account using a Bank Account GL Code where the GL account has existing transactions.  You must begin with an empty GL account
2. When editing an existing Bank Account, it is possible to change the Bank Account GL Code to use a GL account that does have existing transactions, but Reports=>Bank Statements will not include any of those pre-existing transactions.
3. Once created, a bank account cannot be deleted.

https://frontaccounting.com/fawiki/inde … nkAccounts

I had already created the GL acct (1061) and made journal entries for my 2nd bank account before I found I could make it as a bank account.  When I tried to add it, I could not.  but there was an existing bank account called petty cash (gl acct 1065).  I edited that bank account to use gl acct 1061 instead, but when I ran a bank statement report, it gave me nothing.  Today, I can get a report, but it seems to only report on journal entries I have made since yesterday, so it isn't a complete report of activity in gl acct 1061.  Given that the program let me do this I would (and did) think something was broken had I not been looking for some problem

Based on apmuthu's response, I created another gl acct 1062, and I was able to make a bank account tied to this gl acct.  I have made no transactions on this gl acct, but today I cannot delete it, I get this error:

Cannot delete this bank account because transactions have been created using this account.

But there really are no transactions in it.  if I run a bank statement report, it is empty, and there are no journal transactions on gl acct 1062.  So not sure if that is by design, seems like I should be able to delete it.

Though I cannot delete the account, I can modify it to have a different GL account.  This differs from the original petty cash bank account for gl acct 1065 that I modified to gl acct 1061.  I can no longer change the gl acct for that account, which given that the  bank account actually does show transactions now, it makes sense.

While I cannot delete the bank account for glacct 1062, I can successfully inactivate it.

So I guess the way forward is to not delete the bank account for gl acct 1062, use journal entries to move everything from gl acct 1061 to 1062, and deactivate the bank account for gl acct 1061 so it is not listed.  Rinse and repeat for the Visa...

so; summary of suggestions:
-The error message should read as Joe suggests; I would have understood that.
-A user should not be able to modify an existing bank account to use a gl acct that has transactions in it for the same reason he cannot create it.  Same error should be displayed
-If there is a legitimate reason that a bank account cannot be deleted after it is created even when empty, a note should be made on the wiki page warning that it is a non-reversible action, and perhaps a popup warning in the program as well.
-if there are conditions where a bank account can be deleted, it would be useful to have them mentioned in the error message, or have the error message contain a link to a wiki page with explanation.
-On the wiki's getting started page, it mentions setting up bank accounts as part of the POS system, it might be a good idea to have mention that one should also set up bank accounts for each real bank account and visa account.

I want to express gratitude; I am finding this program to be pretty awesome.  Thanks for writing it, and thanks for taking the time to engage me in discussion on these boards...

The key_in_foreign_table checks that there are no transactions on the GL account.

Just to ensure that the transactions on he bank account are mirrored on the GL account without having other transactions.

Joe.

    if ($Mode=='ADD_ITEM' && (gl_account_in_bank_accounts(get_post('account_code')) 
            || key_in_foreign_table(get_post('account_code'), 'gl_trans', 'account'))) {
        $input_error = 1;
        display_error(_("The GL account selected is already in use. Select another GL account."));
        set_focus('account_code');
    }

Line 39 above can have the error message modified as @joe stated or the if statement modified to be more tolerant like:

    if ($Mode=='ADD_ITEM' && (gl_account_in_bank_accounts(get_post('account_code')) )) {
        $input_error = 1;
        display_error(_("The GL account selected is already in use. Select another GL account."));
        set_focus('account_code');
    }

Joe

Joe

@joe: Any logic in this condition needs to be wikied so that when we re-visit it in FA 2.4 we can make better workflows.

Thanks once again for your assistance.  Soon I will owe you a lot of beers...

I did solve it.  The trick is you can't create a bank account unless the GL account is empty when you start.  Since I was trying to turn existing GL accounts that already had transactions in them into bank accounts, it failed.

Sorry for the noise...

Although Credit Card Account used to make payments to suppliers is actually a liability account, it may need to be treated as a checking account (Asset) in FA to be usable.

I still cannot add another bank account, if I try it tells me the GL account is already in use even though no other bank account is using the GL account number I am trying to link.

Changing the existing bank account to a different GL account produces an empty report when you try to get a bank statement.