2,476 Reply by apmuthu

(4 replies, posted in Accounts Receivable)

The customer summary was just occupying top space which was re-allocated for more records below. wink

Go to forum: Accounts Receivable

2,477 Reply by apmuthu

(6 replies, posted in Translations)

The Preferences Tamil page is attached.

Go to forum: Translations

2,478 Reply by apmuthu

(39 replies, posted in Report Bugs here)

There is no need to check for !$no_menu again as we are already inside an if which has already done so.
Also, the add_access_extensions(); is placed between the two divs of class fa-body and fa-content like in the other themes. If done earlier, what happens was not determined. As it is an independent check, the earlier the better but it should have necessary pre-requisites to perform it's job. If we retain it as you suggested, we lose the graphic plot display in the dashboards.

Attached is the latest version.

What about the default dropdown theme in FA 2.4.x?
@joe: must some reconciliation be done between the two?

Go to forum: Report Bugs here

2,479 Topic by apmuthu

(3 replies, posted in Setup)

When using the FA24Extensions repo (or any Git repo), if you want just one extension, it is advisable to paste the folder URL into GitZip to get it. It is written using jQuery and is available on GitHub.

http://kinolien.github.io/gitzip/

To vreate a download link to a specific Git subfolder, paste the URL into DownGit and get it. It is written in javascript and is available on GitHub.

https://minhaskamal.github.io/DownGit/#/home

Go to forum: Setup

2,480 Topic by apmuthu

(0 replies, posted in Translations)

The php-gettext wrapper project is useful for Windows Users who do not have the appropriate locale installed or gettext is not compiled in.

See the comment there.

For those who do not wish to use composer, there is a testgt folder in the attachment that merely uses normal file includes.

Walk thru the various language versions in my FA24extensions/Languages repo with:

find */_init -name config -type f -exec grep ^Version '{}' \;

Go to forum: Translations

2,481 Topic by apmuthu

(6 replies, posted in Translations)

@itronics: Thanks for heeding this long pending request.

FA's official pkg repo now has both Tamil (ta_IN) and Hindi (hi_IN) translations of the core.

Go to forum: Translations

2,482 Reply by apmuthu

(7 replies, posted in Banking and General Ledger)

Use the GL Inquiry if you want Bank Payment and Deposit entries.
Use Tax Inquiry only for the Taxes alone.

Go to forum: Banking and General Ledger

2,483 Reply by apmuthu

(39 replies, posted in Report Bugs here)

Use this file and see (rename as php and use) for dropdown theme.

Lines 163-164:

            echo "<div class='fa-body'>\n";
            echo "<div class='fa-content'>\n";

have been replaced with:

            echo "<div class='fa-body'>\n";
            if (!$no_menu)
                add_access_extensions();
            echo "<div class='fa-content'>\n";

Go to forum: Report Bugs here

2,484 Reply by apmuthu

(5 replies, posted in Setup)

Schema update / synch scripts added to my repo - FA23, FA24.

FA 2.4 Schema optimisations consolidated

- @joe/@itronics can vet it for inclusion in the core.

Go to forum: Setup

2,485 Reply by apmuthu

(39 replies, posted in Report Bugs here)

The Dropdown theme was not updated by the author.
It is based on the Dynamic theme.
Compare the files between the two if you have issues.
Attached is the Dropdown theme after making $SysPrefs fixes.
Updated in my FA24Extensions Repo.

Go to forum: Report Bugs here

2,486 Reply by apmuthu

(5 replies, posted in Setup)

In MySQL 5.0 and later, TEXT/BLOB fields cannot have default values.

The only case in FA where it occurs is in the sys_prefs table and that too only in FA 2.4.x:

`value` TEXT NOT NULL DEFAULT '',

It should be:

`value` TEXT NOT NULL,

In FA 2.3.x it was:

`value` tinytext,

Go to forum: Setup

2,487 Reply by apmuthu

(39 replies, posted in Report Bugs here)

There is no constant SA_CSVIMPORT in any of the themes and the FA core. It is possible you got it from one of your extensions or the official import_items extension. My extensions repo has the updated files (attached) for the official extension and see if they mitigate your issue.

Go to forum: Report Bugs here

2,488 Reply by apmuthu

(5 replies, posted in Setup)

After cleaning up the entire standard Chart of Accounts, we are left with the following CHAR fields (whilst all else have been mostly changed to VARCHAR):

0_bank_accounts:  `bank_curr_code` char(3) NOT NULL DEFAULT '',
0_crm_persons:  `lang` char(5) DEFAULT NULL,
0_currencies:  `curr_abrev` char(3) NOT NULL DEFAULT '',
0_debtors_master:  `curr_code` char(3) NOT NULL DEFAULT '',
0_exchange_rates:  `curr_code` char(3) NOT NULL DEFAULT '',
0_journal:  `currency` char(3) NOT NULL DEFAULT '',
0_prices:  `curr_abrev` char(3) NOT NULL DEFAULT '',
0_stock_category:  `dflt_mb_flag` char(1) NOT NULL DEFAULT 'B',
0_stock_master:  `mb_flag` char(1) NOT NULL DEFAULT 'B',
0_stock_master:  `depreciation_method` char(1) NOT NULL DEFAULT 'S',
0_suppliers:  `curr_code` char(3) DEFAULT NULL,

Go to forum: Setup

2,489 Reply by apmuthu

(14 replies, posted in Accounts Payable)

