Setting Up CTO Pricing—Exercises
IMPORTANT |
It is extremely important that you set up and work within your own site to maintain your data integrity. If you
work within any other site, you will compromise your own exercise data as well as the data of other students. Predictable
exercise results require that your data be isolated in your own site. |
Basic Data
Customer
Purpose: The purpose of this exercise is to set up the basic data required for creating a customer
order, which will be used in CTO price calculations.
Windows:
Customer
- Open the
Customer window, and search for customer 1000.
- Right-click, then click Copy Customer to create your new customer, XX3333.
- Click the Address/Order Address Info tab, and enter a ship via code 30 in the ship via field.
- Right-click and then click Supply Chain Matrix for Customer. In the
From Supply Site tab add a line valid for your site. Use ship via 30, and
external transport lead time one day.
Save the record.
- Click the
Customer/Invoice tab. Verify that invoice data is copied. If not, click New to enter valid data for this external customer.
- Click the
Order/Misc Customer Info tab. Enter NO in the order type field.
- Click the Customer/Address/Delivery
Tax Information tab. Verify that the tax code data is copied. If not,
click the Company field and click New to enter 10 in the company field.
Also verify that the tax code is copied. If not, create a new line and enter AZST in the tax code field.
- Save the record.
General exercise for Customer
General exercise for
Setting Up Site-to-Customer Supply Chain Parameters for Trade
Purchase/Inventory/Sales Part
Purpose: The purpose of this exercise is to create part data entries to be used when performing the CTO
flow in distribution.
Windows:
Inventory Part
Purchase Part
Supplier for Purchase Part
Calculate Purchase Leadtime
Sales Part
- Open the
Inventory Part window.
- Click New, enter 10 in the Inventory Part field, and your site. Save. This will copy the Easyflex garage door to your site.
- Enter yourself as planner in the planner field.
- Click the
Inventory Part/General tab. Verify that Part Type is Purchased.
- Click the
Inventory Part/Costs tab, and enter 1000 in the Estimated Material Cost field.
- Click the
Inventory Part/Default Locations tab. Open a new line and enter one arrival location, and one picking location as default locations.
- Save the record.
- Right click, then click Purchase Part.
- Right click, then click Supplier for Part.
- Connect part 10 to supplier 5000.
- Add 1000 in the price field.
- Click the
Supplier for Purchase Part/Inspection Info tab, and select Receive into Inventory.
- Save the record.
- Open the
Sales Part window, and click New.
- Enter Sales Part Number 10, and your site.
- Enter Sales Price Group EF.
- Enter Sales Group 10.
- Enter Price 1500.
- Change to Use order supply - transit in the Purchase Order field.
- Save the record.
General exercise for Purchased Inventory Part
General exercise for Supplier for Purchase Part
General exercise for Stored Sales Part
Main Exercises
Purpose: The purpose of this exercise is to show you how to set up pricing conditions for configured parts.
Windows:
Part Configuration Revision
Sales Part/Configuration Base Pricing
IFS Racing Inc uses different price conditions for the four characteristics handle, lock, finish of the door and number of
remote controls. Price for GDHANDLE is an amount offset. Prices for GDLOCK and GDFINISH are both connected to which option is
chosen. Finally price for remote controls depend on quantity.
- Open the
Part Configuration Revision window and search for Sales Part 10, EasyFlex.
- Create a new line and choose GDHANDLE via List of Values.
- Enter data listed for GDHANDLE below.
- Save the record.
- Repeat procedure and create records for GDLOCK, GDFINISH and GDREMOTE.
Characteristic |
Default Char Value |
Default Char Qty |
Mandatory character. |
Mandatory price |
Price break type |
Char Qty Price Method |
GDHANDLE |
Classic |
|
Yes |
Yes |
None |
No Price.. |
GDLOCK |
Assa |
|
Yes |
Yes |
None |
No Price.. |
GDFINISH |
1 |
|
Yes |
No |
None |
No Price.. |
GDREMOTE |
IR |
2 |
No |
Yes |
None |
Multiply Price... |
- Open the Sales Part/Configuration Base Pricing tab and search for Sales Part 10 EasyFlex.
- Add the four characteristics created above. Enter the pricing conditions according to the table below. Save the data.
Characteristic |
Quantity Break |
Amount Offset |
Multiply by Quantity |
GDFINISH |
0 |
0 |
Unchecked |
GDHANDLE |
0 |
20 |
Unchecked |
GDLOCK |
0 |
50 |
Unchecked |
GDREMOTE |
0 |
20 |
Checked |
GDREMOTE |
4 |
15 |
Checked |
Options GDFINISH
Option Value Id |
Description |
Percentage
offset |
Amount
offset |
Multiply by |
1 |
Aluminum |
+5 |
|
|
2 |
Steel |
0 |
|
|
3 |
Glass fiber |
-5 |
|
|
Options GDLOCK
Option Value Id |
Description |
Percentage
offset |
Amount
offset |
Multiply by |
Abloy |
Abloy Model 32 |
|
20 |
|
Purpose: The purpose of this exercise is to show you how to set up pricing conditions for configured
parts on a price list.
Windows:
Sales Basic Data/Sales Price Groups
Sales Part/General
Sales Part Base Price
Sales Price List
Customer
Data on Price List
Sales Part |
Description |
Min Quantity |
Base Price |
Percentage Offset |
10 |
EasyFlex |
1 |
1500 |
0 |
Data on Configuration Price List
Characteristics ID |
Percent offset |
Amount offset |
Multiply by Quantity |
Stop Price Search |
GDLOCK |
|
40 |
|
Unchecked |
Option for GDLOCK
Option Value ID |
Percent
offset |
Amount offset |
Multiply by Quantity |
Abloy |
|
10 |
|
- Connect the sales price group EF (EasyFlex) to Sales Part 10 EasyFlex in
Sales Part/General tab.
- Open the Sales Part Base Price window and enter a record for sales part 10. If the base price
has a status other than the Active status,
right-click and then click Activate in the Sales Part Base Prices
window.
- Create a price list in the
Sales Price List window by starting with the header. Name the price list XXC1 and enter a description, USD currency, and EF as sales price group.
- Click the Part Base tab and enter data on price list according to above table.
- Select one of the price list lines, right-click, then click Configuration Price List.
- Enter valid characteristic and option data for GDLOCK, using the table above.
- Finish by entering your site in the
Valid for Site tab.
- Open the Customer/Order/Pricelist per Price Group tab and search for XX3333.
- Add sale price group EF, currency USD, and price list XXC1.
- Verify that the customer is using USD as currency. Check this on both
Customer/Invoice and
Customer/Order/General tabs.