Search options (Page 124 of 201)

No, but the view dimension does allow you to select a long period.

/Joe

When dealing with dimensions on Invoices, it is the Sales account and Purchase accounts that are involved. You can follow the dimension result by taking a Rport Profit and Loss Statement for a dimension. And of course you can select the period as long as you wish.

/Joe

I didn't receive this. Are you sure you used the correct address. Or use this: joe . hunt . consulting @ gmail . com .
Remove the spaces.

/Joe

There are classes, groups (types) and normal COAs, so I guess it will fit. It does for so many other nations.
Just send the CSV file with all layers.

/Joe

If this a kind of comma separated char of accounts, I might be able to convert it into FA.

Please send it to contributions email on the Webpage - Contact Us page.

/Joe

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