Attachments are a privilege permission set by the board admin.
Screenshots of web pages with mostly text are best captured in PNG format for small size and less pixelation on enlargement.

Void the Supplier Credit Note in the Setup tab and then enter a new one.

Go to forum: Accounts Payable

2,490 Reply by apmuthu

(7 replies, posted in Banking and General Ledger)

The existing SQL to debug is:

SELECT 
    SUM(IF(trans_type=21,-1,1) *
    IF((reg_type=0) || ((trans_type IN (20,21) OR (trans_type=0 AND reg_type=1))
        ), net_amount*ex_rate,0)
    ) net_output

    , SUM(IF(trans_type=21,-1,1) *
    IF((reg_type=0) || ((trans_type IN (20,21) OR (trans_type=0 AND reg_type=1))
        ), amount*ex_rate,0)) payable

    , SUM(IF(trans_type IN (21),-1,1) *
    IF(reg_type=1 AND tax_type_id AND taxrec.rate, net_amount*ex_rate, 0)) net_input


    , SUM(IF(trans_type IN (21),-1,1) *
    IF(reg_type=1 AND tax_type_id AND taxrec.rate, amount*ex_rate, 0)) collectible,
    taxrec.rate,
    ttype.id,
    ttype.name

FROM 0_trans_tax_details taxrec LEFT JOIN 0_tax_types ttype ON taxrec.tax_type_id=ttype.id
WHERE taxrec.trans_type IN (10, 11, 20, 21, 0)
-- AND taxrec.tran_date >= '$fromdate'
-- AND taxrec.tran_date <= '$todate'
GROUP BY ttype.id;

Go to forum: Banking and General Ledger

2,491 Reply by apmuthu

(3 replies, posted in FA Modifications)

All numbers/prices/amounts are entered as is and then the system formats it as needed.
The home currency is assumed.
input_num may be needed.

@joe: does it need to change?

Go to forum: FA Modifications

2,492 Reply by apmuthu

(9 replies, posted in Setup)

Close your previous fiscal years and purge them of their data.

Go to forum: Setup

2,493 Reply by apmuthu

(7 replies, posted in Banking and General Ledger)

This issue does not prevail in FA 2.3 and hence the above fix only addresses the output and not the underlying db fetch function in FA 2.4. Attached is the FA 2.3 output without the above fix and it works perfectly.

Therefore the function get_tax_summary() in gl/includes/db/gl_db_trans.inc needs to be investigated and it is different from it's FA 2.3 counterpart.

The new avatar has an extra parameter $also_zero_purchases set to false by default.

Go to forum: Banking and General Ledger

2,494 Reply by apmuthu

(18 replies, posted in Report Bugs here)

Consequent on this commit, all existing DBs may be updated with:

ALTER TABLE `0_debtor_trans`
    CHANGE `debtor_no` `debtor_no` INT(11) UNSIGNED NOT NULL, 
    DROP PRIMARY KEY, ADD PRIMARY KEY (`trans_no`, `type`, `debtor_no`);

ALTER TABLE `0_supp_trans`
    CHANGE `supplier_id` `supplier_id` INT(11) UNSIGNED NOT NULL, 
    DROP PRIMARY KEY, ADD PRIMARY KEY (`trans_no`, `type`, `supplier_id`);

Go to forum: Report Bugs here

2,495 Reply by apmuthu

(7 replies, posted in Banking and General Ledger)

Good catch @andijani.

The Tax Inquiry page is at gl/inquiry/tax_inquiry.php. and it's line 91:

        $collectible = $tx['collectible'];

should be: 

        $collectible = -$tx['collectible'];

If the Outputs/Inputs column too should get the appropriate signs, then make line 104 show the negative value.

This issue prevails in FA 2.3.x (line 95) as well and wonder how it went unchecked for so many years.

@joe: can commit it.

Go to forum: Banking and General Ledger

2,496 Reply by apmuthu

(11 replies, posted in Report Bugs here)

The translations will be available when the lang/new_language_template/LC_MESSAGES/empty.po is refreshed in the next release. In the meanwhile you are free to change your .po file and compile it into a .mo file and use it.

Go to forum: Report Bugs here

2,497 Reply by apmuthu

(15 replies, posted in Banking and General Ledger)

Please checkout the 'working' report from FA 2.3.22 (may need a few tweaks from the FA 2.4.2+ one) and see if all is as you desire. Then place it in your company/#/reporting folder to override the standard version and you should be good to go.

Go to forum: Banking and General Ledger

2,498 Reply by apmuthu

(12 replies, posted in Reporting)

Please take a look at the standard report and annotate it's image of what you would like to see and upload and post the link here.

Almost all reports have their skeletal outputs in image format in the wiki for reference.

Go to forum: Reporting

2,499 Topic by apmuthu

(1 replies, posted in Report Bugs here)

Lines 568-572 of purchasing/includes/ui/invoice_ui.inc:

    if ($mode == 1)
    {
        $ret = display_grn_items_for_selection($supp_trans, $k);
        $colspan = 10;
    }

should be:

    if ($mode == 1)
    {
        $ret = display_grn_items_for_selection($supp_trans, $k);
        $colspan = 9;
    }

Go to forum: Report Bugs here

2,500 Reply by apmuthu

(15 replies, posted in Banking and General Ledger)

See the diffs between the rep709.php across the versions to revert to whichever functionality you want.

Go to forum: Banking and General Ledger