Search options (Page 190 of 246)

We now need to synch these changes into the default Chart of Accounts:

INSERT INTO `0_sys_prefs` VALUES ('default_quote_valid_days', 'glsetup.sales', 'smallint', 6, 30);

The code is done to auto create this entry but adding it to the CoA's is just for completion sake.

$trial = (isset($_POST['trial']) && ($_POST['trial']!=null)) ;

is way better.

What is the meaning of $trial = !null; ? Is the value true or false? Is it's value dependent on PHP version used?

This logic can certainly do with some housekeeping.

The fifth step has an incomplete line:

The individual language files are also available with all extensions in my Unofficial GitHub Repo.

Check the FA Support Page in the Wiki for a list of geographically dispersed FA support entities.

Is it because delivery date is hardcoded as yesterday, current or future date and was considered not necessary to be editable?

@geoffreywalton: Thanks for the checkout.

The payment_terms sql typo stands corrected as also the heading for the persons import para.

AUTO_INCREMENT=@person_id also does not work. I too actually used only hardcoded values and assumed that expressions would be acceptable. The wiki article now stands corrected with an assignment of zero (0) value that automagically acquires the correct value.

Which fields in which statement(s) is not in the same order as those in the FA table definitions? Attached one instance that differs from your post.

Being a pure SQL solution, skipping the header was not an easily accommodate choice.

The reason why the surname was not included was that during creation of a new customer in FA, the branch gets auto populated with the same value as the Customer Name for the "name" field and blank for the "name2" field. These sqls were designed to mimic the default FA behaviour. Subsequent edit of the branch and the associated contacts is where the "name2" can be added in. This will be evident when you import multi branch customers where an extra HQ branch is created first where no surname (name2) is envisaged, but rather a space for accommodating longer client company names. This can however be mitigated by selectively using the name2 field for the extra branches added alone.

No CSV import was done in phpMyAdmin - only tsv (tab separated values) was used in LOAD DATA LOCAL constructs. The usage of linefeeds (\n) especially in the addresses will need to be checked.

The currency used is also only the default company currency and individual cases can be SQLed in or manually edited if only a few.

The first iteration of sqls was to add in the customers one by one, take the last inserted id and then progress to the next table - it was very slow and painful (SAP!).

The last 4 fields of the temporary cust_list table are declared as DEFAULT NULL as they will have to be filled in manually (or possibly with some more sql magic) instead of by some tsv import, though in my case I manually did it in excel and then imported it.

The debtor_ref and branch_ref fields are VARCHAR(30) fields that have to be manually prepared to be unique and meaningful generally alphanumeric being similar to the actual Customer / Branch names without spaces and special characters (hyphens and underscores allowed) since the dropdown boxes have limited width onscreen.

Using a MySQL client like SQLyog (community edition is free) makes it a lot easier.

Spending your Christmas / New Year holidays working for a brand new FA release version is indeed a fine gift to the FA Community.

Thankyou indeed!

This will hopefully avoid having to support multiple versions and focus resources in maintaining just one really good version going forward.

Redundant Indexes removed in FA v2.4 in my unofficial GitHub Repo and shown for v2.3 in attachment.