Performing Manual Reconciliation—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 Setup
Customer
Purpose: The purpose of this exercise is to show you how to create a customer to be used in the main exercise.
Windows:
Customer
- Open the
Customer window, and query for customer 1000.
- Right-click and then click Copy Customer to create your new customer, XX1000. XX represents your initials.
- Click the
Address tab and then the
Order Address Info tab.
- In the Ship Via field, enter a ship-via code.
- Right-click and then click Supply Chain Matrix for Customer.
- In the
From Supply Site tab, add a line that is valid for your site. Use * (asterisk) as the ship-via value, and one day as the
external transport lead time.
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 show you how to create part data entries necessary when
using the customer schedules functionality.
Windows:
New Part Assistant
- Open the New Part Assistant.
- Create XX–58–401 as a purchased, inventory, and sales part. Use Supplier 5000.
General exercise for Purchased Part
General exercise for Stored Sales Part
Reconciler
Purpose: The purpose of this exercise is to familiarize you with the required data that is used in the
exercises below.
Windows:
Customer Schedule Basic Data/Reconciler
- Open the Customer Schedule Basic Data window, and click the
Reconciler tab.
- Enter a reconciler.
General exercise for Reconciler
Approver
Purpose: The purpose of this exercise is to familiarize you with the required data that is used in the
exercises below.
Windows:
Customer Schedule Basic Data/Approver.
- In the Customer Schedule Basic Data window, click the
Approver tab.
- Enter an approver.
General exercise for Approver
Tolerance Template
Purpose: The purpose of this exercise is to familiarize you with the required data that is used in the
exercises below.
Windows:
Customer Schedule Basic Data/Tolerance Template.
- In the Customer Schedule Basic Data window, click the
Tolerance Template tab.
- Enter the values shown in the table below.
Bucket No |
Bucket Size |
Tolerance Bucket Unit |
Tolerance Under (%) |
Tolerance Over (%) |
1 |
5 |
Days |
2 |
0 |
2 |
20 |
Days |
5 |
5 |
3 |
60 |
Days |
25 |
25 |
General exercise for Tolerance Template
Schedule Line Type
Purpose: The purpose of this exercise is to familiarize you with the required data that is used in the
exercises below.
Windows:
Customer Schedule Basic Data/Schedule Line Type.
- In the Customer Schedule Basic Data window, click the
Schedule Line Type tab.
- Create a new line, and enter the values shown in the table below.
Line Type ID |
Description |
Demand Type |
Maintain High Cum Auth |
Default |
XX1 |
Back Order |
Backorder |
Do Not Maintain Cum |
Cleared |
XX2 |
Firm |
Delivery Authorized |
Maintain Cum |
Cleared |
XX3 |
Plan |
Not Delivery Authorized |
Do Not Maintain Cum |
Cleared |
XX4 |
Info |
Information Only |
Do Not Maintain Cum |
Cleared |
General exercise for Schedule Line Type
Required Data
Sales Part Cross-Reference
Purpose: The purpose of this exercise is to familiarize you with the required data that is used in the
exercises below.
- Open the
Sales Part Cross Reference window, and create a new line.
- In the Customer No field, select your customer from the List of Values.
- In the Sales Part Number field, select your sales part from the List of Values.
- In the Customer Part No field, enter the customer number for this sales part.
- In the Customer Sales Part Description field, enter the customer's description for this sales part.
- Save your changes.
Customer Order Header
Purpose: The purpose of this exercise is to familiarize you with the required data that is used in the
exercises below.
- Open the
Customer Order window, and create a new record.
- Create a customer order header for Customer XX1000, using Order Type CU.
- Release the customer order.
General exercise for Customer Order
Customer Schedule Agreement
Purpose: The purpose of this exercise is to show you how to create a customer schedule agreement to be
used in the main exercise below.
- Open the
Customer Schedule Agreement window, and create the customer schedule header.
- Accept the proposed agreement defaults.
- On the
Tolerance Check Defaults tab, check the Call-off to Call-off check-box under Cumulated Tolerance Check Options.
- Indicate the tolerance under 50% and tolerance over 100%. Save your changes.
- Click the
Customer Parts tab, and enter parts into the agreement.
General exercise for Customer Schedule Agreement
Customer Schedule Agreement Part
Purpose: The purpose of this exercise is to show you how to create a customer schedule agreement to be
used in the main exercise below.
- Open the
Customer Schedule Agreement Part window.
- Query for your agreement, and click the
Supply tab.
- Enter the supply data, and save your changes.
- Open the
Customer Schedule Agreement window, and activate the agreement.
General exercise for Customer Schedule Agreement Part
Entering Customer Schedule Manually
Purpose: The purpose of this exercise is to show you how to manually enter a customer schedule
to be used in the main exercise below.
- Open the
Customer Schedule window, and create a new record.
- Enter XXSCH in the Doc No field, and select the Call-Off schedule type.
- Click the
Misc Schedule Info tab. In the Agreement ID field, select the agreement part using the List of Values.
- In the Valid From field, enter a valid-from date of this coming Monday.
- In the Valid To field, enter a valid-to date of the Friday four working weeks later.
- Save your changes.
- Click the
Lines tab.
- Specify daily requirements of 10 pieces per day for the first week, starting Monday and ending Friday (the
Delivery Date/From Date and Qty Due fields). Use a line type that is delivery authorized, e.g., Firm.
- Specify daily requirements of 10 pieces per day for the second week starting Monday and ending Friday (the
Delivery Date/From Date and Qty Due fields). Use a line type that is delivery authorized, e.g., Firm.
- Specify a weekly requirement of 50 pieces on the third Monday. Use a line type that is not delivery authorized, e.g., Plan.
- Specify a weekly requirement of 50 pieces on the fourth Monday. Use a line type that is not delivery authorized, e.g., Plan.
- Save your changes.
General exercise for Entering Customer Schedule Manually
Main Exercises
Purpose: The purpose of this exercise is to show you how to reconcile a customer schedule.
Windows:
Customer Schedule
Customer Schedules
From the
Customer Schedule window:
- Open the
Customer Schedule window.
- Right-click and then click Reconcile to reconcile the schedule.
- Analyze the status in the schedule header.
- Analyzes the information on the
Reconciliation Info tab.
From the Customer Schedules window.
- Open the Customer Schedules window.
- Select the required schedule.
- Right-click and then click Reconcile to reconcile the schedule
Note: It is not possible to perform a reconciliation if the reconciler is
blocked for use.