5,201

(1 replies, posted in Installation)

Setup -> Fiscal Years
Setup -> Company Setup -> Choose Active Fiscal year

5,202

(14 replies, posted in Reporting)

When you download the backup, you can choose to use gzip or zip compression and then download it.

Please refer the files in the existing extensions at:
https://github.com/apmuthu/frontaccounting/extensions/Extensions

5,204

(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

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

Start a fork of my GitHub Repo (or the Official ones) and everyone can chip in.

5,207

(5 replies, posted in Reporting)

Modified report files can be placed under company/#/reporting to override defaults

Related Post

Wiki Pre-requisites section has the necessary notes.

5,209

(3 replies, posted in Items and Inventory)

Wiki-ed it.

5,210

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

(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 replies, posted in Report Bugs here)

Wiki-ed it with screenshot.

5,215

(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

(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

(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

(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 replies, posted in Report Bugs here)

Page Size should be either A4 or Letter

Yes, and collect the money off the account books into your pocket! The boss will never know wink

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

(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');

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

(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

(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

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