unit cost and computing for product cost

[ian tabangay]

Hi. I was looking into product costing and is wondering where the unit cost
specified in the InventoryItem entity is placed in. The only time the unit
cost was used in the computation was when a product is of a manufactured
type. What I was looking for is a way to get the average cost of my
products. These products were purchased from a supplier and are sold as is.

~ ian

[Jacopo Cappellato-4]

You can manage it using the "Cost" tab in the Catalog>Edit Product  
screens.
You can manually enter a record or automatically generate one using  
the form at the bottom of the screen.
However, for products that are purchased, the algorithm is very  
simple: the purchase price of the "primary" supplier is taken from the  
SupplierProduct entity (you can edit that information using the  
"Suppliers" tab).
There is also a service that you can submit from Webtools to bulk  
create the Cost records (using the above algorithm) for all the  
products.
Right now there is no support for the creation of cost information  
based on average in last purchases or similar. It would be a nice  
enhancement and we could enhance the form at the bottom of the Cost  
screen to let the user select the algorithm for cost creation (passing  
additional parameters such as: num of months to go back for the  
average etc...)

Jacopo

On Oct 2, 2008, at 7:20 AM, ian tabangay wrote:

> Hi. I was looking into product costing and is wondering where the  
> unit cost
> specified in the InventoryItem entity is placed in. The only time  
> the unit
> cost was used in the computation was when a product is of a  
> manufactured
> type. What I was looking for is a way to get the average cost of my
> products. These products were purchased from a supplier and are sold  
> as is.
>
> ~ ian

[Jacques Le Roux]

From: "Jacopo Cappellato" <[hidden email]>

> You can manage it using the "Cost" tab in the Catalog>Edit Product  
> screens.
> You can manually enter a record or automatically generate one using  
> the form at the bottom of the screen.
> However, for products that are purchased, the algorithm is very  
> simple: the purchase price of the "primary" supplier is taken from the  
> SupplierProduct entity (you can edit that information using the  
> "Suppliers" tab).
> There is also a service that you can submit from Webtools to bulk  
> create the Cost records (using the above algorithm) for all the  
> products.
> Right now there is no support for the creation of cost information  
> based on average in last purchases or similar. It would be a nice  
> enhancement and we could enhance the form at the bottom of the Cost  
> screen to let the user select the algorithm for cost creation (passing  
> additional parameters such as: num of months to go back for the  
> average etc...)
>
> Jacopo

Yes this would be a nice add-on !

Jacques

> On Oct 2, 2008, at 7:20 AM, ian tabangay wrote:
>
>> Hi. I was looking into product costing and is wondering where the  
>> unit cost
>> specified in the InventoryItem entity is placed in. The only time  
>> the unit
>> cost was used in the computation was when a product is of a  
>> manufactured
>> type. What I was looking for is a way to get the average cost of my
>> products. These products were purchased from a supplier and are sold  
>> as is.
>>
>> ~ ian
>
>