Try to generate 4 separate pdfs in a buffer and then collect them into one pdf file.

Hope you have set the currencies for the supplier and the company correctly and have the exchange rates entered if they are different or different from the company's default currency.

Creating extensions have been the preserve of only a few and it would be nice to have a detailed step by step example to get it done. That is the very purpose of putting all the extension files online so that they can be forked and extended.

An example comprising a new table with a field in it linked to any existing FA table (foreign key) to enable adding/editing/deleting entries in the new table having menu entries in a new tab including one to display data from the new table as well as a few from the linked table would do well to illustrate the method. Permissions can also be demonstrated in the example for complete illustration.

The easiest understood example would be a new "customer notes" table that links to the "customer" table with a tab called "notes" where it would be easy to add new "note description" records in the "customer notes" table and edit and/or delete them whilst displaying the "customer name" from the "customer" table as a link to the "customer details display" page.

Ref:
https://frontaccounting.com/punbb/viewtopic.php?id=4525

5,230

(1 replies, posted in Accounts Receivable)

You have got your credits and debits reversed.

Invoice to customer:
By Service Sales of XL Gathering Event - $700 Cr

Costs:
To Caterer for lunch = $250 Dr
To Travel Agency for transportation = $150 Dr

Since designing $100 is part of your charges and will belong to you, it is not included in the costs to agree with your idea of profit of $300 (Cr) which Service Sales folio will show.

5,231

(1 replies, posted in Setup)

https://frontaccounting.hg.sourceforge.net/hgweb/frontaccounting/frontaccounting/branches
http://devel.frontaccounting.com/git/?p=fa-stable.git;a=summary
https://frontaccounting.com/fawiki/
https://github.com/apmuthu/frontaccounting

Refer files of existing extensions at:
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Extensions

5,233

(1 replies, posted in Installation)

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

5,234

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

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

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

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

(3 replies, posted in Items and Inventory)

Wiki-ed it.

5,242

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

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

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

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

(12 replies, posted in Report Bugs here)

Wiki-ed it with screenshot.

5,247

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

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

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

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