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,177

(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.

folder permissions issue - for the tmp folder, and installed_extensions.php files in the webroot and company folders

Check if the module needs Triggers and procedures rights for the db user.

Just for FA on GitHub and then develop your module.

Use the v2.3.19+ latest snapshot from the official it Repo instead of the outdated v2.3.15

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

(1 replies, posted in Setup)

http://www.wikihow.com/Set-Up-a-Local-Domain-with-Bind-in-Windows

5,184

(1 replies, posted in Installation)

Create your CoA from scratch to suit your needs.

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

(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

(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

(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

(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

(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.

Has the first question by @padma been answered anywhere?

The CoA link is no longer available.

5,193

(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.

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

(1 replies, posted in Setup)

change translation file or hardcode the text at each version change.....

5,196

(1 replies, posted in Reporting)

Textcart Extension?

Roles permissions must be enabled for the user

5,198

(1 replies, posted in Wish List)

Did you mean Logout button - it is there in the header menu line.

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

(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