3,626 Reply by apmuthu

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

Go to forum: FA Modifications

3,627 Reply by apmuthu

(16 replies, posted in Banking and General Ledger)

Attached your screenshot here for self-sufficiency.

Go to forum: Banking and General Ledger

3,628 Reply by apmuthu

(10 replies, posted in Report Bugs here)

It stands committed in the FA 2.4 repo now.

Go to forum: Report Bugs here

3,629 Reply by apmuthu

(8 replies, posted in Report Bugs here)

Try to turn off "STRICT" in PHP 5.4

Go to forum: Report Bugs here

3,630 Reply by apmuthu

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

Go to forum: Setup

3,631 Reply by apmuthu

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

Go to forum: Report Bugs here

3,632 Reply by apmuthu

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

Go to forum: Report Bugs here

3,633 Reply by apmuthu

(4 replies, posted in Setup)

Then all you need to do is make 2015 the current active year in the Setup => Company Setup Form.

Go to forum: Setup

3,634 Reply by apmuthu

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

Go to forum: Setup

3,635 Reply by apmuthu

(29 replies, posted in Wish List)

The sample alluded to in a previous post is attached here for self sufficiency of the forum.

Go to forum: Wish List

3,636 Reply by apmuthu

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

Go to forum: Items and Inventory

3,637 Reply by apmuthu

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

Go to forum: Announcements

3,638 Reply by apmuthu

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

Go to forum: Report Bugs here

3,639 Reply by apmuthu

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

Go to forum: Accounts Receivable

3,640 Reply by apmuthu

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

Go to forum: Accounts Payable

3,641 Reply by apmuthu

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

Go to forum: Accounts Payable

3,642 Reply by apmuthu

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

Go to forum: Accounts Payable

3,643 Reply by apmuthu

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

Go to forum: Accounts Payable

3,644 Reply by apmuthu

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

Go to forum: Report Bugs here

3,645 Reply by apmuthu

(16 replies, posted in Banking and General Ledger)

Wouldn't you want to submit your code?

Go to forum: Banking and General Ledger

3,646 Reply by apmuthu

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

besides being called by various files both in the core and in the extensions.

Go to forum: Banking and General Ledger

3,647 Reply by apmuthu

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

Go to forum: Announcements

3,648 Reply by apmuthu

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

Go to forum: Accounts Receivable

3,649 Reply by apmuthu

(4 replies, posted in Accounts Receivable)

When you enter foreign item code, the quantity you enter for it will be the number of units of the main item that will be used for billing. The foreign item code represents a means of bulk billing (qty > 1) or alias billing name (qty = 1).

Your suggestion for grouping items dropdown box  by stock_id instead of by item_code would mean that the user must remember the stock_id for each item_code wanted which may not be feasible. The replacement of the i.description with s.description will render both descriptions the same and would make for ambiguity in selection.

Go to forum: Accounts Receivable

3,650 Reply by apmuthu

(3 replies, posted in Items and Inventory)

In FA 2.3 it currently shows up only in Sales Entry Forms - Order, Quotation, Invoice, Delivery.

@joe: Is this the intended design?

Go to forum: Items and Inventory