It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by joe
You can preset the references during entrance of the document. Just set the value as you wish, however you must set a value greater than you already have used.
The references are automatically increased during further operations.
You can also have combined alphanumeric and numeric references, like SO001. Thes will increase next time to SO002 and so on.
You are not able to have alphanumeric id's. This is the reason for using references.
/Joe
If you want to make your own report with several dimensions, remember that the dimensions in the listboxes are sorted by reference, not id.
BTW, the dimensions in the debtor_trans table are not used and are there by mistake.
Joe
You can only print info for one dimension at a time. If you want to print for several dimensions, then consider using 2 levels of dimensions, where the first level would be of type f.i. department and level two would no selections.
/Joe
Yes, of course. But you will have to fix all reports.
If you only have a logo, then you could probably just edit the header in pdf_report.inc.
/Joe
No, but the view dimension does allow you to select a long period.
/Joe
Please try to look in your dimensions_db.inc if the changes above have been fixed. Otherwise something strange has happened during update.
/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
You can select the reports over several fiscal years when also selecting Dimensions.
/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
As you say the smartest is to either use an existing module (look in FA, Setup tab, Install/activate extensions. There you can see which modules are available from the central repository. or to write one yourself. Should be fairly easy. Have a look at one of the others to get the understanding of how it works.
/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
The easiest way to handle this is to set PayPal as a Bank Account. Then you will also have a nice check of the transactions.
/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
If this is of general interest we could incorporate it into core FA. Otherwise it could be a module report.
You can send it me via the contribution email (Website - Contact Us).
Thanks
Joe
Please make a search on the forum for these items. Also try the https://frontaccounting.com/fawiki.
/Joe
The std cost price is picked up by purchase order deliveries or entering in standard cost.
/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:
/Joe
Look into the changelog for HG. There you can see what was changed.
/Joe
Hello, huotg01.
This was a bug, please upgrade to 2.3.5.
/Joe
Hi, Tom, I have just returnet from a holiday. I will have a closer look into this topic in a while.
/Joe
Please read the sticky topic regarding updating of translations.
Here you will see how easy this is done 
/Joe
Yes, you set this on the Sales Types.
/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
As I see it doesn't make sense, so they should be removed to release 2.4. I can't recall why they are placed here.
/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
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.