5,901

(13 replies, posted in Wish List)

The alter sql file can now have the following extra line:

INSERT INTO `0_sys_prefs`(`name`,`category`,`type`,`length`,`value`) VALUES ('bcc_email', 'setup.company', 'varchar', 100, '');

Yes, the function check_write() in includes/main.inc should cover the lang folder check as well.

In install/index.php mustn't there be a check to see if lang folder is writeable?

    if (!file_exists($path_to_root . "/lang/installed_languages.inc")) {
        $installed_languages = array (
            0 => array ('code' => 'C', 'name' => 'English', 'encoding' => 'iso-8859-1'));
            $dflt_lang = 'C';
            write_lang();
    }

OK!

5,904

(11 replies, posted in Setup)

@Janusz

The empty.po (and other language files possibly) have your dev machine path set like

#: /home/janusz/FA/fa_stable/Repo/srcs/2.3/requisitions/_devel/../hooks.php:16 

Very extensive work indeed. Congrats.

@Janusz
You're right. I'll post the actual changes in another extension in another post. The attachment was a jumble up of an extension that was in the process of testing the parameters. The extension name change to Item Sales Summary Report may have been appropriate in the light of a similarly named one in the Customer Reports.

5,906

(6 replies, posted in Reporting)

@Janusz
Thanks for the error correction. I'll post the actual changes in another extension in another post. The attachment was a jumble up of an extension that was in the process of testing the parameters.

@flort
The effective correction is to the sql in the rep_sales_summary.php at line 41:

".TB_PREF."debtor_trans_details.quantity

equivalently changed to

SUM(".TB_PREF."debtor_trans_details.quantity) AS quantity

and with aliases in actual code now being

SUM(line.quantity) as quantity

Since there is already a standard report by the same name under Customer Reports, it may have been better to name this report as Item Sales Summary Report.

Wikied the screenshots of both reports:

Customer Sales Summary Report
Item Sales Summary Report

5,907

(3 replies, posted in FA Modifications)

Please be specific.

What is the sequence of menu options
Which version of FA
In what browser and version

did the issue arise?

On your annotations, let us address them one at a time:

Need to address Row Alignment:

You have missed out a blank array element at the last:

Lines 144-146 in sales/includes/ui/sales_order_ui.inc

    $th = array(_("Item Code"), _("Item Description"), _("Quantity"),
        _("Delivered"),
        _("Unit"), $order->tax_included ? _("Price after Tax") : _("Price before Tax"), _("Discount %"), _("Total"), "");

For you should be:

$th = array(_("Confirmation"), _("Source"), _("Avg Rate"), 
        _("Stay"), 
        _("Gross"), $order->tax_included ? _("Our Charge") : _("Price before Tax"), _("GDS"), _("Total"),"");

Check if you also need to increase the col span for the other rows at line 225 (of the original file):

    $colspan = 6;

to be

    $colspan = 7;

5,909

(1 replies, posted in FA Modifications)

Could be default variables injected for Quick Entries or specific instance of certain voucher entry types for invoices.

The stated code appears only once and it is in the function sales_order_item_controls() in the file sales/includes/ui/sales_order_ui.inc.

It is used for Ajax requests for dynamic form population from previously entered values.

Some screenshots on your current invoice table can show what needs to be done - see that the arguments to the insert sql and the output of the form post variables match.

Attached a fresh Customer Sales Summary Extension for v2.3.13-1

5,912

(4 replies, posted in Installation)

You're right Janusz, but it is used in many places acceptably.

The said function is called in:

includes\current_user.inc
    Line 613: function flush_dir($path, $wipe = false)
    Line 621:             flush_dir($path.'/'.$fname, $wipe);
  includes\packages.inc
    Line 29: //                flush_dir($basedir, true);
    Line 102:             flush_dir($targetdir, true);
    Line 428:         flush_dir(PKG_CACHE_PATH.'/'.$name, true);
  includes\lang\language.php     Line 59:             flush_dir(company_path().'/js_cache');
  admin\db\company_db.inc     Line 92:     flush_dir(company_path().'/js_cache'); // clear cache
  admin\inst_theme.php     Line 55:         flush_dir($dirname, true);
  admin\inst_lang.php     Line 256:         flush_dir($dirname, true);
  admin\display_prefs.php    Line 51:         flush_dir(company_path().'/js_cache');   
  admin\create_coy.php     Line 226:     @flush_dir($tmpname, true);

The function can be altered to reflect the hg repo files since CVS is no longer used:

