If the inventory has a dimension, this dimension always follows the stock entry and sales when the GL transactions are created. If a customer has a dimentsion, it will override the item dimension.
/Joe
4,777 07/28/2008 08:06:17 pm
Re: import opening balance from external source (1 replies, posted in Setup)
Hello,
No it is not. The transactions are stored just as it is. If you which to see an opening balance of an account, you just make an accumulate of transactions up to a certain date.
So if you are importing OB from an external system, you would do that in a date 1 prior to the fiscal year you are starting. F.i. you start the fiscal year of 01.01.2008. You make the initial balance with a balanced journal entry from 12.31.2007.
We do not have any special tables for periods or year balances. This way you are free to select your own periods by selecting your period in balance sheets and income sheets.
/Joe
4,778 07/28/2008 07:58:13 am
Re: Set up F.A for microfinance bank (4 replies, posted in Setup)
Thanks for your nice words.
You should follow the install instructions inside the application. We are not familiar with the specific setup for a microfinance bank. Maybe you you shall modify the chart of accounts after creating your own company. Talk to an accountant about that.
Maybe somebody in the audience have additional tips for you.
/Joe
4,779 07/26/2008 08:00:27 pm
Re: Price Listing (3 replies, posted in Reporting)
Hi alvin,
The price listing prints in all entered currencies sorted per currency.
/Joe
4,780 07/25/2008 06:52:09 am
Re: Changing the Default Currency (2 replies, posted in Accounts Receivable)
First you create the currencies in GL. And after that you enter some exchange rates. Now you can select one of your currencies as the default currency for the company (in Company Setup).
/Joe
4,781 07/24/2008 09:40:15 pm
Re: Inventory Search (3 replies, posted in Items and Inventory)
You can use either item code, item category or item name in the search.
/Joe
4,782 07/24/2008 07:50:53 am
Re: database error (1 replies, posted in Report Bugs here)
The query you are referring to is inside /includes/db/inventory_db.inc in function add_stock_move().
The value of $person_id = null is among other in Manufacturing, work order entry.
I can NOT reproduce an error. The value of the person_id field is 0 after execution.
I am using PHP 5.2.4 and MySQL 5.0.18.
/Joe
4,783 07/22/2008 10:25:09 pm
Re: Bank Account Deposit Entry, Reference: will not auto advance (1 replies, posted in Banking and General Ledger)
You are right! Fixed in the CVS repository for unstable.
/Joe
4,784 07/21/2008 09:10:46 pm
Re: NEW COMPANY (7 replies, posted in Setup)
After you have created the 'TestCo' database, you must make sure you have a user with full previlegies for the database. If you do not have direct access to mysql, you can do this in the CPANEL for your server.
After that you are ready for creating a company in FA. Be sure to enter the exact information in the fields.
If you have several companies, it is easier to only use one database with a table prefix for each. Then you don't need to create databases for each new company.
I hope you are up and running now.
/Joe
4,785 07/21/2008 09:36:43 am
Re: NEW COMPANY (7 replies, posted in Setup)
I see that you use a script, called en_USE-new.sql. Are you sure this is right? The script that is shipped with the install is en_US-new.sql.
You should try once again with the correct script. I have never heard of problems creating a new company (beside the creation of the database).
/Joe
4,786 07/21/2008 07:32:44 am
Re: Customer Statements (8 replies, posted in Reporting)
Did you look at the Customer Reports in Sales? Hm...
/Joe
4,787 07/21/2008 07:30:27 am
Re: Setup Multiple Company (4 replies, posted in Setup)
Answered in the Setup Forum.
/Joe
4,788 07/21/2008 07:29:10 am
Re: NEW COMPANY (7 replies, posted in Setup)
If you get this error, you must create the database by yourself. You can do that with the PHPMyAdmin tool (or CPANEL) on the server. After you have created the database, you can create a new company with the same procedure as before.
/Joe
4,789 07/18/2008 09:12:19 pm
Re: Supplier Invoice GL items should be taxed? (2 replies, posted in Accounts Payable)
When entering GL Lines the tax has to be entered as a GL Line too.
FA has, though, been prepared for the automatic entry. Every account has a tax code field, so it would be possible to automatically enter the tax line if a tax code is here.
This is for future implementation.
/Joe
4,790 07/17/2008 07:29:48 am
Re: Proper Way to create a module / add-on (7 replies, posted in Modules Add-on's)
Hello t2webby,
I think it would be great, if you create a module for printing cheques. You can use any of the existing modules as a model. And you can look in the /reporting folder, repXXX.php to see how to make a report. You can also look in the file /reporting/includes/reporting.inc how to initiate a report outside the report-central.
And, of course, use Janusz's suggestion to keep track of check numbers.
If this turns out to be good, we will consider incorporating the cheque printing in coming releases.
/Joe
4,791 07/15/2008 06:36:40 am
Re: Report Error (1 replies, posted in Reporting)
Hello Alvin,
It seems that you have the '$go_debug' flag set in the config.php file. Please check if this is so. Set it to 0 to get the reports sent to your PDF reader.
What you got is the raw code that is sent to the PDF reader. We have determined to show the raw code with the '$go_debug' set.
/Joe
4,792 07/10/2008 10:59:28 pm
Re: An entered tax rate is invalid or less than zero. (2 replies, posted in Setup)
The RC2 installation might still have bugs, where the demo site are continuesly updated from the CVS repository at Sourceforge.net.
Shortly the RC2 will be replaced by a final release.
/Joe
4,793 07/10/2008 07:59:30 am
Re: journal entry in two currencies (3 replies, posted in Banking and General Ledger)
Hi again,
These are the rules:
If you enter a Payment or Deposit into a foreign currency account, the bank Inquiry is shown in the Bank Account Currency.
The GL Transaction is shown in domestic currency.
When you make a transfer between a domestic and foreign currency in Bank Transfer you do that in the foreign currency. The Bank Inquiries still show the statement in the Bank Account Currency.
If you want to enter a Journal Entry (as admin), with a line of a foreign currency account, you must calculate the exchange rate by yourself.
The GL accounts are always in the domestic currency.
I hope this clear things a bit 
/Joe
4,794 07/09/2008 10:57:46 pm
Re: How does the Purchases / C.O.G.S works? (4 replies, posted in Banking and General Ledger)
Hello again,
When you buy from your supplier, you buy to stock, not purchase account. The cost of goods sold is first debited when you make the delivery and the stock is credited. This is the normal way of doing it.
Think of it this way. You increase the stock when purchasing from the supplier. But if you should debit the purchase at this point you should credit the stock, but the stock is still there. First when the stock leaves with a delivery note the stock can be credited and now the COGS is debited.
Maybe still confusing, but...
/Joe
4,795 07/09/2008 09:07:37 pm
Re: How does the Purchases / C.O.G.S works? (4 replies, posted in Banking and General Ledger)
Hello,
When you get a supplier invoice, the Stock account is debited in GL with the purchase price as well as VAT is debited. and the AP account is credited.
When the Delivery Note to Customer is despatched the Stock account is credited with the average cost and the C.O.G.S account is debited with the same amount.
When invoicing the sales account is credited as well as VAT accounts and the AR account is debited.
/Joe
4,796 07/09/2008 08:49:39 pm
Re: journal entry in two currencies (3 replies, posted in Banking and General Ledger)
You only have access to bank accounts in journal entry when you are logged in as admin. Admin should have access to enter initial balances as well as other corrections. But, as admin, you should never add lines with non domestic currencies (bank accounts). This makes no sense.
You should use the Payment or Deposit forms for this.
/Joe
4,797 07/06/2008 08:45:21 am
Re: initial balance (like journal entry) set up for individual clients (12 replies, posted in Accounts Receivable)
Hello,
I understand that you do not mean the general ledger setup, but initial balances for your customers.
Well, this was tricky. I was thinking of using a fiscal year one year back and on the last day, create an invoice with service items for the balance.
Of course, this will also create GL entries, but you will get the AR account updated correctly. The sales account will be there too, but maybe you can do a counter booking manually afterwards.
Well, this was only a thought, maybe other have a better solution.
/Joe
4,798 07/01/2008 08:41:25 pm
Re: Changing languages (22 replies, posted in Report Bugs here)
changing the language in preference only change the language during the session. But for the language to function permanently you must change it in the user setup as well.
I hope you get it to work.
Joe
4,799 06/24/2008 09:12:17 pm
Re: New bugtracking system, Mantis. (9 replies, posted in Report Bugs here)
When reading the forum at Mantis, there was an infected 1.1.1.zip file back in March 2008. I don't know if this could have something to with the blocking. Does anyone know more about this? We are running version 1.1.2.
/Joe
4,800 06/24/2008 08:31:36 pm
Re: System and General GL Setup (4 replies, posted in Setup)
Hello,
It is really not necessary with a payroll account for FA to run. It has been created for future implementation. Anyhow, maybe someone writes a Payroll module, and in that case the default account may be set here.
/Joe