Search options (Page 135 of 247)

To port it to FA 2.3, what gotchas need to be looked out for? Any FA v2.4 specific dependencies are in place?

Can the "vendor" folder in the release be removed and all references to include_once(__DIR__ . '/vendor/autoload.php'); be expanded out or moved to an include-able file since practically everyone uses PHP >= 5. Alternatively include the vendor folder in the git tree.

Also please include the file views/view_sales_order.php in the github code tree as it is still referred to in generate_recurring_invoices.php and is available in the release.

References: DataMapper ORM,  DesignPatterns and Namespaces.

@cambell: Thanks for the info.

Instructions on synching the lost master to the other master on return online would be useful.

Can these variables be set on a per database and/or per db.field on a permanent basis?

@sheik_salman: Thanks for the feedback.

The attachment in the 8th post in this thread suggests:

SET @@global.sql_mode= 'TRADITIONAL';

.

Committed in my repo.

You are using a newer version of MySQL where the 0000-00-00 (and it's timestamp equivalent) is not considered as valid anymore by default. Run MySQL with strict mode turned off and all will be well. This issue has been discussed in the forum more than once if I remember right.

Alternatively, edit your chart of accounts to replace all instances of "0000-00-00" to "0001-01-01" and then install your company.

Read the Wiki.

@cambell: Great work.
@joe: can it be natively incorporated into FA 2.4? If so, can the extra fields in an existing table substitute the need for a new table?

The module and menu items are hard coded. Since the normal table prefix is used, the FA backup will restore the new table used here.

Open the source company's backup sql (extract from zip/gz if needed) file in any text editor (like Notepad++, etc) and check the table prefixes. If the table prefix is say "5_", then you will see statements like:

CREATE TABLE `5_areas` (

For the target company's table prefix, you can take a current backup and do as above, or alternatively, login to the default company and navigate to Setup -> Create/Update Companies and lookup the prefix (see attachment).

Note that the source and target company's table prefix must be the same before restoration. This is done by doing an appropriate search and replace in the source backup to match that of the target company.

Wiki-ed.

Make the email address as a valid one (like "6589789874@mysmsgw.com.sg") for sending SMS thru an SMS gateway.

There is a flag for the msmerge utility: "--no-location" which uniformly strips the file and line references in the output.

If you want the file and line number references possibly with no sorting (-s), then reverse the order of the files:

msgmerge empty.po ar_EG-2.3.12-1.po -o ar_EG-2.3.12-2.po

Pass a single journal voucher to contra all supplier and customer balances (preferably as of the last date of the previous financial year) like for example for a single supplier:

By Supplier 1 Cr $1200 (mock payment)
To Suspense (or Cash) Dr $1200 (mock receipt)
# Allocate above payment to outstanding Supplier Invoice
By Suspense (or Cash) Cr.  $1200 (mock refund)
To Supplier 1 Dr $1200 (mock refund receipt)

Yes by using mock payments and contra journal entries on account.