Documentation
Apps › Manufacturing Suite › Co-Product & By-Product Costing › Documentation
Co-Product & By-Product Costing help
Co-Product & By-Product Costing splits the joint cost of a production run across its products, posts it through standard production orders in Microsoft Dynamics 365 Business Central, and settles each product at actual cost. This guide covers what you need before you start, how to set the app up, and how to use it day to day.
On this page
- Before you start
- Roles, permission sets and licences
- Set up the app
- Co-Product Setup fields
- Items
- Production formulas
- Batch orders
- Cost allocation
- Choosing a method
- Posting a batch
- Closing a batch: actual cost and variances
- Quality
- Lot genealogy and recall
- Reports, APIs and Power BI
- Troubleshooting
- Support
Before you start
- Business Central online, version 29 or later, Premium edition. Batch orders are posted through production orders, which are part of Premium.
- Microsoft Quality Management. A free Microsoft app, installed automatically on new environments. Install it first if your environment does not have it.
- Items for every input and output. Primary products, co-products, by-products, scrap and waste that you keep in stock are ordinary items. In this version every input is a material item: to include labour or machine time, add it as a cost item with the hourly rate as unit cost. Resource, machine centre and work centre inputs are refused when you certify a formula.
The app does not replace Business Central costing. The allocation decides how much of each material each output line of the production order receives. From there, WIP, Adjust Cost – Item Entries and G/L posting work as standard.
Roles, permission sets and licences
Choose the Co-Product Manager role under My Settings > Role for a Role Center with cues for formulas under development, certified formulas, open batch orders, batches to allocate and allocations not posted. Choose a cue to open the list behind it.
| Permission set | For |
|---|---|
| Co-Product User | Planners, production staff and cost accountants: formulas, batch orders, allocations, closing batches, reports |
| Co-Product Administrator | The person who sets the app up: everything in Co-Product User, plus setup, industry templates, and deleting formulas and allocations. To create the Quality Management inspection rule, also assign Quality Management’s own administrator permission set. |
| Co-Product Read Only | Viewing formulas, batch orders, allocations, genealogy and reports without changing them |
Licences are per user, in four plans (Starter 1–2 users, Team 3–5, Business 6–20, Enterprise 21 or more), each with the full app. Users without a licence get read-only access automatically, and Global, Dynamics 365 and Business Central administrators, and partners with delegated admin rights, can install and set up the app without one.
Set up the app
Do these steps once, with the Co-Product Administrator permission set.
- Run the setup guide. Open Assisted Setup and choose Co-Product Costing Setup. It sets the number series, the default allocation and by-product methods, your industry, and whether to load the industry scenario templates. You can also open Co-Product Setup and choose Initialize Setup.
- Assign permission sets to each user, as in the table above.
- Create the inspection rule if you inspect outputs. In Co-Product Setup choose Create Output Inspection Rule and pick the inspection template. Without this rule, Quality Management creates no inspections for batch outputs.
- Set up your items (see Items).
- Check the setup. Choose Validate Setup. It lists anything missing, such as a number series or the inspection rule.
For trials, an optional demo data extension creates sample formulas, batches and allocations. Ask us for it. It is not meant for production companies.
Co-Product Setup fields
| Field | What it does |
|---|---|
| Default Industry Type | The industry new formulas start with. |
| Default Costing Method | The allocation method new formulas start with. |
| Default By-Product Valuation | How new by-product, scrap and waste lines are valued. |
| Formula Nos., Batch Order Nos., Cost Allocation Nos. | The number series for each document. All three are required. |
| Joint Cost Account, By-Product Revenue Account, Scrap Recovery Account | G/L accounts for joint production cost, by-product revenue and scrap recovery. |
| Enable Lot Genealogy | Records which input lots went into which output lots, for the genealogy and recall trace. |
| Require Batch Tracking | Requires a lot on every input and output of a batch. |
| Enable Quality Management | Uses quality status on outputs. When a formula requires inspection, its outputs must be Passed or Conditional before the batch is closed. |
Items
On the item card, the Co-Product Info group holds the fields the app uses:
- Co-Product and By-Product: what the item usually is in a joint process.
- Co-Product Group: groups items for cost allocation.
- Equivalence Factor: the weighting used by the equivalence numbers method.
- Potency: the active-ingredient concentration of a material. Consumption is scaled up so the full active quantity is used.
- Environmental Impact and CO₂e per unit: used for sustainability tracking of by-products, scrap and waste.
The methods also read standard item fields: Unit Price for sales value, Net Weight for physical measure and Standard Cost for standard cost. Choose Formula Where-Used on the item card to see every formula that consumes or produces the item.
Production formulas
A production formula is the recipe for one joint process: its inputs, all of its outputs, and how the joint cost is split.
Create a formula
- Open Production Formulas and choose New, or choose New from Template to start from one of the 21 industry scenario templates.
- Fill in the Description, Industry Type, Base Quantity and unit of measure, and the Costing Method.
- Optionally set Starting Date and Ending Date, the period in which batch orders can be created from the formula, and switch on Genealogy Required or Quality Inspection Required.
- Add Input Lines: the materials, each with a quantity per base quantity and an optional scrap %. Add labour and machine time as cost items.
- Add Output Lines: each output has an Output Type (Primary Product, Co-Product, By-Product, Scrap, Waste or Rework), a quantity per base quantity, and the values the methods need: unit sales price, market price, further processing cost, equivalence number or allocation %.
- For by-products, scrap, waste and rework, choose the By-Product Valuation method.
Certify, reopen and versions
Choose Certify when the formula is ready. It needs at least one input and one output line, and a formula on manual allocation needs percentages that total 100%. If an approval workflow is enabled, the formula goes to Pending Approval first; Cancel Approval Request takes it back.
Certified, pending and closed formulas cannot be edited. To change one, choose Reopen: the version number goes up, and the change is recorded. Version History shows each certified version with its lines, and who certified or reopened it and when. Copy Formula makes a new formula with the next version number. Set a formula to Closed when it is no longer used.
Batch orders
A batch order runs a formula once, at a given size.
- On a certified formula, choose Create Batch Order. Enter the Batch Quantity, location, lot number and dates. Every line is scaled by batch quantity ÷ base quantity, with potency and scrap applied. The formula must be valid on the work date.
- Choose Release. The app creates a released production order with one line per output, and the materials as components. The batch card shows the Production Order No.
- As production runs, enter the actual quantities on the Input Entries and Output Entries, with the lots.
- Choose Finish. The joint cost is calculated from the actual inputs: actual quantity × unit cost.
A batch cannot be released without inputs and outputs, and the steps cannot be skipped: released before finished, finished before posted.
Cost allocation
On a finished batch order, choose Allocate Costs. The app creates a cost allocation with one line per output and calculates it with the formula’s method. You can also create one from Cost Allocations and choose Create Allocation Lines and Calculate Allocation. A batch order has one allocation only.
The calculation runs in two steps:
- By-products first. By-products, scrap, waste and rework are valued with their valuation method. Their value is the By-Product Credit, which is taken off the total joint cost.
- Then the split. What is left, the Joint Cost to Allocate, is split across the primary products and co-products with the allocation method. The percentages total 100%, and any rounding difference goes to the largest line, so the lines always add up to the joint cost.
By-product valuation
| Method | Value given to the by-product |
|---|---|
| Net Realizable Value | Sales value less further processing cost. |
| Reversal Cost (Reduce Main Product Cost) | Like net realizable value, but taken off the primary products only, after the split. |
| Standard Cost | The item’s standard cost. |
| Market Price | The market price on the output line, or the unit sales price if blank. |
| Zero Cost | Nothing. The by-product takes no cost and the main products carry all of it. |
Before you post, check the lines: each shows the basis used, the percentage, the allocated cost and unit cost, and the part of the cost that is material and the part that is capacity. To try another method, choose Reset Allocation, change the method and calculate again. Add dimensions on the allocation if they should be posted with the batch. When you are happy, choose Post Allocation: each output line of the batch order receives its allocated cost. A posted allocation cannot be posted again or changed.
Allocations on the manual method are left open after Allocate Costs, so you can check the percentages before calculating.
Choosing a method
| Method | Splits the joint cost by | Good when |
|---|---|---|
| Sales Value at Split-Off | Quantity × unit sales price | Products are sold as they come out of the process. Common in dairy, food and meat. |
| Net Realizable Value | Sales value less further processing cost | Products need different work after split-off. Common in refining, chemicals, pulp and paper. |
| Physical Measure | Quantity or weight | Products are similar in nature, such as grain or sugar fractions. |
| Equivalence Numbers | Quantity × equivalence factor | Products are similar but of different value or grade. The usual method in SAP. |
| Market Value | Quantity × current market price | Commodity products whose prices change often. |
| Standard Cost | Quantity × standard cost | Standard costs are stable and trusted. |
| Constant Gross Margin % | Gives every product the same gross margin % | Management wants the same margin across the product line. |
| Manual | The percentages you enter | Contracts or decisions the other methods do not cover. Must total 100%. |
Not sure? Start from the industry template’s recommended method, or compare methods on an allocation with Reset Allocation before you post.
Posting a batch
Once the allocation is posted, choose Post on the batch order. In one step, against the batch’s production order, the app:
- posts the consumption of each material, split across the output lines in the ratio of their allocated cost;
- posts every output at its allocated unit cost, with its lot;
- records CO₂e and recoverable value for by-products, scrap and waste;
- finishes the production order and sets the batch to Posted.
Splitting the consumption is what makes the allocation last: Business Central’s cost adjustment values each production order line from what was posted against that line. Nothing is staged in a journal.
Closing a batch: actual cost and variances
After posting, run Adjust Cost – Item Entries as usual. Each product then carries its allocated share at actual cost.
Open Batch Close. It lists the posted batches that are not closed yet, with the allocated joint cost, the actual cost so far, the cost variance so far, the yield variance in money, whether costs are adjusted, and how many outputs are not released by quality. You can run Adjust Cost – Item Entries from this page too.
When Costs Adjusted is on, choose Close Batch. The app reads the actual cost of each output from the ledger and stores, per output and for the batch, the actual material and capacity cost, the actual total and the variance against the allocation. The batch is then closed and its figures are final.
Outputs on standard cost stay at standard: the cost adjustment posts the difference as a variance, and the batch’s cost variance shows it.
Quality
Quality Management creates the inspections, not the app. With the rule from Create Output Inspection Rule, an inspection is created for every output posted. When the inspection is finished, the app sets the output’s Quality Status to Passed or Failed. Reopening the inspection resets it.
- When a formula has Quality Inspection Required, its batches cannot be closed until every output is Passed or Conditional.
- Without a Quality Management rule, you can set the quality status of an output by hand.
- Choose Certificate of Analysis on an output entry to print the Quality Management certificate for that item and lot.
- Blocking a lot that fails is done by Quality Management, with its own settings.
Lot genealogy and recall
Choose Lot Genealogy on a batch order, or open the page and enter a lot number.
- Trace Origin goes back through the batch orders to the materials and lots the lot was made from.
- Recall (Trace Usage) goes forward through every later batch the lot went into, to the customers who received it, with the shipment document and date.
The Recall Trace report prints the same trace. Standard Item Tracing works as well, because lots are posted as standard item tracking.
Reports, APIs and Power BI
| Report | What it shows |
|---|---|
| Co-Product Profitability | Allocated cost against sales value and profit per product. |
| Cost Allocation Report | One allocation in detail, with the basis, percentages, material and capacity cost, and a check that it adds up. |
| Formula Cost Sheet | The expected cost and output value of a formula. |
| Yield Analysis Report | Expected against actual output per batch, with variances. |
| Recall Trace | The forward trace of a lot to batches and customers. |
REST APIs (publisher gmsoft, group coProduct, version v1.0) cover formulas, batch orders and cost allocations, with actions to certify, release, finish, allocate costs and post. API queries for yield, profitability, batch cost variances and allocation line detail can be used from Power BI. Partners can extend the app through its integration events.
Troubleshooting
A batch order cannot be created from a formula. The formula must be Certified and valid on the work date. Check its Starting Date and Ending Date.
A formula cannot be edited. It is Certified, Pending Approval or Closed. Choose Reopen.
Allocate Costs is refused. The batch order must be Finished with a joint cost that is not zero, and it may not have an allocation already.
An allocation gives a zero basis. The method needs values the items do not have: a unit price for sales value, a net weight for physical measure, a market price, an equivalence factor or a standard cost. Fill them in on the item or the output line, or choose another method.
Post is refused on the batch order. The cost allocation must be calculated and posted first.
No inspections are created for outputs. There is no Quality Management rule for production output. Choose Create Output Inspection Rule in Co-Product Setup.
A batch cannot be closed. Either Adjust Cost – Item Entries has not settled every line of the production order yet, or the formula requires inspection and some outputs are not Passed or Conditional.
Something else is not set up. Choose Validate Setup in Co-Product Setup first.
Support
See the support page. Include your Business Central version, the app version shown in Extension Management, the batch order or allocation number, and the exact message.
