Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Manufacturing & Supply Chain

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 7th February 2007, 21:32
Eddie Monster's Avatar
Eddie Monster Eddie Monster is offline
Guru
 
Join Date: Nov 2001
Location: Pittsburgh, PA, USA
Posts: 344
Eddie Monster is on a distinguished road
Baan: Baan IVc4 - DB: MS SQL Server 2008 R2 - OS: MS Server 2008 R2
Cost Price Question on Standard Items
Baan: Other/Unknown

We are using Baan IVc4 (SP 19). We have items set up to represent the scrap which is generated through a normal manufacturing process. For every so many pounds of material required on the BOM, a negative amount of scrap material is also required. This creates a byproduct of scrap which then goes into inventory, outbounded to a sales order for the customer (our scrap dealer), and invoiced. Our current scrap items are set up as purchased items. We do not ever actually purchase these items. We do not utilize purchase price lists.

Our cost price calculation code is set to the following priority:
- Latest Purchase Price
- Average Purchase Price
- Current Purchase Price

The problem… when these items were set up, the system prompted the user to automatically populate the other purchase prices with the value entered into the Purchase Price field and they answered ‘Yes’. So now there are average and latest purchase prices. Since our cost price calculation priorities are what they are we can never update the standard cost since the Average and Latest Purchase prices are stagnant (remember we don't purchase these items). We have set up different cost price calculation codes which use the Current Purchase Price as the first priority (which will allow us to change the price temporarily), but we do not use the Single-Level cost price calculation method so eventually the top-level or a lower-level item will be recalculated using Top-Down or Bottom-Up methodology and using our standard cost price calculation code will revert the cost to the Latest Purchase Price which is not the one we want.

My question is: Although not entirely proper... since this item has no actual purchase history, is it OK to zero out the Average Purchase Price and the Latest Purchase Price for this particular item? If the answer is yes, other than verifying that there is no actually purchase history, are there any additional checks that I should make?


Thank you for any help you can provide.
Reply With Quote
  #2  
Old 8th February 2007, 11:19
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
Questions!!

Eddie,
Wanted to clarify few things about your case...
1) You mentioned scrap is generated through a manufacturing process. Does this mean you get excess when the production order is completed and then you transfer this excess to an item code you have created for storing scrap?
2) If the cost of this scrap changes frequently, have you thought of using projects(pcs)?

sk
Reply With Quote
Sponsored Links
  #3  
Old 8th February 2007, 19:25
Eddie Monster's Avatar
Eddie Monster Eddie Monster is offline
Guru
 
Join Date: Nov 2001
Location: Pittsburgh, PA, USA
Posts: 344
Eddie Monster is on a distinguished road
Baan: Baan IVc4 - DB: MS SQL Server 2008 R2 - OS: MS Server 2008 R2
Not quite...

The particular instance of manufacturing this revolves around is a coil of material running through a stamping press which produces a part and the residual coil (scrap). The finished good has a production BOM which looks like this:

Position 10, Item=Brass, Net Quantity=407 lbs
Position 20, Item=BrassScrap, Net Quantity=-132 lbs

So when they issue all material to the production order, Brass goes from inventory to the production order and Brass Scrap goes from the production order into inventory. Granted, it is the theoretical amount of scrap that should be genereated, but that is how our production people have set it up. The scrap inventory sits in the warehouse until the end of the month when they generate a sales order to sell the scrap to our scrap dealer. Hopefully this clears up your first question.

As far as using the PCS, I don't think that PCS functionality would gain us anything in regards to rolling up the price, plus that would mean we would have to maintain over 100 different projects for all of the different material types we use and their respective rates.
Reply With Quote
  #4  
Old 8th February 2007, 22:15
Eddie Monster's Avatar
Eddie Monster Eddie Monster is offline
Guru
 
Join Date: Nov 2001
Location: Pittsburgh, PA, USA
Posts: 344
Eddie Monster is on a distinguished road
Baan: Baan IVc4 - DB: MS SQL Server 2008 R2 - OS: MS Server 2008 R2
Update

I needed to resolve this so I went to support to pose the same question. They agreed that under the conditions mentioned above it would be ok to zero out the Average and Latest Purchase Price.
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
Standard Cost Price nto getting changed hksahu Manufacturing & Supply Chain 2 1st July 2008 11:33
Cost price question ? PEGAS1 Distribution, Transportation & Warehousing 4 16th November 2004 14:18
5.0c -> Cost price calculation for customized items in pcs-project Andreas Manufacturing & Supply Chain 1 21st September 2004 09:05


All times are GMT +2. The time now is 08:25.


©2001-2017 - Baanboard.com - Baanforums.com