If you have the luxury to reinstall xampp then be it. Because this way you are reinstalling a fresh copy of your environment...including Apache, Mysql and Php. You will also need to reinstall fa code and restore the db backup. I would say this is a very good learning exercise. If you do not have the time and luxury then restoring the db first is a good idea.
We are here if you need help.
Good luck.
176 09/24/2021 03:50:30 pm
Re: Problem logging in (11 replies, posted in Installation)
177 09/24/2021 03:31:48 am
Re: qty_done is not updated correctly when partial invoice is voided (7 replies, posted in Report Bugs here)
Yes I can reproduce the above easily. FA2.4.10
I will post it in mantis.
178 09/23/2021 07:12:32 am
Re: Problem logging in (11 replies, posted in Installation)
The problem clearly indicates a db problem,,its either not found or is corrupt. Are you sure your db name is frontacc?
The dbuser, dbpassword are mysql parameters to access the db, they are different from userid and password in front accounting which is normal in your case...as your fa id is jeff with a password. Do you have other companies in config_db?
If you are confident you can restore the db using phpmyadmin from a previous backup and try again. All data after the backup will be lost though..
179 09/22/2021 06:03:45 pm
Re: Problem logging in (11 replies, posted in Installation)
Anything in /tmp/errors.log?
180 09/20/2021 05:10:16 pm
Re: Withdraw the cash directly from the company for personal use (10 replies, posted in Banking and General Ledger)
Of course the best thing is to talk an Accountant that knows your Chart of Accounts. He/She can advise you best.
Having said that the first thing to find out is in which account the owner contributed his money in your company's COA. Then with Bank Payment you can Credit the Bank (1061 for example) and Debit the Contributing account i.e Common Shares (3350) or alternatively create a new account with the name of the owner i,e John Common Shares (3351) and Debit that account.
181 09/02/2021 08:01:31 am
Re: Invoice Editable (23 replies, posted in FA Modifications)
It should work. I have it working on 2.4.10 latest without any problem. It s installed as any other extension. One thing thing you will notice is that it does not show as an extension because it replaces the some core Sales programs. So to see if it is installed and after giving the right permissions just go into Customer Transaction --> Sales Invoices and choose one and try to edit it.
182 08/31/2021 04:40:00 am
Re: Edit invoice (2 replies, posted in Accounts Receivable)
https://frontaccounting.com/punbb/viewtopic.php?id=7029
It works for Direct Invoices only...and no purchase invoice edit ..
183 08/30/2021 07:17:50 am
Re: Logo on invoices in RTL (2 replies, posted in FA Modifications)
Try in header2.inc
// Company Logo
$this->NewLine(2);
It will give you an extra line. More than this then it will overlap with Customer Box.
OR at the beginning of header2.inc insert
***/
$this->row = $this->pageHeight - $this->topMargin;
$this->NewLine(x);
where (x) is the number of lines you want to skip. But this will also reduce the number of lines to be printed on the report.
184 08/29/2021 02:39:15 am
Re: Recurring invoices result in no dimensions on gl_trans (11 replies, posted in Accounts Receivable)
Hi,
Been testing this and I agree with @advocaat.pollet. I dont see the dimension in the Balance Drill Down for recurrent invoices.
@kvvaradah..can you please guide us on how to test this ..maybe we are doing something wrong.
185 08/17/2021 01:35:57 pm
Re: Accounting for nonprofit (5 replies, posted in Banking and General Ledger)
This is discussed before.
https://frontaccounting.com/punbb/viewtopic.php?id=338
186 08/17/2021 01:13:57 pm
Re: Accounting for nonprofit (5 replies, posted in Banking and General Ledger)
Basically members subscriptions is a revenue.. So when you enlist a donation and the member pays, you debit your bank account and credit your revenue account. This revenue account is dependent on your COA. In FA 5 Digit American COA its the 4xxx accounts..so you can choose any of them ..or you can add another i.e 4511 and Call it Membership Dues for example, and you credit this account.
Tell us what you did.
Good Luck
/Rafat
187 08/17/2021 10:23:00 am
Re: Accounting for nonprofit (5 replies, posted in Banking and General Ledger)
Please elaborate of what is an annual subscription of a new member entails.
Take a look at this. I find it helpful.
https://altruic.com/blog/a-sample-chart-of-accounts-for-nonprofit-organizations
188 08/03/2021 02:59:27 am
Re: REP709.php TAX REPORT BUG (21 replies, posted in Reporting)
Exactly... I don't know why not. I am under the impression that this functionality will be included in FA 2.5.
189 07/26/2021 09:34:21 am
Re: Restore backup of multiple companies and upgrading (6 replies, posted in Installation)
@thorbjornw
Yes it can be done. But I would not recommend it. If you are worried about the backup size then its not because of the first company. When you do backups within FA its by company data and not the entire db. Backups within FA are named after company prefix within the DB. i.e 0_ is for the first installed company that cannot be deleted, and 1_ for the second company ...etc..
In post #2 above @poncho1234 has hinted on how you can do that. I will elaborate further.
I assume your existing installation has two companies. the old company with prefix 0_ and the new company with prefix 1_ you can find out the used prefixes when you login to the old company and go setup->Create/Update Companies Table Pref.
Now:
1. Log in to the new company Setup-> Backup and Restore.
2. Create Backup
3.Choose the Backup and Download it.
4. With a text Editor open the file just downloaded. (must have _1_ char in it if the company prefix is 1_)
5.Find and replace `1_ with `0_ in all occurrences. (Replace All)
6. Save file
7. Install another instance of FA
8. On new instance go Setup->Backup and Restore->Choose file saved in step 6 and then Upload file ->Restore Backup.
Now you will have one company with all the second company data with prefix 0_
Good luck.
190 07/26/2021 03:39:45 am
Re: New company login password incorrect (13 replies, posted in Setup)
@joe
After looking at this I found out that at line 1712
INSERT INTO `0_security_roles` VALUES
is empty..
I just copied the 10 lines from the en_US-demo.sql into en_US-demo2.sql and now all OK.
INSERT INTO `0_security_roles` VALUES
('1', 'Inquiries', 'Inquiries', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;773;774;2822;3073;3075;3076;3077;3329;3330;3331;3332;3333;3334;3335;5377;5633;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8450;8451;10497;10753;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15622;15623;15624;15625;15626;15873;15882;16129;16130;16131;16132;775', '0'),
('2', 'System Administrator', 'System Administrator', '256;512;768;2816;3072;3328;5376;5632;5888;7936;8192;8448;9472;9728;10496;10752;11008;13056;13312;15616;15872;16128', '257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;526;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5641;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;9217;9218;9220;9473;9474;9475;9476;9729;10497;10753;10754;10755;10756;10757;11009;11010;11011;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15628;15625;15626;15627;15873;15874;15875;15876;15877;15878;15879;15880;15883;15881;15882;16129;16130;16131;16132;775', '0'),
('3', 'Salesman', 'Salesman', '768;3072;5632;8192;15872', '773;774;3073;3075;3081;5633;8194;15873;775', '0'),
('4', 'Stock Manager', 'Stock Manager', '768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15872;16128', '2818;2822;3073;3076;3077;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5889;5890;5891;8193;8194;8450;8451;10753;11009;11010;11012;13313;13315;15882;16129;16130;16131;16132;775', '0'),
('5', 'Production Manager', 'Production Manager', '512;768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5640;5640;5889;5890;5891;8193;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132;775', '0'),
('6', 'Purchase Officer', 'Purchase Officer', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;2818;2819;2820;2821;2822;2823;3073;3074;3076;3077;3078;3079;3080;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5377;5633;5635;5640;5640;5889;5890;5891;8193;8194;8196;8197;8449;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15876;15877;15880;15882;16129;16130;16131;16132;775', '0'),
('7', 'AR Officer', 'AR Officer', '512;768;2816;3072;3328;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '521;523;524;771;773;774;2818;2819;2820;2821;2822;2823;3073;3073;3074;3075;3076;3077;3078;3079;3080;3081;3081;3329;3330;3330;3330;3331;3331;3332;3333;3334;3335;5633;5633;5634;5637;5638;5639;5640;5640;5889;5890;5891;8193;8194;8194;8196;8197;8450;8451;10753;10755;11009;11010;11012;13313;13315;15617;15619;15620;15621;15624;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132;775', '0'),
('8', 'AP Officer', 'AP Officer', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;769;770;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5635;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15876;15877;15880;15882;16129;16130;16131;16132;775', '0'),
('9', 'Accountant', 'New Accountant', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13313;13315;15617;15618;15619;15620;15621;15624;15873;15876;15877;15878;15880;15882;16129;16130;16131;16132;775', '0'),
('10', 'Sub Admin', 'Sub Admin', '512;768;2816;3072;3328;5376;5632;5888;8192;8448;10752;11008;13312;15616;15872;16128', '257;258;259;260;521;523;524;771;772;773;774;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5637;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8196;8197;8449;8450;8451;10497;10753;10755;11009;11010;11012;13057;13313;13315;15617;15619;15620;15621;15624;15873;15874;15876;15877;15878;15879;15880;15882;16129;16130;16131;16132;775', '0');
191 07/25/2021 05:52:47 pm
Re: New company login password incorrect (13 replies, posted in Setup)
Guys,
I tested the COA ("5 digit American coa with educational data") that was used by @timada and he's absolutely correct. I attach the script as downloaded from the published setup->Install/Activate Chart of Accounts.
@joe for your attention.. Must be very trivial to you..I have no clue why.
\rafat
192 07/24/2021 10:00:39 am
Re: New company login password incorrect (13 replies, posted in Setup)
It might be a very simple but cunning error...like keyboard language vs db charset. .. What Database Collation you are using? Are you only using English or other languages as well? Any languages on the keyboard other than English?
My humble thoughts.
\rafat
193 07/21/2021 03:50:11 pm
Re: Username login security? (12 replies, posted in Setup)
@joe
I like the Fort Knox analogy... 
I still agree that we need a stronger userid. Most of the sites I visit now have userid rules (not passwords only). This admin is very trivial... of course users need to change it anyway..
195 07/14/2021 12:52:12 pm
Re: How to void a sales invoice from the previous closed fiscal year. (7 replies, posted in Accounts Receivable)
@said.omn
It should work.. What exactly did not work for you? How did you go about it? What is your current fiscal year and in which fiscal year is the invoice? State OS and FA Versions..
\rafat
196 07/06/2021 01:41:47 pm
Re: How to void a sales invoice from the previous closed fiscal year. (7 replies, posted in Accounts Receivable)
@said.omn
Its possible but I don't know what other repercussions this will have. So please use at your own discretion. Maybe other well versed Accountants can advise otherwise. But its very simple:
Setup->Fiscal Years
Edit Pencil
Is Closed NO
Then you can void the invoice and you need to close the year with Is Closed Yes.
Years are closed and opened in chronological order. One cant jump a year to close the other.
/rafat
197 07/01/2021 04:31:20 pm
Re: Existing past fiscal year date in new company setup (4 replies, posted in Setup)
I do have a feeling that the naming convention of the Scripts is somehow not direct.. and sometimes it is misleading. So maybe something like:
Demo Company with American COA ---- For company with demo data.
New Company with American COA ---- For company with no data.
Might be a better way of naming them.. I don't know..I could be mistaken..
Now of course the Database scripts depend on the COA that one chooses to have for the company (once the COA is installed).. But the only COA that have demo data is the Standard American COA (4 digits).
198 07/01/2021 04:20:15 am
Re: Existing past fiscal year date in new company setup (4 replies, posted in Setup)
Most probably is when you created your new company you have chosen a Database Script of "Standard American COA (4 digit) with demo data". This script contains the demo customers you mentioned above. If you do not need the demo data then you should choose Database Script of "Standard new company American COA (4 digit)".. this script contains no demo data at all...empty.
Now the tricky part.. do you need your new company data that you entered with the demo customers? If so then I dont see a straight way to do that unless you are well versed with db tools and be able to remove the demo data by accessing the db directly..which is also dangerous..
If you dont need the company data then the best thing is is to delete the company and recreate it with the above Standared New Script.
Good luck..
199 06/29/2021 05:03:18 am
Re: The new Dashboard (26 replies, posted in FA Modifications)
Thanks @joe
I think we leave it as it is. As you said mixing languages in graphics is not that easy..different fonts, sizes and directions as well.
Meanwhile I will keep experimenting and if I found something useful I will come back to the forum.
/rafat
200 06/28/2021 03:13:28 pm
Re: The new Dashboard (26 replies, posted in FA Modifications)
@joe
Reports look good now.. Where are the fonts size in the graphics of the Top 10 Customers are defined?
Thanks