This article explains how to use the Contoso Coffee demo data to set up a subcontracting price list and allocate extra costs to subcontracted work using item charges. Instead of using a fixed cost on the routing, you can maintain a price list that Business Central uses automatically when you create purchase orders.
Scenario for pricing subcontracted Airpots and freight
You work with the subcontractor that assembles Airpots for Contoso Coffee. The subcontractor charges per unit, but there's a minimum order amount of 100.00 in local currency (LCY). You must set up a price list so that Business Central applies the correct price when you create subcontracting purchase orders.
After receiving the subcontracted work, a separate transport cost arrives from a logistics provider. You need to allocate this cost to the subcontracting output so that the production order reflects the true cost.
Prerequisites
To run this scenario, you need:
- The Manufacturing module generated in Contoso Demo Tool, including its automatically posted opening inventory. Learn more in Set up Contoso Coffee manufacturing data.
- The Subcontracting app installed from the marketplace.
- Item SP-SCM1009 with Routing No. set to SP-SCM1009-SUB-F (single subcontracting operation on Work Center 600, Local Assembly, linked to vendor 83000, Local Assembly). If you ran a previous walkthrough with routing SUB-1, change it back to SUB-F on the item card.
- Vendor 83000, Local Assembly with Subcontracting Location Code set to S83000. Learn more in Set the subcontracting location code on the vendor.
- Work center 600 with Unit Cost Calculation set to Units, as configured by the demo data. The prices in this walkthrough are per item, not per unit of capacity time.
Important
This scenario creates subcontracting price entries and posts purchase documents. If you want to repeat the scenario, delete the price entry and any open production or purchase orders from the previous run.
Set up the subcontracting price list
Select Search (Alt+Q) in the upper-right corner, enter Subcontractor Prices, and then choose the related link.
On a new line, fill in the fields as described in the following table.
Field Value Vendor No. 83000 Item No. SP-SCM1009 Work Center No. 600 Direct Unit Cost 15.00 Minimum Amount 100.00 The Vendor No., Item No., and Work Center No. fields are required. The Minimum Amount means that even if the unit price multiplied by quantity results in a lower amount, the purchase order line amount is at least 100.00.
Tip
For more granular pricing, define prices by Variant Code, Standard Task Code, and Unit of Measure Code. Matching also considers the effective dates, currency, and minimum quantity. Variant Code is hidden by default. To reproduce this example, avoid competing price entries for the same vendor, item, and work center.
Create the production order
Select Search (Alt+Q) in the upper-right corner, enter Released Production Orders, and then choose the related link.
Select the New action, and then fill in the fields as described in the following table.
Field Value Source Type Item Source No. SP-SCM1009 Quantity 5 Location Code MAIN Select the Refresh Production Order action, and then select OK.
Create the subcontracting order and verify pricing
- On the production order, select the Routing action.
- Select the subcontracting operation, and then select Functions, Create Subcontracting Order.
- Open the purchase order.
- On the Lines FastTab, check the Direct Unit Cost Excl. Tax field. Business Central got the price from the subcontracting price list, but because 5 × 15.00 = 75.00 is less than the minimum amount of 100.00, the unit cost is adjusted to 20.00 (100.00 ÷ 5) to meet the minimum.
- Check the Line Amount field on the subcontracting work line. It shows 100.00 because the minimum amount applies.
- In the Subcontracting Details FactBox, select Subcontractor Prices to view matching price entries for this vendor, item, and work center combination.
Receive and invoice the subcontracting order
- On the purchase order, in the Vendor Invoice No. field, enter an invoice number (for example, SC-PRICE-001).
- Select the Post action, and then select Receive and Invoice.
Allocate an item charge for transport costs
- Select Search (Alt+Q) in the upper-right corner, enter Purchase Invoices, and then select the related link.
- Select the New action. In the Vendor No. field, select 10000, Fabrikam, Inc..
- In the Vendor Invoice No. field, enter an invoice number (for example, TRANSPORT-001).
- On the Lines, set the Type field to Charge (Item).
- In the No. field, select JB-FREIGHT.
- Set the Quantity to 1 and the Direct Unit Cost to 50.00.
- With the item charge line selected, select the Line action, and then select Item Charge Assignment.
- On the Item Charge Assignment page, select the Get Receipt Lines action.
- Find the posted receipt line for the subcontracting work (vendor 83000, item SP-SCM1009). Select the line, and then choose OK.
- Verify that the Qty. to Assign is set to 1 on the receipt line. Close the Item Charge Assignment page.
- Select the Post action to post the purchase invoice.
Verify costs on the production order
Go back to the released production order for SP-SCM1009.
Select the Statistics action.
On the Cost tab, compare the columns:
- Expected: the subcontracting cost calculated from the routing (based on the routing line unit cost).
- Actual: the subcontracting cost from the posted purchase invoice plus the allocated item charge.
The actual cost includes both the subcontracting work, 100.00, and the 50.00 freight charge, so it exceeds the expected cost.
Related information
Introduction to Contoso Coffee Manufacturing
Set Up and Process a Subcontracting Operation
Use Different Component Supply Methods in Subcontracting
Subcontracting prices
Subcontracting overview