Solved

Part costing - manual change

  • 18 June 2021
  • 4 replies
  • 464 views
D
Rank
Userlevel 2
Badge +2
  • DKSSI
  • Do Gooder (Customer)
  • 4 replies

Hi

 

I have a finished good with a standard cost (BOM & Routing exist) but I want it at zero cost in my inventory, ie all actual cost on the shop order comes as a shop order deviation in P&L.

 

I guess the best idea is to set the item to ‘zero cost only’

 

 

 

but when I try to save it I get an error

 

 

 

But I have no idea how to set the cost of the product to zero!

Anybody now how to move forward here ?

 

Thanks,    Søren

icon

Best answer by AanHGTS 18 June 2021, 09:21

View original
This topic has been closed for comments

4 replies

AanHGTS
Rank
Userlevel 5
Badge +12

You may try this;

  1. Set the part to Zero Cost Allowed
  2. Create a dummy Cost Template without Cost Buckets
  3. Attached the dummy Cost Template to the Part Cost and calculate cost and copy to cost set 1.
  4. Check the Unit Cost is zero in the Inventory Part/Cost tab
  5. Set the Inventory Partto Zero Cost Only
Cheers, Aan de Silva - https://www.linkedin.com/in/aandesilva/
Tharindu Illangasinghe
Rank
Userlevel 6
Badge +13

Hi @DKSSI ,

 

You cannot set to “Zero Cost Only” when there is a total unit cost like below.

 

When you have on-hand quantities for the particular part it will be quite tricky to set this to “0”. As it affects your inventory value. 

Best Regards, Tharindu Illangasinghe, https://www.linkedin.com/in/tharindubi/
D
Rank
Userlevel 2
Badge +2

Hi

yes it will have effect on inventory value, but that is what I’m looking for, I want it valuated at zero.

To better understand what it is, in this case we are producing some test items where production needs to know which material to use and how much capacity is needed. But the output of the testrun has no value and can’t be in my inventory at a value.

 

Regards

Søren

 

 

Tharindu Illangasinghe
Rank
Userlevel 6
Badge +13

Hi @DKSSI ,

 

One of the options you can do is;

  1. calculate cost for cost set “2”
Make sure Cost Set in the header is “2”

 

  1. Make sure total cost is “0”

 

  1. Then copy costs to cost set one

 

  1. As a result, total unit cost will be zero

 

  1. Now you can change the value

 

  1. Additionally, you can see the existing stocks are revaluated for new cost value (“0”)

 

Best Regards, Tharindu Illangasinghe, https://www.linkedin.com/in/tharindubi/
Terms & ConditionsCookie settings