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,752 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,753 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,754 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,755 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,756 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,757 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,758 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,759 05/09/2018 05:47:22 pm
Re: THEME ADDITION (8 replies, posted in FA Modifications)
1,760 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,761 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,762 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,763 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,764 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,765 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,766 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,767 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,768 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,769 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,770 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:
1,771 05/05/2018 03:08:18 pm
Re: Customize frontaccounting (1 replies, posted in Jobs wanted/offered, non-free offers)
Contact any paid support entity and be specific about your server/platform/FA version details, custom requirements, support and data integration.
1,772 05/05/2018 03:05:47 pm
Re: Inventory Items CSV Import (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,773 05/05/2018 08:30:35 am
Re: Australian Tax Invoice extension (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,774 05/04/2018 10:22:24 am
Re: Failed to load PDF document (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,775 05/03/2018 02:06:15 am
Re: Inventory Planning Report (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