Manually install the files from the module into the modules folder and update the installed_extensions.php files in both the webroot and the company # folders.
5,176 03/06/2014 02:41:59 pm
Re: Cannot install new extensions—"could not open" (6 replies, posted in Modules Add-on's)
5,177 03/06/2014 02:38:02 pm
Re: PNG Logo format not accepted (3 replies, posted in Report Bugs here)
What I was referring to was the hard coded .jpg in the said php files. PNG is handled fine otherwise.
5,178 02/27/2014 03:03:58 am
Re: Cannot install new extensions—"could not open" (6 replies, posted in Modules Add-on's)
folder permissions issue - for the tmp folder, and installed_extensions.php files in the webroot and company folders
5,179 02/27/2014 02:59:53 am
Re: Asset Module Entries don't show up on Balance Sheet (6 replies, posted in Modules Add-on's)
Check if the module needs Triggers and procedures rights for the db user.
5,180 02/27/2014 02:57:33 am
Re: DEMO with batch,expiry,mrp-FA MODIFIED (6 replies, posted in FA Modifications)
Just for FA on GitHub and then develop your module.
5,181 02/27/2014 02:53:18 am
Re: ERROR 500 - INTERNAL SERVER ERROR After installing Textcart (2 replies, posted in Modules Add-on's)
Use the v2.3.19+ latest snapshot from the official it Repo instead of the outdated v2.3.15
5,182 02/27/2014 02:49:31 am
Re: Entering a Zero Opening Balance (1 replies, posted in Accounts Receivable)
Only enter balances that are in your balance sheet (or from trial balance if in mid year). Zero balace accounts should not be entered in the opening balance voucher.
5,183 02/27/2014 02:48:11 am
Re: Take it easy, based server a problem? (1 replies, posted in Setup)
http://www.wikihow.com/Set-Up-a-Local-Domain-with-Bind-in-Windows
5,184 02/27/2014 02:38:26 am
Re: COA GAAP US 4d (1 replies, posted in Installation)
Create your CoA from scratch to suit your needs.
5,185 02/27/2014 02:15:30 am
Re: osCommerce Order and Customer Import Module (8 replies, posted in Modules Add-on's)
Please logout, clear browser cache and also purge the js files in the company folder so that they get re-created and then try again.
5,186 02/27/2014 02:13:50 am
Re: Best practice to modify reporting (2 replies, posted in Reporting)
Make a copy of the original reporting/repXXX.php and place it in your company # reporting folder and modify it there.
5,187 02/27/2014 02:12:36 am
Re: Form letter header (1 replies, posted in Setup)
Search for the word "Dear" in reporting/includes/pdf_report.inc and it's translations in the various compiled language files.
5,188 02/27/2014 02:02:33 am
Re: MySQL OR MySQLi Transaction (9 replies, posted in Wish List)
Please be clear on what checks you want before a commit is envisaged:
Each insert must be successful - define what you mean by successful:
- whether the record was inserted or
- whether it already exists and did not need the insert or
- that the insert values were not acceptable for other reasons like field type and size checks.
Similarly about the definition of the UPDATE sql being successful:
- was the update successful in general
- was the update unnecessary as the record was already in the updated state
- was the update not acceptable at all for reasons like field type and size check failure.
5,189 02/13/2014 02:49:08 pm
Re: Feature suggestion (5 replies, posted in Wish List)
Fork the FA project (or my not frequently updated GitHub Repo for the extensions) and then provide your modules. FA is basically developed on Mercurial and the Git repo is only a mirror and my unofficial GitHub repo is meant only for extension development as it may not be otherwise uptodate and will get updated only when I get time.
5,190 02/13/2014 02:34:57 pm
Re: MySQL OR MySQLi Transaction (9 replies, posted in Wish List)
Check out these links to prove that the UPDATE query check is not functioning as needed:
http://stackoverflow.com/questions/14908087/should-mysqli-update-queries-return-a-result
http://stackoverflow.com/questions/12990164/how-to-check-if-an-update-mysqli-query-is-correctly-executed
http://stackoverflow.com/questions/12744953/mysqli-returns-true-for-insert-query-row-not-inserted
UPDATE will return 0 rows affected if the changed state already exists and the mysql_query function will still return true. Hence remove the UPDATE check in the if statement.
5,191 02/12/2014 05:57:01 am
Re: Tracking Item Inventory at Purchase Price Level (4 replies, posted in Items and Inventory)
Has the first question by @padma been answered anywhere?
5,192 02/12/2014 05:55:56 am
Re: I want to create Chart Of Accounts for Morocco (6 replies, posted in Misc. Charts of Accounts)
The CoA link is no longer available.
5,193 02/12/2014 05:54:23 am
Re: Item and Inventory (8 replies, posted in Items and Inventory)
Make 3 separate FA installs in the same machine and create editable 1:1 views from a common db into each FA instance's db for those tables that need to be the same across all all FAs.
5,194 02/12/2014 05:50:59 am
Re: How Cart is managed in Sales Order Entry form (3 replies, posted in Items and Inventory)
Keep all your columns in your excel sheet but hide them and export the rest to import into FA. Make sure to include the hidden columns details in the description.
abc - 2x3x1
5,195 02/12/2014 05:49:06 am
Re: Change text on documents / Bulk uploads (1 replies, posted in Setup)
change translation file or hardcode the text at each version change.....
5,196 02/12/2014 05:44:35 am
Re: Change text on documents / Bulk uploads (1 replies, posted in Reporting)
Textcart Extension?
5,197 02/12/2014 05:40:58 am
Re: osCommerce Order and Customer Import Module (8 replies, posted in Modules Add-on's)
Roles permissions must be enabled for the user
5,198 02/12/2014 05:32:08 am
Re: why its not working (1 replies, posted in Wish List)
Did you mean Logout button - it is there in the header menu line.
5,199 02/12/2014 05:30:56 am
Re: Moving Hosting. Fine at first, after several hour some columns gone. (1 replies, posted in Installation)
It is possible you did not install some extensions in the new one that was in in the old one that may possess an extra column/table.
Copying the files from one server to another may need to have the file users and groups and permissions set correctly and some apache and php directives set that may be peculiar for the new server like file paths in the config.php, etc.
State what column was missing and check the old sql backup as well.
5,200 02/12/2014 05:24:51 am
Re: Average costing query (2 replies, posted in Items and Inventory)
@dev01: Assuming FIFO, then:
Average cost after sales in step 3:
Avgcost = ((110 * 5.8) - (5 * 6.071)) / (110 - 5)
= (638 - 30.355) / 105
= 607.645 / 105
= 5.7871
Cost of Return saved as 6.071
Average cost after return of sales in step 4:
Avgcost = ((105 * 5.7871) + (5 * 6.071)) / (105 + 5)
= (607.645 + 30.355) / 110
= 638 / 110
= 5.8