Skip to main content
Solved

Part costing - manual change

  • June 18, 2021
  • 4 replies
  • 600 views
D
Do Gooder (Customer)
Forum|alt.badge.img+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

Best answer by AanHGTS

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
    This topic has been closed for replies.

    4 replies

    AanHGTS
    Hero (Partner)
    Forum|alt.badge.img+12
    • AanHGTS
    • Hero (Partner)
    • 132 replies
    • Answer
    • June 18, 2021

    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
    Superhero (Partner)
    Forum|alt.badge.img+16

    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
    Do Gooder (Customer)
    Forum|alt.badge.img+2
    • DKSSI
    • Author
    • Do Gooder (Customer)
    • 4 replies
    • June 18, 2021

    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
    Superhero (Partner)
    Forum|alt.badge.img+16

    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 settingsAccessibility statement