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
Regarding # 9. Yes and this is related to one of the wishes in the polls on the poll page. I think we can do it this easy.
Ah, regarding the Cash Only. In case we do not want to give the customer 1 day for cash only, we should set it to 0. N/A is either column that is not in use.
/Joe
NO you can not get your 1.16 data into a 2.0.1 version that way.
This is mysteriously. There must be something with the database user/password. You can check in the file config_db.inc for the correct data to give to the update_db.php. Please try and check this. I have never heard this error before if the data is correct.
/Joe
I forgot. Your # 7 was a good idea. Will include that in release 2.0.2. We do it as an extra selector box, Inventory Column, or so with 'Yes' and 'No' default to 'No'.
/Joe
There should be a script in the root folder, called update_db.php. Run this script twice. The first time you should include the file alter.sql from the /sql folder. The second time you should include the file alter2.sql from the /sql folder. After that everything should run.
You are simply running the 1.16 database on the 2.0.1 release and there are several changes to the database structure.
There should be instructions in the update.html about that. Probably not very easy to find 
/Joe
You change/add Payment Terms in Setup, Payment terms. After that you can select the payment terms in Sales / Add and manage Customers. You can also set the Payment terms for a supplier in Purchase.
/Joe
6. What is the reason for printing the P/L in another currency than the domestic currency?
8. Due-date is customer specific. It is calculated based on the payment terms.
/Joe
You should press the button in the Sequence # column to get an editable line. After processing the line it is entered to the upper list and removed from the lower list.
/Joe
And just think of the dimensions as a subaccount in this matter. But the dimension are much more powerful. Using dimensions you can get balance sheets/income statements for a local dimension or for a group of dimension 1 (if you use 2 dimensions on a transaction line).
So you can keep your internal accounting by department - cost centres. I mean for a total department or a costcentre inside the department. So you see this approach is much more flexible.
/Joe
Yes and no. You can just let the account code be 101111 Cash Sanur Mr.X. Your reports will be sufficient enough anyhow. Use the groups wisely. You can have as many groups as you like for this, but try to make it easy to understand.
The account_code2 is on another separate level.
And if you need detailed, yes use the dimensions.
/Joe
FrontAccounting is built up from Account classes, account groups (or types) and accounts. So a single account belongs to a group and a group belongs to a class. This way it is easy to build balance sheets and income sheets. How you build the accounts is up to you.
Certain countries use this:
1000 Cash
1010 Cash Jakarta
1011 Cash Bali
10111 Cash Sanur
and so on.Without building these as subaccounts, which is not necessary when you use a modern SQL tool like MySQL. Instead companies use dimentions to get detailed (internal) accounting for projects, cost centres and departments aso.
Some tax authorities in certain countries insist on having a special code for calculating taxes in their own way. The account_code2 is used in these cases but it is a total free field, and if your tax authorities do not demand this, you can either ignore it or use it for your own need.
/Joe
You are free to build your account just like you wish. There are a total of max 11 characters in the account code field. You can build with or without a point in the account. Just remember to set the chart_of_accounts to be alphanumeric in config.php if you with to use non-digits in your account code.
If you need a detailed accounting, consider using the dimensions instead. Look in the dimension forum for more info.
/Joe
I'm not sure if I understand your question? If you mean which type of accounts, the answer is that we only have the provided ones that can be downloaded in the download section. You can select a fresh chart, like en_US-new.sql that comes with the core installation and create one that suits your need. Delete not needed accounts and create your own. Then you can make a backup of this and download it and use it in future companies. In that case, make sure the table prefix is set to 0_ before all the tables.
/Joe
The item categories are sorted by category id. You can change the order by adding an ORDER BY in /inventory/manage/item_categories.php.
/Joe
Hello, just create the items as services, then there is no stock control.
/Joe
Your solution is perfect.
/Joe
We are aware of this problem. We had to escape all the input database fields in FrontAccounting to eliminate spammer injections. Spammers could add html code into the fields and thereby inject the script.
/Joe
Instead of using the class-member TextCol, you can use TextColLines. This will wrap the column. But you must keep track of the row counter yourself to get a nice layout. Ex.
Before:
$rep->TextCol(0, 1, $myrow2['stock_id'], -2);
$rep->TextCol(1, 2, $myrow2['StockDescription'], -2);
$rep->TextCol(2, 3, $DisplayQty, -2);
$rep->TextCol(3, 4, $myrow2['units'], -2);
$rep->TextCol(4, 5, $DisplayPrice, -2);
$rep->TextCol(5, 6, $DisplayDiscount, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->NewLine(1);
After:
$rep->TextCol(0, 1, $myrow2['stock_id'], -2);
$row = $rep->row;
$rep->TextColLines(1, 2, $myrow2['StockDescription'], -2);
$next_row = $rep->row;
$rep->row = $row;
$rep->TextCol(2, 3, $DisplayQty, -2);
$rep->TextCol(3, 4, $myrow2['units'], -2);
$rep->TextCol(4, 5, $DisplayPrice, -2);
$rep->TextCol(5, 6, $DisplayDiscount, -2);
$rep->TextCol(6, 7, $DisplayNet, -2);
$rep->row = $next_row;
$rep->NewLine(1);This will wrap the description nicely.
If you want to use the long description from the stock_master, you have to change the function get_customer_trans_details in the file /sales/includes/db/cust_trans_details_db.inc, line 5. You have to add the field long_description from stock_master table.
/Joe
Well, Alvin, when we are in a catch 22 situation, it is good to be able to do this 
. We can then use the order for another occation, maybe use it as a template
/Joe
The sales orders can be deleted by edit - cancel order, in sales order inquiry.
/Joe
Is Javascript disabled?
/Joe
But all the critical transactions are voided, right? GL Postings and Item movements and corresponding sales invoices and delivery notes?
This has something to do with the spam injection avoidance we did a while ago. We had to escape all the database entry fields for html to avoid injections from spammers. Maybe Janusz can comment more on that.
/Joe
The search functions only works for items, customers and suppliers lists.
But when you enter account characters/digits the account list will try to follow your entrance where there is a fit for your entry.
/Joe
It is often practically to use just one database and use table prefixes when creating new clients. Then you avoid these problems.
Another approach is to first create the database with phpMyAdmin before using the 'Install New Company'. This way you avoid the install break down.
/Joe
I am not sure if it works, but probably it does. I haven't tried. Try to do a test.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.