3,551 Reply by joe

(8 replies, posted in Wish List)

Hello chaitanya,
Frankly speaken, I am not convinced either. The problem is that the purchase has not gone into stock as a service item, but gone directly to COGS from supplier invoice.
The manufacturing is some kind of a cake upon cake development during the years. We really need to redesign it to get it more professional. I hope that we can make some kind of developers talk regarding this.
I guess that most of it works, with some major changes.
Regarding the existing usage of service of bom will only work with additional overhead/labour cost entry.

However, you could also solve it by letting the service item be a purchasable item. Instead of using the existing stock gl (inventory) account you could use another account in the GL for this. You could do me a favor testing how this would work.

Best regards

/Joe

Go to forum: Wish List

3,552 Reply by joe

(13 replies, posted in Setup)

You should setup your real company with an empty chart of accounts, f.i. en_US-new.sql.

/Joe

Go to forum: Setup

3,553 Reply by joe

(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

Go to forum: Wish List

3,554 Reply by joe

(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

Go to forum: FA Modifications

3,555 Reply by joe

(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

Go to forum: Accounts Payable

3,556 Reply by joe

(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

Go to forum: Modules Add-on's

3,557 Reply by joe

(8 replies, posted in Accounts Receivable)

Sorry for misleading. Glad you found it smile

/Joe

Go to forum: Accounts Receivable

3,558 Reply by joe

(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

Go to forum: Banking and General Ledger

3,559 Reply by joe

(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

Go to forum: Modules Add-on's

3,560 Reply by joe

(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

Go to forum: Accounts Receivable

3,561 Reply by joe

(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

Go to forum: Banking and General Ledger

3,562 Reply by joe

(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

Go to forum: Banking and General Ledger

3,563 Reply by joe

(8 replies, posted in Wish List)

Yes, no problems.

/Joe

Go to forum: Wish List

3,564 Reply by joe

(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

Go to forum: Dimensions

3,565 Reply by joe

(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

Go to forum: Dimensions

3,566 Reply by joe

(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

Go to forum: Report Bugs here

3,567 Reply by joe

(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

Go to forum: Accounts Receivable

3,568 Reply by joe

(10 replies, posted in Report Bugs here)

Hello, I see what you mean. We will have to do some internal descussions about this.

/Joe

Go to forum: Report Bugs here

3,569 Reply by joe

(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

Go to forum: Report Bugs here

3,570 Reply by joe

(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

Go to forum: Report Bugs here

3,571 Reply by joe

(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

Go to forum: Report Bugs here

3,572 Reply by joe

(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

Go to forum: Reporting

3,573 Reply by joe

(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

Go to forum: Manufactoring

3,574 Reply by joe

(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

Go to forum: Manufactoring

3,575 Reply by joe

(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

Go to forum: Accounts Payable