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
Hello Alexey,
The version 1.12 and v2.0 are not compatible. There are changes in the database structure. Therefore you can not restore the backup from v1.12 on the newly installed v2.0.
You can, however, run the update_db.php script on the companies if you have installed in the same folder as the 1.12. This should be done before logging into the companies.
/Joe
Yes, Jan, we understand what you mean. The search boxes were implemented because you can have many thousands of items, up to 90000 items perhaps, and the ability to search partly on either item id, category or name makes the listbox much more handy to select the right item. The same for ustomers/suppliers.
For items you have the option to see id, category and name.
I understand that for customers/suppliers the info is sparse. Maybe we can find something here, but the general structure is to get it as easy as possible to select the items/customers or suppliers, should you have many of them.
/Joe
There are several ways of doing this. The most common one is to set up a cash customer with a cash branch. In the branch select a cash account as 'Account Receivable Account'. Set the 'Payment Terms' on the cash customer to 0 days.
This should do it. You will get all the statistics with this approach.
/Joe
Hard to say. When the serious bugs are gone. Expect a month or so.
/Joe
It is straight forward. Inside the Supplier Credit Note, press the Edit button in the section 'Received Items Credited on this Note'. Here you can select which received items for the supplier you want to return.
/Joe
Well, you should look into /sales/customer_invoice.php and the included files. Here you will get the idea of how to write the add_on module. You should be able to include the same files when doing this.
/Joe
One way to handle it, is to setup this as a service item and do a manual calculation.
/Joe
This is not covered by FA at present.
/Joe
Look in the mailing list fa-list on https:/sourceforge.net/projects/frontaccounting.
Janusz has given instructions for the CVS downdoad.
/Joe
The default user/password in file is: admin/password
/Joe
Yes Jan, and there is such a searchable list already. For release 1.16 there is 3 variables inside config.php for doing this. From unstable release 2.0 these values has been moved to Company Setup.
/Joe
The problem is that the stock items require GL transactions, based on an item value. It is possible to change the Import module to do these transactions, but we do not have the resource for that at present. So otherwise you have to enter it manually.
/Joe
Check the file, config_db.php, and change it to
$def_coy = 0;
$tb_pref_counter = 1;
$db_connections = array (
0 => array ('name' => 'Training',
'host' => 'localhost',
'dbuser' => 'user',
'dbpassword' => 'password',
'dbname' => 'dbname',
'tbpref' => '0_')
);change the values for dbuser, dbpassword and dbname to fit your database creation.
/Joe
Yes, Hans Peter, we are aware of this. The problem is that we have to convert the numeric values when moving it to and from the database. But we are trying to fix it.
/Joe
Yes, this has been in my mind for a while. I guess you mean common transactions not related to any specific supplier, like gasolin bills, representations, small cash equipments that you purchase with your check book or cash.
While it is easy to enter it in the Bank/Cash Payments, the trouble is finding the correct cost account and eventually tax additions. We can not promiss that we can have this implemented in the current unstable release 2.0, but it is still in our thoughts.
/Joe
Hello again,
Yes it is possible to update from 1.xx to 2.0. We have prepared SQL scripts to do so, and instructions will be available.
Please monitor the Mailing List at SourceForge either by subscribing or looking at SourceForge.
/Joe
Hello,
I guess you are right. The exchange rates are all calculated from the selected end date. It should be by document date.
We are heavily working on the release 2.0 of FrontAccounting. We will fix this in the unstable branch of the CVS repository. Later we will merge it back to release 1.16.
If you want to fix it now, you can move the rate calculation in rep201.php down to the record loop.
/Joe
Hi,
You can edit a sales/purchase order as long as it has not been invoiced. Just select the inquiries or the delivering/invoicing where you se the list. There you can edit them.
There are many changes and improvements in the unstable release 2.0 that you can monitor in the Mailing List on SourceForge.
/Joe
Sushil, you must remember to set the Standard Costs for the items. You do that at the bottom right in Items and Inventory. Enter at least the material cost in the first textbox. This way it will create the correct GL transactions.
Regards
Joe
Thanks sushil,
We will take a closer look into this. We haven't heard of bugs in the manufacturing, but there have been some misunderstanding about the GL bookings. There are only GL bookings of manufacturing when the assembled items are sold to customer or if there are additional costs to the assembling.
/Joe
Hi,
Are you sure the file was uploaded? Was the config_db.php file writable? Otherwise please tell us a bit more about your server details. Normally it should install without any problems.
/Joe
Thanks, this is much appreciated.
/Joe
No we think that sending the PDF invoices by email is fine and user friendly for the customers, but if you want to have another approach, you can always write your own add-on module.
/Joe
This is not possible, but you can send him the invoice by email automatically.
/Joe
Thanks for pointing this out. It will be corrected and uploaded to the download chart of accounts.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.