FA 2.3.24
MariaDB 10.1
Apache2 2.4.7 (Ubuntu)
Ubuntu 14.04 LTS Trusty

I installed FA by extracting to /var/www/html/fa and running the installation script, but skipped specifying the CoA as I wanted to install a customised Australian CoA. However, it looks as though an USA 0000 CoA was installed anyway.

Setup > Install/Activate Chart of Accounts opens a page entirely blank except for the heading Install/Activate Chart of Accounts, and the tabs Chart, Installed, Available, and Encoding. Did I do something wrong, or is this page to be included in the next release?

If I use the method of restoring from a CoA *.sql file in fa/sql/company*/backup/, how do I avoid overwriting options already specified for the company that has been set up? Can I delete all the table descriptions from the *.sql CoA file except for those with 'chart' in their names?

Regards,
Hedley

FrontAccounting fans:

If you, like me, are not a tech head used to working with client/server applications, this may be of interest to you.

Bitnami produces the XAMPP stack easy installer for Linux/Windows/MacOS, Apache, MySQL, PHP, and Perl. It also produces easy installers for Moodle, Drupal, Wordpress, etc. on top of XAMPP. To vote for FrontAccounting to be added to their XAMPP-driven installers, go to Vote for FrontAccounting.

Find out all about Bitnami at Bitnami Rocks!.  Then sign up for reminders to vote every month.  Can we get 60 votes to push a FrontAccounting server stack over the line?

Regards,
Hedley,
2014-11-01

FrontAccounting fans:

Bitnami produces the XAMPP stack easy installer for Linux/Windows/MacOS, Apache, MySQL, PHP, and Perl. It also produces easy installers for Moodle, Drupal, Wordpress, etc. on top of XAMPP. To vote for FrontAccounting to be added to their XAMPP-driven installers, go to Vote for FrontAccounting.

Find out all about Bitnami at Bitnami Rocks!.  Then sign up for reminders to vote every month.  Can we get 60 votes to push a FrontAccounting server stack over the line?

Regards,
Hedley,
2014-11-01

4

(11 replies, posted in Report Bugs here)

Broken company subdirectories system. You have to remove this company manually.

I stupidly deleted a company database from MySQL with phpAdmin. Not surprisingly, FA wouldn't delete the company. Then I deleted the .../company/1/ folder. Again, no go.

How do I now delete the company manually?

Blush. Apparently if you Force Exit from Windows 7, all the unsaved edits in your text editor are lost. Who'd a thought?

Hedley

@tm
I tried 'renumbering' 0_chart_types from 01 to 11 but that just produced a CoA report with all the classes at the top, no accounts, except for type expenses, and then only type 10 (refer to my post of Yesterday 06:17:39 pm above). Just reverted to no leading zeroes and will put up with ordering anomaly. Why wasn't a numerical type specified for the field, rather than alphanumeric?

@Joe and others:

I finally figured out the relationship of classes, groups, and accounts, and successfully copied en-AU-0000.sql to en-AU-0000-HHP.sql and made my changes to the classes ...

('1', 'Assets', '1', '0');
('2', 'Liabilities', '2', '0');
('3', 'Equity', '3', '0');
('4', 'Revenue', '4', '0');
('5', 'Expenses', '5', '0');

... and to the groups ...

('1', 'CURRENT ASSETS', '1', '', '0');
('2', 'CAPITAL ASSETS', '1', '', '0');
('3', 'CURRENT LIABILITIES', '2', '', '0');
('4', 'TERM LIABILITIES', '2', '', '0');
('5', 'EQUITY', '3', '', '0');
('6', 'SALES INCOME', '4', '', '0');
('7', 'OTHER INCOME', '4', '', '0');
('8', 'COST OF GOODS SOLD', '5', '', '0');
('9', 'PAYROLL EXPENSES', '5', '', '0');
('10', 'GENERAL & ADMINISTRATIVE EXPENSES', '5', '', '0');
('11', 'VEHICLE EXPENSES', '5', '', '0');

I also edited the 0_chart_master SQL lines to add, delete and modify the accounts I wanted.

Following your instructions, I put en-AU-0000-HHP.sql in the backup/ folder for my Sandpit company, and successfully restored it, overwriting the existing tables.

But, when I print out a CoA, some groups -- and their correct accounts -- are printed out of order:

1    Assets
        1    CURRENT ASSETS
        2    CAPITAL ASSETS // STOCK ON HAND group removed
2    Liabilities
        3    CURRENT LIABILITIES
        4    TERM LIABILITIES
3    Equity
        5    EQUITY
4    Revenue
        6    SALES INCOME
        7    OTHER INCOME
5    Expenses // This is where the fun starts
        10    GENERAL & ADMIN EXPENSES
        11    VEHICLE EXPENSES
        8    COST OF GOODS SOLD
        9    PAYROLL EXPENSES

No amount of staring at the SQL code in the .sql file has enable me to find why this is occurring. The account numbers increase through groups 8 to 11.

Any ideas why this behaviour is occuring? (I can send the file if you want.)

