Try to generate 4 separate pdfs in a buffer and then collect them into one pdf file.
5,226 01/15/2014 05:15:00 am
Re: print copies of invoice with variable text (6 replies, posted in Reporting)
5,227 01/15/2014 05:12:37 am
Re: Allocation for Credit Notes not working correctly (18 replies, posted in Report Bugs here)
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.
5,228 01/13/2014 02:39:04 am
Re: Release 2.3 - Creating Extensions and Modules. How to? (16 replies, posted in Modules Add-on's)
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.
5,229 01/12/2014 06:42:57 pm
Re: Ext. mysql Deprecated, use PDO or mysqli (1 replies, posted in Report Bugs here)
Ref:
https://frontaccounting.com/punbb/viewtopic.php?id=4525
5,230 01/12/2014 06:32:53 pm
Re: setup Service Items (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 01/12/2014 06:30:01 pm
Re: Git or Mercurial setup (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
5,232 01/12/2014 06:28:35 pm
Re: How to integrate new application with gl and accounting (1 replies, posted in FA Modifications)
Refer files of existing extensions at:
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Extensions
5,233 01/12/2014 06:27:26 pm
Re: Need Help in FA (1 replies, posted in Installation)
Setup -> Fiscal Years
Setup -> Company Setup -> Choose Active Fiscal year
5,234 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,235 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,236 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,237 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,238 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,239 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,240 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,241 01/03/2014 08:04:34 pm
Re: List of stock adjustments. (3 replies, posted in Items and Inventory)
Wiki-ed it.
5,242 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,243 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,244 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,245 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,246 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,247 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,248 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,249 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,250 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.