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 itronics
The process is straight forward: installer connects to mysql server host, tries to select database, if selection fails it finally tries create database with given name. If creation error still appears the only reason is that account recognized by given dbpassword:dbuser have no access rights to just created database.
Janusz
Yes, having en_US directory installed while we use en_GB as default language seems to be a small inconsistency. Thanks for pointing this out. But why have you had to reinstall the application?
Janusz
You database for your first company is broken, but there is too little information to effectively help you. When you set go_debug=1 and retry you will have displayed sql query which failed. Having this information you can try repair database manually.
Janusz
I think you can define the service as two items: once as taxable item, and once as tax_exempt.Then you can put two lines on invoice: first using exempt item on amount which was purchased form A, and second using taxable item for the rest of amount sold.
I'm not sure if this way is satisfactory for you, but there is a couple of guys from India on the forum, so maybe they can point you out the better solution.
Janusz
This issue is fixed in forth going FA version 2.3.
Janusz
1. It probably will be never implemented just because there is no single bank interface in use. In practice many banks does not allow any other interaction then manual with their interface. Those which allow it, have various interfaces in use.
2. You can use poedit translation tool. I do not know easier application to do this. Swedish po file is already available, however it can require some update.
3. IMHO this is mainly matter of habits, and of course you _can_ create your own themes. See on our download section to find a couple of them created by FA users.
Janusz
Please confirm the sequence to let me understand the problem:
1. bank transfer was voided
2. database was restored from another sql file
3. error appeared on next bank transfer entry.
Is this right? What was the file with 'reference data' you have loaded in mean time? Was it some previous backup file, some COA found on our download page, en_US-demo.sql bundled with FA tarball or any other customized sql file?
Janusz
The problem is in 0_refs table, not bank_accounts. I don't know how it happened, but seems that transaction number '1' is already used in 0_refs. This can be fixed just by removal 0_refs record where type=4 and id=1. Seems this record lasted after some earlier gl bank transfer transaction removal. Haven't you removed it manually?
Janusz
Nothing obvious. Please set $go_debug=1 temporarily in config.php file and try again. This way you will have displayed also sql command which cause the duplication problem.
Janusz
Set 'Service' type on every item in your inventory. That's all.
You can print all entered invoices under Customer Trnasactions Enquiry or Customer and Sales Reports.
Janusz
Try to remove .httaccess file temporarily from main frontaccounting directory, just to be sure it is not the source of problem.
Janusz
Well, I'm not sure about other side effects which can be result of not quite complete CSV import, but above updates should be enough to have GL transactions repaired.
Janusz
Tax details are not stored in a system for Sales Order/Sales Quotation. In Sales Quotation Enquiry only total amount is displayed (including or excluding VAT/GST - depends on sales type selected).
The simplest way to retrieve taxes calculated for SO/SQ would be open sales order using cart class e.g.:
$quote = new cart(ST_SALESQUOTE, $quote_number);
$taxes = $quote->get_taxes();
var_dump($taxes);Janusz
Yes, in Absolute URL, but not in Host Name field of course.
Janusz
Probably for some reason you have broken database records which store sales account number used during invoicing. This is sales_account field in cust_branch record, or (if it is empty) stock_master.sales_account for given stock item is used.
Janusz
You should not set 'http://' prefix in Host Name field,as mysql is not connecting via http.
And if MySQL server is located on the same host when FA is installed, set 'localhost' as host name.
Janusz
Every competent advice on FA design is highly appreciated. I will contact you to by email. Thanks in advance.
Janusz
This is really strange. I think you should first check whether the related GL postings are properly written to gl_trans table, or not. After this we will know whether the problem is due to bad postings written to the table, or right postings are not displayed properly.
Janusz
Please search the forum about this - theproblem was explained at least twice lately.
Janusz
I guess you have installed some translation package for FA (french?). The charset (encoding) should be noiced in documentation to the package, or you can read it form *.po file's header. If you do not use any translation package,
Janusz
Code for 2.3 release (still in progress) is located on sourceforge.net CVS server. This is branch named unstable.
Janusz
Many thanks for the example. There is still no good documentation on extension system. One of the reasons are changes implemented in forthgoing 2.3 release. Hope those will be the last bigger changes in extension system.
Janusz
This bug was already fixed in main CVS, to be relea with 2.2.10. Ad hoc solution you will find here.
Janusz
Allocation is done only against invoice/credit note. Sales delivery does not generate any debt for your customer, so there is no allocation done nor required against it.
Janusz
Sorry, there was a typo in my post.
You can change charset declarations in lines 58 and 65 of /reporting/includes/class.mail.inc to the encoding you are actually using in your system.
Janusz
FrontAccounting forum → Posts by itronics
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.