Will post more when I know more

I am using Indonesian's COA btw

Cheers

The Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.

This appears to be a false positive as the balances (without zeroes for clarity) do actually tally.

Cannot duplicate your date picker error - is it specific to your choice of date format? The en_US date format seems to work okay.

If so, what might contribute a 404 error ?

*Update : I did purge. However whenever there is a select date From and To. The To will use datepicker but with 'undefined' Month, whereas the value should've been July / August / other months accordingly

code wise, there may be some mini error to 'TransToDate' function ?

from gl_trial_balance.php

<td><input type="text" name="TransToDate" class="date"  size="10" maxlength="12" value="31/07/2018" > 
<a tabindex='-1' href="javascript:date_picker(document.getElementsByName('TransToDate')[0]);">    
<img src='../../themes/default/images/cal.gif' style='vertical-align:middle;padding-bottom:4px;width:16px;height:16px;border:0;' alt='Click Here to Pick up the date'></a>

The function get_js_date_picker() in includes/ui/ui_view.inc includes the said file and generates the js include code based on user select options.

Hence purge the said file in the js_cache and it should get generated anew and all should be well.

I'm using v2.4.3 with Indonesian's 4 Digit COA. I can confirm that in apmuthu's GitHub the 'memo_' field is there, it's probably didn't make way to official sourceforge yet ? That's the FA version that I downloaded and what currently in use

After adding the 'memo_' field, I now notice something FUNNY with datepicker.js ( It complains 404 ! when you want to pick a date ). I have no idea where it comes from; I swear the only modification I made was adding the 'memo_' field to my budget_trans table. There's no correlation between these two, right ?

version 2.4.3 - new installation. not an upgrade from previous version

I'm using Indonesian's Chart of Accounts. Any chance that may be the 'culprit' ?

A similar DB schema check will need to be done for all tables and for all records in lookup tables.
Note that the default document numbering system now has a pattern template in FA 2.4.x.

Some Chart of Accounts in FA 2.3.x and even in FA 2.4.x have field order differences with the standard sql/en_US-new.sql chart.

After synch-ing the chart, then see if an upgrade withing FA is necessary (Setup=>Software Upgrade). In each instance backup before and after such interventions.

Does this indicate that everything is ok?

You should have done all this and then upgraded to FA v2.3.26 and then if all was well, attempt to do an upgrade to FA 2.4.4 and then verify that the resultant schema is in consonance with the tables and field orders and the new config.php settings and new sys_prefs table records - above all, the schema being in synch with the latest sql/en_US-new.sql.

CREATE TABLE `0_budget_trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tran_date` date NOT NULL DEFAULT '0000-00-00',
  `account` varchar(15) NOT NULL DEFAULT '',
  `memo_` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `dimension_id` int(11) DEFAULT '0',
  `dimension2_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
) ENGINE=InnoDB;

It has just 7 fields and the memo_ field is the 4th one.

Which Chart of Accounts did you start out with?

BTW, from Company setup: Database Scheme Version    2.4.1

Bruce

ALTER TABLE `0_budget_trans` MODIFY `memo_` tinytext NOT NULL;
ALTER TABLE `0_comments` MODIFY `memo_` tinytext;
ALTER TABLE `0_gl_trans` MODIFY `memo_` tinytext NOT NULL;
ALTER TABLE `0_supp_invoice_items` MODIFY `memo_` tinytext;
ALTER TABLE `0_voided` MODIFY `memo_` tinytext NOT NULL;

Do not make any change to your current schema unless you are sure of the direction of change (from which schema to which) for now.