Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor

Main

Poll
I manage and monitor my Baan server/application with
HP Openview
7%
IBM Tivoli
14%
BMC Patrol
2%
Nagios
11%
Other
30%
What are you talking about?
37%
Total votes: 120

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 12th April 2009, 11:43
DineshSharma DineshSharma is offline
Senior Member
 
Join Date: Mar 2007
Location: Delhi
Posts: 204
DineshSharma is on a distinguished road
Baan: BaaN IV, ERP Ln 6.1 SP0, FP2 - DB: SQL2000 - OS: Windows Server 2000, 2003
Cost of Good Sold
Baan: ERP LN 6.1

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
Attached Files
File Type: doc cost of good sold.doc (30.0 KB, 45 views)
__________________
Dksharma
E-Mail: dksharma78mba@gmail.com
Reply With Quote
  #2  
Old 12th April 2009, 12:51
Dieter's Avatar
Dieter Dieter is offline
Member
 
Join Date: Aug 2001
Location: Germany
Posts: 88
Dieter is on a distinguished road
Baan: ERP LN 6.1 FP3 - DB: Oracle, MS SQL - OS: SuSE Linux, W2K3
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
Reply With Quote
  #3  
Old 13th April 2009, 08:44
DineshSharma DineshSharma is offline
Senior Member
 
Join Date: Mar 2007
Location: Delhi
Posts: 204
DineshSharma is on a distinguished road
Baan: BaaN IV, ERP Ln 6.1 SP0, FP2 - DB: SQL2000 - OS: Windows Server 2000, 2003
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
__________________
Dksharma
E-Mail: dksharma78mba@gmail.com
Reply With Quote
  #4  
Old 16th December 2009, 11:37
quelle's Avatar
quelle quelle is offline
Senior Member
 
Join Date: Oct 2008
Location: Thailand
Posts: 133
quelle is on a distinguished road
Baan: ERP LN 6.1 - DB: x - OS: x
hi, is there any solution for this issue?
i find same problem when try to receive from wh order transfer .
__________________
Regards,
Quelle
Reply With Quote
  #5  
Old 22nd December 2009, 05:01
DineshSharma DineshSharma is offline
Senior Member
 
Join Date: Mar 2007
Location: Delhi
Posts: 204
DineshSharma is on a distinguished road
Baan: BaaN IV, ERP Ln 6.1 SP0, FP2 - DB: SQL2000 - OS: Windows Server 2000, 2003
hi Quelle

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
__________________
Dksharma
E-Mail: dksharma78mba@gmail.com
Reply With Quote
Sponsored Links
  #6  
Old 22nd December 2009, 12:45
SiRfHuM SiRfHuM is offline
Junior Member
 
Join Date: Jan 2009
Posts: 17
SiRfHuM is on a distinguished road
Baan: Baan LN SP0, FP2, FP3, Baan IV, Baan V - DB: SQL - OS: Window xp
Cool Read Carefully

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.

Thanks
Sirf Hum
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: Cannot determine cost of goods sold baan_info Distribution, Transportation & Warehousing 0 19th August 2008 12:36
error mess "Cannot determine the cost of goods sold kinley Manufacturing & Supply Chain 2 29th July 2008 12:13
cannot determine cost of goods sold jadcoumine Project & Services 1 19th August 2004 11:22
Produce from raw mat'l or from semi finished good Paul P Manufacturing & Supply Chain 2 8th January 2004 07:52
Cost of goods sold integration NA YOUNG HOON Finance, Invoicing and Integration 1 10th June 2003 14:06


All times are GMT +2. The time now is 07:00.


©2001-2010 - Baanboard.com - Baanforums.com