1,301

(4 replies, posted in FA Modifications)

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.

1,302

(5 replies, posted in Setup)

The only place in the current FA 2.4.x that the said $HTTP_RAW_POST_DATA variable is used is in includes/JsHttpRequest.php twice in line 263.

@joe: any changes envisaged? If so, would it break older installs?

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.

1,304

(2 replies, posted in Dimensions)

Thanks for the explanation.

1,305

(1 replies, posted in FA Modifications)

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.

1,306

(2 replies, posted in Dimensions)

@braathwaate has a commit in his fork that incorporates Dimensions into payments.
@joe: can vet and see if it can be included in the core.

@braathwaate's commits that partakes of his custom functions are also worth a look.

1,307

(2 replies, posted in Announcements)

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.

CODE128 supports the entire ASCII set (Type B has lower and upper case as well) and would be useful if a mere character check is inculcated till a complete induction occurs. Also choice of Barcode Type may be included in the sys_prefs table. That would ofcourse preclude the use of multiple types of Barcodes in the same company.

The above test will fail if CODE128 or those other than the leading ones like EAN% and UPC% are checked since the foreach() traverses the array in order of the array elements. The earliest "true" when returned may not be right!

Whilst testing is in progress, a flag to suppress Barcode validation may be preferred.

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';

1,310

(11 replies, posted in Reporting)

Updated the Wiki with the screenshots.

Whilst the Suppliers Trial Balance Report has a hot key (T), the Customer Trial balance Report does not have any. Also naming styles (plurals) can be standardised.

A recent commit restricts BarCodes to be generated only if the stock_id is an integer.

This was done since the Barcode generation routine generated errors on malformed input as a stop-gap arrangement since the auto generation of Barcode stock_id was restricted to a random / sequential available number.

The file /reporting/includes/barcodes.php manages Barcode generation and is taken from the TCPDF Library.

In the said library above, each type of barcode is properly generated with the appropriate methods listing the valid ASCII codes and size range / limits along with check-digit computations and verification where enabled.

The following links in reference are in order:
1. Make BarCode
2. BarCode Resource
3. Keyence

Clearly, the stock_id and item_code fields are VARCHAR in the FA DB and several BarCode formats support alphanumeric characters (CODE128, Codabar, etc) and some even symbols too.

Currently available libraries:
1. A Zend Library Validation of BarCode "code" input is also available.
2. A JavaScript Validation of a few barcode formats are available here.

The need now is to hammer out a function to validate the stock_id before allowing the generation of the barcode in pure PHP without external dependancies so that errors don't get generated while doing so during generation.

Any suggestions?

Blindly suppressing all errors during Barcode generation and leaving it blank when not possible to generate on for whatever reason is a simplistic but effective choice for many.

1,312

(4 replies, posted in Announcements)

Unresolved issues:

1. Older issues that still remain unresolved are at this post.
2. Items Commit issue - Problem in View of an already Created Item whose Code is Same as that of any GL Code.
3. Barcode of stock_id restricted to integers as a stop gap arrangement discussed in this post. This is as of the commit on 2018-12-22.

1,313

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

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.

1,314

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

The following is all you will need:

CREATE TABLE `0_addlflds` (
  `FldName` varchar(30) NOT NULL,
  `TblName` enum('Customers','Suppliers','Items') NOT NULL,
  `FldType` enum('Text','Number','Date','DateTime','TimeStamp','Bool') NOT NULL,
  `FldSize` varchar(255) NOT NULL,
  `FldUIType` enum('EditBox','SelectBox','TextArea','Password','CheckBox','Radio','MultiSelect') NOT NULL,
  `FldUIChoices` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`FldName`)
) ENGINE=InnoDB;

CREATE TABLE `0_addlfld_values` (
  `TblPKid` int(10) unsigned NOT NULL,
  `FldName` varchar(30) NOT NULL,
  `FldVal` varchar(255) NOT NULL,
  PRIMARY KEY (`TblPKid`,`FldName`)
) ENGINE=InnoDB;

1,315

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

Included in my unofficial repo for FA 2.4.x extensions.

Cut down on the number of extra tables. Keep just one table for all lookup value tables. Can also use json stored in single field for it as well.

1,316

(7 replies, posted in FA Modifications)

The version details in FA for Kanban are okay for third party non-official extensions.
What version of PHP  (php -v) are you using and on what platform/version?
What PHP modules do you have enabled (php -m)?

1,317

(7 replies, posted in FA Modifications)

The kanban code I last updated in my repo is at:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/kanban

The entire extension is attached herewith from there.

1,318

(4 replies, posted in Reporting)

The background colour can be set as one of the TCPDF native functions.

Check the spelling of the QuickSand.php file and use it accordingly as the error shows a different spelling.

1,319

(12 replies, posted in Reporting)

Try playing around with where the New Page line needs to be added.

1,320

(7 replies, posted in FA Modifications)

The application installs okay and the tab is present. Some installs may need to logout and login again. The pages are not visible for the links in the kanban application as the files may not have been uploaded correctly.

- see if the said file exists:
http://divabuilders.org/news/modules/kanban/manage/projects.php

1,321

(20 replies, posted in Report Bugs here)

@joe: Please include the fixes to ECB in my previous post and @boxygen's currencyconverterapi.com (CCA) as exchange providers.

CCA's output of:

https://free.currencyconverterapi.com/api/v5/convert?q=USD_EUR&compact=y

is a json value formatted like:

{"USD_EUR":{"val":0.875505}}

The reverse currency rate check for large decimal differences like IDR => KWD is not accounted for in it as yet.

1,322

(20 replies, posted in Report Bugs here)

ECB exchange rate can be fixed by modifying from line 139 onwards in gl/includes/db/gl_db_rates.inc:

    if ($provider == 'ECB')
    {
        $filename = "/stats/eurofxref/eurofxref-daily.xml";
        $site = "www.ecb.europa.eu";
        $proto = 'https://';
        $site_ip="172.230.157.137";
        $contents=file_get_contents($proto.$site.$filename);
    }

Also remove the trailing tab character in the config.default.php file for the $xr_providers line.

1,323

(20 replies, posted in Report Bugs here)

https://fx-rate.net/USD/GBP/
Shows rate for 1000 units of source currency

1,324

(20 replies, posted in Report Bugs here)

ECB allows download of some rates at:
https://www.ecb.europa.eu/stats/eurofxref/eurofxref.zip

After extracting the CSV from the ZIP file, the following format of 32 exchange rates in Euros are there:

Date, USD, JPY, BGN, CZK, DKK, GBP, HUF, PLN, RON, SEK, CHF, ISK, NOK, HRK, RUB, TRY, AUD, BRL, CAD, CNY, HKD, IDR, ILS, INR, KRW, MXN, MYR, NZD, PHP, SGD, THB, ZAR, 
18 December 2018, 1.1377, 127.86, 1.9558, 25.753, 7.4675, 0.89715, 323.11, 4.2848, 4.6467, 10.2760, 1.1281, 139.00, 9.8835, 7.4048, 76.1678, 6.0782, 1.5810, 4.4366, 1.5249, 7.8455, 8.8976, 16472.76, 4.2812, 80.2530, 1284.35, 22.8293, 4.7579, 1.6556, 60.390, 1.5590, 37.277, 16.3106, 

1,325

(4 replies, posted in Reporting)

footer.inc
doctext.inc
header2.inc
rep107.php