PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

Production Standard (Std) Cost Rollup

SAP Business One Tips Production Standard Cost Rollup

SAP Business One have a function to calculate Production Cost of an item. It can be calculated base on Standard Cost or it can be calculated base on current valuation cost.

The result will be stored in Item Master Data – Tab Production – “Production Std Cost” field.

SAP Business One Tips - FG Item Master Data

SAP Business One Tips – FG Item Master Data

To use this function, there are some things you need to prepare :

  1. You need to have a bill of material.
    For example, I have a BoM for item CPC10 that need components :

    • 5 pcs of RMCM01
    • 1 gr of RMCM02b

      SAP Business One Tips - Bill of Material Screen

      SAP Business One Tips – Bill of Material Screen

  1. Go to Item Master Data to setup production standard cost for those 2 components (RMCM01 & RMCM02b) and activate the option “Include in Production Std Cost Rollup”
    SAP Business One Tips - Component Item Master Data

    SAP Business One Tips – Component Item Master Data

     

    SAP Business One Tips - Component Item Master Data

    SAP Business One Tips – Component Item Master Data

     

  2. If it’s all setup, you can run the production standard cost rollup to update the production standard cost for the Finish Goods Items.

    SAP Business One Tips - Production Std Cost Rollup Menu

    SAP Business One Tips – Production Std Cost Rollup Menu

  3. In this example, I want to get production standard cost for the Finish Goods “CPC10”

    SAP Business One Tips - Production Std Cost Rollup

    SAP Business One Tips – Production Std Cost Rollup

  4. After you run the process, it will automatically update the production standard cost for CPC10 with the result as below.
    SAP Business One Tips - FG Item Master Data (After)

    SAP Business One Tips – FG Item Master Data (After)

    The value 573 comes from the component qty in BoM for CPC01 X component cost in item master data :

    • RMCM01 => 5 x 100 = 500
    • RMCM02b => 1 x 73 = 73
    • So total will be 573

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , ,