4,826 Reply by apmuthu

(5 replies, posted in Wish List)

Customise reports in reporting/repXXX.php and place in your company path - hard code anything you need if it is constant.

Go to forum: Wish List

4,827 Reply by apmuthu

(13 replies, posted in Reporting)

This can be generically included in the core by having a form field to included the report preparer's name / username printed or not for appropriate documents that can be invoices, quotations, etc.

I have included a generic implementation using a hard_coded flag variable and enabled for Sales Quotations along with a screenshot.

@joe - you can include it in the core with any mods thought fit.

Go to forum: Reporting

4,828 Reply by apmuthu

(13 replies, posted in Wish List)

Wiki-ed it.

Go to forum: Wish List

4,829 Reply by apmuthu

(6 replies, posted in Accounts Payable)

It is already in the Wiki under Invoicing Notes.

Go to forum: Accounts Payable

4,830 Reply by apmuthu

(8 replies, posted in Setup)

check file and folder permissions and db user permissions.

Go to forum: Setup

4,831 Reply by apmuthu

(21 replies, posted in Manufactoring)

@joe:
Just wanted to know if such a feature exists!
And if so, what are the menu click and entry sequences to achieve it.
Not the code behind it.

Go to forum: Manufactoring

4,832 Reply by apmuthu

(1 replies, posted in Jobs wanted/offered, non-free offers)

Translation:
Hi I need to make modifications to Frontaccounting to work in my country Chile, I need support from someone who speaks Spanish, please write to my email mgarces@intelicom.cl thank you very much.

===

Don't worry - just read the forum in Google Translated Spanish and fill in the mistakes improving Google Translate!
Install language es_CL
Install CoA es_ES


Translated:
No se preocupe - Acabo de leer el foro en Google Traducido española y complete los errores mejorando Google Translate!

Go to forum: Jobs wanted/offered, non-free offers

4,833 Reply by apmuthu

(6 replies, posted in Accounts Payable)

After all, the invoice is the only document you will always want to email to the customer if you ever email them at all!
Thanks @joe for this very simple answer right before our eyes....

Go to forum: Accounts Payable

4,834 Reply by apmuthu

(21 replies, posted in Manufactoring)

@joe: I did not mean this code. I meant:

How is the work flow managed in FA when a single BoM is used to produce a set of products and not just one product.
How does the system handle the stock moves then?

Go to forum: Manufactoring

4,835 Reply by apmuthu

(6 replies, posted in Accounts Payable)

Refer this post.

Go to forum: Accounts Payable

4,836 Reply by apmuthu

(21 replies, posted in Manufactoring)

Your flow is wrong.
There must be a stock transfer when you use a BoM to manufacture - whether it is one or more products. In your flow, you are preventing any stock transfer in the second sql if there is only one product - if the $nope is actually one or more products made.

@joe, how is this implemented in FA for now? Should he use kits in manufacture?

Go to forum: Manufactoring

4,837 Reply by apmuthu

(21 replies, posted in Manufactoring)

The syntax is correct. The next statement is returning from the function with an array of fields from the first sql instead of an integer that should be the last insert id of the second sql. The calling script is expecting an integer in return.

Go to forum: Manufactoring

4,838 Topic by apmuthu

(0 replies, posted in Report Bugs here)

Please fix the combo box selection css for the standard themes to accomodate the standard choices and stay within the width of the longest textarea and textbox widths.