function flush_dir($path, $wipe = false) 
{
    $dir = opendir($path);
    if(!$dir)
        return;
    while(false !== ($fname = readdir($dir))) {
        if($fname=='.' || $fname=='..' || $fname=='CVS' || (!$wipe && $fname=='index.php')) continue;
          if(is_dir($path.'/'.$fname)) {
            flush_dir($path.'/'.$fname, $wipe);
            if ($wipe) @rmdir($path.'/'.$fname);
        } else
            @unlink($path.'/'.$fname);
    }
}

5,913

(8 replies, posted in Accounts Receivable)

Wikiied it.

5,914

(5 replies, posted in Installation)

Maybe the specific IIS install uses Basic Auth by default and needs to be turned off. Thanks Janusz.

5,915

(4 replies, posted in Installation)

It is actually on the "not-safe side" unless we try to delete a non existant folder which is covered by the "if" check.

The said library file has been used in numerous open source projects and not even in one of them is it commented out.

Some projects it is in use are:
LifeType
OntoWiki
ZenPhoto
Automne-CMS
b2evolution

Wikiied as a prequisite for installation.

5,917

(16 replies, posted in Setup)

Which version are you using?

Try the latest Mercurial v2.3.13 Build 3122 attached.

5,918

(1 replies, posted in Report Bugs here)

In the file admin/inst_module.php, shouldn't the line 116

        $is_mod = $ext['type'] == 'module';

be

        $is_mod = $ext['type'] == 'extension';

Better still, have the line removed as the $is_mod variable is not used anywhere at all.

In the file includes/ui/ui_lists.inc, shouldn't the line 2213

        if ($ext['type'] == 'module' && !$ext['active'])
            $tabs[$ext['tab']] = access_string($ext['title'], true);

be

        if ($ext['type'] == 'extension' && !$ext['active'])
            $tabs[$ext['tab']] = access_string($ext['title'], true);

Also the subsequent line refers to the $ext['tab'] variable coming from $installed_extensions array that has been commented out in includes/packages.inc file in lines 128, 494, 671-672.

On a similar note, consequent to the gross changes in the extensions / plugins system in FA v2.3+, the file sql/alter2.3.php has the line 297 as part of a commented out block.

check apache error logs for issues and hints to where typos may exist.

5,920

(4 replies, posted in Modules Add-on's)

@kusuma

Unless you are up to programming PHP it is better to go with supported programs like AntERP - @tclim has provided several plugins, contributed enough code and is knowledgeable in FA - you are likely to find his products fit in well with FA. Likewise other SOAP proponents too can provide support and LogicWorks can tailor it for FA being a fork, though does not say so online.

5,921

(11 replies, posted in FA Modifications)

FA uses the PHP mail() function to send mail.

There are other mature libraries like PHPMailer that have a host of options including SMTP relaying enabling you to use hotmail / gmail / yahoo mail to send out your emails but you need to patch them in or create a module for it.

Please read the PHP mail() function and the comments there in to configure your Windows box to relay mail.

When using the PHP mail() function with IIS 6 on Windows Server 2003, check your "Relay" settings on the SMTP Virtual Server in IIS.  If you grant access to 127.0.0.1 and set then set your php.ini SMTP to the same IP address (along with setting the same port 25), you should have success in sending mail.

Allocations appears on both sides of the website's first 2 column feature list summary.

5,923

(4 replies, posted in Modules Add-on's)

Commercial applications that interface with FrontAccounting are AntErp and Logicworks CounterLogic.

Roll your own using any of the Restful APIs - check out the SipleAPI Module and others on the Wiki and / or contact Support.

5,924

(5 replies, posted in Installation)

Ref - MS KB and Troubleshooting IIS.

Check if the .htaccess file is being used or set it's equivalent in the IIS so that Basic Authentication error will go off.

Installed the Debian Archiver using apt-get install binutils. This makes the ar binary available.

Installed the Sales Summary Report Extension from the default Repo and made corrections to the files in modules/rep_sales_summary. Now try to re-package it after setting the correct sha1sums.

The following does not produce FA compatible pkg from the above already installed one:

cd /var/www/frontac/modules/rep_sales_summary
ar rcs ../rep_sales_summary-2.3.3-1.pkg  \
       ../_cache/rep_sales_summary-2.3.3-1/_init/config \
       ../_cache/rep_sales_summary-2.3.3-1/_init/files \
       index.php \
       reporting/index.php \
       reporting/rep_sales_summary.php \
       reporting/reports_custom.php