Yes - printing cheques only.
Use the Memo field to put in cheque Number, bank name, etc in the payment allocation entry.
4,127 04/24/2015 01:58:36 am
Re: Sales customer set up (2 replies, posted in Reporting)
Which version of FA are you using. There was a commit to rectify a similar (or same) issue a few months ago.
4,128 04/24/2015 01:55:16 am
Re: PayPal import issues (15 replies, posted in Modules Add-on's)
Which version of the paypal extension are you using?
There was some feature reduction in a later version.
There could be some error in the file sales/includes/db/payment_db.inc since only 11 arguments are initialised in the code fragment from line 29-31:
$args = func_get_args(); while (count($args) < 12) $args[] = 0;
$args = (object)array_combine(array('trans_no', 'customer_id', 'branch_id', 'bank_account',
'date_', 'ref', 'amount', 'discount', 'memo_','rate','charge', 'bank_amount'), $args);Try changing the first line above:
$args = func_get_args(); while (count($args) < 12) $args[] = 0;to
$args = func_get_args(); while (count($args) <= 12) $args[] = 0;and report the results.
4,129 04/24/2015 01:42:02 am
Re: urgent response required please (3 replies, posted in Reporting)
Do you have the dejavu.php file in your FA webroot?
If not, get it from the frontaccounting.com downloads section.
Read the related section in the wiki.
dejavu.php missing - TCPDF Font Failure
Download dejavu.php
Extract contents to reporting/fonts folder
This is the default unicode font when none are defined
Can change this font at around line 161 in reporting/includes/class.pdf.inc
4,130 04/24/2015 01:38:06 am
Re: Notepad Direct Print (5 replies, posted in Reporting)
Use Windows Scheduler and print the TXT files from the folder using normal Windows Batch commands. Why do you need PHP here?
The following links may be useful:
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/batch.mspx?mfr=true
http://en.wikibooks.org/wiki/Windows_Batch_Scripting
http://ss64.com/nt/
http://www.robvanderwoude.com/batchcommands.php
4,131 04/24/2015 01:34:43 am
Re: Why FrontAccounting? (4 replies, posted in Installation)
@genebarker: Thanks indeed.
The writeup will be useful for FA Evangelism.
Wonder why you have not upgraded to FA 2.3.24 yet (from your screenshot).
4,132 04/24/2015 01:24:04 am
Re: Supplier Credit Note Incorrect Header and GST (12 replies, posted in Accounts Payable)
Your computation of GST (in the notes) assumes 70% for Item 1 instead of 7%. FA calculates it correctly.
The label for the column "Qty yet to Credit" should be "Rate".
@joe: Please change this.
4,133 04/24/2015 01:16:00 am
Re: Modules problem (9 replies, posted in Installation)
Which versions of FA and extension are you using?
Use FireFox Browser and not MSIE.
Check the error.log to locate the line number that causes the fault.
4,134 04/24/2015 01:13:39 am
Re: FA v2.4 development (48 replies, posted in Setup)
FA 2.4 is heading towards PHP 5.4 and UTF-8 fully. Use "UTF-8 without BOM" in your IDE.
Is default '' illegal for text fields?
See if there have been changes in the latest FA 2.4 build.
I see you have forked the official FA Unstable as well - that is the way to go - not a fork of my frontac24.
4,135 04/24/2015 01:09:45 am
Re: cheque Sales (3 replies, posted in Accounts Receivable)
You need to install the module from within the default company and then activate it for the target company and possibly enable permissions for the user to access it's functionality before you can start using it. Search the forums and read the wiki for more info.
4,136 04/24/2015 01:08:09 am
Re: Add check payments (18 replies, posted in Wish List)
Study the various extensions available and roll your own. The extensions files are available in my unofficial github repo.
4,137 04/24/2015 12:57:11 am
Re: report generator (7 replies, posted in Reporting)
Copy the rep304.php into company/#/reporting/rep304 and edit it there - # is your company number. It will override the original report file of the same name.
4,138 04/24/2015 12:55:51 am
Re: Error when trying to edit Journal Entry (4 replies, posted in Banking and General Ledger)
Changes in config file values to reflect in FA may need a logout and login again if session variables are depended upon.
Your workaround could be useful for others till the dev fixes it. Thanks.
4,139 04/24/2015 12:53:02 am
Re: Batching Invoice against Sales Delivery (8 replies, posted in Accounts Receivable)
The selections in one screen are the ones which get processed. Selections in the second screen must be done separately. You can try to increase the number of entries on each screen as stated in this thread, if you want all in one go.
4,140 04/14/2015 04:05:40 pm
Re: HTML Reports (3 replies, posted in Reporting)
You will have to increase the number of variables in php's php.ini - see another post for it.
Using Courier New or Terminal font (slashed zero) may be suitable.
4,141 04/14/2015 04:04:14 pm
Re: Direct Print Option (1 replies, posted in Reporting)
This is so that you have all links available after the transaction and you can choose what you want.
4,142 04/14/2015 04:02:31 pm
Re: Page Not Found (2 replies, posted in Setup)
Platform - Linux/Windows.
FA version?
Files and Folder permissions for webserver user.
4,143 04/14/2015 11:42:45 am
Re: Bug in Excel Reports (10 replies, posted in Report Bugs here)
The php closing tag issue generally comes up on PHP 5.4 onwards.
The include_once should have no effect and is needed to enforce authority to download only if logged in.
If the generated file is good, then the browser transfer may be the issue. Check the apache error logs for any clues.
4,144 04/14/2015 11:19:28 am
Re: Add check payments (18 replies, posted in Wish List)
What you ask will break the normal workflow of FA. Better make a module (extension) with a new table that keeps track of these fields but you will have to take into account what happens when such entries are edited. There is another thread with info on editing Journal Vouchers and their consequences for the database tables and next_reference field.
There is huge scope for misuse of FA for money laundering and embezzlement besides hiding transactions amidst legitimate ones making forensics that much more difficult if what you say is allowed since there is no info on the final resting place for the monies to all the intermediate parties concerned.
4,145 04/14/2015 11:16:52 am
Re: Add Currency Symbol at Invoice Top (8 replies, posted in Accounts Receivable)
If the autoupdate is enabled, then what you state is acceptable as a current exchange rate would have been acquired. If not, only an older exchange rate would be available and may be used for the current transaction as would obtain if it is withing a few days of no significant change.
If the date_ >= $date is used, then the Order by Desc should be Order by Asc. Should there be a dictate to use the old exchange rate if autoupdate is disabled with an option to update for that specific time alone as well otherwise?
4,146 04/14/2015 06:26:46 am
Topic: FA Forum Registrations Stats (0 replies, posted in Reporting)
Today is Tamil New Year's Day. Let us hope Tamil makes it to the list of FA languages officially (it is there in my unofficial GitHub Repo though).
Attached is a snapshot of the last 1001 registrations in the FA Forums.
4,147 04/14/2015 06:23:29 am
Re: Add Currency Symbol at Invoice Top (8 replies, posted in Accounts Receivable)
Thanks for the policy decision - any rationale?
4,148 04/14/2015 05:37:31 am
Re: Journal Inquiry (2 replies, posted in Reporting)
Would it then not clutter the standard listing of the transaction summary listing? Some vouchers could have huge GL postings like Opening balances and P & L Transfers.
4,149 04/14/2015 05:35:12 am
Re: Add Currency Symbol at Invoice Top (8 replies, posted in Accounts Receivable)
The function get_exchange_rate_from_to() calls the following functions in the same file includes/banking.inc:
1. get_exchange_rate_to_home_currency($from_curr_code, $date_)
2. get_exchange_rate_from_home_currency($currency_code, $date_)
The first one is the arithmetic inverse of the second one.
All currency exchange rates in FA are relative to the home currency.
The sql used in the second function (lines 91, 92) is:
SELECT rate_buy, max(date_) as date_ FROM ".TB_PREF."exchange_rates WHERE curr_code = ".db_escape($currency_code)."
AND date_ <= '$date' GROUP BY rate_buy ORDER BY date_ Desc LIMIT 1The date_ <= $date is key to the record being pulled out.
Should it not be for all future transactions by making it date_ >= $date ?
After all, when we get an exchange rate from a provider (YAHOO, ECB, BLOOMBERG, GOOGLE, etc) it should be for all future transactions till the next one is obtained and not for all past transactions.
@joe: your take?
4,150 04/13/2015 09:22:07 pm
Re: Add Currency Symbol at Invoice Top (8 replies, posted in Accounts Receivable)
If SGD is the home currency, get the exchange rate of the alternate currency say USD here. The exchange rate of the home currency will always be "1". The Supplier / Customer Currency needs to be used for the Supplier / Customer Invoice respectively.