Search options (Page 209 of 247)

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.

Create your CoA from scratch to suit your needs.

Make a copy of the original reporting/repXXX.php and place it in your company # reporting folder and modify it there.

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.

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.

The CoA link is no longer available.

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

Textcart Extension?

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

@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

Check if the filesize is restricted by Apache, PHP or FA application.

Would References, Dimensions and / or Tags do?