--- old/themes/aqua/default.css    Mon Sep 29 21:21:28 2014
+++ new/themes/aqua/default.css    Tue Nov 18 18:19:02 2014
@@ -43,7 +43,7 @@
 }
 
 select {
-    max-width: 200px;
+    max-width: 230px;
 }
 
 option.inactive {
--- old/themes/cool/default.css    Mon Sep 29 21:21:28 2014
+++ new/themes/cool/default.css    Tue Nov 18 18:18:44 2014
@@ -43,7 +43,7 @@
 }
 
 select {
-    max-width: 200px;
+    max-width: 230px;
 }
 
 option.inactive {
--- old/themes/default/default.css    Mon Sep 29 21:21:28 2014
+++ new/themes/default/default.css    Tue Nov 18 18:17:32 2014
@@ -43,7 +43,7 @@
 }
 
 select {
-    max-width: 200px;
+    max-width: 230px;
 }
 
 option.inactive {

The before and after screenshots of MS Internet Explorer 6 (same in FF 33 as well) are in the attachments.

Go to forum: Report Bugs here

4,839 Reply by apmuthu

(21 replies, posted in Manufactoring)

Check which statement is causing the blank by commenting out your code block and then working in.

Is your test case passing into the initial if code block at all? If so, it will just return (that's what your code directs)  without doing anything since there is just 1 record.

Go to forum: Manufactoring

4,840 Reply by apmuthu

(2 replies, posted in Accounts Payable)

Should you need to create Supplier for GRN items and another for the same Supplier for non GRN as well?

It is also possible to write off one time (Non GRN) expenses directly as a Journal Voucher with the Supplier name and other details in the description!

Go to forum: Accounts Payable

4,841 Reply by apmuthu

(21 replies, posted in Manufactoring)

The variable $nope is just the first record if it passes the initial single record if check when the second sql is attempted. Otherwise if there is only 1 record, the second sql will not be attempted at all. This variable is sought to fill in the discount_percent field.

What are you trying to do?

What happens if there are no results from the first sql? You will be assigning null to a not null field or boolean false to a integer field. The following may work after the initial single record if check fails.

$nope =  ($row[0] ? $row[0] : 0);

Go to forum: Manufactoring

4,842 Reply by apmuthu

(21 replies, posted in Manufactoring)

What version of PHP / MySQL are you using?

Some of the later PHP versions expect that the first $result must be a resultset and not a boolean (false) for the next db_num_rows to work.

Try the function by just displaying the sqls and not executing them and then try to manually execute the sqls in phpmyadmin and you will see the error that arises.

Go to forum: Manufactoring

4,843 Reply by apmuthu

(7 replies, posted in Announcements)

FA ERD subset updated on Wiki - Account Masters Relationship to POS.

Go to forum: Announcements

4,844 Reply by apmuthu

(3 replies, posted in Manufactoring)

Thanks @elax for your seasoned perspective. Using excessive stock or turning it into a service item may be the best for most instances after all!

Go to forum: Manufactoring

4,845 Reply by apmuthu

(21 replies, posted in Manufactoring)

In file manufacturing/work_order_entry.php lines 264-266:

    $id = add_work_order($_POST['wo_ref'], $_POST['StockLocation'], input_num('quantity'),
        $_POST['stock_id'],  $_POST['type'], $_POST['date_'],
        $_POST['RequDate'], $_POST['memo_'], input_num('Costs'), $_POST['cr_acc'], input_num('Labour'), $_POST['cr_lab_acc']);

function add_work_order() above is defined in 3 files in manufacturing/includes/db folder =>
work_orders_db.inc,
work_orders_quick_db.inc and
work_order_issues_db.inc
all of which get added when manufacturing/manufacturing_db.inc is included - this will cause only the first occurrence of the function definition to be taken, viz., from work_orders_db.inc unless the preferred one is included earlier!

Search for the add_stock_move function call in any of them and work your way through.

Go to forum: Manufactoring

4,846 Reply by apmuthu

(1 replies, posted in Setup)

Most certainly.

Go to forum: Setup

4,847 Reply by apmuthu

(21 replies, posted in Manufactoring)

function add_stock_move()
in
includes/db/inventory_db.inc

Go to forum: Manufactoring

4,848 Topic by apmuthu

(2 replies, posted in Report Bugs here)

ECB Exchange rate provider (FA default 0) needs the following patch since the URL has been moved permanently and the IP has changed.

It is safe_mode setting that needed to be checked and not the non existent save_mode as listed.

--- old/gl/includes/db/gl_db_rates.inc    Mon Sep 29 21:21:28 2014
+++ new/gl/includes/db/gl_db_rates.inc    Sun Nov 16 20:31:15 2014
@@ -112,7 +112,7 @@
     if ($provider == 'ECB')
     {
         $filename = "/stats/eurofxref/eurofxref-daily.xml";
-        $site = "www.ecb.int";
+        $site = "www.ecb.europa.eu";
     }
     elseif ($provider == 'YAHOO')
     {
@@ -141,15 +141,15 @@
            curl_setopt ($ch, CURLOPT_COOKIEJAR, "$path_to_root/tmp/cookie.txt");
            curl_setopt ($ch, CURLOPT_HEADER, 0);
            curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
-           // prevent warning while save_mode/open_basedir on (redireciton doesn't occur at least on ECB page)
-           if (!ini_get('save_mode') && !ini_get('open_basedir'))
+           // prevent warning while safe_mode/open_basedir on (redireciton doesn't occur at least on ECB page)
+           if (!ini_get('safe_mode') && !ini_get('open_basedir'))
                curl_setopt ($ch, CURLOPT_FOLLOWLOCATION, 1);
            curl_setopt ($ch, CURLOPT_TIMEOUT, 3);
            $contents = curl_exec ($ch);
            curl_close($ch);
             // due to resolver bug in some curl versions (e.g. 7.15.5) 
             // try again for constant IP.
-           $site="195.128.2.97";
+           $site="172.230.157.137";
        } while( ($contents == '') && $retry--);
        
     } else {

Go to forum: Report Bugs here

4,849 Topic by apmuthu

(0 replies, posted in Installation)

A default FA install comes with lang/en_US/LC_MESSAGES/en_US.mo file which is UTF-8 encoded. Therefore it must be included in the lang/installed_languages.inc file like:

<?php

/* How to make new entries here for non-packaged languages:

-- 'code' should match the name of the directory for the language under \lang
.-- 'name' is the name that will be displayed in the language selection list (in Users and Display Setup)
-- 'rtl' only needs to be set for right-to-left languages like Arabic and Hebrew
-- 'encoding' used in translation file
-- 'version' always set to '' for manually installed languages.
-- 'path' installation path related to FA root (e.g. 'lang/en_US').
*/


$installed_languages = array (
  0 => 
  array (
    'code' => 'C',
    'name' => 'English',
    'encoding' => 'iso-8859-1',
  ),
  1 => 
  array (
    'code' => 'en_US',
    'name' => 'English US UTF8',
    'encoding' => 'utf-8',
    'path' => 'lang/en_US',
    'version' => '',
  ),
);

$dflt_lang = 'C';
?>

Now when we install the en_US ISO 8859-1 version from the official repo, the new mo and po files with the version number as part of their filename get into the same folder along with the original en_US UTF-8 encoded file.

Now only the official ISO encoded en_US is available in the language choice drop down boxes.

When we now uninstall the official en_US ISO language, the whole en_US folder gets deleted including the original UTF-8 encoded mo file.

If the original path is changed from en_US to en_US_UTF8 to prevent such deletion, then it does not show up as part of the installed languages!

Go to forum: Installation

4,850 Reply by apmuthu

(8 replies, posted in Setup)

company/0/backup/
company/1/backup/
..
..

The path is set in the config.php file.

Go to forum: Setup