A flag variable that enables / disables discount display would be a nice way to go.
4,476 02/04/2015 05:14:00 am
Re: How to remove discount column (4 replies, posted in Accounts Receivable)
4,477 02/03/2015 07:38:19 am
Re: email single invoice to multiple recipients (31 replies, posted in Accounts Receivable)
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.
4,478 02/03/2015 07:17:12 am
Re: change tax group of customer (3 replies, posted in Accounts Receivable)
That's right - voiding is necessary or a credit note / journal entry to contra the tax can also be done.
4,479 02/03/2015 07:12:42 am
Topic: xls mail patch (5 replies, posted in Reporting)
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
4,480 02/03/2015 05:00:51 am
Re: change tax group of customer (3 replies, posted in Accounts Receivable)
Change the Tax in the customer / branch:
Sales => Customer Branches => Choose branch to edit => Tax Group => ChooseTax Exempt.
4,481 02/03/2015 04:56:00 am
Re: email single invoice to multiple recipients (31 replies, posted in Accounts Receivable)
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.
4,482 02/03/2015 04:39:04 am
Re: How to create a template invoice? (4 replies, posted in Accounts Receivable)
It is detailed in the Wiki.
4,483 02/03/2015 04:37:19 am
Re: How to add a new field in sales delivery (3 replies, posted in FA Modifications)
Yes. The Non Field DB Data concept has now become available - see detailed instructions in the wiki.
4,484 02/03/2015 04:35:52 am
Re: Sales Order Page refresh codes (2 replies, posted in FA Modifications)
Instead of one more field, try to use the Hash delimited space separated Non Field DB Data in the long_description field. See how bin location was accommodated in FA v2.3 detailed in the wiki. This is an example of full disclosure that you may practice when creating tutorials.
4,485 02/01/2015 05:05:45 am
Re: Returnable Items (3 replies, posted in Items and Inventory)
When you bill the customer, just bill it as 2 items, one for the gas and the other for the empty cylinder and track the latter.
4,486 01/30/2015 07:44:02 am
Re: Mismatch between transaction and payment (7 replies, posted in Accounts Payable)
Your version and customisation is now dependant on the "php known girl" as it is married to her only. If you had submitted the changes back to the project, then it is possible that it may have been carried forward. Unless you provide adequate details, the community will find it hard to serve you.
What version of FA did you take to develop from?
What platform are you running it on?
What steps are needed to simulate your error as it may be generic to FA even now and went undetected?
Is MetisERP your brand name?
How long have you been using it and how much data has accumulated in it?
Expect that it is now in production use.
Have you changed the database schema / extended it?
Have you customised your reports?
Do you have a maintenance contract for your ERP?
Contact me offline and let me see how to bring you back into the core FA flock.
Many FA users in the enterprise level fail to provide a budget for ongoing maintenance and customise FA heavily that when their "developers" leave they are left high and dry. All of this brings all Open Source projects a lack of dependability tag since branded offerings tout the fact that they are there to serve them. In the case of FA, the community is there to serve but there is a cost for human time - the code is free though.
If you have benefited from the project please donate generously to it and help enhance it's useability by participating in the forums creditably.
4,487 01/30/2015 07:30:16 am
Re: Frontaccounting behind reverse proxy? (3 replies, posted in Installation)
Thanks for the feedback. Sharing is what makes the community dependable and trusted.
4,488 01/29/2015 04:08:15 pm
Re: Can Dimensions be added later? (3 replies, posted in Dimensions)
Attached is one I hammered out for you. Please complete the translations and submit it back for updating it in my GitHub repo.
Next time please post it as a different topic under the Charts of Accounts head.
4,489 01/29/2015 09:59:29 am
Re: Report generator (3 replies, posted in Modules Add-on's)
There are many report generators available based on PHP/MySQL/TCPDF and you can easily extend the FA reports by writing your own. Proprietary ones are pre-canned and limited to field level logic but you can customise FA reports to suit your needs. The project relies on "experienced FA advanced users" like yourself to extend it's functionality - welcome to the party.
Why not make a mockup graphic design of the reports you like so that some community member may want to and be able program it? If they are just some modifications to existing ones, then mark the add/delete/modify portions in them and link it here. For example, see this thread.
You may refer to this thread for a tutorial on report making in FA.
4,490 01/29/2015 09:51:39 am
Re: connection within the fields (2 replies, posted in Accounts Receivable)
Take a backup of the db.
Make 2 sales orders
Batch them into one invoice
Take another backup of the db
Compare the two backups and see what records get inserted into which tables and what keys are involved and provide feedback here so that the ERD diagrams in the wiki can be enhanced.
4,491 01/27/2015 07:40:11 pm
Re: Batch Invoice from Search Not Invoiced Deliveries - Failed (5 replies, posted in Accounts Receivable)
Thanks for the feedback. This will be the case when large reports are to be generated like when we have too many items.
Generally available since PHP v5.3.9 but Debian implemented it in PHP 5.3.3-7+squeeze7 but may be ignored (YMMV) but works in PHP 5.1.6.
Adding the directive into php.ini or placing following lines into .htaccess will work:
php_value max_input_vars 3000
php_value suhosin.get.max_vars 3000
php_value suhosin.post.max_vars 3000
php_value suhosin.request.max_vars 3000
Please note, you cannot set this directive in run-time with function ini_set(name, newValue).
The best way is to compact all form data using javascript.
On the receiving side you cannot use the PHP parse_str() function because the max_input_vars directive affects this function too, so you need something else like my_parse_str().
Otherwise, the serialize and JSON.stringify may work together.
4,492 01/27/2015 01:47:44 pm
Re: How to remove discount column (4 replies, posted in Accounts Receivable)
Name the url you see for the forms and the repXXX number you see for the reports - take detailed snapshots and mark the areas you do not want to see, fix a price and put it into the Job/Offers forum topic and wait for someone interested in taking it up.
If however, you wish to attempt it on your own, then here is the info to start you off. The Invoice script is reporting/rep107.php and it's line 128 can be commented out like:
// $rep->TextCol(5, 6, $DisplayDiscount, -2);
or just blanked out like:
$rep->TextCol(5, 6, "", -2);
and the heading for the column is in reporting/includes/doctext.inc in line 30:
_("Unit"), _("Price"), _("Discount %"), _("Total"));
where the Discount % label may be a blank string or removed out depending on whether you commented out the earlier one or just made it display a blank string as well.
4,493 01/27/2015 01:45:06 pm
Re: WO with multiple items (7 replies, posted in Manufactoring)
Use a skeletal FA install.
Take a backup - 1.
Make a Sales Order 1.
Take a backup 2.
Make a Work Order 1 using the Sales Order 1 created above.
Take a backup 3.
Make a Sales Order 2.
Take a backup 4.
Make a Work Order 2 using the Sales Order 2 created now.
Take a backup 5.
You will now ave 4 incremental backup diffs from the above, based on which you should be able to figure out the sqls needed to bulk transform Sales Orders to Work Orders. The problem is to now segregate which Sales Order items are gotten from which Work Orders and their items.
That is why for simplified data entry and understanding, only one Sales Order is mapped into one Work Order for a 1:1 tracking. All other complex means that satisfy individual users are to be made as extensions which may be submitted tot he project so that it will be carried forward into future releases and benefit from user testing and improvement.
4,494 01/27/2015 01:33:31 pm
Re: Batch Invoice from Search Not Invoiced Deliveries - Failed (5 replies, posted in Accounts Receivable)
Increase script timeout value in php. - max_execution_time.
It may also need more memory - memory_limit.
Try to choose half and see if it is successful, and progressively increase / decrease it to check when it hits the limit.
4,495 01/26/2015 11:02:40 am
Re: FA v2.4 development (48 replies, posted in Setup)
The standard Charts of Accounts have redundant indices. A cleaned up set is attached for incorporation into the current Hg repo.
4,496 01/26/2015 11:00:50 am
Re: What is FA (1 replies, posted in Installation)
FA is a full fledged Accounting Software with ERP extensions built in. Financial, Logistics, Manufacturing and simple document management along with a simple CRM are in it. If there is anything more you need in your ERP, you can extend FA with your custom extensions. It supports themes and multiple platforms for servers.
The best way would be for the end user or their consultant to try FA out firsthand for suitability.
Key metrics besides cost (free for code but need to pay for implementation and maintenance like all other ERP) would be:
1. time to migrate data in and out,
2. extend functionality and
3. no vendor lock-in for code and support and
4. no Damocles Sword of unknown legal liabilities and licencing issues.
4,497 01/25/2015 10:00:58 pm
Re: FA v2.4 development (48 replies, posted in Setup)
Today's snapshot of FA 2.4 installs correctly but reports will not display correctly unless line 759 of includes/current_user.inc - function company_path() is changed from:
return ($comp_path[0]=='.' ? $path_to_root.'/'.basename($comp_path) : $comp_path);
to
return $path_to_root.'/'.(in_array($comp_path[0], Array('.', '/')) ? $comp_path : basename($comp_path));
(devs have been notified)
In FA 2.3, in config.php:
$comp_path = $path_to_root.'/company';
In FA 2.4, in config.php:
$comp_path = dirname(__FILE__).'/company';
Now relative paths too can be used. If they are outside the webroot, either an apache conf alias or a symlink may be used.
The equivalent of the default for reporting purposes is:
$comp_path = '../company';
and if it is to be reporting/company:
$comp_path = './company';
and if at the webroot:
$comp_path = '/company';
The use of relative addressing was generally fraught with various path value consequences but now that a wrapper function is used, all should be well.
All upgrades will now have a log file at tmp/upgrade.#.log where # is the company number. (Attached screenshot).
Logs can now be viewed from within FA - themes may need to accommodate it if hardcoded.
A new patch class has been made and the upgrade php files now use it.
Default utf-8 collation of the database changed from general to unicode.
4,498 01/25/2015 02:01:04 pm
Re: Page numbering on invoices report (5 replies, posted in Reporting)
You can use the Non Field DB Data feature of FA and design your own invoices accordingly. The functional elements are already in FA v2.4 and are available as backports in my GitHub repo's FAMods folder. This way, you do not need any extra field for it and it can remain in the same field itself using hash delimited space separated elements.
Assisting you with this is outside the scope of the FA forum and you will need to either do it yourself or seek professional assistance.
The specific function that does this job is the last one in reporting/includes/reporting.inc file in the FA v2.4 Mercurial repo.
4,499 01/25/2015 01:29:32 pm
Re: modify direct invoice later (3 replies, posted in Accounts Receivable)
That is why I stated in my previous post that you only make Sales Orders and not Invoices during the month and make the invoice only after all changes have been made to the Sales Orders and that too only at the end of the month!
4,500 01/25/2015 01:27:38 pm
Re: Quickbooks to FrontAccounting conversion (1 replies, posted in Modules Add-on's)
Check out some of the extensions already in FA. The pkg files are individually available (and updated in many cases) in my GitHub repo.