Setup -> Fiscal Years
Setup -> Company Setup -> Choose Active Fiscal year
5,201 01/12/2014 06:27:26 pm
Re: Need Help in FA (1 replies, posted in Installation)
5,202 01/12/2014 06:22:54 pm
Re: Size limit on restoring backup (14 replies, posted in Reporting)
When you download the backup, you can choose to use gzip or zip compression and then download it.
5,203 01/12/2014 06:14:57 pm
Re: Release 2.3 - Creating Extensions and Modules. How to? (16 replies, posted in Modules Add-on's)
Please refer the files in the existing extensions at:
https://github.com/apmuthu/frontaccounting/extensions/Extensions
5,204 01/04/2014 07:48:40 pm
Re: Supplier payment fails (4 replies, posted in Report Bugs here)
Joe/Janusz, now the rest of the changes in my commits can be incorporated into the FA hg repo now that confirmation is available.
https://github.com/apmuthu/frontaccounting/commit/854c8067faa29399b655ac317d0d1ace48c3c622
https://github.com/apmuthu/frontaccounting/commit/1a2834b600e83e50372667d365cc737835d1b990
https://github.com/apmuthu/frontaccounting/commit/5d3a64a1880df01af314ff8d33de01ecfad44250
5,205 01/04/2014 05:44:33 am
Re: Accounts chart for Belgium (24 replies, posted in Setup)
RapidMiner v5.3.015 (Studio) is at:
http://pan.baidu.com/wap/link?uk=1949354531&shareid=1455012332&third=0
The RapidMiner v6.0.001 Studio in the page at the link above is a trial edition.
5,206 01/04/2014 05:40:58 am
Re: affiliate program + referral program (1 replies, posted in Modules Add-on's)
Start a fork of my GitHub Repo (or the Official ones) and everyone can chip in.
5,207 01/03/2014 08:25:15 pm
Re: Slip printer (5 replies, posted in Reporting)
Modified report files can be placed under company/#/reporting to override defaults
5,208 01/03/2014 08:20:14 pm
Re: Install/Activate Extensions, Theme, Chart of Accounts not working (27 replies, posted in Installation)
Wiki Pre-requisites section has the necessary notes.
5,209 01/03/2014 08:04:34 pm
Re: List of stock adjustments. (3 replies, posted in Items and Inventory)
Wiki-ed it.
5,210 01/03/2014 07:25:56 pm
Re: Supplier payment fails (4 replies, posted in Report Bugs here)
In the purchasing/includes/db folder, the two files:
grn_db.inc
and
suppalloc_db.inc
have changed.
Also some small changes in sql cleanup have not been (fully) included in the official hg repo as yet like https://frontaccounting.com/punbb/viewtopic.php?pid=18517#p18517
You can try the FA core from my unofficial github repo and let me know if it gets clarified.
Verify that the function get_bank_trans() at lines 66 to 91 in gl/includes/db/gl_db_bank_trans.inc is like:
function get_bank_trans($type, $trans_no=null, $person_type_id=null, $person_id=null)
{
$sql = "SELECT bt.*, act.*,
IFNULL(abs(dt.ov_amount), IFNULL(ABS(st.ov_amount), bt.amount)) AS settled_amount,
IFNULL(abs(dt.ov_amount/bt.amount), IFNULL(ABS(st.ov_amount/bt.amount), 1)) AS settle_rate,
IFNULL(debtor.curr_code, IFNULL(supplier.curr_code, act.bank_curr_code)) AS settle_curr
FROM ".TB_PREF."bank_trans bt
LEFT JOIN ".TB_PREF."debtor_trans dt ON dt.type=bt.type AND dt.trans_no=bt.trans_no
LEFT JOIN ".TB_PREF."debtors_master debtor ON debtor.debtor_no = dt.debtor_no
LEFT JOIN ".TB_PREF."supp_trans st ON st.type=bt.type AND st.trans_no=bt.trans_no
LEFT JOIN ".TB_PREF."suppliers supplier ON supplier.supplier_id = st.supplier_id
LEFT JOIN ".TB_PREF."bank_accounts act ON act.id = bt.bank_act
WHERE 1 ";
if ($type != null)
$sql .= " AND bt.type=".db_escape($type);
if ($trans_no != null)
$sql .= " AND bt.trans_no = ".db_escape($trans_no);
if ($person_type_id != null)
$sql .= " AND bt.person_type_id = ".db_escape($person_type_id);
if ($person_id != null)
$sql .= " AND bt.person_id = ".db_escape($person_id);
$sql .= " ORDER BY bt.trans_date, bt.id";
return db_query($sql, "query for bank transaction");
}
5,211 12/30/2013 06:04:01 pm
Re: Query page size bug (12 replies, posted in Report Bugs here)
Updated in my personal GitHub Repo.
For those not intending to wait for FA v2.4, grab the code from here.
5,212 12/30/2013 05:36:00 pm
Re: Query page size bug (12 replies, posted in Report Bugs here)
ALTER TABLE `0_users` CHANGE `query_size` `query_size` TINYINT(1) UNSIGNED NOT NULL DEFAULT 10;
Do that for each of the companies (replacing the table prefix "0_" with the appropriate one for each company) and for all Charts of Accounts in the sql folder.
5,213 12/30/2013 05:21:27 pm
Re: Bill of Exchange (1 replies, posted in Banking and General Ledger)
Please do not request for such info here unless it pertains to FrontAccounting Software.
There are a host of Accounting primers on the net for such information.
The following is from:
http://www.preservearticles.com/201104065101/difference-between-promissory-note-and-bill-of-exchange.html
Difference between Promissory note and bill of exchange
(1) Parties.
There are three parties to a bill of exchange, namely, the drawer, the drawee and the payee; while in a promissory note there are only two parties – maker and payee.
(2) Nature of payment.
In a bill of exchange, there is an unconditional order to pay, while in a promissory note there is an unconditional promise to pay.
(3) Acceptance.
A bill of exchange requires an acceptance of the drawee before it is presented for payment, while a promissory note does not require any acceptance since it is signed by the persons who is liable to pay.
(4) Liability.
The liability of the maker of a promissory note is primary and absolute, while the liability of a drawer of bill of exchange is secondary and conditional. It is only when the drawee fails to pay that the drawer would be liable as a surety.
(5) Notice of dishonor.
In case of dishonor of bill of exchange either due to non-payment or non-acceptance, notice must be given to all persons liable to pay. But in the case of a promissory note, notice of dishonor to the maker is not necessary.
(6) Maker’s position.
The drawer of a bill of exchange stands in immediate relationship with the acceptor and not the payee. While in the case of a promissory note, the maker stands in immediate relationship with the payee.
(7) Nature of acceptance.
A promissory note can never be conditional, while a bill of exchange can be accepted conditionally.
(8) Copies.
A bill of exchange can be drawn in sets, but a promissory note cannot be drawn in sets.
(9) Payable to bearer.
A promissory note cannot be made payable to a bearer, while a bill of exchange can be so drawn provided it is not payable to bearer on demand.
(10) Payable to maker.
In a promissory note, the maker cannot pay to himself. While in the case of a bill of exchange, the drawer and the payee may be one person.
(11) Protest.
Foreign bills must be protested for dishonor when such protest is required by the law of the place where they are drawn. But no such protest is required in the case of a promissory note.
5,214 12/30/2013 05:39:41 am
Re: Query page size bug (12 replies, posted in Report Bugs here)
Wiki-ed it with screenshot.
5,215 12/30/2013 05:06:13 am
Re: Query page size bug (12 replies, posted in Report Bugs here)
The current version on the Official GitHub is still TINYINT for query_size and is VARCHAR(20) for page_size.
CREATE TABLE IF NOT EXISTS `0_users` (
`id` smallint(6) NOT NULL auto_increment,
`user_id` varchar(60) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`real_name` varchar(100) NOT NULL default '',
`role_id` int(11) NOT NULL default '1',
`phone` varchar(30) NOT NULL default '',
`email` varchar(100) default NULL,
`language` varchar(20) default NULL,
`date_format` tinyint(1) NOT NULL default '0',
`date_sep` tinyint(1) NOT NULL default '0',
`tho_sep` tinyint(1) NOT NULL default '0',
`dec_sep` tinyint(1) NOT NULL default '0',
`theme` varchar(20) NOT NULL default 'default',
`page_size` varchar(20) NOT NULL default 'A4',
`prices_dec` smallint(6) NOT NULL default '2',
`qty_dec` smallint(6) NOT NULL default '2',
`rates_dec` smallint(6) NOT NULL default '4',
`percent_dec` smallint(6) NOT NULL default '1',
`show_gl` tinyint(1) NOT NULL default '1',
`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',
`graphic_links` tinyint(1) default '1',
`pos` smallint(6) default '1',
`print_profile` varchar(30) NOT NULL default '1',
`rep_popup` tinyint(1) default '1',
`sticky_doc_date` tinyint(1) default '0',
`startup_tab` varchar(20) NOT NULL default '',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;
The column query_size has not changed since FA v2.1 as seen from:
File: sql/alter2.1.sql
Line 74: ALTER TABLE `0_users` ADD `query_size` TINYINT(1) DEFAULT '10';
5,216 12/30/2013 04:37:08 am
Re: Cannot place a Purchase Order (19 replies, posted in Accounts Payable)
As far as maintaining the software is concerned, in an Open Source project, the onus would devolve on the the members of the community of users generating a gradient for increasing the numbers of those who make quality code shares and support experiences. Joe/Janusz have done a commendable job thus far and my efforts have been to provide the extensions files for easier forking and parallel development. The alter2.3.sql is useful for existing CoAs only and existing upgrade environs - the last line in the file is the onlly one added now. The new en_US and en_US-demo sqls already have them (from the Hg/Git repo)
Please state the steps starting from the install choices and the menu navigations and work done in reaching your error status chronologically. This will help solve the issue.
Make sure that the exchange rates for the currencies involved in the transaction pre-date the transaction envisaged.
5,217 12/29/2013 06:38:15 pm
Re: Cannot place a Purchase Order (19 replies, posted in Accounts Payable)
Please overwrite files in your latest install with the Post Releases Fixes from:
https://frontaccounting.com/punbb/viewtopic.php?pid=18849#p18849
Now try again and see what gives.
5,218 12/29/2013 06:35:41 pm
Re: Release 2.3.19 (21 replies, posted in Announcements)
All Current HG Repo fixes till 2014-01-04 with full slow query fix is available in the attachment to this post.
5,219 12/29/2013 06:27:27 pm
Re: Query page size bug (12 replies, posted in Report Bugs here)
Page Size should be either A4 or Letter
5,220 12/29/2013 04:35:39 am
Re: how do we deal with default payment (10 replies, posted in Accounts Receivable)
Yes, and collect the money off the account books into your pocket! The boss will never know
Nice work. Good Standard Operating Procedure, provided that good people manage the books and those who pay their debts after a long time do so with a view to continue to do business and not for merely avoiding long term legal hassles. That way jest above will not become real.
5,221 12/28/2013 04:31:28 pm
Re: PNG Logo format not accepted (3 replies, posted in Report Bugs here)
The affected file for company is: admin/company_preferences.php
On checking the code, only .jpg seems to be referenced everywhere for display usage.
The above anomaly will probably be there for stock item images as well and the affected file here is: inventory/manage/items.php.
The help strings indicating file types other than .jpg to be allowed for upload are in the language .po files.
The stock item image file is referenced as .jpg in
reporting/rep104.php and
reporting/rep303.php
The database entry in sql/en_US-demo.sql refers to the company logo as:
INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');
5,222 12/27/2013 04:08:48 pm
Re: One installation with multiple subdomain (4 replies, posted in Installation)
1. Create an FA instance in one folder not allocated to any domain.
2. Symlink the files and folders to each of the domains' web roots.
3. Keep a separate database and config file in each domain web root folder.
4. Keep a separate company folder for each company in each domain but keep the default company 0 symlinked in all domains so as to be able to administer it from each domain as well.
5. Make necessary entries in each domain's virtual host fragments
6. Make an archive of all symlinked files for rapid creation of FA instance in each new domain.
This can be the basis for an FA Farm.
5,223 12/26/2013 04:07:06 pm
Re: void a transaction error (4 replies, posted in Installation)
Why don't you try the latest codebase from the mercurial repo or just use the difference file set to overwrite the v2.3.19 files?
Attached is the changed fileset after v2.3.19 was released.
Only one sql command needs to be executed on the existing db (change 0_ to whatever your company # is):
ALTER TABLE `0_debtor_trans` ADD INDEX `Order` (`order_`);
5,224 12/25/2013 07:01:01 am
Re: void a transaction error (4 replies, posted in Installation)
The function get_bank_trans() in lines 66 to 91 in the file gl/includes/db/gl_db_bank_trans.inc has the stated SQL construct.
It is possible that some data may have not had the desired effect on being db_escaped.
Lines 77-79:
LEFT JOIN ".TB_PREF."suppliers supplier ON supplier.supplier_id = st.supplier_id,
".TB_PREF."bank_accounts act
WHERE act.id=bt.bank_act ";
may be changed to:
LEFT JOIN ".TB_PREF."suppliers supplier ON supplier.supplier_id = st.supplier_id
LEFT JOIN ".TB_PREF."bank_accounts act ON act.id=bt.bank_act
WHERE 1 ";
Try and let us know if this solves your issue. It may be a better construct anyway.
5,225 12/25/2013 06:42:37 am
Re: statement pdf (1 replies, posted in Report Bugs here)
You seem to have changed:
$cols = array(4, 100, 130, 190, 250, 320, 385, 450, 515);
to
$cols = array(4, 90, 150, 210, 250, 320, 385, 450, 515);
Notice that a sum of 10+10 units have been increased whilst the others have increased for columns 2 and 3 whilst column 5 has been shortened by 20 units - hope the output is acceptable.