You will have to logout and login again after clearing browser cache.
3,602 01/17/2016 02:17:59 am
Re: odd journal entries - advanced manufacture 2.3.24 (3 replies, posted in Manufactoring)
The relevant commit is here.
3,603 01/17/2016 02:16:49 am
Re: Remove all info relating to tax, vat (2 replies, posted in FA Modifications)
All you need to do is edit the various reporting/repXXX.php files and remove all references to Tax/VAT.
3,604 01/17/2016 02:14:59 am
Re: How to include checkbox in Table Pager (16 replies, posted in Banking and General Ledger)
Attached your screenshot here for self-sufficiency.
3,605 01/17/2016 02:01:21 am
Re: FA won't close fiscal year (10 replies, posted in Report Bugs here)
It stands committed in the FA 2.4 repo now.
3,606 01/17/2016 01:47:48 am
Re: under customers, cant add deliveries, general, invoices, orders (8 replies, posted in Report Bugs here)
Try to turn off "STRICT" in PHP 5.4
3,607 01/07/2016 10:41:15 am
Re: Issues Upgrading from FrontAccounting 2.3.1 to Version 2.3.24 Build 2 (1 replies, posted in Setup)
Check for file and folder permissions and compare the sql/en_US-new.sql files in both versions and look for missing entries.
3,608 01/07/2016 10:39:32 am
Re: under customers, cant add deliveries, general, invoices, orders (8 replies, posted in Report Bugs here)
In your FA folder look for a tmp folder and in it check the errors.log file in a text editor like notepad.
3,609 01/06/2016 08:29:00 pm
Re: under customers, cant add deliveries, general, invoices, orders (8 replies, posted in Report Bugs here)
Take the latest snapshot of FA 2.3.24+ from the official GitHub Repo.
Check the config.php for any changes you might need.
You may need to make changes to your database tables (in your Chart of Accounts) and some IDs (like fiscal year), apart from some AUTO_INCREMENT presets.
The patch code for the file differences between the versions 2.3.16 and v2.3.24+ in sql/en_US-new.sql are:
diff --git "a/sql/en_US-new.sql" "b/sql/en_US-new.sql"
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -3,7 +3,7 @@
-- http://www.phpmyadmin.net
--
-- Host: localhost
--- Generation Time: May 11, 2010 at 11:37 PM
+-- Generation Time: Sep 26, 2014 at 11:37 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6-1+lenny2
@@ -653,7 +653,8 @@ CREATE TABLE IF NOT EXISTS `0_debtor_trans` (
`payment_terms` int(11) default NULL,
PRIMARY KEY (`type`,`trans_no`),
KEY `debtor_no` (`debtor_no`,`branch_code`),
- KEY `tran_date` (`tran_date`)
+ KEY `tran_date` (`tran_date`),
+ KEY `order_` (`order_`)
) ENGINE=InnoDB;
--
@@ -755,18 +756,14 @@ CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
PRIMARY KEY (`id`),
UNIQUE KEY `begin` (`begin`),
UNIQUE KEY `end` (`end`)
-) ENGINE=InnoDB AUTO_INCREMENT=4 ;
+) ENGINE=InnoDB AUTO_INCREMENT=3 ;
--
-- Dumping data for table `0_fiscal_year`
--
-INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES(4, '2011-01-01', '2011-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES(5, '2012-01-01', '2012-12-31', 0);
-INSERT INTO `0_fiscal_year` VALUES(6, '2013-01-01', '2013-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(1, '2013-01-01', '2013-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(2, '2014-01-01', '2014-12-31', 0);
--
-- Table structure for table `0_gl_trans`
@@ -955,7 +952,8 @@ CREATE TABLE IF NOT EXISTS `0_item_units` (
-- Dumping data for table `0_item_units`
--
-INSERT INTO `0_item_units` VALUES('ea.', 'Each', 0, 0);
+INSERT INTO `0_item_units` VALUES('each', 'Each', 0, 0);
+INSERT INTO `0_item_units` VALUES('hr', 'Hours', 0, 0);
-- --------------------------------------------------------
@@ -1559,7 +1557,7 @@ CREATE TABLE IF NOT EXISTS `0_stock_category` (
INSERT INTO `0_stock_category` VALUES(1, 'Components', 1, 'each', 'B', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
INSERT INTO `0_stock_category` VALUES(2, 'Charges', 1, 'each', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
INSERT INTO `0_stock_category` VALUES(3, 'Systems', 1, 'each', 'M', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
-INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hrs', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
+INSERT INTO `0_stock_category` VALUES(4, 'Services', 1, 'hr', 'D', '4010', '5010', '1510', '5040', '1530', 0, 0, 0, 0);
-- --------------------------------------------------------
@@ -1790,7 +1788,7 @@ INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, ''
INSERT INTO `0_sys_prefs` VALUES('domicile', 'setup.company', 'varchar', 55, '');
INSERT INTO `0_sys_prefs` VALUES('curr_default', 'setup.company', 'char', 3, 'USD');
INSERT INTO `0_sys_prefs` VALUES('use_dimension', 'setup.company', 'tinyint', 1, '1');
-INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '6');
+INSERT INTO `0_sys_prefs` VALUES('f_year', 'setup.company', 'int', 11, '2');
INSERT INTO `0_sys_prefs` VALUES('no_item_list', 'setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES('no_customer_list', 'setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES('no_supplier_list', 'setup.company', 'tinyint', 1, '0');
@@ -2058,10 +2056,10 @@ CREATE TABLE IF NOT EXISTS `0_users` (
`show_codes` tinyint(1) NOT NULL default '0',
`show_hints` tinyint(1) NOT NULL default '0',
`last_visit_date` datetime default NULL,
- `query_size` tinyint(1) default '10',
+ `query_size` tinyint(1) unsigned NOT NULL default '10',
`graphic_links` tinyint(1) default '1',
`pos` smallint(6) default '1',
- `print_profile` varchar(30) NOT NULL default '1',
+ `print_profile` varchar(30) NOT NULL default '',
`rep_popup` tinyint(1) default '1',
`sticky_doc_date` tinyint(1) default '0',
`startup_tab` varchar(20) NOT NULL default '',3,610 01/06/2016 09:21:00 am
Re: Fiscal Year (4 replies, posted in Setup)
Then all you need to do is make 2015 the current active year in the Setup => Company Setup Form.
3,611 01/05/2016 05:59:52 pm
Re: Fiscal Year (4 replies, posted in Setup)
Possibly needs correction in the primary database itself.
As long as 2015 is active and the current one is temporarily 2014 which is closed, it is possible you have been entering data that has been correctly taken in for 2015.
Have a look at your actual entries - invoices, payments, etc and see if the date is correctly set in 2015.
3,612 01/03/2016 03:50:39 am
Re: serial number tracking (29 replies, posted in Wish List)
The sample alluded to in a previous post is attached here for self sufficiency of the forum.
3,613 01/03/2016 03:46:15 am
Re: Item with expire date (10 replies, posted in Items and Inventory)
State the workflow you need to achieve Serial Number tracking. What do you want to do for items that have "expired"? How does the FA sync with the actual "expired" items among the physical inventory for disspatch? Do you store goods in separate bin based on expiry date?
Also refer the thread stated in one of the previous posts here.
3,614 01/03/2016 03:43:56 am
Re: New UI For Frontaccounting (12 replies, posted in Announcements)
Check the use of DIRECTORY_SEPARATOR or do a blind replace of "\\" with "/" in paths for use in your non-localhost even if it is windows.
3,615 01/03/2016 03:41:29 am
Re: Company Creation gives me the following error. (6 replies, posted in Report Bugs here)
Please state where you find $db not globally accessible as your instance is not replicable. Responses such yours should be fully qualified and not plant apprehensions especially in new user's minds in using FA.
3,616 01/03/2016 03:37:45 am
Re: Sales Invoice Print - Original / Duplicate / Triplicate (1 replies, posted in Accounts Receivable)
Print the invoice (rep107.php) using a for loop 4 times, each time using the appropriate watermark (background PDF) of "Original", Duplicate, Triplicate, etc. The watermark can be replaced with appropriate equivalent of TCPDF functions / abstractions.
Please note that there is no sanctity of the named invoice printouts since each invoice PDF would still have all the watermarks for eg., in your case, it will have 16 pages in all.
3,617 12/27/2015 01:36:08 pm
Re: Invoice: Include VAT/GST selection with every entry (10 replies, posted in Accounts Payable)
Since there are a lot of EU users, a small HOWTO for some specific country is in order.
FA 2.4 though now at RC1 can be used with caution for small entities. The DB structures are still subject to change there as development goes through to release.
3,618 12/27/2015 08:31:15 am
Re: Invoice: Include VAT/GST selection with every entry (10 replies, posted in Accounts Payable)
Check out the equivalent report in FA 2.4 and see if it does what you want.
Whatever means you use, the taxman can still assume cheating on all such tax-less invoices. Choose a country where there is no tax (atleast for overseas transactions) and do business from there! Better no audit than bad audit (corrupt government audits!)
3,619 12/26/2015 02:58:12 am
Re: Invoice: Include VAT/GST selection with every entry (10 replies, posted in Accounts Payable)
It is rather an extension of the transaction than a correction.
Alternatively, create a generic zero valued supplier and enter office use items without VAT as if purchased from them and put in the Supplier name in the details.
3,620 12/25/2015 06:09:32 pm
Re: Invoice: Include VAT/GST selection with every entry (10 replies, posted in Accounts Payable)
Assume everything bought is for resale at first. When you want to use it for Office purposes, then make an issue to Office Use and credit back the VAT in a Quick entry (if it is a common occurrence) for such issues or in a Journal Voucher (if it is once in a blue moon).
3,621 12/25/2015 06:03:17 pm
Re: Company Creation gives me the following error. (6 replies, posted in Report Bugs here)
FA v2.3.2 is very old.
Use v2.3.24+ or v2.4rc1.
What version of PHP/MySQL are you using.
Are you using it in Windows?
What are the DB storage engine and collation used?
The said SQL line is at line 20 in the sql/en_US-new.sql file.
Since the comments are hyphens in the sql file, make sure your MySQL recognizes it or strip it of all comments and create a company with it.
3,622 12/24/2015 06:02:50 pm
Re: How to include checkbox in Table Pager (16 replies, posted in Banking and General Ledger)
Wouldn't you want to submit your code?
3,623 12/22/2015 04:50:12 pm
Re: How to include checkbox in Table Pager (16 replies, posted in Banking and General Ledger)
Please state the context, function and the file you are trying to modify along with an intended screenshot of what you want to achieve.
There are:
includes/db_pager.inc
includes/ui/db_pager_view.incbesides being called by various files both in the core and in the extensions.
3,624 12/22/2015 04:45:22 pm
Re: Query Simplification functions (5 replies, posted in Announcements)
In your article, you stated:
...
So I wrote the following functions which are also available in my github page for download.
...
Which github page of yours has the functions?
3,625 12/22/2015 04:42:59 pm
Re: Sales Order Entry (4 replies, posted in Accounts Receivable)
This is implementable using the Bin Location workaround shown in the wiki. This uses the long_description field to store delimited information parsed out when needed.