1,351 Reply by apmuthu

(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.

Go to forum: Modules Add-on's

1,352 Reply by apmuthu

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

Go to forum: Modules Add-on's

1,353 Reply by apmuthu

(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.

Go to forum: Modules Add-on's

1,354 Reply by apmuthu

(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)?

Go to forum: FA Modifications

1,355 Reply by apmuthu

(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.

Go to forum: FA Modifications

1,356 Reply by apmuthu

(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.

Go to forum: Reporting

1,357 Reply by apmuthu

(12 replies, posted in Reporting)

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

Go to forum: Reporting

1,358 Reply by apmuthu

(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

Go to forum: FA Modifications

1,359 Reply by apmuthu

(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.

Go to forum: Report Bugs here

1,360 Reply by apmuthu

(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.

Go to forum: Report Bugs here

1,361 Reply by apmuthu

(20 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

1,362 Reply by apmuthu

(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,

Go to forum: Report Bugs here

1,363 Reply by apmuthu

(4 replies, posted in Reporting)

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

Go to forum: Reporting

1,364 Reply by apmuthu

(5 replies, posted in Banking and General Ledger)

This is some quirk of choosing rows in alphabetical or some other order in the sqls used.

Go to forum: Banking and General Ledger

1,365 Reply by apmuthu

(6 replies, posted in Setup)

No. No updates like you thought. Only the parameters are saved in the browser form for the duration of the login session for use in other or same report for change of only some parameters and not having to shoose every option each time.

Go to forum: Setup

1,366 Reply by apmuthu

(12 replies, posted in Reporting)

Attached are the outputs obtained before and after the change.

Go to forum: Reporting

1,367 Reply by apmuthu

(4 replies, posted in Announcements)

Post Release Fixes.

Changes:
1. New translation string: GL #
2. New Reports: Customer (115) and Supplier (206) Trial Balance Reports
3. New Exchange Rate Providers: EXCHANGE-RATES.ORG, CCA

Also the index of exchange rate providers has changed in the config file.

Go to forum: Announcements

1,368 Reply by apmuthu

(7 replies, posted in Report Bugs here)

@notrinos, kindly check rep202.php as well. I do not have the later PHP versions at the moment to test.

Go to forum: Report Bugs here

1,369 Reply by apmuthu

(7 replies, posted in Report Bugs here)

The same problem should be there in line 214 of rep202.php as well.

Go to forum: Report Bugs here

1,370 Reply by apmuthu

(8 replies, posted in Items and Inventory)

@itronics: Please have a look. Will need to revert the line 363 changes in inventory/manage/items.php

Go to forum: Items and Inventory

1,371 Reply by apmuthu

(7 replies, posted in Report Bugs here)

This might be a specific case of the $trans[$i] being an integer and the $rate being a (float).

@joe: This can be committed.

Go to forum: Report Bugs here

1,372 Reply by apmuthu

(6 replies, posted in Setup)

Search the forums - some users have created commercial and open source themes and may be willing to share them. Study the existing theme files and use the bootstrap library to make FA mobile friendly and submit it back to the project for inclusion into the core.

Go to forum: Setup

1,373 Reply by apmuthu

(6 replies, posted in Setup)

When you wish to generate a report, you first go to a report request form where you enter the parameters for the report. Some of these parameters are same in many reports. Once you generate one report, your report parameter choices will get saved and be available as the defaults for the same or other reports that have the same parameters and you can edit only the ones that are different for the new report needed.

The filenames are quite random and the folder location is the same. Yes, no usernames or passwords are needed to access it and hence you are expected to quickly delete such cache when done preferably through a cron job.

Go to forum: Setup

1,374 Reply by apmuthu

(5 replies, posted in Banking and General Ledger)

Then try with all the Cr Entries first and then enter the Dr entries and see what the output is.

Go to forum: Banking and General Ledger

1,375 Reply by apmuthu

(14 replies, posted in Accounts Receivable)

It works in PHP 5.3.1 on WinXP3 as well (XAMPP 1.7.3).

Go to forum: Accounts Receivable