1,276 Reply by apmuthu

(1 replies, posted in Setup)

https://www.youtube.com/watch?v=7qW_ReF60aU
https://www.howtoforge.com/one_machine_mysql_replication
https://www.toptal.com/mysql/mysql-master-slave-replication-tutorial
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
https://dba.stackexchange.com/questions/63159/fastest-way-to-create-local-copy-of-live-innodb-mysql-database

Go to forum: Setup

1,277 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

As all your data is in ar_EG, what is the account code for your P&L Account? The sys_prefs table shows it as: 9990. There is also such an account in the chart_master table. Why did you have other accounts after the P&L account like:

,('9990','','الربح / الخسارة للعام','23',0)
,('9991','','م. سولار وبنزين السيارات','22',0)
,('9992','','مصروفات نثرية متنوعة','50',0)
,('9994','','محمد سلطان - دائنون','41',0)
,('9995','','م. كهرباء','50',0)
,('9996','','صيانة عقار','50',0)
,('9997','','م. مياة','50',0)
,('9998','9998','غرامات ','50',0)
,('99982','','اغلاق العام','23',0)
,('9999','9999','م كارته ','50',0);

-- Translation

, ('9990', '', 'profit / loss for the year', '23', 0)
, (1999), M. Solar and Benzin Motor, 22, 0)
, ('9992', 'Miscellaneous sundry expenses', '50', 0)
, (9994', '' Mohamed Sultan - creditors', '41', 0)
, ('9995', '', 'M. electricity', '50', 0)
, ('9996', '', 'maintenance of property', '50', 0)
, ('9997', '', 'M. water', '50', 0)
, ('9998', '9998', 'Fines', '50', 0)
, ('99982', '', 'General Fines', '23', 0)
, ('9999', '9999', 'M Karate', '50', 0);

?

You cannot have sub-ledger accounts across different chart classes.

Go to forum: Banking and General Ledger

1,278 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

File not visible in BSNL, India

Go to forum: Banking and General Ledger

1,279 Reply by apmuthu

(2 replies, posted in Jobs wanted/offered, non-free offers)

Fork the project on GitHub and commit your changes with notes - good development model. Your changes can also be pulled into the core for sustainable upgradation.

Go to forum: Jobs wanted/offered, non-free offers

1,280 Reply by apmuthu

(11 replies, posted in FA Modifications)

The following sys_prefs parameters:

default_loss_on_asset_disposal_act
depreciation_period

have their length field value in quotes.
Automated systems looking for these gotchas beware.

Go to forum: FA Modifications

1,281 Reply by apmuthu

(11 replies, posted in FA Modifications)

The text and tinytext fields have " COLLATE utf8_unicode_ci" now.
The table and field ordering should be the same in both en_US-sql and en_US-demo.sql to make for ease of comparison and error detection. Changes between commits should be easily spottable especially in such core files.
It is okay to keep the comment as "--" for now.

Go to forum: FA Modifications

1,282 Reply by apmuthu

(11 replies, posted in FA Modifications)

It appears that the dashboard_reminders and dashboard_widgets tables are now present in the new en_US-demo.sql file. The comment character is a condensed "#" instead of the multi line "--". This makes it difficult to compare with the en_US-new.sql which has the "--" as it's comments character. Some sys_prefs items are also missing.

Go to forum: FA Modifications

1,283 Reply by apmuthu

(27 replies, posted in Setup)

Post your bounty and specs on the Job Offers Board.

Go to forum: Setup

1,284 Reply by apmuthu

(4 replies, posted in Setup)

Contact UK users like:

@dvarsani
@dls
@kerrsmith
@bailey86
@geoffreywalton
@londondaveuk

Go to forum: Setup

1,285 Topic by apmuthu

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

Here is a list of Extensions for FA 24 from the Official Extensions Repo as on date:

39 Charts
20 Extensions
41 Languages
16 Themes

# Charts

