1,726

(5 replies, posted in Accounts Receivable)

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,727

(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

(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

(6 replies, posted in Wish List)

Do you mean prefixing the Account Number to the Account Name in search results?

1,730

(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

(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)?

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

(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 wink

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

(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

If you intend to depreciate it as a block, treat them all as one asset - a block of assets rolled into one.

1,736

(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.

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

(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

(8 replies, posted in FA Modifications)

The said theme is AdminLTE and is on Github.

1,740

(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.

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

(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

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. 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

(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.

@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?

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.

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

(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.

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:

https://github.com/anoopmb/FrontAccounting-2.3.26-CORE

https://github.com/Dolibarr/dolibarr/issues/7221