1,701

(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,702

(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,704

(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,706

(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,707

(8 replies, posted in FA Modifications)

The said theme is AdminLTE and is on Github.

1,708

(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,710

(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,713

(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,717

(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

Contact any paid support entity and be specific about your server/platform/FA version details, custom requirements, support and data integration.

1,720

(13 replies, posted in Modules Add-on's)

Contact any paid support entity to resolve your issue that will most probably need manual intervention or post a bounty in the Job Offers board.

1,721

(9 replies, posted in Modules Add-on's)

@joe: Please add in an extra column in function get_customer_trans_details to obtain just the price without tax as it is needed for the likes of the Australian Tax Invoice and possibly elsewhere. This is in file sales/includes/db/cust_trans_details_db.inc. Hence the lines 19-21 in the said file:

    $sql = "SELECT line.*,
        line.unit_price+line.unit_tax AS FullUnitPrice,
        line.description As StockDescription,

should now be lines 19-22:

    $sql = "SELECT line.*,
        line.unit_price+line.unit_tax AS FullUnitPrice,
        line.unit_price AS UnitPriceExTax,  
        line.description As StockDescription,

@PaulShipley: The said function is used in rep107.php (sales invoice), rep110.php (deliveries) and rep113.php (credit notes).

1,722

(3 replies, posted in Report Bugs here)

The document stands delinked from the transaction. Manually delete it physically if it is a permissions issue. It is possible that one may want to link it to another transaction otherwise.

The code for deletion is in lines 145 to 154 in  admin/attachments.php:

if ($Mode == 'Delete')
{
    $row = get_attachment($selected_id);
    $dir =  company_path()."/attachments";
    if (file_exists($dir."/".$row['unique_name']))
        unlink($dir."/".$row['unique_name']);
    delete_attachment($selected_id);    
    display_notification(_("Attachment has been deleted.")); 
    $Mode = 'RESET';
}

The unlink statement clearly is supposed to delete the file.

1,723

(18 replies, posted in Items and Inventory)

@joe: Lines 50 and 52 can be removed in reporting/rep302.php as there can be only one description for one id for both category_id and stock_id fields.

Also Line 77  filters on ST_CUSTCREDIT (11) and ST_CUSTDELIVERY (13) instead of on ST_SUPPRECEIVE (25) and ST_CUSTDELIVERY (13) and the need to take care of transactions pertaining to ST_MANUISSUE (28) and ST_MANURECEIVE (29) with the signs being taken care of as well.

Further, lines 38 and 39:

            IF(move.stock_id IS NULL, '', move.loc_code) AS loc_code,
            SUM(IF(move.stock_id IS NULL, 0, move.qty)) AS qty_on_hand

can be re-coded as

            COALESCE(move.loc_code, '') AS loc_code,
            SUM(COALESCE(move.qty, 0)) AS qty_on_hand

1,724

(18 replies, posted in Items and Inventory)

You can still insert file write statements to spit out the inspection points / variable values. Read the Wiki.

Inventory Planning Report is reporting/rep302.php.

1,725

(4 replies, posted in Translations)

What is your server platform - Windows / Linux?
Waht are your PHP/MySQL/Apache/FA versions?
Are you using Simplified or Traditional Chinese?
Do you have the necessary locales installed both in the OS and for your client browser?

Do the weird strings when recalled in the Web UI appear as the correct characters?