chart_de_AT-general-2.4.1-3.pkg
chart_en_PH-general-2.4.1-4.pkg
chart_en_US-general-2.4.1-4.pkg
chart_en_CA-general-2.4.1-4.pkg
chart_en_GB-general-2.4.1-5.pkg
chart_en_US-4digit-2.4.1-4.pkg
chart_zh_CN-general-2.4.1-4.pkg
chart_de_DE-general-2.4.1-4.pkg
chart_ro_RO-general-2.4.1-4.pkg
chart_sl_SI-general-2.4.1-4.pkg
chart_pl_PL-general-2.4.1-4.pkg
chart_sv_SE-general-2.4.1-4.pkg
chart_nl_NL-general-2.4.1-4.pkg
chart_nb_NO-general-2.4.1-4.pkg
chart_en_ZA-general-2.4.1-4.pkg
chart_en_AU-service-2.4.1-4.pkg
chart_en_IN-general-2.4.1-4.pkg
chart_en_US-5digit-2.4.1-4.pkg
chart_de_CH-5digit-2.4.1-3.pkg
chart_en_US-service-2.4.1-4.pkg
chart_fr_CA-general-2.4.1-4.pkg
chart_en_SG-general-2.4.1-4.pkg
chart_en_FR-general-2.4.1-4.pkg
chart_id_ID-4digit-2.4.1-4.pkg
chart_en_AU-general-2.4.1-4.pkg
chart_zh_HK-general-2.4.1-4.pkg
chart_ar_EG-english-2.4.1-3.pkg
chart_es_ES-general-2.4.1-4.pkg
chart_ka_GE-general-2.4.1-4.pkg
chart_hu_HU-general-2.4.1-4.pkg
chart_en_US-nonprofit-2.4.1-4.pkg
chart_en_US-GAAP-2.4.1-4.pkg
chart_en_US-demo2-2.4.1-4.pkg
chart_ar_EG-GAAP-2.4.1-3.pkg
chart_ar_EG-general-2.4.1-3.pkg
chart_id_ID-general-2.4.1-4.pkg
chart_de_CH-general-2.4.1-3.pkg
chart_da_DK-general-2.4.1-3.pkg
chart_fr_FR-general-2.4.1-4.pkg

# Extensions

import_transactions-2.4.0-5.pkg
repgen-2.4.0-4.pkg
rep_annual_balance_breakdown-2.4.0-4.pkg
rep_check_print-2.4.0-3.pkg
fronthrm-2.4.0-1.pkg
rep_cash_flow_statement-2.4.0-2.pkg
import_paypal-2.4.0-1.pkg
rep_statement_reconcile-2.4.0-1.pkg
import_items-2.4.0-3.pkg
rep_inventory_history-2.4.0-1.pkg
rep_sales_summary-2.4.0-1.pkg
rep_cheque_print-2.4.0-1.pkg
rep_annual_expense_breakdown-2.4.0-2.pkg
auth_ldap-2.4.0-3.pkg
rep_dated_stock-2.4.0-1.pkg
rep_tax_cash_basis-2.4.0-1.pkg
zen_import-2.4.0-4.pkg
import_multijournalentries-2.4.0-3.pkg
requisitions-2.4.0-3.pkg
osc_orders-2.4.0-3.pkg

# Languages

hi_IN-2.4.2-2.pkg
en_ZA-2.4.1-3.pkg
en_US-2.4.1-3.pkg
ka_GE-2.4.1-3.pkg
de_CH-2.4.1-3.pkg
es_NI-2.4.1-3.pkg
pt_BR-2.4.1-3.pkg
es_MX-2.4.1-3.pkg
es_PA-2.4.1-3.pkg
it_IT-2.4.1-3.pkg
id_ID-2.4.1-3.pkg
en_IN-2.4.1-3.pkg
de_DE-2.4.1-3.pkg
es_ES-2.4.1-3.pkg
nl_BE-2.4.1-3.pkg
bg_BG-2.4.1-3.pkg
es_CL-2.4.1-3.pkg
ur_PK-2.4.1-3.pkg
hu_HU-2.4.1-3.pkg
en_NZ-2.4.1-3.pkg
pt_PT-2.4.1-3.pkg
sl_SI-2.4.1-3.pkg
nl_NL-2.4.1-3.pkg
bs_BA-2.4.1-3.pkg
en_AU-2.4.1-3.pkg
es_CO-2.4.1-3.pkg
sv_SE-2.4.1-3.pkg
pl_PL-2.4.1-3.pkg
fr_FR-2.4.1-3.pkg
zh_CN-2.4.1-3.pkg
ru_RU-2.4.1-3.pkg
nb_NO-2.4.1-3.pkg
ro_RO-2.4.1-3.pkg
el_GR-2.4.1-3.pkg
ta_IN-2.4.2-3.pkg
es_AR-2.4.1-3.pkg
ar_EG-2.4.1-3.pkg
da_DK-2.4.1-3.pkg
zh_TW-2.4.2-1.pkg
sq_AL-2.4.1-3.pkg

# Themes

graypink-2.4.0-1.pkg
response-2.4.0-4.pkg
fancy-2.4.0-1.pkg
greyred-2.4.0-1.pkg
thinker-theme-2.4.0-1.pkg
grayblue-2.4.0-1.pkg
exclusive_db-2.4.0-1.pkg
graylime-2.4.0-1.pkg
modern-2.4.0-1.pkg
exclusive-2.4.0-1.pkg
newwave-2.4.0-1.pkg
bluecollar-2.4.0-3.pkg
studio-2.4.0-1.pkg
elegant-2.4.0-2.pkg
anterp-2.4.0-1.pkg
dynamic-2.4.0-3.pkg

Go to forum: Modules Add-on's

1,286 Reply by apmuthu

(11 replies, posted in FA Modifications)

Fork the FA24Extensions repo and change what you want.

Go to forum: FA Modifications