Regards,
Hedley

@p2409, @joe

During installation I selected this CoA as a basis for my company. The en_AU-0000.sql file written to the www/fa/sql folder by the installation script has this header:

# MySQL dump of database 'faupgrade' on host 'localhost'
# Backup Date and Time: 2010-08-06 13:56
# Built by FrontAccounting 2.3RC1
# http://frontaccounting.com
# Company: Company name
# User:

There is something strange about the CoA classes in Setup > Maintenance > GL Account Classes ...

Class ID    Class Name    Class Type       
1    Assets    Assets       
2    Liabilities    Liabilities
3    Income    Income       
4    Costs    Expense       
[  ] Show also Inactive

... in that the Equity (or Capital) class is missing.  Bookkeeping for Total Drongos tells me that the accounting equation is  Equity = Assets - Liability.

I created an Equity class with type Equity and got this:

Class ID    Class Name    Class Type       
1    Assets    Assets       
2    Liabilities    Liabilities       
5    Equity    Equity       
3    Income    Income       
4    Costs    Expense       
[ ] Show also Inactive

Now, printing out the CoA from Setup > Inquiries and Reports > General Ledger Reports > Chart of Accounts shows an existing Equity account as a Liability:

...
5 LONG TERM LIABILITIES
       2620 Bank Loans 2000
       2640 Hire Purchase 2000
       2650 Other Loans 2000

6 EQUITY // What the?
       3350 Issued & Paid up Capital 3300
       3360 Payments for G & S for own Use 3300
       3370 Opening Account Balance 3300
       3380 Credit Payments / Holding Account
       3390 Retained Profits 3300

5 Equity // The new Equity class I just added

3 Income

7 SALES REVENUE
4020 Sales / Manufactured Products 4000
...

Can someone more knowledgeable than me about accounting conventions advise whether 3350 to 3390 should be changed to be Equity type accounts?

Regards,
Hedley

9

(23 replies, posted in Misc. Charts of Accounts)

I downloaded en_AU-0000.sql and edited the definitions of the GST accounts and added a couple. I then checked for any cross-references in the rest of the file, and found only one, to 2290. When I tried to create a new company, I could not figure out to import this local CoA file. The only choice was to tick one of the Australian CoA options in the company details page.

How do I import a local SQL file?

Regards,
Hedley

10

(44 replies, posted in Announcements)

I installed the 2.3.19 dashboard plus exclusive-db theme into 2.4.x. Now the dashboard is incorrectly showing the version number as "2.3.19" in the top LH corner of the window. Can someone fix this so that the current version is displayed instead?

11

(11 replies, posted in Reporting)

Just noticed that another person has asked for a UK VAT Cash Reporting fix for the VAT 100 form. Australia allows monthly, quarterly, and annual reporting, and both accrual and cash reporting. Could all this be taken into account in a BAS module, please? @Joe, could you perhaps get the parties who are working on solutions to VAT and GST to collaborate? The two systems are so similar that it must be possible to produce a single solution, with only the reports having to be custom.

12

(11 replies, posted in Reporting)

I fiddled around with GnuCash for a couple of years but eventually found it too deficient (no inventory, no credit note, etc.) AND it somehow ate my database (I know, I know, I should have backed up). Looked at TurboCash (too buggy according to former Australian support consultant), SQL Ledger and LedgerSMB (too difficult technically to install and setup for this liddle black duck), and AdminSoft (probably okay but has a scary, amateurish GUI).

Finally, Nirvana! FrontAccounting is professional, has a great GUI, and is way overcapable for my tiny hobby retail and service business. Would really love the ability to select a zero percent GST category that appears on invoices, reports, etc., and from that a BAS report.

In GnuCash I had these Liability accounts:

  • GST Receipts (from sales)

  • GST Paid (from purchases)

  • GST Adjustments

  • GST Liability

GST Receipts was posted automatically from invoices, and GST Paid from bills received. GST Adjustments was a journal transaction. GST Liability was posted by clearing the first three, and then itself cleared when payment was made to the Australian Taxation Office.

In FrontAccounting I have to use some dummy accounts to allow 0% tax "rates" to be selected from GST Exempt, GST No Tax (not reported), and GST Input Taxed. The BAS form requires you to report both GST taxed and untaxed sales and purchases, so I hope someone can come up with a lovely one-click way of generating the required report. And not doubt that fundamental processing is similar for Australian, Canadian, and New Zealand GST sales tax; and UK and European VAT.

In Sandpit Co. I may even experiment with modifications of AlastairR's tweaks, but that won't cut it for purchases. So can some angel with skills and experience way beyond mine please, please, please develop a GST/BAS module!

Regards,
Hedley

P.S. Having worked at MYOB as in the final 6 years of my career as a technical writer of user documentation, I know enough of coding and bookkeeping in general to be a danger to humanity, but nought about SQL, MySQL, and PHP in particular.

13

(3 replies, posted in Installation)

You don't need a separate box. Just install it on localhost (127.0.0.1) if it is just for yourself.