This article was created with the assistance of AI tools for research and drafting. It was reviewed, edited, and fact-checked by our human editorial team before publication.

Trade-Ins

This chapter describes how to set up and process trade-ins via a calculation worksheet. This functionality proves valuable when you intend to both sell a machine and trade in a used one at the same time. To access the documentation for processing trade-ins without calculation worksheets, click here. This chapter is divided into the following sections:

Creating a Trade-In via a Calculation Worksheet

For the following description, we assume that you have already created a Sales Calculation Worksheet with an associated Calculation Worksheet. To create a trade-in via a calculation worksheet, proceed as follows:

  • Use the quick search (ALT+Q) to find the Configure/Price/Quote List page.
  • Open a sales calculation worksheet that contains a completed calculation worksheet.
  • Navigate to the Lines FastTab and open the calculation worksheet for which you want to create a trade-in.
  • Select the Return Type Trade-In in the General FastTab.
  • Then, click Trade-Ins in the menu bar.
  • The Trade-Ins FastTab is added to the page.
  • In the line for the trade-in, enter a Quantity and the Unit Price, i.e., the amount credited to the customer.
  • The amount will be offset against the sales price of the purchased machine.
  • Optional Additionally, enter a Responsibility Center, an Order Type, and a Location Code.
  • The values entered will be transferred to the trade-in document.
  • Click Trade-In > Create/Update Trade-In Order in the menu bar of the Trade-Ins FastTab.
  • The document for the trade-in is created.

You have successfully created a trade-in via a calculation worksheet. It is still possible to edit a trade-in even after a sales order has been created.

Tip

To open the trade-in, click Trade-In > Open Document in the menu bar of the Trade-Ins FastTab.

Creating a Purchase Document via a Calculation Worksheet

Instead of a trade-in, you can also create a purchase document via a Calculation Worksheet to post a returned machine in the system. Unlike a normal Trade-In, no credit memo is issued to the customer in this scenario. Instead, the vendor receives an invoice from the customer. In this case, the amount will also be offset against the sales price of the purchased machine. For the following description, we assume that you have already created a Sales Calculation Worksheet with an associated Calculation Worksheet. To set up a purchase document via the calculation worksheet, proceed as follows:

  • Use the quick search (ALT+Q) to find the Configure/Price/Quote List page.
  • Open a sales calculation worksheet that contains a completed calculation worksheet.
  • Navigate to the Lines FastTab and open the calculation worksheet for which you want to create a purchase document.
  • Select the Return Type Purchase in the General FastTab.
  • Then, click Purchase in the menu bar.
  • The Purchase FastTab is added to the page.
  • Enter the quantity in the Quantity column and the amount for the returned machine in the Unit Price column, i.e., the amount that will be invoiced to the vendor.
  • Optional Additionally, enter a Responsibility Center, an Order Type, and a Location Code.
  • The values entered will be transferred to the purchase order.
  • Click Purchase > Create/Update Purchase Order in the menu bar of the Purchase FastTab.
  • Confirm the dialog window with Yes to open the document.

You have successfully created a purchase order for a machine that is to be traded in. You will find more information on processing purchase orders in the Purchase Orders chapter. It is still possible to edit a purchase order even after a sales order has been created.

Setting Up Automatic Application of Trade-Ins to Sales Invoices

You can have open customer ledger entries of posted trade-ins and sales invoices applied automatically, provided the documents belong to the same CPQ. To set this up, proceed as follows:

  • Use the quick search (ALT+Q) to find the Sales & Receivables Setup page.
  • Navigate to the CPQ FastTab.
  • Activate the Apply Trade-Ins Automatically toggle.

You have successfully set up the automatic application of trade-ins to sales invoices. The system now checks during posting whether a uniquely assignable counter-document exists and automatically applies the open customer ledger entries in this case.