Search options (Page 122 of 247)

Till this is done, try to get hold of one set of transactions' sql inserts / updates and make an sql for creating a new supplier invoice/goods_receipt/payment from the differences in the sql backups before and after it and use that in any mysql client when operating in exclusive mode during that time.

Lines 40-41 of the file gl/view/gl_trans_view.php:

    label_cell($myrow["reference"]);
    label_cell(sql2date($myrow["tran_date"]));

can now be changed to

    label_cell($myrow["reference"], "nowrap align=center ");
    label_cell(sql2date($myrow["tran_date"]), "nowrap align=center ");

to center the Reference and Date field values.

You are on your own if you try to run FA stable on PHP 7 though the wiki and the forum have pointers to others efforts. Later versions of MySQL have the non zero date issue as well where the '0000-00-00 00:00:00' and '0000-00-00' are not accepted in datetime / timestamps.

Also check the cache of your browser and make sure it is cleared on exit and the new user logs in from a new instance of the browser after all instances have been closed.

1. Take a sql backup.
2. perform your FA Transaction
3. Take another sql backup
4. Compare both backups using diff in Linux or WinMerge in Windows.
5. You will have all the sqls that have occurred / db changes for the transaction.

When you complete a FA transaction, you will see a link to the Journal Entries.

Payable / Procure to Pay (P2P) is a SAP term.

Where? Did you mean CustomerID on Customer List Report?

This means that either you
1. skipped the install process or
2. your folder permissions did not allow the creation of the file /lang/installed_languages.inc during the install process or
3. Your path to webroot is wrongly set somewhere possibly in the extension's files.

A sample /lang/installed_languages.inc file would be 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',
  ),
);

$dflt_lang = 'C';

No.

No approvals in default FA.
All entries stand posted on creation.

It will not be an ERP then. Might as well have ExcelAccounting....

The FrontReport class property $companyLogoEnable needs to be enabled. It is false by default in it's class method Info().

In most if not all reporting/repXXX.php files there will be a line like:

$rep->Info($params, $cols, $headers, $aligns);

Just change it to:

$rep->Info($params, $cols, $headers, $aligns, , ,  true);

The actual prototype for it is:

function Info($params, $cols, $headers, $aligns,
        $cols2 = null, $headers2 = null, $aligns2 = null,
        $companylogoenable = false, $footerenable = false, $footertext = '')

@joe: Should we not have a config file switch for it or atleast a preference setting on a per company basis?

Employee attendance and reports can be done completely outside of FA unless you need to tie in with accounting / salaries.

Try Adminer or Radicore to get it done.