Cost By Seria Number

[Former Member]

Dear All,

In B1, there are 3 valuation methods (FIFO, Average, and Standard). And we can Manage Cost by Item Code or by Warehouse.

Anybody know how to maintain cost by serial number? it is possible to maintain cost by serial number or not in B1?

For Example :

Item Code : A001 - Item1

Good Receipt Transactions

====================

Receipt Date Item Code Serial Number Unit Price

1/1/2009 A001 SN001 1000

1/10/2009 A001 SN002 1200

1/30/2009 A001 SN002 1500

In 2/2/2009, if we make a delivery order for Item A001 (Item1), and we choose serial Number SN002.

Cost Of Good Sold In B1 for this Delivery Order:

===================================

- If we use FIFO Valuation Method : COGS Value = 1200

- If we use Average Valuation Method : COGS Value = 1233.33

Is it possible if we want use Actual Cost (Cost By Serial Number) which value is 1200 (because we choose SN002 for this Delivery Order).

Thank U All.

Regards,

Ratna

[Former Member · Accepted solution]

Hi Ratna,

In SAP business one, cost of goods sales is calculated from cost price of the item. The calculation of each item's cost price depends on the costing method you have chosen for it on the inventory tab page .

Item is the lowest unit for cost calculation and the cost price cannot be calculated by serial number separately. Since we couldn't set different cost price for the same item with different serial numbers, it

is not possible to calculate the cost of goods sales by serial number.

Regards,

Varun

SAP Business One Forum team.

[former_member186095 · Accepted solution]

The best solution for this is using Microsoft Dynamics Navision

Rgds,

[Former Member]

Dear Ratna,

As far as I know, your wish would be too difficult or even not possible to achieve because you want item level valuation lowered to serial number level. Since B1 determine the cost by one of the three levels: warehouse, item group and item. The calculation to lower level need to change every single transaction to make it happen. That task looks to me just like recreate the whole program. You option would be using standard cost and manage cost on your own.

Thanks,

Gordon

[former_member196647]

Hi,

I don't think it is possible in standard edition. There might be some add-on or something to do this.

Rahul