3,651

(5 replies, posted in Setup)

Actually you can do it all in excel and then paste it into any MySQL client like phpMyAdmin / SQLyog.

1. Take a backup of FA from within the Web GUI.
2. Enter a typical set of transactions from one record (row) in excel in several steps in FA in the Web GUI manually.
3. Take another backup of FA from within the FA Web GUI.
4. Compare the 2 Backups and see what has changed - tools like SQLyog can provide for database synch sql commands across databases (copies of before and after).
5. Using your Excel record's set of FA transactions SQLs, generate the SQLs using CONCATENATE for all the other records and paste them into the MySQL client.

3,652

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

The GitHub link is empty.
The SVN link has been zipped and attached here.
The original WP post is here.

3,653

(5 replies, posted in Setup)

Whilst each of these CSVs can be imported separately in bulk, to link them together would be the challenge - which sale would map to which receipt / receivable / expense. If however, you have one combined csv having all the bank payments and sales and expenses pertaining to each transaction (one consolidated transaction per line entry in the CSV) in a single csv, you might be able to hammer out a PHP script to do it with MySQL's last_insert_id() function.

Line 310 in purchasing/supplier_payment.php is hardcoded with number of decimals and hence it did not use the chosen 3 decimal places you set in the preferences for Prices/Amounts.

This appears to be the only hardcoded place left in FA 2.3.

Omitting the last argument ($dec) will automatically take the preference value set when the function amount_row() which finally calls the function amount_cells_ex() is executed. These functions are defined in includes/ui/ui_input.inc file.

Hence Line 310 in purchasing/supplier_payment.php :

        amount_row(_("Bank Amount:"), 'bank_amount', null, '', $bank_currency, 2);

should be changed to:

        amount_row(_("Bank Amount:"), 'bank_amount', null, '', $bank_currency);

It stands committed in FAMods in my unofficial FA 2.3 repo.

@joe: Kindly do the needful in FA 2.3 and in Line 304 in FA 2.4.

3,655

(48 replies, posted in Setup)

Fixed Assets application has been extended and debugged in commits yesterday and today.

Some icons for login and others have been changed for the standard themes.

There are some ERD issues as in the attachment that need to be sorted out.

The $depreciation_methods array is defined in includes/sysnames.inc (D - Declining balance, S - Straight line, N -  Sum of the Year Digits, O - One-time) has now been extended to include sum-of-the-year digits method, fixed declining balance method.

The version seems to have been bumped to 2.4.1 in the upgrade file sql/alter2.4rc1.php, but the version.php file and the sys_prefs table still show 2.4.0 in the en_US-new.sql and en_US-demo.sql files:

INSERT INTO `0_sys_prefs` VALUES ('version_id', 'system', 'varchar', 11, '2.4.0');

.

3,656

(12 replies, posted in Announcements)

None of the report request forms work.

3,657

(48 replies, posted in Setup)

Additional fixes to the last set of commits in the FA 2.4 branch can be taken from my unofficial FA 2.4 repo:

Fixed es_MX installer translation files

Fixed typo in en_US-new.sql: Finsihed => Finished

*** As of 2015-12-11, the above fixes have been incorporated into the Official FA 2.4 core.

3,658

(2 replies, posted in Setup)

2 databases for the same company?

Switch database in the file config_db.php's dbname element for the appropriate company..

3,659

(2 replies, posted in FA Modifications)

You are missing the file:
http://membtech.com/demo/fa/themes/amb/images/edit.gif

CSS corrections needed.

Good work.

3,660

(48 replies, posted in Setup)

FA 2.4 now has a Fixed Asset application which provides for a new mb_flag value of 'F' for Fixed Asset along with a new table stock_fa_class and a few new fields in stock_master table and an extra field in locations table with appropriate extended security roles. All Charts will need to be updated accordingly.

Two new sys_prefs have been added as well: default_loss_on_asset_disposal_act account code and depreciation_period flag (1 = Yearly, 0 = Monthly defined in includes/types.inc). The $depreciation_methods array is defined in includes/sysnames.inc (D - Declining balance, S - Straight line, O - One-time).

The assets_register extension (obsolete for FA v2.4 now) uses the SA_ASSETS security descriptor whilst this new application uses the singular SA_ASSET security descriptor.

The attachments are screenshots with default roles and enabled roles for this application.

3,661

(5 replies, posted in Accounts Receivable)

Please clear your stale sessions - the location will be in your phpinfo().
Also increase your PHP max_input_cars value in php.ini from the default 1000 to say 3000 or 10000 provided your memory permits.
Check your LAN cables for network issues and latency (NetScan)

3,662

(2 replies, posted in Items and Inventory)

Whilst most FA forms specify width of the form field's display, they rarely look at it's length in the php code.

stk_code, item_code and stock_id are found in quite a few tables in FA Core:

debtor_trans_details.stock_id
grn_items.item_code
item_codes.stock_id
item_codes.item_code
prices.stock_id
purch_order_details.item_code
sales_order_details.stk_code
stock_master.stock_id
supp_invoice_items.stock_id
workorders.stock_id

The super secret discount code can actually be the item code of the discounted item!

Do not write to js_cache/utils.js as it will get overwritten on cache refresh when some settings change. The file js/utils.js is what you will want to change.

What is the context of your post?

jQuery is not used in FA core and in the standard themes. The dashboard_theme and exclusive_db themes use jQuery v1.3.2 in the themes' js folder.

3,665

(1 replies, posted in Installation)

Are you using the latest Dutch Translation 2.3.19-3 from the FA pkg repo?

Any version lower than the current FA version should generally work fine but after installation, the version number is used from the lang/languages.inc file and the version part of the .mo file.

You can compare and use the .po/.mo files from my unofficial repo.

Replace line 35:

            if(!$this->preventHijacking())

with

            if(1 == 0)

Please list this feature on FA 2.4 release.

@joe: Can the Next Reference be just tentative on the form and on acceptance of submission can it not display the actual reference assigned?

Enter it in your php.ini file and restart the webserver.

Will such a dead letter box serve any useful purpose? Is it not better to inform the user of the lack of a valid recepient?

The class.mail.php included and used in inventory/includes/inventory_db.inc and in reporting/includes/pdf_report.inc where you can hardcode some fall through email id in it's object instance properties.

3,671

(2 replies, posted in Wish List)

Please do so as it will enhance the usability of FA. Also do not forget to inform the community here of your links and efforts. Back links to the FA site, wiki and forum will also spread the word for others to benefit as well.

Does it have anything to do with cache settings of the browser? There may be a setting in includes/session.inc where preventHijacking() will cause such mischief unintentionally. Comment out the unnecessary bits of code there.

Allow Negative Inventory is a setting in the sys_prefs table that is set in Setup => System and General GL Setup screen.

File: sales/includes/db/customers_db.inc
Function: get_customer_details()
The mandatory parameter must be a valid $customer_id.
If invalid, it causes an error in line the sql construction portion on line 100:

             AND ".TB_PREF."debtors_master.debtor_no = ".db_escape($customer_id)." ";

You tried to create a quotation without having created atleast 1 customer.

@seend: Try to use the FA 2.3.24+ snapshot and see if the error persists. It might also be that you are using a newer version of PHP that uses the STRICT option which may be disabled in PHP 5.6 but is compiled hardcoded in PHP 5.7 onwards.

@joe: An error should be output when no customer exists if a Document Form depends on it. I thought it was so now.

Instead, just change the Decimal Places for Prices/Amounts to 3 in Setup => Display Setup.