1,287 Reply by apmuthu

(4 replies, posted in Setup)

1. Yes. Use the Git Master for now.
2. Read the Wiki and Forum Posts and contact fellow UK users.
3. Make / or have made an extension for it if you cannot make do with standard UI.
4. Country specific features can be used through custom extensions contracted for - place offers in the Job Board.

Remember, that FA users span almost every country on the net. Any country specific features should generally be provided with suitable web links for more info so that those outside your country may also be leveraged to assist you.

Recently, there has been a surge in UK based downloads of FA and hence you are in adequate company!

Go to forum: Setup

1,288 Reply by apmuthu

(11 replies, posted in FA Modifications)

Better to make it dynamic where SQL user variables are suitably populated and used.

Go to forum: FA Modifications

1,289 Reply by apmuthu

(1 replies, posted in Report Bugs here)

@joe: Thanks.

It now stands committed.

Go to forum: Report Bugs here

1,290 Topic by apmuthu

(1 replies, posted in Report Bugs here)

The recent commit addressed only one double semicolon line ending.
The following files all need have one or more of them removed:

admin\attachments.php
fixed_assets\includes\fa_classes_db.inc
gl\includes\db\gl_db_trans.inc
inventory\view\view_transfer.php
js\behaviour.js
manufacturing\view\wo_issue_view.php
purchasing\view\view_po.php
reporting\rep451.php
sales\customer_credit_invoice.php
sales\includes\db\customers_db.inc
taxes\tax_groups.php

@joe: Kindly take in the changes from the commit in my repo.

Attached is the list of changed files and their consolidated diff.

Go to forum: Report Bugs here

1,291 Reply by apmuthu

(82 replies, posted in FA Modifications)

@notrinos: Thanks. The fix now includes the missing variable $title in the function arguments. It is also a property in the Widget class.

Go to forum: FA Modifications

1,292 Reply by apmuthu

(3 replies, posted in Report Bugs here)

@joe: ST_DIMENSION is referenced in the reflines table for type 40. If allowed, how did this get leftout for so long?

Go to forum: Report Bugs here

1,293 Reply by apmuthu

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

Just install from official repo and then overwrite the files with the latest ones and then activate it for the desired companies and then activate the permissions for those companies roles.

The modules/_cache folder will have the remnants of module installations and the modules folder will have the module files in a fodler in it. Also the installed_extensions.php will have it listed if installed and will be also present in the various company counterparts where activated.

To manually install just copy over the module folder into the modules folder and then activate as normally done.

Go to forum: Modules Add-on's

1,294 Reply by apmuthu

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

Thought as much. Thanks @notrinos. Reverted it in my FA24Mods.

Go to forum: Modules Add-on's

1,295 Reply by apmuthu

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

This occurs because your CSV file is not properly formatted.
The list() statements in the files import_transactions.php and includes/import_transactions.inc populate the $code_id variable.

The possibilities where it could go wrong are at:

ST_JOURNAL:
  list($reference, $date, $memo, $amt, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $comments)
ST_BANKPAYMENT:
  list($reference, $date, $memo, $amt, $ignore, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $BranchNo)
ST_BANKDEPOSIT:
  list($reference, $date, $memo, $ignore, $amt, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $BranchNo)
ST_BANKDEPOSIT / ST_BANKPAYMENT:
  list($reference, $date, $memo, $amt, $code_id, $taxtype, $dim1_ref, $dim2_ref, $person_type_id, $person_id, $BranchNo)
ST_SALESORDER / ST_SALESINVOICE:
  list($customer_id, $branchNo, $reference, $date, $payment_id, $sales_type_name, $dimension_id, $dimension2_id, $item_code, $item_description, $quantity, $unit, $price, $discountpercentage, $freightcost, $delfrom, $deldate, $delto, $deladdress, $contactphone, $email, $custref, $shipvia, $comments, $exrate)

Go to forum: Modules Add-on's

1,296 Reply by apmuthu

(1 replies, posted in Installation)

Try an earlier version of PHP. Also set the file and folder permissions for the webserver user where write permissions are needed.

Go to forum: Installation

1,297 Reply by apmuthu

(82 replies, posted in FA Modifications)

@notrinos: You have placed a lot of widgets php files in the reporting folder - should they not be in a separate folder?

If some common css is needed for every theme, should they not be in a separate include file?

Go to forum: FA Modifications

1,298 Reply by apmuthu

(5 replies, posted in Report Bugs here)

This is useful when the supplier is not organised or is illiterate.

Go to forum: Report Bugs here

1,299 Reply by apmuthu

(82 replies, posted in FA Modifications)

@joe: will this affect the non dashboard default themes and if not, can it be included in the core?

Go to forum: FA Modifications

1,300 Reply by apmuthu

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

Check if the DB user in FA has the necessary permissions - use the debug feature in FA and check it out or take local professional assistance.

Go to forum: Modules Add-on's