Dear All,

We are facing the problem related to the Cost of the Product. When we want to confirm the shipment line, the error message appeared " cost of Good Sold can not be determined.

I want to know, which table have the data of "cost of Good sold". We face this type of Problem in Shipment lines and some other receipt lines.

Please suggest me how can I correct this problem. The error screen shot is attached, for your reference.


Thanks in advance

Regards
Dinesh Sharma

Hello Dinesh,

this could be a problem with the date of the order. If the order intake date is before the date of calculation the cost of good sold then you get this message.

1. Check the date of the order
2. Re-caculate the cost of good sold for this item with a date that is before the date of the order.

Good luck

Dieter

Hi Dieter,

Thanks for your response.

I check the costing data of that item, it's costing date is prior the date of Sales order.

e.g. Costing date is 13-06-2008 and order date is 16-03-2009. And this shipment is partly confirmed. ( Sales Order Qty is 1000, we shipped and invoiced 600 pcs, Now, we want to process the balance quantity.

We release and Advice, the Outbound Line. But when we confirm the shipment line. The error message occured of Cost of Good Sold.

Regards

Dinesh

hi, is there any solution for this issue?
i find same problem when try to receive from wh order transfer :(.

Please check the Tables
tdsls401: Shipment number and delivered quantity
tdsls402: check the shipment number and delivered quantity
tdsls406: shipment number with date & time
tdsls409: check the costing data is avilable or not.

you get the difference with the shipment number is present in these tables.

Please check & correct these tables your shipment line is confirmed.

Regards

dksharma

Hi Dinesh,
I am agreed with Dieter,
Please check the BOM materials costing date,

and also please drill down your checking criteria.... in your case check backward detail. e.g.

Item code which you are going to sell.
Lot qty which you are going to sell.
Production order no. from which this lot qty generated
and in the same production order check the estimated material.
and check the Estimated material Cost price calculation date.

I am damn sure that estimated item is not as per Bill Of Material. so check estimated item and its date. than u will definitely find the exact item which have cost price calculation is after sales order date.
:cool:
Thanks
Sirf Hum