Check if the specific delinquent sales order is in the previous fiscal year and if it is not closed as yet and work accordingly.
1,726 05/17/2018 02:52:12 am
Re: Unable to cancel a sales order (5 replies, posted in Accounts Receivable)
1,727 05/17/2018 02:50:33 am
Re: Current date on invoices (7 replies, posted in Setup)
That is the date on which the invoice was created. It is not the financial year date.
If you want the "printed on" date, then just add that line to the footer of the invoice as stated in the wiki.
The invoice data is the legal on on which it is accepted to get into the books of account and not the printed on date which can be done any number of times anytime.
1,728 05/16/2018 07:53:29 pm
Re: Find a wiki for Simple REST API (3 replies, posted in Modules Add-on's)
"Find" or "Fund" ?
Some applications built recently have been founded on REST APIs that are used by the application's menu links directly but not FA as of now.
1,729 05/16/2018 07:51:35 pm
Re: Account Number (6 replies, posted in Wish List)
Do you mean prefixing the Account Number to the Account Name in search results?
1,730 05/15/2018 07:35:21 pm
Re: No access to one of several companies (3 replies, posted in Installation)
All db access info are in config_db.php - check if those credentials are okay.
It is possible that some sys_prefs table records may have become corrupted.
If you have a backup for those companies, then try to manually restore them using any mysql client (phpMyAdmin, SQLyog, etc).
Since your other companies are working, the specific company/#/* files may be corrupted too. Check for the installed_extensions.php file contens in each of these folders.
Actually, at the very start, you should be examining your webserver error logs!
1,731 05/15/2018 07:24:09 pm
Re: Current date on invoices (7 replies, posted in Setup)
Have a look at the attachment in my previous post. The Invoice Sales Date is used in 2 places. I do not see any Financial Year Date. Which version of FA are you using and what versions of PHP / MySQL and Platform (Windows/Linux)?
1,732 05/12/2018 03:52:11 am
Re: problem regarding "Fixed Asset Purchase" -- comes only 1qty (6 replies, posted in Fixed Assets)
FA treats each fixed asset as a single entity for that very same reason - if one is damaged/sold etc.
The FA interface can be made to acquire a set of assets in a single block but get stored as single assets.
1,733 05/11/2018 05:20:04 pm
Re: Reports and Analysis (1 replies, posted in Wish List)
Take full P&L (rep707.php) as one report.
Take only Dimension 2 in another report.
Now use the difference
Alternatively, make a temporary modification to the SQL in the report file and invert the logic to get all but dimension 2. $_POST['PARAM_3'] > 0 && isset($_POST['PARAM_9']) && !(isset($_POST['PARAM_10']) will be for the presence of a single dimension.
1,734 05/11/2018 02:41:45 pm
Re: Database error. Please help (1 replies, posted in Reporting)
It is possible you upgraded your FA which now requires all tables to be InnoDB.
One work around is to convert all tables in the database into MyISAM type from InnoDB - FA 2.4.x should still work fine.
The current stock FA v2.4.x does not use any of the InnoDB features like references and cascades yet.
SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,' ENGINE=MyISAM;')
FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'DBNAME' AND ENGINE = 'InnoDB' AND TABLE_TYPE = 'BASE TABLE';
Replace your FA database name in 'DBNAME' above and then execute the output sql statements.
Alternatively enable InnoDB engine in your my.cnf or my.ini file and restart the MySQL server:
default-storage-engine=innodb
default-table-type=innodb
1,735 05/11/2018 02:36:55 pm
Re: problem regarding "Fixed Asset Purchase" -- comes only 1qty (6 replies, posted in Fixed Assets)
If you intend to depreciate it as a block, treat them all as one asset - a block of assets rolled into one.
1,736 05/10/2018 10:21:07 am
Re: Current date on invoices (7 replies, posted in Setup)
The default Sales Invoice in FA does not show the Financial Year. See attachment. If you customised your invoice then you will need (to get your programmer) to make the changes.
1,737 05/10/2018 10:16:52 am
Re: Pages with URL ending with ? are forbidden [FA 2.4.2] (2 replies, posted in Setup)
Some hosts require a 755 permission for all files and folders to be visible on the web. This could be some SELinux setting.
1,738 05/10/2018 01:11:17 am
Re: Australian Tax Invoice extension (9 replies, posted in Modules Add-on's)
Can try to avoid making several changes in the core reports to include the pdf inc file if possible.
Attached is one instance of a function that may no longer be required or one that can be selectively incorporated with if(!function_exists(... at creation time and it's complement at usage time.
1,739 05/09/2018 05:47:22 pm
Re: THEME ADDITION (8 replies, posted in FA Modifications)
1,740 05/08/2018 07:38:13 pm
Re: How to add Land as fixed assets (1 replies, posted in Fixed Assets)
Make each land purchase a separate asset if a different seller is involved and / or individual payments are made to different persons. All land particulars can be attached as documents to the transaction and listed summarily in the memo fields accordingly.
1,741 05/08/2018 07:35:49 pm
Re: We feel that a lot more people should know about FrontAccounting. (4 replies, posted in FA Modifications)
PDF docs may look unprofessional if they have others branding on it much like a "Trial" watermark on them or "Printed by Big Printers, Timbuktoo" on your visiting cards.
FA is one of the popular accounting packages for simple usage and the need for sufficient familiarity gained through searching forums / wikis etc before one can use it in an advanced manner and best self-supported. The latter is not for everyone though. It is slowly becoming the ERP of choice for the "poor" company and for those dissatisfied with proprietary expensive ones with enormous data lock-ins and recurring charges.
1,742 05/08/2018 07:28:46 pm
Re: Disable server side cache (7 replies, posted in FA Modifications)
Have a cron job clear the tmp folder where the cache gets stored or disable caching in the apache server config.
Refer:
http://bertanguven.com/disable-caching-of-assets-in-apache
https://stackoverflow.com/questions/11532636/how-to-prevent-http-file-caching-in-apache-httpd-mamp
https://gist.github.com/JamieMason/3245483
1,743 05/08/2018 07:26:20 pm
Re: How to correct old allocation errors (2 replies, posted in Accounts Receivable)
The journal entry should have been from the wrong sales account to the correct one. This should not affect the allocation of customer's payments.
1,744 05/08/2018 07:22:03 pm
Re: REQUIRE SOME MODIFICATION IF POSSIBLE (3 replies, posted in FA Modifications)
1. Yes, it can be done.
2. Editing the language translation .po file and compiling it into a .mo file after replacing Vendor with Supplier, etc will do the job.
3. Make a custom invoice of reporting/rep107.php and place it in your company/#/reporting folder for overriding it and adjust the Invoice into three parts - one above the other - within the same A4 page.
4. The themes do not affect the reports or the translations - yes you can make your own theme.
5. No, FA does not have approvals at this time - make your own extension for it.
If you want assistance, post your bounty offer in the Job Offers board.
1,745 05/08/2018 07:14:57 pm
Re: Australian Tax Invoice extension (9 replies, posted in Modules Add-on's)
@joe: Thanks for the commit.
@PaulShipley: The file sales/includes/db/cust_trans_details_db.inc can be removed from your extension as the one in the core would now suffice.
1,746 05/08/2018 07:08:06 pm
Re: Inline addition of Tax for item in Quotation/Sales order/Inovoice (14 replies, posted in Accounts Receivable)
@nikhunjpatel1222: Do we have different GST slabs for the same item in a single jurisdiction where a TaxGroup for different location based rate will not suffice?
Is @poncho1234's solution sufficient for the Indian GST?
1,747 05/06/2018 08:08:58 pm
Re: Inline addition of Tax for item in Quotation/Sales order/Inovoice (14 replies, posted in Accounts Receivable)
The problem here is that the customer / branch must have different tax for different items as well!
In fact to alleviate this issue for the Australian GST (see post), we needed an extra column in the query for PriceExTax that can be used in customised reports.
1,748 05/06/2018 08:04:09 pm
Re: We feel that a lot more people should know about FrontAccounting. (4 replies, posted in FA Modifications)
Looking at this from the security point of view, a complete de-branding / re-branding is essential.
Do a Google search for "FrontAccounting 2.4.4 - Login" and it will ferret out all the native FA code based installs. Do that for older (known vulnerable) versions and it might be a security nightmare.
Even if you do what you want to do, make sure there is a flag in the Company Preferences (sys_prefs table) to turn them off without having to wade through the code base. If most will then hide it, the exercise would prove useless.
Popularising FA is best done by word of mouth and through articles / reviews / courses across nations in all languages.
To be truly effective, the Chart of Accounts and Language extensions should be up-to-date and all schemas in synch. Transifex is where I hammer it out.
Also the FA pkg repo should be up-to-date so that the extensions will install correctly and work as desired. In fact, the extension packages were signed for that very purpose. For now, users are left to manually install from the FA24extensions repo.
1,749 05/06/2018 04:08:15 pm
Re: SQL code on web (2 replies, posted in Report Bugs here)
It appears that you have some of the debug parameters in your config.php file turned on - turn them off to get rid of these outputs.
This last specific SQL comes from the function get_sql_for_journal_inquiry() in gl/includes/db/gl_db_trans.inc.
1,750 05/06/2018 03:30:08 am
Re: Inline addition of Tax for item in Quotation/Sales order/Inovoice (14 replies, posted in Accounts Receivable)
Refer the Wiki and see if the Intersection of lowest tax and additive tax slab for customer (destination location) will satisfy it. The Tax Config page too has examples.
Those who have implemented the Indian GST can share their implementations.
GST in India is still evolving and may be totally changed with any change in Government.
Some links to Indian Taxes for Accounting Software are: