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
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
If you don't use the tax, just create a tax group called 'Not Used' or something like that. and select none of the taxes (just like tax-free).
If you only have this one tax group, it will always be default when creating customers/suppliers. Do a similar thing for the Item Tax Types, and you are free of the tax. It will not be written on any documents and no tax transactions are done.
/Joe
The reason for the backward numbering in document printing is that you normally will print the latest ones, and therefore it is easier to find them this way. But as you found out, they have to be select in ascending order
No it is not possible to only select invoices from one customer.
The best and safest thing to do, is to void the sales transactions. You do that in Setup tab, Void transactions. First look in the inquiries to pick up the numbers first. Remember to void both sales invoice, delivery notes and sales orders. If there are GL postings and Inventory movements they will automatically be voided as well.
There are so many links between the tables that is is almost impossible to remember them all by doing this in phpMyAdmin.
/Joe
BTW, if you try to void a sales order, that is also a template, it will not be voided, but this has no influence over the critical postings.
FA2 uses the PHP built-in mail function to send mail so you should be able to use it transparently. The messages are in doctext.inc and doctext2.inc, that are included by pdf_report.inc in /reporting/includes folder.
/Joe
You do that in Sales - Sales Order Inquiry. Mark the Tmpl checkbox for the items you want to be templates. Then they will show up when selecting Template Delivery/Invoice.
Those company extra fields are not used by FA, but more to extra info for yourself.
In the company setup, you place your VAT no in Tax Authority Reference field
In the customer setup, you place the customers VAT no in th GSTno field. Sorry for the different words.
If these fields are filled then the info will come on the documents.
/Joe
You should see, that if this is a bank account, this bank account is updated as well, right?
/Joe
This is on our priority list
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.