Set up subcontracting prices and allocate item charges

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

  1. Select Search (Alt+Q) in the upper-right corner, enter Subcontractor Prices, and then choose the related link.

  2. On a new line, fill in the fields as described in the following table.

    FieldValue
    Vendor No.83000
    Item No.SP-SCM1009
    Work Center No.600
    Direct Unit Cost15.00
    Minimum Amount100.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

  1. Select Search (Alt+Q) in the upper-right corner, enter Released Production Orders, and then choose the related link.

  2. Select the New action, and then fill in the fields as described in the following table.

    FieldValue
    Source TypeItem
    Source No.SP-SCM1009
    Quantity5
    Location CodeMAIN
  3. Select the Refresh Production Order action, and then select OK.

Create the subcontracting order and verify pricing

  1. On the production order, select the Routing action.
  2. Select the subcontracting operation, and then select Functions, Create Subcontracting Order.
  3. Open the purchase order.
  4. 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.
  5. Check the Line Amount field on the subcontracting work line. It shows 100.00 because the minimum amount applies.
  6. 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

  1. On the purchase order, in the Vendor Invoice No. field, enter an invoice number (for example, SC-PRICE-001).
  2. Select the Post action, and then select Receive and Invoice.

Allocate an item charge for transport costs

  1. Select Search (Alt+Q) in the upper-right corner, enter Purchase Invoices, and then select the related link.
  2. Select the New action. In the Vendor No. field, select 10000, Fabrikam, Inc..
  3. In the Vendor Invoice No. field, enter an invoice number (for example, TRANSPORT-001).
  4. On the Lines, set the Type field to Charge (Item).
  5. In the No. field, select JB-FREIGHT.
  6. Set the Quantity to 1 and the Direct Unit Cost to 50.00.
  7. With the item charge line selected, select the Line action, and then select Item Charge Assignment.
  8. On the Item Charge Assignment page, select the Get Receipt Lines action.
  9. Find the posted receipt line for the subcontracting work (vendor 83000, item SP-SCM1009). Select the line, and then choose OK.
  10. Verify that the Qty. to Assign is set to 1 on the receipt line. Close the Item Charge Assignment page.
  11. Select the Post action to post the purchase invoice.

Verify costs on the production order

  1. Go back to the released production order for SP-SCM1009.

  2. Select the Statistics action.

  3. 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.

Introduction to Contoso Coffee Manufacturing
Set Up and Process a Subcontracting Operation
Use Different Component Supply Methods in Subcontracting
Subcontracting prices
Subcontracting overview

Find free e-learning modules for Business Central here