You should setup your real company with an empty chart of accounts, f.i. en_US-new.sql.
/Joe
3,552 09/11/2010 12:07:40 am
Re: Groupings or hierarchy of services (items) (8 replies, posted in Wish List)
The overhead cost and labour cost can be used in these cases where you have either purchase cost or other costs.
/Joe
3,553 09/10/2010 07:10:44 am
Re: some more inventory control features (2 replies, posted in FA Modifications)
Yes, a very good idea, Alvin. This will go to next major upgrade 2.4. Unfortunately the 2.3 database is locked by now.
/Joe
3,554 09/08/2010 11:59:55 pm
Re: Taxes and Supplier invoices (7 replies, posted in Accounts Payable)
If you are using a supplier with tax, you should put the correct tax group on this supplier. Look eventually in the FrontAccounting Wiki regarding tax, .
For items there are no problems then. The purchase prices are ex. tax. The tax is calculated as you enter the items. And when you save the invoice the tax GL line(s) are done automatically.
If you are using the GL part of the supplier invoice, you will have to enter the tax manually. But I would suggest creating some Quick Entries for this. Then it is very handy to just select a quick entry and the lines are created automatically for you. Look in the FrontAccounting Wiki regarding this too.
/Joe
3,555 09/08/2010 08:45:01 pm
Re: repgen, pdf report blank (3 replies, posted in Modules Add-on's)
Alvin, it is a long since I have worked with this repgen, so I have almost forgotten how it works.
Maybe something is wrong in designing your report. Try to look in the manual.html file to see if something is missing.
Or maybe other out there can help us with this, please.
/Joe
3,556 09/08/2010 01:21:39 pm
Re: How could it be done with sales without inventory? (8 replies, posted in Accounts Receivable)
Sorry for misleading. Glad you found it 
/Joe
3,557 09/08/2010 10:48:11 am
Re: My COGS is doubled. Please help (6 replies, posted in Banking and General Ledger)
Hello again,
It seems that you have encountered a bug in 2.2.11 and 2.3 RC1.
We are not maintaining 2.2.11 anymore, but you can fix this bug in file /sales/includes/db/sales_delivery_db.inc line 93:
if ($delivery_line->standard_cost != 0) {
to
if (is_inventory_item($delivery_line->stock_id) && $delivery_line->standard_cost != 0) {
This will prevent future problems.
The operations already done, you can counter-book the bookings from the delivery note in Journal Entry. Remember to use the same date.
Thanks for finding this bug, and good luck.
/Joe
3,558 09/08/2010 06:59:09 am
Re: repgen, pdf report blank (3 replies, posted in Modules Add-on's)
Set the $go_debug flag in config.php and see if any errors are reported. Also try pdf_debug.
/Joe
3,559 09/08/2010 06:56:51 am
Re: How could it be done with sales without inventory? (8 replies, posted in Accounts Receivable)
No, you will have to register the Item before sales. However you can sell it without buying. But then you will have to mark 'Allow negative Stock' in Company Setup before.
We do not recommend using it, but sometimes it is necessary to get started.
/Joe
3,560 09/08/2010 06:51:21 am
Re: My COGS is doubled. Please help (6 replies, posted in Banking and General Ledger)
There must be some setup problems somewhere in the chart of accounts you use. Which chart of account did you use when creating a new company?
Check that all related Inventory and COGS accounts are setup correctly in System and GL Setup, Supplier, Item Categories, Items, Branch accounts.
According to your information you have created a correct Service Item. But somewhere there is a mismatch in COGS account setting.
/Joe
3,561 09/07/2010 08:54:29 pm
Re: My COGS is doubled. Please help (6 replies, posted in Banking and General Ledger)
There seems to be some wrong setup. When you call it a service item, are you sure you didn't set it up as Item Category 'Service' and not the Item Type as 'Service'?
If this is setup correctly as a Service Item Type there will be no GL transactions on delivery.
/Joe
3,562 09/06/2010 02:53:05 pm
Re: Groupings or hierarchy of services (items) (8 replies, posted in Wish List)
Yes, no problems.
/Joe
3,563 09/02/2010 10:55:03 pm
Re: Dimension In Direct Delivery (1 replies, posted in Dimensions)
Ha, there is no logic here. We have just forgotten to include it.
We will try to get it done for 2.3 RC.
/Joe
3,564 09/02/2010 06:39:27 am
Re: Dimensions in Sales Order andd Sales Quotation? (1 replies, posted in Dimensions)
If dimensions on items, customers, then they are already there. Otherwise first on delivery or invoicing where you can select.
/Joe
3,565 09/01/2010 09:52:18 pm
Re: Recurrent invoices uses customer pricelist instead of template prices (10 replies, posted in Report Bugs here)
We have to take into consideration the currency, if used.
We are still considering. If this is going to be an option, we need another field in the recurrent invoice, and the database for 2.3 is locked, so this will first be implemented in 2.4 if we do so.
In the meantime, you can do what Gerhard suggest.
/Joe
3,566 09/01/2010 06:37:34 am
Re: Mailing updated invoices (9 replies, posted in Accounts Receivable)
First check that you have a functional email provider in your environment. Secondly check that your customer/branch has a valid email address.
/Joe
3,567 08/31/2010 03:20:35 pm
Re: Recurrent invoices uses customer pricelist instead of template prices (10 replies, posted in Report Bugs here)
Hello, I see what you mean. We will have to do some internal descussions about this.
/Joe
3,568 08/31/2010 10:50:39 am
Re: Recurrent invoices uses customer pricelist instead of template prices (10 replies, posted in Report Bugs here)
Just to ensure that we are not misunderstanding each other.
When the line prices are calculated it uses the current customers (that are addresses in the recurrent invoice) sales type and/or currency.
Not the price from the template. The template is only telling which items are to go on the recurrent invoice and are not linked to the customers that are receiving the invoice.
I hope it works that way.
/Joe
3,569 08/30/2010 02:48:02 pm
Re: Recurrent invoices uses customer pricelist instead of template prices (10 replies, posted in Report Bugs here)
Yes, please try if you can reproduce your error in the demo.
If you get an error, then let it be on the demo, so I can follow it.
/Joe
3,570 08/30/2010 11:05:53 am
Re: Recurrent invoices uses customer pricelist instead of template prices (10 replies, posted in Report Bugs here)
Hello,
Are you sure you have set things up correctly. These routines have been tested rigoriously.
The algorithm to get the line prices can be found here:
In the file /sales/includes/sales_db.inc
Line 86
function get_price ($stock_id, $currency, $sales_type_id, $factor=null, $date=null)
Please look and try to follow the algorithms to see that it really does many operations depeding on how you have set up the prices.
/Joe
3,571 08/30/2010 10:35:48 am
Re: Miscellaneous issues in financial reporting (1 replies, posted in Reporting)
The 'Calculated return' in Balance sheet is the same as the Net Profit for the Period. When the year is closed it will be converted to Retained Earnings. So it is a kind of Equity, although not yet booked. This is the reason for calling it Calculated Return.
The calculated return is also the difference between assets and liabilities.
/Joe
3,572 08/30/2010 07:19:28 am
Re: Bulk Manufacturing (2 replies, posted in Manufactoring)
In the BOM you define the products that are included in 1 item (1 lip stick).
When you manufacture you enter the number of lip sticks you want to produce. Any problems with that?
/Joe
3,573 08/30/2010 07:16:24 am
Re: Can we purchased Manufctured item also? (2 replies, posted in Manufactoring)
There are some internal reasons to do that. You could create a purchasable item of the normally assembled item.
/Joe
3,574 08/30/2010 07:13:34 am
Re: There are no purchasable inventory items defined in the system (9 replies, posted in Accounts Payable)
Try to put the debug flag, $go_debug' in config.php to 1 and see if this create some warnings. There must be some mismatch somewhere.
/Joe
3,575 08/29/2010 10:42:41 am
Re: FA setup error fiscal year (13 replies, posted in Setup)
Hello again,
I can't tell what has went wrong here.
If you know what you are doing and the years are open you can use phpMyAdmin and manually fix the fiscal years. But be careful that you have a continuance. No gap between the years.
/Joe