It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
Can print the on screen view of the Invoice as it is text in proper format.
Win7 still comes with a driver for EpsonLQ-compatible dot-matrix machines, and the latter can achieve 360 dpi when all the pins are working. Changing the printer settings to higher CPI helps the print quality be better. This link may be useful.
The Annual Breakdown Reports for detailed Balance and Expenses in the official package repo need fixes to work as desired.
Ross Addisson has found the bug:
My one company is skipping excel printing and printing pdf instead for the Annual Expense/Balance Breakdown Detailed extensions. Annual Expense Breakdown (Non-detailed) is printing Excel however
...
...
The fixes are in my GitHub Repo.
The fix for inclusion of the dimension2 parameter in the request form is in this commit.
The fix for the parameter order issue is in this commit.
The Wiki has been updated with screenshots of these reports.
Since the devs are busy with FA v2.4, do not expect these to enter into the repo any time soon.
If the local machine is connected to the win8 xampp server, map the latter's ip address in the former's c:\windows\system32\drivers\etc\hosts file againsta the Fully Qualified Domain name you would generally access FA from the internet side.
Please describe your network more completely as to which machines have the FA application running and which machines need to access it from which networks.
Is your FA running in Win7/8 or only the client browser in it?
If your FA is running in Linux, then CUPS printing is possible. If in Windows, check out Internet Printing Protocol or use one of the windows tools above where moving pdfs to a monitored folder will enable instant printing.
In FireFox, Tools => Options => Applications => Choose the PDF application and set what you want.
Configure the printer in FA using Port 515 or 9100 (open on your router) and use CUPS / IPP from your Linux server. Then set it in the Printer profile in FA.
Edit php.ini in your webserver - increase the value of the variable max_execution_time from 30 (secs) to say 120 or 180 or more depending on the time it takes to prepare your report. You will need to restart your webserver process generally.
Your SQL will not work as it will only pull out the immediately prior transaction alone and we cannot rely on an auto-increment field when multiple users will use it and many records per transaction will occur even if it is restricted to quick-entries since other transactions too may use the accounts in question.
Try the following in the en_US-demo.sql Training Company and compare it with the actual data in the 1_gl_trans table (2150 is Sales Tax):
SELECT amount, counter, account FROM `1_gl_trans`
WHERE counter IN (SELECT counter-1 FROM `1_gl_trans` WHERE account=2150);There are some errors in the standard UK CoA (as also the Canadian one) in the schema and unless you created your own CoA probably based on the en_US-new.sql CoA or any other proper one, chances are that some FA operation will fail and no one would be the wiser.
The corrected standard UK CoA is in my GitHub repo.
The project devs are busy with getting FA v2.4 out the door, the pkg repo remains to be updated.
Please let us know how we can make the wiki better by submitting a screenshot with info overlaid to be meaningful in context.
The Sales Order Entry page and the Sales Order Inquiry page have the necessary info besides a forum post that discussed it now marked as SOLVED.
I am not clear as to how you populated your contact data.
All email addresses must reside in the #_crm_persons table. All many-to-many linkages are in the #_crm_contacts table where the entity_id will indicate the source table's id (customer => debtor_master table, branch => cust_branch table, supplier, etc). The person_id refers to the id of the crm_persons table. The ERD is self-explanatory.
Now please check your relevant records in the crm_contacts, crm_persons, cust_branch and debtors_master tables and list the sequence you undertook to populate them.
Try to trace the source sql for the $contactData in the pdf_report.inc file.
Manually execute the SELECT sql obtained above and see what gives.
The #_exchange_rates table uses only the rate_buy field as the exchange rate in FA v2.3. The rate_sell field is populated with the same value using line 74 in gl/includes/db/gl_db_rates.inc:
add_exchange_rate($curr_code, $date_, $ex_rate, $ex_rate);You might want to directly populate the said table from your records - either a CSV import or using INSERT sql statements generated in a spreadsheet.
The structure of the said table is listed here for reference:
CREATE TABLE `0_exchange_rates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`curr_code` char(3) NOT NULL DEFAULT '',
`rate_buy` double NOT NULL DEFAULT '0',
`rate_sell` double NOT NULL DEFAULT '0',
`date_` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `curr_code` (`curr_code`,`date_`)
) ENGINE=MyISAM;Create a separate category for true services and pseudo services (non inventory items).
The actual wiki page on fiscal years does not have any info on the consequences of re-opening a closed fiscal year possibly by directly changing it in the table.
@joe: Any thoughts on it?
What I meant was the extra tabs in some lines added highlighted in the attachment.
Thanks Joe. Check the indents.
The immediate priority is to get everything in 2.4 working for all functionality that exists in 2.3 and hence the retention of the 2.3 repo. Many fixes to the standard CoAs too are yet to get into the core and rely on "initial auto upgrades" for now. Subsequent fixes to 2.3 have yet to be merged into 2.4 as well. All updated extension files are available in my GitHub repo including ones not in the official pkg repo.
As a short term measure, it may be okay to clone the 2.3 repo (or symlink it) and make the changes in the core to point to it.
In fact as on date, no updates have occurred to the 2.3 repo itself since 28th Dec, 2014, though many contributions have been received into the official mailbox as stated in the forums since then.
You can use the various APIs that already exist for FA.
Refer the wiki.
There is also a desktop offering of FA by one of the board members using PHP-Desktop.
A flag variable that enables / disables discount display would be a nice way to go.
Currently email is sent using the reporting/includes/class.mail.inc file's email class and that too only using reporting/includes/pdf_report.inc's End() method of the FrontReport class and the function send_reorder_email() in inventory/includes/inventory_db.inc (yes, there is no inventory/includes/db folder in FA 2.3). These wrapper function and method are the only ones that get mail sent in FA.
The email class' methods to(), cc() and bcc() are the ones that add email addresses to the respectively named class properties that get into the mail header before being sent.
Therefore the calling wrapper functions/methods must properly populate the email addresses into the appropriate array argument's to be passed on to the actuator functions in the email class.
Also see a related post.
That's right - voiding is necessary or a credit note / journal entry to contra the tax can also be done.
The current reporting/includes/class.mail.inc does not allow emailing of xls files. Also the CC and BCC constructs can be simplified using implode(). The following patch addresses them:
--- old/reporting/includes/class.mail.inc Mon Sep 29 21:21:28 2014
+++ new/reporting/includes/class.mail.inc Tue Feb 03 12:30:19 2015
@@ -97,6 +97,8 @@
if ($filename == $file . '.zip') return 'application/x-zip-compressed';
$file = basename($filename, '.pdf');
if ($filename == $file . '.pdf') return 'application/pdf';
+ $file = basename($filename, '.xls');
+ if ($filename == $file . '.xls') return 'application/vnd.ms-excel';
$file = basename($filename, '.csv');
if ($filename == $file . '.csv') return 'application/vnd.ms-excel';
$file = basename($filename, '.tar');
@@ -114,31 +116,17 @@
function send()
{
- // CC Empfänger hinzufügen
- $max = count($this->cc);
- if ($max > 0)
- {
- $this->header .= "Cc: ".$this->cc[0];
- for ($i = 1; $i < $max; $i++)
- {
- $this->header .= ", ".$this->cc[$i];
- }
- $this->header .= "\n";
- }
- // BCC Empfänger hinzufügen
- $max = count($this->bcc);
- if ($max > 0)
- {
- $this->header .= "Bcc: ".$this->bcc[0];
- for ($i = 1; $i < $max; $i++)
- {
- $this->header .= ", ".$this->bcc[$i];
- }
- $this->header .= "\n";
- }
+ // Add CC Recipients
+ if (!empty($this->cc))
+ $this->header .= "Cc: " . implode(", ", $this->cc) . "\n" ;
+
+ // Add BCC Recipients
+ if (!empty($this->bcc))
+ $this->header .= "Bcc: " . implode(", ", $this->bcc) . "\n" ;
+
$this->header .= "Content-Type: multipart/mixed;\n boundary=\"$this->boundary\"\n";
- // Attachment hinzufügen
+ // Add Attachments
$max = count($this->attachment);
if ($max > 0)
{In the file reporting/includes/excel_report.inc this will enable the creation of an equivalent method End() (what a name for a class method!) that now only exists in reporting/includes/pdf_report.inc file.
@joe: can incorporate into FA 2.4 and backport it.
References:
http://stackoverflow.com/questions/9740 … l-document
http://filext.com/faq/office_mime_types.php
Change the Tax in the customer / branch:
Sales => Customer Branches => Choose branch to edit => Tax Group => ChooseTax Exempt.
See if the function that gets the email addresses returns a scalar / one address only.
Also see if your sys_prefs table has this entry.
Also check if this post is relevant to this issue.
You may have to manually hard code in 2 or more email addresses into the routine that emails out and see if the emails sent actually get through php in the first place.
Some issues discussed in this post may be relevant as well.
It is detailed in the Wiki.
Yes. The Non Field DB Data concept has now become available - see detailed instructions in the wiki.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.