Search options (Page 54 of 246)

@itronics: An example of "separate identifier for every user" would be useful. Otherwise, all would have to wade thru the code for it. This may be explained in the Wiki. The following lists the possibilities.

Lines 55-66 in includes/references.inc:

$refline_placeholders = array(
    'MM' => 'date',
    'YY' => 'date',
    'YYYY' => 'date',
    'UU' => 'user',
     'P' => 'pos',
//     FIXME:  for placeholders below all the code should work, but as the ref length is variable,
//       length specification in placeholder format should be implemented.
//    'C' => 'customer',
//    'B' => 'branch',
//    'S' => 'supplier',
//    'L' => 'location'

Lines 302-332:

        $regex = preg_replace(
            array(
                '/\\\{/',    // unquote placeholders
                '/\\\}/',
                '/\{MM\}/',
                '/\{YY\}/',
                '/\{YYYY\}/',
                '/\{C\}/',
                '/\{B\}/',
                '/\{S\}/',
                '/\{L\}/',
                '/\{UU\}/',
                 '/\{P\}/',
                '/\{\d+}/',
            ),
            array(
                '{',
                '}',
                $month,
                $year2,
                $year4,
                $cust,
                $branch,
                $supp,
                $location,
                $user,
                 $pos,
                '\d+',
            ), $regex);

        $regex = '"^'.$regex.'"i';

The said variable is defined in config.php:

$comp_path = $path_to_root.'/company';

Line 11 in repgen_print.php includes session.inc which in turn includes the sysprefs.inc file in line 374 which in turn includes the config.php file above in line 31 which assigns the needed value to $comp_path.

Attached is the fully fixed extension from my repo.

There has been a couple of commits (1, 2) to rectify this error after the FA v2.4.5 release. Upgrade to FA 2.4.6 and all should be well.

@anoopmb: The changed files zip is a dead link.

Have you seen the ajax search box means of choosing an item, supplier or customer by using the appropriate checkboxes in the company setup form? Similar paged lists are also available for items, suppliers and customers in some other forms on pressing the search icon (magnifying glass) beside those fields.

There is nothing in the codebase during the Nov commits that should generally invoke such a situation. Did the hosting provider change the PHP/MySQL versions? What are your current PHP/MySQL versions? Also check if the next reference number is really the next reference number in your DB tables, if not make it accordingly.

These tests can be a separate project instead of integrating with the core as it will be used by developers only. Thanks @cambell for your offerings and keep up the good work. Hope the current release tests well.

Attached is the set of changed files between FA 2.4.5 and FA 2.4.6.

1. SF zip Snapshot of the Release.
2. SF Release from Kent Mirror
MD5: 24b531463579a2aea5e840c97cddb81991c54253
Size: 1,574,175 bytes

JAN (Japanese Article Numbering) is another name for the EAN-13 barcode. The first two digits - the country code - must be 45 or 49 (Japan).

Upgrade notes:
1. New translation string GL # in your language
2. Index of your Exchange Rate Provider in config.php file if synched to the new config.default.php file may need to be changed.

First 2 day SF download stats shows UK, followed by India and then Indonesia. Singapore clocked 192 downloads on 2018-12-27 (and Pakistan 27 on 2019-01-09) at SF which is clearly an aberration to skew results and needs to be deducted from date range results that encompass it.

Unresolved issues hitherto are at this post.

The following should do the trick:

include $path_to_root."reporting/includes/barcode.php";

function is_valid_barcode($code, $type) {
    $barcode = new TCPDFBarcode($code, $type);
    $chk = $barcode->getBarcodeArray();
    return ($chk !== false);
}

The possible barcode types that tcpdf supports in FA are:

$barcode['C39']['name']     = 'CODE 39';
$barcode['C39+']['name']    = 'CODE 39 with checksum';
$barcode['C39E']['name']    = 'CODE 39 EXTENDED';
$barcode['C39E+']['name']   = 'CODE 39 EXTENDED with checksum';
$barcode['I25']['name']     = 'Interleaved 2 of 5';
$barcode['C128A']['name']   = 'CODE 128 A';
$barcode['C128B']['name']   = 'CODE 128 B';
$barcode['C128C']['name']   = 'CODE 128 C';
$barcode['EAN2']['name']    = '2-Digits UPC-Based Extension';
$barcode['EAN5']['name']    = '5-Digits UPC-Based Extension';
$barcode['EAN8']['name']    = 'EAN 8';
$barcode['EAN13']['name']   = 'EAN 13';
$barcode['UPCA']['name']    = 'UPC-A';
$barcode['UPCE']['name']    = 'UPC-E';
$barcode['POSTNET']['name'] = 'POSTNET';
$barcode['CODABAR']['name'] = 'CODABAR';

The id field of the 0_item_codes table is the Primary Key that can be used instead of the stock_id or the item_code field for linking into the additional fields extension's tables.