Search options (Page 124 of 200)

Please make a search on the forum for these items. Also try the https://frontaccounting.com/fawiki.

/Joe

I am sorry for the sparse instruction. Here is the diff:

 --- a/dimensions/includes/dimensions_db.inc    Fri Dec 10 13:12:45 2010 +0000
     1.2 +++ b/dimensions/includes/dimensions_db.inc    Sun May 22 16:15:21 2011 +0200
     1.3 @@ -172,8 +172,7 @@
     1.4      $id = db_escape($id);
     1.5      $sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE tran_date >= '" .
     1.6          date2sql($from) . "' AND
     1.7 -        tran_date <= '" . date2sql($to) . "' AND (dimension_id = " .
     1.8 -        db_escape($id)." OR dimension2_id = " .db_escape($id).")";
     1.9 +        tran_date <= '" . date2sql($to) . "' AND (dimension_id = $id OR dimension2_id = $id)";
    1.10      $res = db_query($sql, "Sum of transactions could not be calculated");
    1.11      $row = db_fetch_row($res);
    1.12  

This was changes about 7 weeks ago in /dimensions/includes/db/dimensions_db.inc. The problem was the double db_escape of the $id. Remove the minus lines and insert the plus line.

The link to the HG repository is:

HG repository

/Joe

Hello, huotg01.
This was a bug, please upgrade to 2.3.5.

/Joe

Please read the sticky topic regarding updating of translations.
Here you will see how easy this is done

/Joe

This is a tricky one. The Invoiced member is not the same legal entity as the payer. However one way could be to act that the payer is the same as the invoiced member, and let the Discount part of the Customer payment be the fee to the third party.
You should then use a relevant account for the discount to be of type service fee.

Well this is just an approach. Maybe there are better approaches out there. Please help us.

Joe

These fields in debtor_trans table are not used at present.

The sales accounts and purchase accounts are stamped with the dimension in GL for the line values.

/Joe

You can simply create a customer, called f.i. Cash Sales with no address and a branch also called Cash Sales.
Then use this customer every time you want no customer visible. Remember to use the Cash Payment method on these sales.

/Joe

Jujuk, please download from HG Repository. This has now been fixed by Janusz.
The same 2 files was changed.

/Joe

If you have the Automatic Revaluation Currency marked in the Company Setup, then your foreign currency bank accounts are revaluated in the underlying GL accounts every time a payment is done to one of the currency bank accounts.

You can unmark this and do this manuelly in the Banking and General Ledger tab. Every time you do the revaluation manuelly, you will also get the foreign currency AR/AP accounts revaluated.

/Joe

You can follow this info on the Customer Balance Sheet, although not dated.

/Joe

The interval of 30 days, set in company_prefs, only cover 2 periods of 30 days. If you want to extend this you would have to print the report in Landscape and add the columns and algorithms in file /reporting/rep102.php.
And the same thing in /sales/includes/db/customers_db.inc, function get_customer_details.
The on screen customer transactions also use the function get_customer_details.
Another approach is to extend the interval to 45 days. And use the report as is now.

/Joe