Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
Oops, I was wrong, it seems that it's not fixed...
I think I understand what the following query does:
SELECT account.*, gl_account.account_name
FROM 0_bank_accounts account, 0_chart_master gl_account
WHERE account.account_code = gl_account.account_code AND !account.inactive ORDER BY account_code, bank_curr_code
But it returns empty set, when I try it on db myself.[/strike]
Update:
OK, the 0_chart_master table is empty. This is the problem... Hm...
When I add new bank account, it says "New bank account has been added", but there is nothing in 0_chart_master table
How to fix this?
current_user.inc states:
if (!defined('TB_PREF')) {
define('TB_PREF', '&TB_PREF&');
}
Hello there again!
I checked the sql query which is generated by get_bank_accounts function.
SELECT account.*, gl_account.account_name
FROM &TB_PREF&bank_accounts account, &TB_PREF&chart_master gl_account
WHERE account.account_code = gl_account.account_code AND !account.inactive ORDER BY account_code, bank_curr_code
As you can see, &TB_PREF& is wrong here. So how to fix it?
I have fixed it temporarily but putting 0_ as prefix, but that's wrong way to do. Please help me.
Hi!
Well, there is no any other company... Only one.
By the way when I check "Bank Account Inquiry", there are all the bank accounts in the dropdown list...
So, "GL->Bank Accounts" - empty, "GL->Bank Account Inquiry" - accounts are present in dropdown list.
Is it a bug or there is some configuration involved?
P.S. Again only half of the message appeared after I posted it... Again it cuts after double quote "
I hope admins will fix this soon. I have to edit my message again.
Hello!
When I go to "Bank accounts", the table with the headlines
Account Name Type Currency GL Account Bank Number Bank Address Dflt" is empty.
However, when I check the database for the 0_bank_accounts table, they are there.
In the code (bank_accounts.php, line 97)
$result = get_bank_accounts(check_value('show_inactive'));
returns empty set.
I checked that function, the sql query looks ok.
I'm using FrontAccounting 2.3.2.
Please help me to resolve this issue.
Thank you!
P.S. Hey, check using double quotes in the posting message in this forum...
It is just removed the whole part of my message when I posted it
I've opened Setup -> Access Setup, but when I open the role of Super Administrator, there is no checkbox with the Import Items text.
And the link is disabled.
FrontAccounting 2.2.11.
Please help.
Thank you very much.
Posts found: 6
