x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 138 subscribers
  • Views 1987 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
Jeremy Rosenbaum

Standard Cost Calculation and BOM Codes

SOLVED
Posted By

I have been an X3 users for over 10 years (currently on v12; P18) but I am stumped on this one.  It has to do with the standard cost calculation function (CALCSTSTD).  I want X3 to calculate the std cost for items which all are contained in a single product category,  No issues here - i can set my formula in CALCSTSTD for this.  My issue is within this category; over 20+ BOM codes/routing codes are used.  My issue is when I run CALSTSTD; it creates a zero cost for all the items outside the BOM/routing code I ran CALCSTSTD for.

Example:  I have Product A with BOM/routing code 10 and Product B with BOM/routing code 11.  When I run CALCSTSTD for this product category AND BOM/routing code =10; Product A gets a STD cost; Product B gets zero.  Then when I run CALCSTSTD for the same product category but BOM/routing code =11; it gives Product A a zero cost and gives Product B a STD Cost.

What am I missing here?!?!?

  • 0
    SUGGESTED

    It is normal. You should set a primary BoM code (a unique one for a single site) that you use on multi-levels. Of course, you can have alternate BOM codes. But the BoM you define as primary is often the most used or cheapest one. You need to do it for Standard cost AND MRP processing.

    So you need to change the BoM records (you wish to use in standard cost / MRP) to use the same BOM code (at least per site).

  • 0
    SUGGESTED

    If Code is Alteernative BOM and Alternative Route, and you run CALCCSTSTD for all products calculation but selecting Bom Alt 10 is normal that the product which has Alternative 11 can not calculate the correct cost. In theoru if you run for each product separatlly but with the correct BOM/ROU alternative, will work. 

  • +1 in reply to Xavier.Buxade
    verified answer

    I think you may have the egg and chicken problem with this solution:

    *If you have level 1 of BoM using BoM code 10, level 2 of BoM using BoM code 11 and level 3 of BoM using BoM code 10, then when running the standard cost on BoM code 10 you will base your calculation on an old value for level 2 products.

    *Same if running the standard cost on BoM code 11 first then you will use the old value for level 3 products. 

    And if using MRP you don't know which BoM code to use. 

*Community Hub is the new name for Sage City