Search options (Page 228 of 246)

You will need to clear any browser cache left over.

I only looked into one report listing the assets. Can you list the assets correctly as a report? This extension uses functions and triggers and hence your MySQL database user must have the necessary privileges.

List each issue and what file / url shows up on the browser for each issue and what menu click sequence brought up the issue. This will help replicate and resolve the issue.

Since the extensions are not in a repo for public to refine it over time and are just packed up into pkgs with magic glue it is a little difficult for the community to contribute and appears designed to help only coders.

I am planning a git repo for the extensions from where users can manually upload extensions outside of the magic web interface - any takers? Maintaining a repo over time is time consuming and requires great commitment - the folks at FA are already doing the best they can under the circumstances and it will not be fair to burden them any more.

Whilst Charts of Accounts, Languages and Themes get updated fast, extensions take longer to get updated when they do.

It appears that the SELECT field assets.id was erroneously made same as the GROUP BY field.

Edit Line 34 of modules/asset_register-2.3.3-9/reporting/rep_assets_list.php:

            $sql = "SELECT ".TB_PREF."asset_types.asset_type_id,

to

            $sql = "SELECT ".TB_PREF."assets.asset_id,

What is the current status of this issue?
Where are the hot key definitions stored?
Any report to list them?

Signs of the Sign! There you go.

Compare the SQL dumps of both installs and check in non transactional data for differences.

Look up the sql used. It will be missing a GROUP BY clause and possibly a SUM/COUNT aggregate function as well.

Hence we are not following the Debit is -ve and Credit is +ve rule for all accounts like most packages do or is it only in the presentation that there exists a difference in the P&L?

Since Cash on hand will always be debit, should not the Assets be -ve and Liabilities be +ve?
The earlier post with the example of cash withdrawal from bank actually appears to support Assets being -ve and Liabilities being +ve as seen from a gl transaction record.

Yes Janusz, the ledger will become correct only at the year end - after all in such businesses, most of the profit gets accumulated in stocks that appreciate in time without getting taxed - when sold, the sale price cannot be disputed since it is 'old stock' and in non-recorded condition!

The real reason, however, is that there are no clerks to enter such consumption vouchers as and when it occurs. Also, such businesses do accounting just because the Govt / Statutory bodies require it - transactions being purely on trust, interest-free credit and mostly on cash and carry basis. That is why such businesses thrive - unnecessary white collar salaries that do not contribute to the bottom line. At best the ledger folio of Suppliers and Creditors would suffice for them to manage Payables and Receivables.

Yes Joe, the Calculated return bridges both Profit and Loss and both sides of the divide, but for those coming from conventional manual accounting, especially vernacular ones (an old Indian one has audit tracking using a daybook-cum-ledger accounting that the Indian money lenders of the British Empire used to transfer the pay of British troops back home - look up a building that is 4th from Buckingham Palace - 1878), it is a tad offbeat to contend with in the short run.

Thanks for the inputs and clarifications!

What sign convention do we use in FA? The loss seems +ve in the Balance Sheet - the one I am converting from Tally.....

Is this okay:

Assets +ve
Liabilities -ve
Income +ve
Expense -ve
P & L = -ve of (Income+Expense) placed alongside Liabilities in the Balance Sheet

Try the FA v2.3.14 HG Build 3175 available in post 11 of a thread[ here and see if the problem persists.

GIT repo can also be in a normal ubuntu desktop as well. Can run a Win "Box" on Ubuntu in VMWare / Virtual Box as well or Win Apps in Wine.

@ed10: thanks for the info.

Since the users.email field is not being used anywhere in the code if acquired using get_user_by_login() (as is done here in line 81 of includes/current_user.inc), the following patch will ensure it's availability in any script that uses it:

--- old/includes/current_user.inc    Thu Jan 17 19:16:02 2013
+++ new/includes/current_user.inc    Mon Feb 04 05:42:49 2013
@@ -22,6 +22,7 @@
     var $loginname;
     var $username;
     var $name;
+    var $email;
     var $company; // user's company
     var $pos;
     var $access;
@@ -120,6 +121,7 @@
                 $this->username = $this->loginname;
                 $this->prefs = new user_prefs($myrow);
                 $this->user = @$myrow["id"];
+                $this->email = @$myrow["email"];
                 update_user_visitdate($this->username);
                 $this->logged = true;
                 $this->last_act = time();