Com 61 Se Common Data in Baan LN PDF
Com 61 Se Common Data in Baan LN PDF
Com 61 Se Common Data in Baan LN PDF
1
Student Manual and Exercises
SSA ERPLN 6.1.00
Common Data
Contents........................................................................................iii
About this course........................................................................ ix
Course Goal....................................................................................................... x
Course Objectives.............................................................................................. x
Who Should Attend this Course........................................................................xii
Audience .......................................................................................................xii
Prerequisites .................................................................................................xii
Organization of Course Materials ....................................................................xiii
Lesson Objectives........................................................................................xiii
Lesson Materials ..........................................................................................xiii
Lesson Exercises .........................................................................................xiii
Flows............................................................................................................xiv
Icons Used Within this Course .....................................................................xiv
Navigation ........................................................................................................xvi
Menu Paths .................................................................................................xvii
Course Agenda .............................................................................................. xviii
Duration...................................................................................................... xviii
Course Introduction .................................................................. xix
Enterprise Structure Model ...................................................... 1-1
Enterprise Structure Model .............................................................................1-2
Company Structures ...................................................................................1-2
Enterprise Structure Model .........................................................................1-3
Enterprise Units and Entities.......................................................................1-7
Company Data ..............................................................................................1-15
iii
ERP LN 6.1.00 Common Data
iv
Contents
v
ERP LN 6.1.00 Common Data
vi
Contents
List of Flows
The Flow: Sample Flow ...................................................................................xiv
The Flow: Company Set up ..........................................................................1-18
The Flow: Calendars.....................................................................................1-37
The Flow: Number Groups and First Free Numbers.......................................2-2
The Flow: Units and Unit Sets ......................................................................2-11
The Flow: Routings .......................................................................................4-40
The Flow: Alternative Manufacturers ............................................................4-68
The Flow: Cost Price Calculation Master Data ...............................................5-5
The Flow: Cost Price Calculation..................................................................5-24
The Flow: Calculate Cost Prices...................................................................5-41
The Flow: Business Partners ..........................................................................6-2
The Flow: Business Partner Customer Roles ...............................................6-12
The Flow: Supplier Business Partner Roles .................................................6-14
The Flow: People Master Data Flow...............................................................7-4
The Flow: Team Hours .................................................................................7-45
vii
ERP LN 6.1.00 Common Data
viii
About this course
Common Data covers the basic master data and base data required to set up
and operate a new company install. The Common Data course introduces the
basic concepts of how data is organized and entered in the Common Data
package. Common Data is used by the other packages and modules and forms
the foundation data used throughout ERP LN.
This section contains information that will help you use this course material
effectively both during training and as a performance tool after training.
Navigation
Course Agenda
Course Introduction
ix
ERP LN 6.1.00 Common Data
Course Goal
The goal of this course is to enable you to enter and maintain the basic Common
Data that is used and shared among the various modules and packages.
Course Objectives
After completing this course, you will be able to:
Define Countries
x
About this course
xi
ERP LN 6.1.00 Common Data
Audience
This course is designed for all persons working with the logistics or applications
aspects of the software. The audience should include planners, project
managers, materials personnel, sales and purchasing, and financial persons.
SSA® ERPLN, Common Data is the foundation course in the logistics curriculum
and should precede any other courses.
Prerequisites
These courses should be completed before taking SSA® ERPLN, Common Data
xii
About this course
Lesson Objectives
The objectives at the beginning of every lesson enable you to see the functions
and concepts you will master by the end of the lesson.
Lesson Materials
Each lesson sequentially presents concepts and guides you through step-by-step
procedures. You may see items such as figures, screens, bulleted text, notes,
business examples, and/or definitions intended to help you follow along with the
procedures and focus on important ideas.
Lesson Exercises
Lesson exercises are included to give you hands-on practice with the important
skills you will learn in the lessons.
xiii
ERP LN 6.1.00 Common Data
Flows
Flows provide a sequential listing of key sessions or activities required to execute
the functionality within the software. Each box within the flow states an activity
you will perform. This activity statement is written at the top half of the box. In
some cases, however, activities or tasks may be optional, which may be
represented by additional lines drawn from one box to another. Flows containing
session names and codes tell you where in the software the activity is to be
completed. Alternatively, you may also see Flows that only contain activity
statements.
Start
End
xiv
About this course
NOTE: A Note icon alerts you to additional and helpful information or hints
regarding the topic.
xv
ERP LN 6.1.00 Common Data
Navigation
®SSAERPLN Webtop uses a Graphical User Interface (GUI) to operate on the
Windows operating system. Sessions contain icons and menus, which allow you
to navigate and execute activities within the software. The sample Toolbar
displays the icons and menu options you will commonly encounter within the
sessions. You may see different icons and menu options depending upon the
session you are in.
Sample Toolbar
xvi
About this course
Menu Paths
You may see several menu paths in the lessons and exercises. These paths
illustrate where you must navigate to within the software to find the appropriate
session.
In the lesson exercises, menu paths direct you to the appropriate sessions in the
software. Within each exercise, you will normally open the session listed in the
menu path and view or insert a new record. Sub-sessions may also be required
during exercises and (in most instances) can be accessed from the main session
listed in the menu path.
xvii
ERP LN 6.1.00 Common Data
Course Agenda
The key topics covered within this course include:
Business Partners
People Data
Duration
xviii
Course Introduction
Common Data is data that is general data that can be applied across multiple
packages and modules. By defining Common Data in a single location, rather
than within each package and module, there is a reduction in the amount of data
required to be defined in the system.
Financial master data establishes base data in your company for financial
transactions to occur. The information is important because once defined, it
forms the basis for all transactions. When defined incorrectly, financial master
data such as Financial Integrations can seriously affect the performance and
accuracy of the financial data in the system.
Item data is used in almost every package in the application. Item base data
enables defining item information in a central location that can be accessed and
applied to the other packages and modules.
The Cost Price Calculation (CPR) module simulates or establishes the costs of
production items and purchase items. The cost price calculates and compares
costs generated on the shop floor and also determines the inventory valuation.
Cost prices can be broken down into material, operation, and overhead costs.
xix
ERP LN 6.1.00 Common Data
xx
1
Enterprise Structure
Model
Lesson Objectives
After completing this lesson, you will be able to:
1-1
ERP LN 6.1.00 Common Data
Company Structures
The Company Structure determines how your organization operates and also
determines how the table structures are defined within the application. The
Enterprise Structure model represents the various Enterprise Units and Entities
and their relationships within the company structure.
Single Logistic/Multi-Finance
Multi-Logistic/Single Finance
Multi-Logistic/Multi-Finance
When you decide to create a multi-company structure, you are required to use
one company to:
1-2
1 Enterprise Structure Model
Business Example
RAC Manufacturing Company makes chairs and train car seats within 2
divisions. Financial Company 100 and 101 represent the 2 divisions. RAC has
three manufacturing plants represented by Logistic Companies 103, 104, and
105. Some entities (warehouses, work centers, and Business Partners in this
example) within the plants report to the Chair Division and others report to the
Rail Division.
Bus. Bus.
Warehouse Work Warehouse Warehouse
Partner Partner
BBF Center JN1 CA3
BA101 BC02
By linking the entities to the EUs, you can direct the appropriate financial
reporting to the correct division.
One level below the enterprise structure model are the business models.
Business models can be linked to enterprise units. This relationship implies that
1-3
ERP LN 6.1.00 Common Data
the enterprise unit is the indirect link between an enterprise structure model on
the one hand and multiple business models on the other hand
2. Click the Edit Diagram icon or select Edit Diagram from the Specific menu
The diagram will display the currently defined Enterprise Units for your company
1-4
1 Enterprise Structure Model
3. From the Enterprise Structure Model select the Enterprise Model and from
the Specific menu select Enterprise Structure Model Browser option.
1-5
ERP LN 6.1.00 Common Data
You will see a display that indicates which Enterprise Units are linked to the
Enterprise Model and the number of Entities (in parenthesis) that are associated
with each Enterprise Unit.
1-6
1 Enterprise Structure Model
Enterprise Units
Enterprise Units are used to model and setup single and multi-company
organizations. The Enterprise Units can represent a grouping of entities such as
departments, work centers, warehouses, and projects. The enterprise unit
entities must all belong to the same logistic company. Multiple enterprise units
can be defined per logistic company. An enterprise unit is linked to a single
financial company.
When logistics transactions between enterprise units occur, the transactions are
posted to the financial companies to which each enterprise unit is linked. The
enterprise structure models define the relationships between the enterprise units,
and the transfer of goods that is allowed between the enterprise units.
There must be at least one Enterprise Unit defined for each company. You may
have several enterprise units, but at least one is required. This is the case, even
if your company is a single logistic/single financial company.
1-7
ERP LN 6.1.00 Common Data
Business Example
You have 2 Logistic companies that are posting financial transaction into 1
Finance company.
The figure represents a grouping of entities into an Enterprise Unit. The figures
within the Enterprise Unit ovals represent the entities (departments, work
centers, and warehouses). The Enterprise unit links the entities from Logistic
companies 100 and 101 to Financial Company 100.
1-8
1 Enterprise Structure Model
Enterprise Units
Field Description
Enterprise Unit The code or name representing the enterprise unit
Description The description or name for the enterprise unit
Enterprise Unit Category The Enterprise units can be divided among a user-
defined system of classification. This enables managing
enterprise units as a group.
Financial Company The company in which the data such as the exchange
rate required for the transactions between enterprise
units is stored. The financial company for all financial
transactions for this enterprise unit.
Default Purchase Office
Entities
Entities are the separate and independent building blocks for clusters and/or an
enterprise unit. Entities represent the logistical or financial functional units within
your organization. Departments, warehouses, work centers, employees, and
1-9
ERP LN 6.1.00 Common Data
Entities are linked to an Enterprise Unit. You do not define an entity in one
session, rather when you create a warehouse, department, or business partner
(internal or affiliated) the entity record is created. You can view all entities in the
Key Entities (tcemm1510m000) session.
Key Entities
Field Description
Entity Type Displays the type of entity displayed:
Department
Warehouse
Work Center
Project
Etc.
Operational Company The logistic company the entity resides within
Entity The code representing the entity.
Enterprise unit The enterprise unit that links this entity to the
appropriate financial company for recording financial
transactions.
1-10
1 Enterprise Structure Model
Entity Relationships
Goods transfer relationships can be defined between entities to make it possible
to automatically generate internal or inter-company transactions. This is helpful
when entities are linked to enterprise units that have different financial
companies.
There are several Entity relationships that exist. The purpose of relationships is
to define the structure for transactions between entities within the Enterprise
Structure. The details apply to the goods transfer relationship between:
For example, the relationship between a purchase office and a sales office is
required if the sales office receives an order for goods that are not in stock. The
sales office can request the purchase office to purchase the goods and deliver
them directly to the customer. The sales office invoices the customer, and the
purchase office invoices the sales office. An invoice is then generated from the
purchase office to the sales office.
The shipping office that is linked to the issuing warehouse or the receiving
warehouse is responsible for planning the delivery and pays the carrier's invoice.
The sales office invoices the business partner for the order, or the purchase
office pays the business partner.
If you define a goods transfer relationship between the shipping office and the
sales office or purchase office, the internal invoices can be generated between
the shipping office and the sales office or purchase office to balance the
accounts.
1-11
ERP LN 6.1.00 Common Data
You can define goods transfer relationships between warehouses and between
shipping offices to specify whether the issuing entity or the receiving entity is
responsible for planning the goods transfer and paying the carrier's invoice. The
internal invoices can be generated between the entities involved to balance the
accounts.
You can define goods transfer relationships between warehouses of the same
and of different logistic companies of a multi-company structure. You can only
define goods transfer relationships between other types of entities if the entities
belong to the same logistic company.
To define the details of the goods transfer relationship, use the Goods Transfer
(tcemm2150m000) session. You can select the set of goods transfer details that
applies to the relationship in the Relationship Detail field.
The relationship only applies between the effective date and the expiry date.
Outside this period, goods transfer between the entities are handled in the
standard way
1-12
1 Enterprise Structure Model
Entity-Entity Relationships
Field Description
From Entity type The type of entity that will issue the goods
Company The logistic company for the entity issuing the goods.
Entity The entity that will issue the goods.
To Entity type The type of entity that will receive the goods transfer.
Company The logistic company where the goods will be
transferred.
Freight Planning Entity The entity responsible for the freight orders for the
goods transfer.
Shipping Office The shipping office, linked to the freight planning. This
office controls the freight order for the goods transfer.
1-13
ERP LN 6.1.00 Common Data
Field Description
Type of Order to be If the relationship defined applies to warehouses of
Generated by Enterprise different logistic companies, this is the replenishment
Planning method used to replenish the inventory in the issuing
warehouse.
Effective Date The date the entity relationship is valid.
View the Key Entity session to observe what entities have been created.
Key Entities
The session displays all the available entities that have been defined in the
logistical company by Entity type. The various entities displayed are an overview
of all entity types created in the system.
1-14
1 Enterprise Structure Model
Company Data
A company, generally identified by a three-digit number such as 120, represents
an individual company. A company contains a set of data tables that store
records unique to that company. A Company also consists of one or more
entities: warehouses; departments; business partners, projects.
Address
Language
Calendar
Currency
This information defined for the company, is used as the default values when
defining a new:
Department
Warehouse
Employee
You define data and work with data stored in the company database tables.
Company Data for a company typically includes base data such as:
Business Partners
Departments
Ledger Accounts
Item Codes
Invoicing Methods
Sales Orders
Purchase Orders
Invoices
Projects
1-15
ERP LN 6.1.00 Common Data
Currencies
Company Types
A Company Type identifies the purpose and application of the company within
the Enterprise Structure. There are four types of companies that can be defined:
Field Description
Logistic Company Used for logistic transactions such as the production
and transportation of goods. The company tables
store all logistic data transactions.
Financial Company Used to post financial data transactions from the
Finance package. You can link one or more
Enterprise units from one or multiple logistic
companies to a financial company.
Both (Logistic and Contains both logistic and financial tables and can
Financial) log logistical transactions as well as the associated
financial transactions in the company database
tables.
Financial Group A financial company that has a number of other
Company financial companies liked to it. A Financial Group
company is used as a central company to group
transactions and:
Process corporate or administrative accounting
Accumulate data for consolidated financial
reporting from the group’s financial companies.
Perform central cash management processes
such as payments and direct debit.
Logistical
A Logistic company uses the logistic tables in the database. Therefore, a
logistic company handles logistical transactions. Various entities such as sales
offices, purchase offices, warehouses, and work centers often comprise a logistic
company.
Financial
A Financial company is used for posting financial data within the Finance
package. You can link one or more enterprise units from multiple logistics
companies to one financial company. A company of the type Financial can only
1-16
1 Enterprise Structure Model
When using a Financial Group Company, you can specify default information in
the Group Company Parameters (tfgld0101s000) session. The parameters
contain information such as:
1-17
ERP LN 6.1.00 Common Data
Start
End
1-18
1 Enterprise Structure Model
Field Description
Archive Company Indicates if this company is used as an archive company
to store archived transactions.
Address Code The default company address.
Country The default country for your company. This value
defaults to departments and addresses for your
company.
Language The default language for you company and printed on
instructions and documents.
1-19
ERP LN 6.1.00 Common Data
Field Description
Package checkboxes Selecting the checkbox indicates that package will be
implemented in the current company database.
1-20
1 Enterprise Structure Model
Field Description
Modules check boxes Selecting the checkbox indicates that module will be
implemented in the current company database.
1-21
ERP LN 6.1.00 Common Data
Field Description
Concepts checkboxes Selecting the checkbox indicates that particular
functionality will be implemented in the current company
database.
In the actual Implemented Software Components session you can define your
company data using the values
1-22
1 Enterprise Structure Model
1. On the record for the Actual Implemented Software Components data set,
click the Details icon.
General Data
Field Input Value
Address Code ADD000001
Country NLD
Language NLD
1-23
ERP LN 6.1.00 Common Data
You have defined the default information for address, language, and country for
your company. Also, you have indicated which packages and modules are
implemented for the company as well as what functionality is being used such as
unit effectivity.
1-24
1 Enterprise Structure Model
Companies
This session is used to maintain the enterprise modeling data of the company,
including currency and company type information. This session follows after
defining the logistic data for the company in the Implemented Software
Components (tccom0100m000) session.
1-25
ERP LN 6.1.00 Common Data
Companies
Field Description
Company Type The company type dictates the type of transactions that
are posted to the tables. The available options are:
Logistical
Financial
Both
1-26
1 Enterprise Structure Model
Field Description
Currency System The currency system for the company. Defines how
amounts are calculated and registered.
The three available currency systems:
Single
Independent
Dependent
Local Currency The currency of the country where the company is
physically located.
Reference Currency The base currency for all calculations of currencies. The
reference currency is the common base currency of all
companies in a multi-site structure.
Purchase The exchange rate type used to convert purchase
transactions form another currency to the home
currency.
Sales The exchange type used to convert sales transactions
form another currency to the home currency.
Calendar The default calendar used for the company.
Time Zone The time zone where the company is physically located.
For companies of the type Financial or Both you must
specify a time zone. The time zone is used to post
transactions and calculate exchange rates with the
proper time.
1-27
ERP LN 6.1.00 Common Data
Companies
The result is that your company now has the Company Type defined as Both and
the currencies have been defined. The new company has been defined in the
Companies (tcemm1170m000) session. You now must indicate the general
information for your company.
1-28
1 Enterprise Structure Model
Companies
Common Parameters
Parameters set default data for the system. Common parameters include the
Initialize Parameters (tcmcs0295m000) session and Common Parameters
(tccom5000m000) session. Setting Common parameters is one of the first
actions when establishing a new company
The Common Parameters establishes default setting and functional settings. The
main session contains a history list of parameter sets and their effective dates as
well as the current parameter set, at the top of the list (without an effective date).
The current set is the set of parameters that are currently in effect.
The Common Parameters lists the history of the parameter settings and
maintains the current set of parameters. This session lists:
1-29
ERP LN 6.1.00 Common Data
The current parameter set, at the top of the list (without an effective date)
You can view previous parameter settings by double-clicking one of the historical
parameter sets.
If you make changes and save the new parameter set the system will:
Update the current parameter set, identified by the record without a date.
COM Parameters
1-30
1 Enterprise Structure Model
Field Description
Introduction Date The date and time that the parameters are valid. The
parameters are valid up to the effective date of a more
recent parameter setting
Business Partners If you want to use a number group or series numbers for
coding business partners select this check box.
If you create a business partner, you must select a series
from the number group. The system generates the
business-partner code from the series code plus the first
free number in the series.
If you want to enter your own code for a new business
partner, clear this check box.
Business Partners The number group used to generate business-partner
codes.
Select a number group that is not already assigned to
another purpose
Addresses If you want to use a number group and series numbers for
coding addresses, select this check box.
If you create an address, you must select a series from the
number group. The systtem generates the address code
from the series code plus the first free number in the series.
If you want to enter your own code for new addresses,
clear this check box.
Addresses The number group used to generate address codes.
Contacts If you want to use a number group and series numbers for
coding contacts, select this check box.
If you create a contact, you must select a series from the
number group. The system generates the contact code
from the series code plus the first free number in the series.
If you want to enter your own code for new contacs, clear
this check box.
Contacts The number group used to generate Contact codes.
Priority Distance Tables The sequence in which the distance between two
addresses is determined:.
Using the city name
Using the ZIP/postal code.
This information to verify delivery dates in:
The Sales Control module
The Purchase Control module
The Service Order Control module
1-31
ERP LN 6.1.00 Common Data
Field Description
Time Unit for Seconds The time unit in which the distance (time needed to cover
the distance) between two delivery addresses is
expressed.
The unit must be of the Time type and must be expressed
in seconds in order to enable the distance calculations
based in time in the sessions:
Distance Tables by City (tccom4537m000)
Distance Table by ZIP Code/Postal Code
(tccom4538m000).
1. Find the Parameter record for the Actual COM Parameters record and click
on the details.
1-32
1 Enterprise Structure Model
COM Parameters
The New Addresses number group is now ADD. When you create a new
address, you will view the First Free Numbers that are defined for the Address
Number Group ADD.
1-33
ERP LN 6.1.00 Common Data
COM Parameters
1-34
1 Enterprise Structure Model
COM Parameters
The COM Parameters are now set for your company. The default number groups
for Business Partners, Addresses, and Contacts are defined.
1-35
ERP LN 6.1.00 Common Data
You can assign calendars to various resources in the application to manage that
resource. For each type of resource you can assign a specific calendar to:
Business Partners in each of the sub entity role sessions from the Business
Partners (tccom4500m000) session
1-36
1 Enterprise Structure Model
Start
Set Parameters
CCP Parameters
(tcccp0100m000)
End
1-37
ERP LN 6.1.00 Common Data
Parameters
The CCP Parameters (tcccp0100m000) session establishes the base parameters
for Start Time, Calendar Length, and Availability type. These will be the values
that default if no values are defined for the respective resources.
The CCP Parameters set the default information for Start time, Calendar length
and the Default Availability Type for external software packages.
CCP Parameters
Availability Types
Availability types provide a means to categorize the availability of a resource.
Typically, an availability type relates to a specific activity type and enables
categorizing the availability of a resource depending on the activity. The value of
the Availability Type determines where the resource is available.
1-38
1 Enterprise Structure Model
You can indicate if an Availability Type is available for use or not by checking the
Available check box on the Availability Type on the corresponding day in the
Calendar Working Hours (tcccp0120m000) session.
Availability Types
Field Description
Availability type Code representing the availability type
Default Available If this check box is selected, the availability types is
available during the related time intervals in the
calendar, that is, the activity associated with the
availability type is available.
The setting of the field is just a default for the lines
recorded in the Calendar Working Hours
(tcccp0120m000) session, and to which a certain
availability type is linked. In each of these lines you can
still determine whether the availability type is available
or not by clicking the Available check box.
1-39
ERP LN 6.1.00 Common Data
1. Insert a new record and create Availability type WC1 for the work center.
Availability Types
1-40
1 Enterprise Structure Model
Availability Type
Field Input Value
Availability Type XX1 (Replace XX with your initials)
Description Standard Avail. - Daily
Default Available Select the check box
Availability Types
1-41
ERP LN 6.1.00 Common Data
Field Description
Start Time The beginning mark for the time frame the working
hours type applies
End Time The ending mark for the time frame the working hours
type applies.
Efficiency Factor Use this factor to account for resources that work more
or less efficiently for the planning of shop floor
operations.
Impacts lead time calculation.
Capacity % The maximum utilization percentage of a resource for
the working hour type. If you specify 80%, then only
80% of the available working hour duration is
considered available for utilization.
Overtime If checked, this working hours type is considered as
overtime and is used in modules such as Service and
Contracts.
1-42
1 Enterprise Structure Model
2. Enter the Working Hour Type Code MON and define the time from 8:00am to
4:00pm and indicate it is available for overtime. The Efficiency Factor is 1.00
and the Capacity is 100%.
3. Click New and insert a second Working Hour Type code WED with the time
8:00am to 4:00pm. The Efficiency Factor is 1.00 and the Capacity is 100%.
The new Monday and Wednesday working hours are now defined with an 8 hr
time frame.
1-43
ERP LN 6.1.00 Common Data
Standard Calendar
This session is used to define the defaults for each day of the week. The
standard calendar supplies default information, such as availability type, working
hours, and efficiency factor for each day of the week. The system needs this
information to update the Calendar Working Hours (tccp0120m000) session. If
the end date of a specific calendar is reached and you still want to plan ahead, a
search for the parent calendar is made and if no parent calendar exists, the
standard calendar is used.
The standard calendar is the basic calendar for which you define for your
company. This calendar can have exceptions, such as non working or non
available time. You must define at least one new calendar, and link this calendar
to your company in the Companies (tcemm1170m000) session. This step is
mandatory. If you need a calendar in a rather elementary business structure, the
definition of a standard calendar and a company calendar can be sufficient.
1-44
1 Enterprise Structure Model
Standard Calendar
Insert the Availability type WC1 for Monday and Wednesday for use with the new
Distribution Center.
2. Insert the Availability type WC1 and use the Working Hour Type MON.
1-45
ERP LN 6.1.00 Common Data
Standard Calendar
This indicates that for Monday, the availability type WC1 applies and the working
hours available for the Availability type will be from 8:00am to 5:00 pm.
1-46
1 Enterprise Structure Model
Standard Calendar
1-47
ERP LN 6.1.00 Common Data
Standard Calendar
You can repeat the steps and enter the Availability Type XX1 for each Tuesday,
Wednesday, Thursday, and Friday.
Calendar Codes
The Calendar Codes (tcccp0110m000) session is used to define specific
calendars. These can be the various calendars you wish to use for the
application. Each Calendar has a start and end date specified and if applicable a
parent calendar is referenced.
1-48
1 Enterprise Structure Model
Calendar Codes
Field Description
Calendar Code User defined code to represent the calendar definition.
Parent Calendar If you do not want to enter a parent calendar, the
standard calendar is linked directly to this calendar.
If you link a parent calendar to your calendar, you
cannot set the start date later, nor set the end date
earlier than the start and end date of the parent. You
can only set the start date earlier and the end date later
than the end and start date of the parent calendar.
Start Date The date the calendar begins
End Date The expiry date for the calendar.
Define a Calendar
The next step is to define a calendar code to define the start and end dates for
the calendar. You then link availability types to this calendar under the Calendar
Availability Types
1-49
ERP LN 6.1.00 Common Data
1. Insert a new record for calendar DS1 with the effective dates from today to
six months in the future.
Calendar Code
Enter the new Calendar code XXW and make the dates valid for 1 year.
1-50
1 Enterprise Structure Model
Calendar Codes
1-51
ERP LN 6.1.00 Common Data
This is only used when you are referencing the standard calendar as a template.
Field Description
Availability Type The availability type that is available for use with this
particular calendar code. Only the availability types
linked to the calendar code are considered when the
calendar is generated during the Update Calendar
(tcccp0226m000) session.
Link the availability type WC1 to the calendar DS1 for the distribution center.
1-52
1 Enterprise Structure Model
You now have linked Availability Type WC1 to the Calendar DS1.
The details of this session are generated when the calendar is updated. If you
modify the working hours for the calendar, then the modified line is marked as
Manual in the Derived From Field.
The working hours types that you connect to a combination of calendar and
availability type in this session, determine the available time and capacity of that
combination of a calendar and availability type.
This session enables viewing details for calendars after the Update Calendar
(tcccp0226m000) session is executed or to manually enter or modify working
hours for a calendar.
1-53
ERP LN 6.1.00 Common Data
Field Description
Date Date for the working hours type for the specified
calendar/availability type combinations.
More than one working hour type for the same date can
be specified. If there is an overlap for the working hours
on a specific date a warning will be displayed.
Available The available check box is selected by default. If the
checkbox is cleared, the fields that become unavailable
are:
Working Hours Type
Start Time
End Time
Capacity
Efficiency Factory
Derived From Displays the recurrence code, or the name of the parent
calendar. If the line is derived from the standard
calendar, from an unavailable day, or if the Calendar
Working Hours (tcccp0120m000) session was used to
link the specific working hours type to an availability
type, this field is empty.
1-54
1 Enterprise Structure Model
You can use the icons on the toolbar to shift backward and forward in the
calendar, to go to a specific date, and/or to allow display of the working hours for
the specified calendar per:
Day
Week
Month
Year
In addition to the display functions, you can select the View By option on the
Specific menu and select the viewing option for the system to display the working
hours per:
4 Weeks
Quarter
Half
Year
The Specific menu also provides various options to zoom to sessions that
contain more calendar details.
2. Change the Working Hours Type from MON to STD for 9/13/2004.
The new Calendar Working Hours indicates that on 9/13/2004 the available
working hour type for that day is STD and the Start time is 12:00 and the End
Time is 5:00. This is now the time frame the Distribution Center is operating for
that day.
1-55
ERP LN 6.1.00 Common Data
Update Calendar
This session is used to update the working hours and capacity details in the
Calendar Working Hours (tcccp0120m000) session.
You run this session to generate the calendar after specifying changes in the
Calendar Working Hours (tcccp0120m000) session to make the changes take
effect. Whenever changes are made to the calendar working hours, this session
is run.
1-56
1 Enterprise Structure Model
Addresses
Addresses are defined for Companies, Departments, Employees, Warehouses,
Business Partners, Contacts, and Banks. Addresses can be set up to print in
alternative ways by using address formats. For instance, you may want to print
the fax number and e-mail address on a request for quotation, but not on the
shipping documents. You can define a format for each application.
1-57
ERP LN 6.1.00 Common Data
Field Description
Address Code The manual or system generated code representing the
address. If the COM Parameters indicate using address
number groups, you select the First Free Number for the
address code.
Country Specified the country the address is located in.
Zip Code The postal code or zip code identifying the location of
the address.
State /Province Identifies the state or province the address is located.
City Identifies the city where the address is located.
1-58
1 Enterprise Structure Model
Field Description
Country for VAT ID Check When using tax, this field records the VAT ID code.
Tax Number When tax is applicable, the tax number can be based on
the address to identify the applicable tax.
1-59
ERP LN 6.1.00 Common Data
The new address code ADD000046 for the Distribution Center is now available.
You can assign this address to a Department, Business Partner, Warehouse, etc
indicating the physical location of the entity.
1-60
1 Enterprise Structure Model
Addresses
Address Formats
You use address formats to define how addresses must be printed on
documents. You can use this to avoid that address information is truncated at the
end of a field or line.
1-61
ERP LN 6.1.00 Common Data
Field Description
Line The Line number indicates which line on the address
label the field will print.
Sequence The sequence is used to print more than one field per
line. The information is truncated if the multiple fields do
not fit on one line. Priorities are not checked when
truncating occurs.
Priority Priority indicates if a field can be omitted. If there are not
enough lines available to print the complete address
according to the format, the lines with the highest priority
(lowest priority number) are printed until the address is
full.
1-62
1 Enterprise Structure Model
1-63
ERP LN 6.1.00 Common Data
1-64
1 Enterprise Structure Model
The address printed using the Address Format GER prints the House Number
(B-120) and the City (Los Angeles) which were defined in the address format
instead of the address (500 W. Palm) which is specified in the standard address
format.
1-65
ERP LN 6.1.00 Common Data
Lesson Review
In this lesson, you learned how to:
1-66
1 Enterprise Structure Model
Review Questions
1. The Enterprise Structure Model?
1-67
ERP LN 6.1.00 Common Data
1. A
2. D
3. B
1-68
2
Logistics Common Data
Common Data is general data that can be applied across multiple packages and
modules. By defining Common Data in a single location, rather than within each
package and module, there is a reduction in the amount of data required to be
defined in the system.
Lesson Objectives
After completing this lesson, you will be able to:
Define Countries
2-1
ERP LN 6.1.00 Common Data
Start
End
Definition
A Number Group defines information specific to a type of document, order, or
other logical numbering sequence. This includes information such as:
2-2
2 Logistics Common Data
COM Parameters
The Number Group to use for each type of document or common data record is
specified in the relevant parameter table. For instance, the number groups to use
for Business Partners, Addresses, and Contacts, are detailed in the COM
Parameters (tccom5000m000) session.
Number Groups
You identify orders, contracts, invoices, and other documents by their order
number or document number. The document number consists of the series code
2-3
ERP LN 6.1.00 Common Data
followed by a sequential number. In addition, you can use series codes and
series numbers to identify other types of records than documents.
Business partners
Addresses
Purchase contracts
Sales orders
Production orders
Service orders
Warehousing orders
Freight orders
Number Groups
Field Description
Number Group The code used to identify the number group.
Series Length Determines the number of characters that can be
defined for the series for the number group.
For example: If you specify a series length of 3 for a
number group, you can specify series of 001, 100,.ABC
etc.
2-4
2 Logistics Common Data
Field Description
In Use Indicates if the number group is currently being used
and is selected as a parameter setting in one of the
packages. You cannot remove number groups that are
in use, but you can add additional series.
Dedicated for Number groups can be dedicated to a specific use or
package. More than one number group can be
dedicated to the same use.
For example: You can specify number groups PRD and
PRO as dedicated for Production.
To use the series for a type of document or record, you must assign the number
group to the document type or record type. You can assign a number group to
only one type of document or record.
As the series codes can be alphanumeric, the generated document numbers can
be alphanumeric and they can consist of up to nine characters.
2-5
ERP LN 6.1.00 Common Data
Field Description
Series The alphanumeric code representing the series
associated with the Number Group identified.
First Free Number The first number available for use with this series. When
you define a new series you must indicate the first
starting number. Each time an order is generated with
the series, the number is incremented by one.
Cache Size The number of sequential series numbers that can be
generated and reserved for an individual user login. The
system will generate sequential numbers reserved for
the user and hold them until the user logs out, or uses
the number.
For example: If the cache size is 3 for series ADD with a
first free number of 1, the system will hold the numbers
ADD000001, ADD000002, and ADD000003 for the user.
Blocked for Input You can stop the use of a series by indicating it is
blocked. This prevents using that series number for
generating orders or documents.
Business Example
It is determined the number group PRO will be establishes for production orders.
You define the series length of three (3) places. You then define a series of 110
to represent manually created production orders. For the series 110 you also
2-6
2 Logistics Common Data
specify the First Free Number of 10. When you enter a production order
manually you select series 110. When the data is saved and the production order
number is generated it will be 110000010. The next manually generated number
will be 110000011.
Create the new series WHS and PUR for Number Group 001 Addresses.
Two new series, WHS and PUR, are now available for use. When a new address
is being created, the series WHS and PUR are available for use.
2-7
ERP LN 6.1.00 Common Data
2-8
2 Logistics Common Data
2-9
ERP LN 6.1.00 Common Data
2-10
2 Logistics Common Data
Start
End
Units
You use units to express and manage physical quantities. You must define all the
units used by your company using the Units (tcmcs0101m000) session. Unit Sets
are user-defined and contain as many or as few units as required.
2-11
ERP LN 6.1.00 Common Data
The rounding factor specifies the decimal place you want to round off to when
converting one unit to another. For example, the centimeter (cm) unit has a
rounding factor of 0.1. There are 2.54 centimeters in one inch. Rounded off to the
nearest tenth of an inch, 2.54 becomes 2.5.
Define Units
A new unit of measure is required to represent the shipping crates your company
uses for oversees shipments. The new unit CRT will represent the Crate.
2. The physical quantity is Piece and the rounding factor is 1.00000 since you
do not wish to have partial crates
Your new unit CRT has now been defined. You will still require conversions for
this unit and the unit will need to be added to the appropriate Unit Sets before
use.
2-12
2 Logistics Common Data
Units
Unit Sets
A Unit Set links multiple units to an item. You use a Unit Set to specify which
units you will make use of for Items and Item Groups. A Unit Set lists all available
units that can represent an item. When defining Units by Unit Set, you must list
all units used for the item. For example, Item FAB.0001 uses the Feet unit for
Production. However Item FAB.0001 is purchased by the yard and sold by the
piece. The feet, yard, and piece units must be included in the Unit Set linked to
item FAB.0001. You must also define Unit Sets for engineering and
subcontracting items, equipment, and tools.
2-13
ERP LN 6.1.00 Common Data
Unit Sets
Field Description
Unit Set The code used to represent the unit set.
Description The description to identify the unit set.
You express quantities of an item in different units depending upon the point of
use. For example, you can produce an item by volume, store it in pallets, and
then sell and invoice it by kilograms. In most cases, manufacturing tools are
managed by the piece.
To use Item Base Units/Inventory Units to measure your inventory, you need to
specify the Base Unit or Inventory Unit for each item. This Unit/Inventory Unit
must be included in the item’s unit set, but it does not need to be one of the
company’s base units.
2-14
2 Logistics Common Data
The new unit set 002 is now defined. You can then link units to the Unit set 002
to identify all the units used for electronic items. The unit set can then be linked
to items to link the units to the item.
Unit Sets
Base Units
Base Units are the basic units of measure for all quantities. These units of
measure are used when you convert units of the same physical quantity.
You use the Base Units (tcmcs0100s000) session and the Com Parameters
(tccom5000m000) session to identify your company’s base units of measure. All
conversions from one unit to another are converted based upon the base unit
conversion. For example, a Base Unit for length is meter. To convert from yards
2-15
ERP LN 6.1.00 Common Data
to feet, a unit will first be converted from yards to meter, and then converted to
feet from meters.
You define base units during the implementation. If you change a Base Unit of
measure, you will have to re-define all items converted to the Base Unit as well.
The system cannot accommodate changing Base Units without redefining the
items. A Base Unit is typically the smallest unit of measure for the system.
Base Units
Field Description
Weight The base weight unit. The units physical quantity type
must be weight.
Length The base length unit. The unit’s physical quantity type
must be length.
Area The base area unit. The unit’s physical quantity type
must be area.
2-16
2 Logistics Common Data
Field Description
Volume The base volume unit. The unit’s physical quantity type
must be volume.
Time The base time unit. The unit’s physical quantity type
must be time.
Business Example
If the Base Unit for length is one meter, all other length units used are based on
the conversions to meters (as shown below).
2-17
ERP LN 6.1.00 Common Data
Field Description
Unit The unit of measure.
Inventory Indicates if the unit can be used as an inventory unit of
measure.
Order Management Indicates if the unit can be used within order
management.
Manufacturing Indicates if the unit can be used within manufacturing.
Price Indicates if the unit can be used for price calculations.
Storage Indicates if the unit ca be used as a storage unit.
Only units previously defined in the Unit (tcmcs0101m000) session can be linked
to a Unit Set. Once a unit is in use for an item, the unit cannot be deleted from
the Unit Set. You can only use units linked to the Unit Set applied to the item for
handling that item.
Inventory
Order Management
Manufacturing
2-18
2 Logistics Common Data
Price
Storage
No: This unit is not applicable for inventory, storage, manufacturing, etc.
Stop: You were once using this unit, but are not using it now.
1. Click the New Group icon and enter Unit Set 002.
2. Click the New icon and enter the units pcs and box selecting yes for all the
options for using the item.
The new Unit Set 002 now has two items that you can use when dealing with an
item. You can now assign the Unit Set 002 to an item in the Items – General
(tcibd0501m000) session.
2-19
ERP LN 6.1.00 Common Data
Unit Set
Field Input Value
Unit Set XX1 (Replace XX with your initials)
Description Purchased Items
Unit Sets
From the Specific menu you can attach units to the unit set, or you can use the
Units by Unit Set (tcmcs0112m000) session
Unit 1
Field Input Value
Unit Pcs
2-20
2 Logistics Common Data
Unit 2
Field Input Value
Unit box
Unit 3
Field Input Value
Unit Plt
The unit set XX1 now has 3 units assigned to the Unit Set. You can now apply
the Unit Set to a new item. You can enter pcs, box, or plt for the unit of measure
for the item in all modules and packages.
2-21
ERP LN 6.1.00 Common Data
Item Groups
Item Groups enable you to manage like items or items with similar
characteristics, classifications, or uses together. This makes handling these
groups of items easier.
An item group, along with the item type can be used to specify default
information for item data and is also used for integrations mapping.
Inventory Valuation Methods are linked to Item Groups, but the use of Inventory
Valuation Groups and Warehouse Valuation Groups provide more flexibility for
Inventory Valuation methods at the warehouse level.
Item Groups
Field Description
Currency The default currency used to calculate the cost price for
items associated with this item group.
2-22
2 Logistics Common Data
Field Description
Costs to be Specified If checked you can enter the costs for the item attached
to this item group, manually when you use the Matched
Purchase Invoice/Statement Line Transactions
(ttfacp1133s000)
Business Example
RAC Manufacturing produces office furniture. One of the product lines, office
chairs, contains a number of items. By creating an Item Group, 420 Office Chairs
and specifying the new item group when an item is created enables all the office
chairs to be handled in the same manner.
2-23
ERP LN 6.1.00 Common Data
Inventory valuation methods are linked to Item Groups and enable you to
determine the manner that inventory is valued.
You can either specify the valuation method by Warehouse Valuation Group or
Item Valuation Group. This process provides more flexibility for assigning
Valuation Methods by warehouse for items. The combination of Item Valuation
Group and Warehouse Valuation Group determines the default Inventory
Valuation Method for the item and warehouse combination specified in the
Warehouse – Item (whwmd2110s000) session. The value of inbound and
outbound quantities are calculated based on the Inventory Valuation Method
defined.
Items can be grouped together through the use of an Item Valuation Group. You
can define an Item Valuation Group and link the group to the items to include in
the Warehouse Valuation Group. Item Valuation Groups and Warehouse
Valuation Groups are linked, for example, to Inventory Valuation Methods to
value the inventory for the items linked to the Inventory Valuation Group.
2-24
2 Logistics Common Data
Field Description
Warehouse Valuation If you group warehouses together you can also assign a
Group valuation method to the warehouse valuation group. If
no warehouse valuation group is defined, the inventory
valuation methods are general use.
Item Valuation Group Items can be linked to an Item Valuation Group to
assign an Inventory Valuation Method to the items
belonging to the valuation group.
Inventory Valuation Method The valuation method when lot prices are registered for
Lot Price Used the item.
Inventory Valuation Method For all items not lot controlled, the valuation method to
Remaining apply to those items.
2-25
ERP LN 6.1.00 Common Data
Item Groups
The new item group can new be used to establish item defaults or item data.
2-26
2 Logistics Common Data
_____________________________________________________________
You can change the valuation method for an item or a range of items. You can
change the valuation method on a range of methods based on:
Item Type
Warehouse
2-27
ERP LN 6.1.00 Common Data
Field Description
Lot Price (group box) Determines the action to take for valuation of lot price
items.
No Changes: Do not change Lot price items
Change No to Yes: Convert non-lot items to lot.
Change Yes to No: convert lot items to non-lot.
Old Valuation Method The old valuation method that will be replaced for the
item within the selection range. You will only change the
valuation for items with this valuation method within the
selection range.
New Valuation Method Lot The new valuation method for items with Lot Pricing in
Price Used effect.
New Valuation Method New valuation method for items that are not lot prices.
Remaining
2-28
2 Logistics Common Data
Field Description
Update Defaults in If checked, the inventory valuation methods specified in
Inventory Valuation the Inventory Valuation Methods (whina1100m000)
Methods session will be changed as well.
Field Description
Lot Price (if already When defining new valuation methods for lot items, you
present) determine the type of lot price to use for the new
inventory value.
Prices Used for Not Indicates what price to use for itmes associated with an
Approved Invoices (group invoice that has not yet been approved.
box)
Business Example
There are inventory items in Warehouse 500 currently valued using a First in
First Out (FIFO) method. The items in the warehouse are linked to Item
Valuation Group 120 Electronic Components or 140 Computer Components. The
2-29
ERP LN 6.1.00 Common Data
2-30
2 Logistics Common Data
Entities
Entities are the logistical departments, warehouses, and work centers as well as
the financial offices that comprise your organization.
Departments
Departments represent a company organizational unit that carries out a specific
task or function. Departments can be assigned number groups as defaults for
orders issued from the entity. The enterprise unit linked to the department
determines the financial company the financial transactions generated in the
department are posted in. Departments can be:
Sales office
Purchase office
Service department
Work center
Shipping office
Accounting office
A company can define multiple departments or each type within one logistical or
financial company. There must be at least one department defined of each type if
transactions of that type are to be performed in the company. For example: if
sales orders are used in the logistical company, there must be at least one Sales
Office defined. If production orders are used, then at least one Work Center must
be defined.
2-31
ERP LN 6.1.00 Common Data
Departments
2-32
2 Logistics Common Data
Field Description
Department Type Identifies the function and use of the department and the
type of transactions it will handle.
Sales office: manages sales relations with a
business partner and is responsible for sales
activities for the organization.
Purchase office: manages purchase relations with
a business partner and is responsible for purchase
activities for the organization
Service department: manages service relations
with a business partner and is responsible for
service and maintenance activities for the
organization
Work center: an entity consisting of one or more
people or machines with like capabilities, that can
be considered a single unit for capacity and
scheduling purposes.
Shipping office: responsible for the organization of
transportation for one or more warehouses. Used in
the Freight Management package.
Accounting office: used by a financial company to
register and receive business partner financial data.
Address The address where the department is physically located.
Calendar Code The calendar used for availability of the department. By
default the company central calendar is used if none is
specified.
Enterprise Unit The enterprise unit identifies the financial company to
post financial transactions from orders within this entity.
Also used to group departments together for logistical
purposes.
Define a Department
A new Purchase office has opened in Grand Rapids Michigan. Create a new
Department to represent the new purchase office.
2. Enter the Department Code PGR with a description of Purch. Office Grand
Rapids
2-33
ERP LN 6.1.00 Common Data
The new department record is created for the Purchase Office PGR.
2-34
2 Logistics Common Data
Department XXPUR
Field Input Value
Department XXPUR (Replace XX with your initials)
Description Purchase Office
Department Type Purchase Office
Address Select one from list
Enterprise Unit 1
Department XXSLS
Field Input Value
Department XXSLS (Replace XX with your initials)
Description Sales Office
Department Type Sales Office
Address Select one from list
Enterprise Unit 1
Department XXWRK
Field Input Value
Department XXWRK (Replace XX with your initials)
Description Work Center
Department Type Work Center
Address Select one from list
Enterprise Unit 1
2-35
ERP LN 6.1.00 Common Data
Departments
Warehouses
Warehouses are used to represent goods storage areas. Optionally, you can
specify that a warehouse is divided into zones and locations.
Typically purchased and produced items are stored in a warehouse. Goods are
then retrieved from a warehouse when demand from production, sales, service,
project, or transport places a requirement for the goods.
The warehouse is also and entity. You define the warehouse first in the
Warehouses (tcmcs0503m00) session, then it is displayed in the Warehouses
(tcemm1112m000) session as an entity.
2-36
2 Logistics Common Data
Warehouses
Field Description
Enterprise Unit The enterprise unit this entity is linked to. The Enterprise
Unit determines where financial transactions resulting
from logistics transactions in this warehouse are posted.
The Enterprise unit enables grouping entities together.
2-37
ERP LN 6.1.00 Common Data
Field Description
Warehouse Type Indicates the purpose for which you will use the
warehouse. The type also determines the functionality
the warehouse exhibits in the application. The available
types are:
Normal
Shop Floor
Project
Service
Service Customer Owned
Service Reject
Consignment (owned)
Consignment (not owned)
Define a warehouse
Define a warehouse for finished goods for your organization. The new
warehouse will be a normal warehouse.
The new record for the warehouse entity 100 is now created. The warehouse
type is normal and the enterprise unit is 1.
2-38
2 Logistics Common Data
Warehouse XXFIN
Field Input Value
Warehouse XXFIN (Replace XX with your initials)
Description Finished Goods
Address Code Select one
Enterprise Unit 1
Address Type Normal
2-39
ERP LN 6.1.00 Common Data
The new warehouse entry should display similar to the screen display.
2-40
2 Logistics Common Data
Countries
Countries are the national states where suppliers and customers are located. For
each country you can define the country code, international dialing, telex, and fax
codes. The country information is part of the data that must be defined for set up
of tax reporting. You can specify if tax is required.
By country code, you can group and select items according to the country of
origin. The country code can be applied to Business Partners, Addresses, and
items. The information such as address format and language default from the
country to other records when the country is identified.
2-41
ERP LN 6.1.00 Common Data
Countries
Field Description
ISO Code The international country code.
Address Format IF address formats are to be used for addresses
associated with this country, you specify the default
address format to apply to new addresses.
Time Zone Default time zone for delivery and shipments with this
country.
2-42
2 Logistics Common Data
Languages
The languages are defined to determine document print defaults. When the
corresponding installed (system) language is available in the database, the
documents will be printed in the specified language.
A language code
A description
Languages
Business Example
The installed system is an English version of ERP ln and you are installing French
as a second language. For each Language defined, you can specify the System
Language (French or English) you wish to display the documents.
2-43
ERP LN 6.1.00 Common Data
Lesson Review
In this lesson you have learned how to:
Define Countries
2-44
2 Logistics Common Data
Review Questions
1. Number Groups can only be used for generating Business Partners,
Addresses, and Contacts
A. True
B. False
A. True
B. False
3. You can either specify the valuation method by Warehouse Valuation Group
or Item Valuation Group.
A. True
B. False
2-45
ERP LN 6.1.00 Common Data
1. False (Number Groups are used to identify all the document and serialized
code generations for orders, documents, business partners, addresses, etc)
3. True
2-46
3
Financial Master Data
Financial master data establishes base data in your company for financial
transactions to occur. The information is important because once defined, it
forms the basis for all transactions. If set up incorrectly financial master data
such as Financial Integrations can seriously affect the performance and accuracy
of the financial data in the system.
Lesson Objectives
After completing this lesson, you will be able to:
3-1
ERP LN 6.1.00 Common Data
Tax Codes
A tax code is a code that identifies the tax rate and determines how the software
calculates and registers tax amounts. These codes are maintained in the Tax
Codes (tcmcs0137m000) session. You can define the details of each tax code
per country in the Tax Codes by Country (tcmcs0536m000) session.
3-2
3 Financial Master Data
Field Description
Kind of Tax The kind of tax for which the tax code is defined. This field
can have the following values:
Vat: Regular value added tax (VAT) on sales and
purchases
Investment Charge: A shifted expensed purchase tax that
is applied on investment amounts on purchase invoices in
Norway.
Stamp Tax: A type of tax that is imposed on legal
documents.
Tax Type The tax type can be:
Normal: The tax amount is added to the net amount which
results in the gross amount on invoices.
Shifted: The tax amount is not added to the net amount. The
tax amount is posted to a tax account.
On Payments: The tax is paid in the same way as normal tax,
but only becomes reclaimable or payable after the invoice has
been paid. The tax is posted to an interim account and will
only be transferred to the real tax account when the invoice is
paid.
Singular Tax (check If this check box is selected, the tax code refers to a single tax
box) percentage. One tax amount is calculated on the basis of one
percentage and posted to one tax ledger account.
3-3
ERP LN 6.1.00 Common Data
Financial Tables
Financial tables contain the common financial data that, once defined, is used
throughout the system. The Financial tables store data regarding financial
common data.
Credit Ratings
Credit Ratings are used to established predefined a status that can be assigned
to a business partner indicating their credit worthiness. This credit rating can be
useful in determining if a business partner is a risk for doing business. The
available credit ratings are maintained in the Credit Ratings (tcmcs0164s000)
session. You assign the credit rating to an Invoice-to Business partner. The credit
rating can determine the action to take when a sales order is processed and at
what point the credit check is repeated.
Credit Ratings
3-4
3 Financial Master Data
Field Description
Action The action to be taken for the Credit Rating. The options
are:
Always Hold (credit)
Never Hold (credit)
Check Credit
Always Hold (Overdue Invoice)
Sales Order Entry (check If this check box is selected, credit checking is
box) performed during sales order entry and any subsequent
processing of the sales order
Release to Warehousing If this check box is selected, phase 2 credit checking is
(check box) performed when you release orders to Warehouse
Management.
Confirm Shipment (check If this check box is selected, phase 3 credit checking is
box) performed when you confirm the shipment in
Warehouse Management.
Business Example
A Business Partner is assigned a credit rating of D (Poor) because of problems
with the customer paying invoices in a timely manner. When a sales order is
placed for that business partner, the credit rating of D (Poor) may indicate that
business partner is not eligible for a 30 day terms of payment and must pay
immediately before the goods are shipped.
Insert a new record for Credit Rating A1 and indicate the Action is Credit Check.
You will check the credit only before Release To Warehousing to ensure the
goods are not shipped until Credit is approved.
3-5
ERP LN 6.1.00 Common Data
Credit Ratings
Indicate the new Credit Rating is the default Credit Rating in the Sales Order
Parameters (tdsls0100s400) session.
3-6
3 Financial Master Data
When a Business Partner is created, the Credit Rating A1 will default to the
Invoice to Business Partner record and will also default to the Sales Order when
created.
Currencies
A company’s currencies are first defined as generic units in the Generic Units
(ttaad1106m000) session. Next you can maintain the currencies in the
Currencies (tcmcs0102m000) session.
3-7
ERP LN 6.1.00 Common Data
Currencies
Field Description
Short Description The international currency-indication for the monetary
unit. For example, USD for American dollars or DM for
Deutschmark.
Rounding Factor Indicates how entered and calculated quantities
expressed in this unit are rounded off. For example, if
the rounding factor is 5, rounding is to the nearest
multiple of 5. The rounding factor must have the same
number of decimals or less than specified for the
currency in the Formats by Generic Unit
(ttaad1107m000) session.
EMU Currency (check box) If the currency is part of the Economic and Monetary
Union (EMU) you must select this check box.
3-8
3 Financial Master Data
Field Description
Belgian BoP Currency If the currency is to be defined as Belgian Balance of
(check box) Payments reporting currency, you must select this check
box.
Invoicing Methods
Invoicing methods specify the terms of invoicing regarding orders. If you do not
use the Project or Service modules, leave the fields from those tabs with the
default values.
These check boxes combined with the Print Order Lines selection enable you to
print four types of sales invoices:
3-9
ERP LN 6.1.00 Common Data
Invoicing Methods
3-10
3 Financial Master Data
Purchase Types
The Purchase Types (tcmcs2101m000) session is used to define Purchase
Types. A Purchase Type is a purchase order property that enables you to
identify the kind of purchase made and the kind of payable. This is used to post
the purchase to the correct Accounts Payable account when the invoice is
created. You must define at least one Purchase Type that will then be used as
the default Purchase Type for the Business Partner group in Accounts Payable.
Purchase Types
3-11
ERP LN 6.1.00 Common Data
Sales Types
The Sales Types (tcmcs2102m000) session is used to define Sales Types. A
Sales Type is a sales order property that allows you to identify the kind of sale
made and the kind of receivable. This is used to post the sales to the correct
Accounts Receivable account when the invoice is created. You must define at
least one Sales Type that will then be used as the default Sales Type for the
Business Partner Group in the Accounts Receivable module.
Sales Types
3-12
3 Financial Master Data
Financial Integrations
Financial Integrations are important for recording financial transactions resulting
from logistical transactions that take place within the applications. Financial
integrations allow you to coordinate the financial transactions in a logical
structure.
3-13
ERP LN 6.1.00 Common Data
Reconciliation
The reconciliation process matches the financial transactions to the related
logistic transaction data in order to check whether the financial postings are
correct and complete and to correct any detected differences. The way in which
3-14
3 Financial Master Data
the mapping scheme is set up also partly determines the extend to which
reconciliation is possible. The features of the mapping scheme that support
extensive reconciliation are:
Consistent usage of the currency exchange rate type for the related debit and
credit transactions on a ledger account.
Reconciliation group
A reconciliation group is used to group related integration transactions for
reconciliation purposes. Every integration document type belongs to a
reconciliation group. For example, the Purchase Order/Receipt and the
Purchase Order/Price Variance integration document types both belong to the
same reconciliation group (reconciliation group Invoice Accrual 3).
3-15
ERP LN 6.1.00 Common Data
Lesson Review
In this lesson, you learned how to:
3-16
3 Financial Master Data
Review Questions
1. To specify which ledger accounts are to be used for posting tax amounts you
can use:
A. Tax Authorities
B. Tax Rates
C. Tax Codes
D. Tax Accounts
2. All of the following are actions that are available for a Credit Rating EXCEPT:
A. Always Hold
B. Sometimes Hold
C. Never Hold
D. Check Credit
A. True
B. False
C. Mapping Scheme
D. Integration Parameters
3-17
ERP LN 6.1.00 Common Data
1. C (Tax Codes)
3. B (You must have at least one Sales type and Purchase Type if you will be
using the Sales and Purchase modules)
3-18
4
Item Base Data
Item data is used in almost every package in the application. Item base data
enables defining item information in a central location that can be accessed and
applied to the other packages and modules.
Lesson Objectives
After completing this lesson, you will be able to:
4-1
ERP LN 6.1.00 Common Data
Conversion Factors
Conversion Factors define the ratio between different units of measure. The
conversion factors enable you to handle an item using several units of measure.
General conversion factors define the conversion ratio for units of the same
physical type.
Item dependent Conversion factors are defined by Item or by Item Group and
only apply to the specific item, or to the items associated to the Item Group with
the conversion factor. You can define conversion factor ratios for units
expressed in different Physical quantities using the Item and Item Group
conversion factors.
Item
Item Group
General
4-2
4 Item Base Data
The general conversion factor, which is used if the units are of the same physical
type and the conversions are standard or always true (such as weight to weight,
volume to volume, etc.). Physical Types include weight, length, area, volume,
and time.
Conversion Factors
4-3
ERP LN 6.1.00 Common Data
Field Description
Item The conversion can be specified on three levels
Item level
Item Group level
General Level
If you will be specifying an item level conversion, enter
the item code for the item you will be defining the
conversion.
Item Group IF the conversion will apply to a specific item group, and
thus all items in the item group, define the item group for
the conversion.
Base Unit The base unit the conversions apply. The base unit is
the general level conversion. There will be conversions
for all units at a general level conversion at the
minimum.
Unit The unit you are defining the conversion for between the
base unit.
Conversion factor The number of base units that comprise a single Unit.
Example: If the base unit is pcs, and the Unit is box. The
conversion factor of 24 indicates 24 pcs are equivalent
to one box.
Raise 10 to the Power When dealing with large numbers, use the power of ten
to shorten the number for clarity.
For example: The conversion factor is 12 and the Raise
to the Power is 3, the actual conversion factor is 12000.
Inverse Value The reverse conversion factor. The number of
alternative units in one base unit.
4-4
4 Item Base Data
3. Click the New icon and enter the Conversion factor specifying 125 m2 will be
equal to 1 rll
The conversion factors for Item Group 500 now exist. When an item assigned
with Item Group 500 is converted, the system will check the conversion factor for
m2 to rll. If the item were to be converted from m2 to pcs, then general level
conversion factor would be used, not the conversion factor at the Item Group
level since there a conversion from m2 to pcs is not defined at this level.
4-5
ERP LN 6.1.00 Common Data
Conversion Factors
4-6
4 Item Base Data
4-7
ERP LN 6.1.00 Common Data
Field Description
Item Type Specifies the Item Type the defaulted defined will apply
against. The item type and item group specify the
unique combination to which the defaults apply.
Item Group Specifies the Item Group the defaulted defined will apply
against. The item type and item group specify the
unique combination to which the defaults apply.
Item Type Specification The default item type that will be defined in the General
Item Data when the Item Type and Item Group are
entered.
4-8
4 Item Base Data
Field Description
Unit Set The default Unit Set that will apply to all items with the
same Item Type and Item Group combination defined in
the Item – General Defaults (tcibd0502m000) session.
Field Description
Zoom to item defaults Provides access to the sub entity details sessions where
session (group box) you can define default sub entity data for the item type
and item group combination. These sub entity sessions
can also be accessed directly from the respective
module. For example; Sales data can also be accessed
from the menu in the Sales Master Data module.
4-9
ERP LN 6.1.00 Common Data
Field Description
Use Item Defaults When the data in the sub entity sessions is defined, you
can indicate if the information is to be included as
default information for this Item Type and Item Group
combination. If the check box is selected, the item
defaults for that sub entity session are included.
You can also include item sub-entity information as defaults or you can leave the
sub-entity information for entry in the corresponding module. It is user defined
and can be as specific or general as you require.
4-10
4 Item Base Data
1. Click New and insert the item code PUR_TST1 with a Description Item
Defaults
3. Hit the tab key once the Item Group 500 is entered.
4-11
ERP LN 6.1.00 Common Data
4-12
4 Item Base Data
Before you can define General Item Data you must define the Common
Parameters, Item Groups, Base Units, and Unit Sets. This ensures adequate
base data is available for defining the item.
Item Type
The item type identifies how the item is used within the system and determines
how the item can be handled. T
Purchased
Manufactured
Cost
Service
Generic
Subcontracting
List
For Common data we will only discuss setup of Manufactured and Purchased
Items.
Purchased Items
Purchased items are typically purchased from an outside source. A purchased
item can also have a Bill of Material and a Routing linked to it.
Manufactured Items
The items of this type can be manufactured end items or subassemblies. A
manufactured item is typically associated with a Bill of Material and a Routing
describing the components to assemble the item and the manner in which it is
assembled. Manufactured items are also referred to as production items and can
also be purchased.
4-13
ERP LN 6.1.00 Common Data
Cost Items
Cost items, also called expense items, are used for administrative purposes and
to post additional costs to and order. An example of extra costs are accounting
expenses and freight expenses. Cost items are not used in production and are
not held in inventory.
Service Items
Service items are standard items that are used to represent services instead of
physical items. These items are used in the Services module.
Generic Items
An generic item is an item that exhibits multiple product variants. Before
manufacturing of a generic item can occur, the item must be defined with all the
product variants. For example: an electric drill may have three power options
(battery, 12 V, or 220V) and two color options (blue and gray). The desired
options need to be defined before manufacturing.
Subcontracting Items
An auxiliary item code used to record subcontracting operations. These items are
also used for administrative item costs. Subcontracting Items are non-physical
items used to record subcontracting costs.
List Items
List items consist of multiple components. The components can be managed and
ordered separately The list item type (kit, menu, option, or accessory) determines
how the components are related to the list item and how they can be ordered.
List items are used to facilitate order entry (purchase and sales) and are not used
to configure items for manufacturing.
4-14
4 Item Base Data
Field Description
Item The first field is the Project field. This field is used to
identify the project. The Project and Item combined
make the item code. Enter the Item code in the second
field.
Item Type Items are classified by type to indicate the use of the
item. The available functions for that item depend on the
time type. The Item sub entities that you can define also
depend on the item type
Item Group Every item ins assigned to an item group. The item
group is used to group items with similar characteristics.
The item group is used in combination with the item type
to establish item defaults.
4-15
ERP LN 6.1.00 Common Data
Field Description
Unit Set The unit set determines the units that are available for
use with the item.
Inventory Unit The unit that the item will have inventory recorded.
You can only enter the inventory unit for items of the
type:
Purchased
Manufactured
Generic
The Item Data II tab determines if lot control is used and what type of lot tracking
will be applied to the item. The two options are Lot Controlled and Serialized. Lot
Controlled indicates a group of items will be assigned the same number, such as
in batch processes. A Serialized lot tracking will generate a single tracking
number per item.
4-16
4 Item Base Data
Field Description
Lot Controlled If checked you will use lot numbers in conjunction with
this item.
Serialized If checked this item will use serialized number
generation for tracking each unit.
The Grouping Data tab provides reporting, categorizing, and additional details on
the item data. This enables grouping items and reporting based on criteria you
choose to record on the various items.
4-17
ERP LN 6.1.00 Common Data
Field Description
Manufacturer The supplier of finished goods. This is used for sorting
and grouping purposes.
Technical Coordinator An employee responsible for the technical specifications
and requirements of the item. Also responsible for
information for the Warehouse Management module.
Cost Component For Cost items, you must specify the cost component
used for this item.
4-18
4 Item Base Data
The mandatory sub entity information for an item depends on the item type and
the transactions processed against the item. For example, an item of the item
type Cost item, will need the Costing sub entity information defined. An item of
the type Purchased requires the Purchasing, Warehousing, and Costing sub
entity information defined in order to be usable for purchase and warehouse
transactions.
You can only maintain sub entity information for an item after the item exists in
the Item – General (tcibd0101s000) session
4-19
ERP LN 6.1.00 Common Data
\\ Order Management \ Sales \ Sales Master Data \ Sales Item Data \ Item –
Sales (tdisa0501m000)
Field Description
Sales Unit The default unit which is used for the sale of the item.
Commitment Policy Enables you to specify if the ordered quantity for the
item is allocated to the order during order entry. The
values are:
No: default value – indicates no commitments for the
item.
Order Line Entry: The inventory is committed to the
order during the line entry.
Batch: The commitment is not made until the Generate
Inventory Commitment (whinp2200m000) session is
executed.
Manual: The order quantity is manually committed.
4-20
4 Item Base Data
Field Description
Minimum Order Quantity Indicates the lowest quantity allowable for order.
Direct Delivery From You will drop ship the item to the customer from your
supplier from the quantity specified and above.
Release to Warehouse If checked, the issuing of the item is performed in the
Warehouse Management module. If it is unchecked, the
issuing of the item will occur in the Sales Control
module.
Warehouse The default warehouse the item is issued from for sales
orders.
Field Description
Sales Price Unit The unit of measure the sales price is based on.
Sales Price The standard price charged for the sale of the item in
the reference currency.
4-21
ERP LN 6.1.00 Common Data
Field Description
Allow Over Deliveries If checked, you will allow shipments for the item in
excess of the ordered quantity on the sales order.
Tolerance Type Indicates what type of over delivery is acceptable.
Values are:
No: Over deliveries are not allowed
Percentage: The tolerance is based on a percentage of
the ordered quantity.
Quantity: The tolerance is a fixed quantity above the
ordered quantity.
Action The action to take if a delivery exceeds the Maximum
Tolerance.
Block: The shipment is blocked in Warehouse
Management.
Warn: A warning message is displayed in Warehouse
management.
Maximum Tolerance The quantity or percentage above the ordered quantity
that is permitted without action taking place.
Production Data
The production data defines the basic routing and bill of material quantity
information. You can specify the number of items the bill of material or routing
are defined for. For example; if you specify the BOM Quantity is to (2), when the
BOM is defined, it contains the quantities of components to build 2 main items.
4-22
4 Item Base Data
The default back flush information for the item is also defined in the Production
data.
Field Description
BOM Quantity The number of manufactured items on which the BOM is
based.
Scrap Factor The amount of waste, based on percentage, when the
manufactured item is assembled. This quantity is added
to the issuing quantity on the BOM for issuing raw
materials and components to the production order.
Scrap Quantity The amount of waste, based on quantity, when the
manufactured item is assembled. This quantity is added
to the issuing quantity on the BOM for issuing raw
materials and components to the production order.
4-23
ERP LN 6.1.00 Common Data
Field Description
Backflush Materials Indicates you will backflush the issuing of materials for
the components of the manufactured item. Backflushing
refers to issuing materials or hours against a production
order after the work or materials are used and other
operations are completed.
Backflush Hours Indicates you will backflush the issuing of hours against
the building of the manufactured item. Backflushing
refers to issuing materials or hours against a production
order after the work or materials are used and other
operations are completed.
Direct Processing of WH If checked the warehouse outbound order procedure is
Order Line carried out automatically for materials in the warehouse
if they are not blocked.
Direct Initiate Inventory If checked the warehouse order line for material is
Issue automatically unblocked during the production order
release and the materials are directly issued to the
production order.
4-24
4 Item Base Data
Costing Data
The Items – Costing ticpr0107m000) session is used to define the cost
components and currency used for the cost price calculation for the item. Once
the details have been entered and the record is saved, the Calculate button is
activated and you can calculate the standard cost price for the item.
Field Description
Material The cost component for the aggregated or combined
material costs for the item.
4-25
ERP LN 6.1.00 Common Data
Field Description
Operation The cost component for the aggregated or combined
operation or labor rates for the item.
Surcharge The cost component for the aggregated or combined
surcharges applied to the item.
Cost Component Chart For detailed reporting of cost accounts, you can define a
cost component chart and link various cost components
to the chart. The chart can then be assigned to the item.
Currency The currency to express the cost price.
The Price tab displays the cost price of the item and provides a date and time
stamp indicating when the last cost price calculation for the item took place.
Warehousing Data
The Warehouse data defines the base data for inventory and issuing information
regarding the item. The Item – Warehousing (whwmd4100s000) session also
enables defining dimensions and weight information to determine storage
capacity. This is the base data, individual item and warehouse combination data
can be defined to further detail the item.
4-26
4 Item Base Data
Field Description
Item Valuation Group The valuation group assigned to the item for inventory
valuation purposes. You can calculate the inventory
value for all items in a valuation group.
Package Definition The default package definition assigned to the item.
Once the record is saved, you can enter the Package
Definition by zooming to the Items – Package Definitions
(whwmd4130m000) session.
4-27
ERP LN 6.1.00 Common Data
Field Description
Dimensions (group box) The dimensions for the item are used to calculate
storage capacity for the item in warehouse locations.
Expected Annual Issue The expected annual issue quantity of the item for the
next year expressed in the Inventory unit for the item.
When less than three periods of history are present, the
system will use the Expected Annual Issue for the ABC
analysis calculation, the Calculate Economic Order
Quantity (whina2201m000), and Calculate Demand
Forecast (whina2202m000).
Project Data
If Projects are used you can define the base data for projects regarding the item.
4-28
4 Item Base Data
Purchase Data
You can define and maintain purchase related item data in the Item – Purchase
sub entity session. The data is then linked to the general item data and is used
as the default information for the item. From this session, you can highlight an
item and from the specific menu access several other purchase master data
sessions to define the purchase data for the item and business partner,
manufacturer, and price information.
4-29
ERP LN 6.1.00 Common Data
Field Description
Buy from BP The default business partner for purchasing the item.
This business partner is retrieved when a purchase
order is generated.
Purchase Price Unit The unit in which the purchase price is expressed.
Purchase Price The price paid for the item, specified in the purchase
currency.
Field Description
Purchase Office The default department responsible for purchasing this
item. Default number groups can be assigned to
coordinate order number generation based the purchase
office.
4-30
4 Item Base Data
Field Description
Warehouse The default warehouse that receives the item when
purchased. This receiving warehouse is defaulted to the
purchase order line.
Inspection Indicates if inspection is required for this item during the
receiving process.
Release to Warehouse If selected, the receiving process is executed in the
Warehouse Management module, otherwise receipts
can be executed in the Purchase Control module.
Check Approved Source If selected, the buy from business partner on the
List purchase order must be an approved supplier for the
item in the Item – Business Partner (tdipu0110m000)
session.
4-31
ERP LN 6.1.00 Common Data
Field Description
Multiple Manufacturer Item If selected, alternative manufacturers can be maintained
by item – business partner combination. If the check box
is cleared, only one manufacturer can be defined per
item – business partner combination.
Alternative manufacturers are typically used in
companies that buy components with similar
specifications or quality from multiple suppliers. If the
ordered quantity is less than the minimum quantity you
can order from a manufacturer, you can purchase
through an intermediate supplier. The supplier can then
obtain the ordered quantity through the specified
manufacturer defined as approved.
Ordering Data
The Item – Ordering Data sub entity contains the default information regarding
order quantities and
4-32
4 Item Base Data
Field Description
Order Policy Determines the default policy for ordering the item. The
options are:
Anonymous: The item is produced or purchased before
a customer order is received.
To Order: The item is produced or purchased only after
customer orders are received.
4-33
ERP LN 6.1.00 Common Data
Field Description
Order System The order system available depends on the combination
of item type and order policy for the item. The values
are:
SIC: replenishment orders for the item are planned
within the Warehouse Management module.
Planned: replenishment orders for the item are planned
within the Enterprise Planning module.
FAS: For generic items, the item is planned in a mixed
model flow process on an assembly line.
Manual: Orders for the item are placed manually in the
system and not generated by any planning engine.
Order Method The order method controls the recommended quantity
for purchase and production orders. Values are:
Lot for Lot
Economic Order Quantity
Fixed Order Quantity
Replenish to Maximum
Warehouse The default warehouse where the item is stored. The
default warehouse is used to:
Calculate the cost price
Create plan items
Generate purchase orders.
Order Quantity Settings The fields contain the default information on the quantity
(group box) to order for an item when a purchase or production
order is generated for the item. You can specify the
minimum and maximum order quantities you will allow
as well as a fixed order quantity. The economic order
quantity can be manually entered or system calculated.
Planning Data
When the item has an order system of Planned, you can use this sub entity
information to define the default planning information.
4-34
4 Item Base Data
Field Description
Plan Item Type Determines if the planning for this item is per item, or as
part of a family. A family plan item type can be used to
generate a plan for several similar items, for example
bikes or chairs, that can be part of the same family. If
you specify the plan item type is family, you can use
plan levels to define the structure for the items within
that family.
Default Supply Source The default supply source determines where the spply
for the item will come from. The values are:
Production Purchase: The replenishment of the item will
come from a purchase or production order.
Distribution: Indicates the item replenishment will be
based on transfer of goods from other warehouses
within the warehouse structure of your organization.
4-35
ERP LN 6.1.00 Common Data
Field Description
Default Warehouse The default warehouse for orders to indicate the receipt,
shipment, or storage for this item.
Maintain Master Plans This checkbox determines if the item is a Master Based
or Order Based planning item.
Service Data
If the Service package is implemented and the item type is service, you can
specify Service related base data for the item in the Service Data sub entity tab.
Freight Data
When Freight Management is used, you can specify freight data in the Freight
Data sub entity tab regarding the item.
4-36
4 Item Base Data
Item Structures
Item Structures are generally defined for manufactured items. An Item structure
may consist of Item Data, a Bill of Material (detailing the components of an end
item), and a Routing definition (which details the steps to manufacture the end
item). An item may contain all three components, or only one or two such as
General Item data and a Bill Of Material, but not a Routing. The combination of
the components, BOM, Routing, and Costing details define the structure of an
item. The item structure provides the basis for generating cost calculations.
Detailed item management data is defined for ordering, production, and planning
purposes.
XX.CHAIR
XX.SEAT XX.FRAME
XX.BACK Frame assembly
Seat subassembly Back subassembly
The item structure defines a manufactured item and its associated components
as well as the procedure to produce or assemble the item.
Bills of Material
The Bill of Material (BOM) lists the components or parts that constitute the main
item. To manufacture a product, you must know what raw materials or items are
needed and the quantity required of each. A BOM is created to represent the
component structure of an item and the quantity of each component required to
build the main item. A BOM can be thought of as a recipe, which specifies what
ingredients (i.e. eggs, milk, sugar, flour, etc.) and the quantity of each that is
4-37
ERP LN 6.1.00 Common Data
required to make the end product (i.e. a cake). The components of an item can
be manufactured or purchased.
Definition
A Bill of Material is a listing of all components and relevant data (sub-assemblies
and raw materials) that comprise a manufactured item. The BOM establishes the
parent-child relationship between a manufactured item and its components.
4-38
4 Item Base Data
Field Description
Item The Manufactured item for which you are defining the
BOM.
Position The component item position number on the BOM.
Sequencing is 10, 20, 30 etc as defined in the
parameters. Each insert of a component increments the
position number.
Item The component item of the manufactured item for the
particular position.
Net Quantity The total number of component items required for the
manufactured item.
WH (Warehouse) The default warehouse the component item will be
issued from to build the manufactured item.
Routings
Routings identify the sequence of steps and procedures used to produce
manufactured goods. Routings consist of tasks defining what activity will be
performed. Work Centers define where the activity or task will be performed.
Machines will identify the equipment, if required, to execute the task. Routings
are the basis for calculating operational costs of a manufactured item. In addition,
routings also are used to determine the lead-time to manufacture an item. There
are four types of routings: Default, Order Quantity Dependent, Standard and
Alternative. All manufactured items need to have either Default or Order Quantity
Dependent routing in order to calculate the standard cost and to plan production
orders. The decision of default versus quantity dependent routing occurs on the
4-39
ERP LN 6.1.00 Common Data
item in the Item Production Data session indicated by the field Up to Order
Quantity.
Start
End
Work Centers
A work center designates an area where work is performed. Normally, Work
Centers are grouped by similar machines or processes. The information specified
in the work center may be used for capacity and costing calculations. A work
center is first defined in the Departments (tcmcs0565m000) session.
4-40
4 Item Base Data
Work Centers
Field Description
Work Center Type Defines the main purpose of the work center and its
function. Values are:
Main Work Center: An single work center, or a work
center consisting of multiple sub work centers.
Sub Work Center: A work center that belongs to a
higher level work center. If so, specify the parent work
center in the Main Work Center field.
Operation Rate Code The code used to assign the labor and machine rates
used to calculate standard costs for items produced
within the work center.
Capacity Data (Group Box) Determines the availability and capacity within the work
center. This is used for lead time, scheduling, and
costing purposes.
4-41
ERP LN 6.1.00 Common Data
Business Example
The framework for the passenger seat is made from metal tubing. A cutting
machine is used to cut the tube into sections. Three identical cutting machines
are grouped together into a single work center that will represent the available
capacity of all three machines. Each cutting machine is available for 8 hours a
day, and 5 days a week. The weekly capacity is therefore 8*5=40 hours for each
machine. Collectively, the work center for cutting machines has 120 hrs of
capacity.
Machines
Machines represent the various manufacturing equipment used during the
manufacturing process. The Machines (tirou0102m000) session enables you to
record the cost of operating a machine and the available machine capacity. The
machine can be linked to the work center or task and can then be linked to a
routing.
Machines
Field Description
Machine The code representing the particular machine
Work Center The work center the machine is located and associated
with. This is used to calculate resources.
4-42
4 Item Base Data
Field Description
Machine Rate The rate used for actual production order costing if the
Actual Operation Rates field in the Shop Floor Control
Parameters (tisfc0100s000) session is Actual Man and
Machine Rates.
Cost Component The cost component that will capture the machine costs
for this machine.
Capacity Data (Group Box) Defines the weekly and daily capacity and availability of
the machine. This information is used for calculation of
lead time.
Business Example
Several passenger seat frames have been rejected due to problems with the
painting process. A new machine to pre-treat the frames prior to painting is
purchased in an attempt to eliminate the problem. The new machine details are
added to the system, to allow its use on future routings.
Tasks
Each task can be directly or indirectly related to production. A task may range
from maintaining a machine to an employee taking leave. The Task Type
specifies the nature of the activity, and determines which mandatory information
is required. Only direct production tasks can be used in a routing. When the
production tasks are defined, they can be associated with a work center and a
machine. The task can be added as an operation to the routing, representing an
executable action in the production process.
4-43
ERP LN 6.1.00 Common Data
The machine or work center required to complete the task can be linked in the
Tasks (tirou0103m000) session.
Tasks
Field Description
Work Center Selection Determines if the work center is available for multiple
Method tasks or a specific task. The values are:
All: The task can be used for all work centers. For
example, a task for Inspection.
Only Default: Only the work center specified in the
Default Work Center field can be linked to the task.
Specific: you can specify task/work center combinations
in the Task Relationships (tirou0104m000) session.
4-44
4 Item Base Data
Field Description
Machine Selection Method Determines if the machine is available for multiple tasks
or a specific task. The values are:
All: The machine can be used for all tasks. For example,
a press machine can be used in multiple.
Only Default: Only the machine specified in the Default
Machine field can be linked to the task.
Specific: you can specify task/machine combinations in
the Task Relationships (tirou0104m000) session.
Business Example
A task must be defined for the pre- treat operations. The task type is a machine
operation as it is carried out on a machine. The setup time for the machine is
measured and found to be 10 minutes, while the run time for each framework is
averaged at 3 minutes.
Item – Routings
The routing code defines a unique relationship between the routing code and the
item code defining a unique sequence of operations required to manufacture the
4-45
ERP LN 6.1.00 Common Data
end item. Several items may have the same routing code, but because the
routing code and item code make a unique combination, each routing and item
combination can have different operations.
Items-Routings
Routing Operations
The routing defines the tasks, and the sequence in which the tasks occur, which
machines are used, and in which work center the task is executed. The routing
steps are called operations and are defined in the order in which they will be
executed to manufacture or assemble the manufactured end item.
Routing Operations
4-46
4 Item Base Data
Field Description
Operation Indicates the sequence in which the routing operation
will occur.
Task The task linked to the operation indicates the nature of
work to be performed for that step.
Work Center The work center where the task in the operation will take
place.
Machine If a machine is involved with the operation, you specify
which machine will be performing the machine
operation.
Average Setup The time required to set up or change over the machine
in order to run the machine for this operation. T
Cycle Time The time required between completion of two separate
units of production. It can also equal the time that a
product remains in one position on an assembly line or
the time an operation is carried out on and item in a
work station.
Effective Date/ Expiry Date The date range the operation is valid. You can specify
additional operation sequences that may take effect or
change the operation over time and implement their use
by using the date range for effectivity.
Depending upon the source item type, you can choose various check boxes to
duplicate additional item data.
4-47
ERP LN 6.1.00 Common Data
Field Description
Source (Group Box) The item code you are using as the source item to use
as the reference for the new item.
Target (Group Box) The new item code and description for the item you wish
to create during the copy function.
4-48
4 Item Base Data
Field Description
Copy (Group Box) Depending upon the item type different selections are
available to select for copying. For example, when a
manufactured item is copied, you can indicate to copy
the source item Bill of Material and Routing as well as
the general item data and sub entity data. If the Bill of
Material check box is not selected, the new item will
require you to define a new Bill of Material.
Copy Product Configuration If the source item is configured you can select the
Data (Group Box) attributes defined in the Product Configuration that will
be copied to the new target item.
Cost and Valuation Price If the check box is selected the cost and valuation price
is calculated for the target item during the copy function
and the new price is actualized.
CHAIR
Easy Chair
SEAT FRAME
BACK Chair Frame
Easy Chair Seat Easy Chair Back
The item SEAT and FAB.0001 still need to be defined in the system. Copy the
Manufactured item SEAT and manually define the purchased item FAB.0001.
4-49
ERP LN 6.1.00 Common Data
4-50
4 Item Base Data
The item sales data enables the fabric to be used in the sales module for sales
orders. For example, the fabric can be entered on a sales order now that the Item
Sales Data is defined.
4. Click the Calculate button to calculate the standard cost price for the item.
Until the costing data is defined, production, purchase, and sales orders for
the item cannot be created and the item cannot be put into inventory.
The warehouse data must be defined for the item to be available for use in the
warehouse module. Most information is optional and does not require defining.
Entering a width and depth for the fabric will suffice.
4-51
ERP LN 6.1.00 Common Data
3. Enter the new item code SEAT and the new Description Easy Chair Seat.
4. Click Copy
4-52
4 Item Base Data
The Item data has now been defined based on the source item data. You can
edit data by opening the Items-General (tcibd0501m000) session and selecting
the new item SEAT and making any desired changes.
4-53
ERP LN 6.1.00 Common Data
2. Click New and insert BOM items FAB.0001, FAB.0004, and RAW.0002
Item FAB.0004
Field Input Value
Position 10
Item FAB.0004
Net Quantity 0.5
Warehouse 001
Item FAB.0001
Field Input Value
Position 20
Item FAB.0001
Net Quantity 1
Warehouse 001
Item RAW.0002
Field Input Value
Position 20
Item RAW.0002
Net Quantity 2
Warehouse 001
The BOM for item SEAT now contains three items, FAB.0004, FAB.0001, and
RAW.0002 being issued from Warehouse 001 when production occurs.
4-54
4 Item Base Data
1. Click the New Group icon and enter item SEAT and Routing code 001
1. Click the New Group icon and enter the item SEAT and the routing 001.
4-55
ERP LN 6.1.00 Common Data
The routing for the item SEAT now has two steps, or operations, that will need to
be executed to build a chair seat.
4-56
4 Item Base Data
XX.CHAIR
XX.SEAT XX.FRAME
XX.BACK Frame assembly
Seat subassembly Back subassembly
From the item structure for the chair, you will create the manufactured item
(XX.SEAT), and a purchased item (XX.FAB.0001).
4-57
ERP LN 6.1.00 Common Data
The item sales data enables the fabric to be used in the sales module for sales
orders. For example, the fabric can be entered on a sales order now that the Item
Sales Data is defined.
The warehouse data must be defined for the item to be available for use in the
warehouse module. Most information is optional and does not require defining.
Entering a width and depth for the fabric will suffice.
4-58
4 Item Base Data
Click the Calculate button to calculate the standard cost price for the item. Until
the costing data is defined, production, purchase, and sales orders for the item
cannot be created and the item cannot be put into inventory.
The Item Ordering data provides default values for ordering the item. The
defaults can be over written.
Item XX.SEAT
Use the Copy function in the Items – General (tcibd0501m000) session.
When copying, also select the check boxes to copy the Bill of Material and the
Routing of item SEAT.
Copy Item SEAT and create a new item called XX.SEAT (Replace XX with your
initials)
4-59
ERP LN 6.1.00 Common Data
4-60
4 Item Base Data
4-61
ERP LN 6.1.00 Common Data
______________________________________________-
What is the total routing operation time to produce one piece of item XX.SEAT?
4-62
4 Item Base Data
Alternative Items
An alternative item is an item that can be substituted or used to replace a
standard item if it is not available. Alternative items can be defined for production
items, purchased items, and end items. When multiple items can replace an item,
a priority code can be assigned defining which item has first priority and so on for
the standard item.
Business Example
Passenger seats are being produced and the item FAB.0002 is the fabric used in
the seat. There currently is has no remaining inventory for item FAB.0002. The
item FAB.0003 is a higher grade of fabric and is available in inventory. Item
FAB.0003 can be defined as an alternative item, in this case a substitute, for item
FAB.0002.
Alternative Items
You can define substitutes for standard items in case they are not available or no
longer used within the Alternative Items (tcibd0505m000) session
4-63
ERP LN 6.1.00 Common Data
AlternativeItems
The sub-session is where the details for the alternative item are defined.
4-64
4 Item Base Data
Alternative Items
Field Description
Alternative Items Items that serve as a substitute for the standard item if the
standard item is not available or is being replaced.
Introduction Date The first date that the alternative item becomes effective.
Expiry Date The last date the alternative item is valid.
Priority If you have defined several alternative items as substitutes
for a standard item, you can assign a priority code to each
alternative item. The priority code determines which item
you will first use as a substitute.
Reverse Creates a reversible relationship between the original item
and its alternative. The alternative item can substitute for
the original item, and vice versa. The system automatically
creates the record for the opposite entry.
Interchangeable The original item and alternative item have similar
properties and are completely interchangeable. When an
alternative item is defined as interchangeable, PCS can
have the system make an automatic substitution without
user intervention.
4-65
ERP LN 6.1.00 Common Data
Field Description
Replacement The alternative item replaces the original item. A
replacement item always has different properties than the
original item.
4-66
4 Item Base Data
Alternative Manufacturers
To support buying items from several approved manufacturers, you can specify a
number of manufacturers for an item, and ensure that only approved
manufacturers provide goods to your company.
The item’s manufacturers are specified in the Purchase Master Data module. In
the item purchase data, you can indicate that you accept items from the buy-from
business partner that are produced by any of the manufacturers that you
specified for the combination of item and buy-from business partner.
4-67
ERP LN 6.1.00 Common Data
Start
End
Define Manufacturers
The Manufacturers (tcmcs0160m000) session is used to identify the available
manufacturers and the status of each manufacturer.
Items – General
The default manufacturer is identified in the Items – General (tcibd0101m000)
session. This is the manufacturer any order placed will default for ordering and
specify for the item.
4-68
4 Item Base Data
Item – Purchase
The check box for Multiple Manufacturer in the Item – Purchase (tdipu0101m000)
session indicates if the item can be purchased from multiple manufacturers or if
only one manufacturer is allowed. An effective date period can also be defined.
Item Manufacturer
The Item Manufacturer (tdipu0130m000) session identifies the valid item
manufacturer combinations available for ordering the item. Here you define the
various manufacturers that are approved to supply the item.
4-69
ERP LN 6.1.00 Common Data
Unit Effectivity
The Unit Effectivity section is covered in more detail in the Manufacturing course.
This section is included to introduce the topic and provide a brief overview of how
Unit Effectivity functions.
Unit Effectivity is used to control variations of an item. You can use unit effectivity
to model deviations from a standard end item so you do not require separate
item codes and bills of materials for every combination of item variations. The
deviations typically consist of small deviations of the end item.
Unit Effectivity typically apply changes for the end item when:
1. By Series:
Effectivity units are used to define exceptions for an item series, or series’
subset. You can use this approach in low -volume production of complex
products, for example, in aerospace and defense industries. Series are defined
for a specific end item, for example, an airplane. Exceptions are then defined per
series, for example for numbers 50-100 of an item’s series you define a unique
option.
2. By Sales Order:
Effectivity units are used to configure items on individual sales order lines. You
can use this approach in high-volume industries, such as electronics industries.
Effectivity Unit
An effectivity unit is a code that is linked to an end item. The effectivity unit
identifies the item, and can also represent deviations from the standard end item.
The effectivity unit can be linked to manufactured items and purchased items.
The effectivity units represents several changes in the end item such as:
4-70
4 Item Base Data
Routing.
Routing operations.
Deviations for and items configuration can be the result of several circumstances
such as:
The use of one component instead of another: This affects the Engineering
BOM or the Production BOM. For example, when a touring car, which is
completely standard, requires red seats instead of blue seats.
The way the end item is produced: This affects the routing or the routing
operations in the Routing (ROU) module. For example, when you want to test
a new production technique, which affects the routing or some of the routing
operations, but the result is a standard item. In this case, unit effectivity only
relates to the routing.
The origin of the end item's parts: This affects the sourcing strategies defined
in the Enterprise Planning module. For example, when you want to test the
components that are supplied by a new manufacturer.
If you use unit effectivity during the design and/or engineering phases, the
resulting end items must be lot-controlled. The items can also be serialized
items. Component items (material) do not need to be lot-controlled. However, to
distinguish items by effectivity unit in the warehouse, material must also be lot-
controlled.
4-71
ERP LN 6.1.00 Common Data
Lesson Review
In this lesson, you learned...
4-72
4 Item Base Data
Review Questions
1. Which statement about Items – General Defaults session is correct? _____::
2. Sub Entity information for an item can only be defined in the Items – General
session?
A. True
B. False
4-73
ERP LN 6.1.00 Common Data
1. B (Items – General Defaults information reduces the amount of data entry for
similar items in the same item type and item group.)
2. False (Sub entity information can be defined during item creation, or within
each respective module providing flexibility in when and how sub entity
information is created.
4-74
5
Cost Price Calculation
The Cost Price Calculation (CPR) module simulates or establishes the costs of
production items and purchase items. The cost price calculates and compares
costs generated on the shop floor and also determines the inventory valuation.
Cost prices can be broken down into material, operation, and overhead costs.
To get the cost price for an item, the operation cost, or the cost to produce the
item in terms of labor costs and machine costs is calculated. Operational cost
information comes from the item routing for a manufactured item. The costs of
all materials to make the item are added for the cost. The material costs come
from the bill of material for manufactured items and from the item data for
5-1
ERP LN 6.1.00 Common Data
purchased items. Finally, any overhead or surcharges are added to get a total
cost. Overhead costs can be associated with either material or operations.
You can use cost information to calculate the standard cost for an item. The
standard cost can help you to determine an appropriate selling price. For
example, if it costs you $120.00 US dollars to produce each item, you want to set
a selling price higher than that to allow for a good profit margin. You can also use
standard costs to:
The Cost Price Calculation module provides features that allow you to simulate
and compare methods of costing your production items. Once cost price
calculations have been performed, reports are available to analyze the cost
structure of an item. When you have completed your simulations, you can update
the actual prices in a process called actualizing.
Definitions
Operation: An Operation is based on a series of routing steps that are carried
out successively to produce an item. These steps are recorded in data that is
used to help calculate cost prices. The types of data that are collected during a
routing operation consist of:
The machine used to carry out the task (for example, a sawing machine).
This data collection is optional.
The place (Work Center) where the task is carried out (for example, the
woodwork work center).
Routing: A series of steps that the system takes to complete an operation task.
Lesson Objectives
After completing this lesson, you will be able to:
5-2
5 Cost Price Calculation
5-3
ERP LN 6.1.00 Common Data
For the calculation of the project costs in the Project Control module, the
operation rates and the subcontracting rates for the estimated item-related costs
can also be defined in the Cost Price Calculation module.
5-4
5 Cost Price Calculation
Start
No
End
CPR Parameters
CPR Parameters define the rules to set up costing data and calculate the costs
of items in your company. The Standard Price Calculation Code defined is the
code the system searches for when actualizing the cost price of an item during
Cost Price Calculations. The Type of Operation Rates determines where you will
retrieve Operation Rates (by work center or task). This rate calculates operation
costs from the Routing.
5-5
ERP LN 6.1.00 Common Data
Field Description
Effective Date The date range the current parameter settings are valid.
Description Provides a description of the current parameter setting.
Provides date and time stamp to indicate when the
parameter settings were established.
Standard Cost Price The one Cost Price Calculation Code that represents
Calculation Code the method used to calculate and Update/Actualize the
Standard Cost Price
Type of Operation Rates Determines whether operation rates are linked to work
centers or tasks. The selection made in this parameter
applies to the entire Company. Tasks define information
in a more detailed manner than work centers
Zero Component Cost Price If the check box is selected, the cost price calculation for
Allowed an item will be calculated even if one of the item’s
components has a cost price of 0.
Include Fixed Costs in Determines if any costs identified as fixed costs will be
Sales Price included when the sales price for an item is calculated.
The sales price will always contain the variable costs.
Include Fixed Costs in Determines if any costs identified as fixed costs will be
Valuation Price included when the valuation price for an item is
calculated. The valuation price will always contain the
variable costs.
5-6
5 Cost Price Calculation
Field Description
Include Surcharges in Indicates if surcharges assigned to an item in the main
Valuation Price of Shop warehouse are included in the item’s valuation price in
Floor Warehouse the shop floor warehouse. As a result, the issue price of
the item from the main warehouse is the same as the
receipt price in the shop floor warehouse. Consequently,
no transfer results and production results will occur.
Cost Components
Detailed categories can be defined for production costs according to your
company’s needs. Production costs can be broken down into several types or
accounts to enable detailed analysis on the types of costs incurred for the
production of an item. Cost components categorize production costs into specific
groups called Cost Types. The Cost Type categorizes the costs for the
production process, such as, material costs. The cost component is user defined
to allow maximum flexibility in the allocation and analysis of product costs. You
can define a cost component and description to represent multiple machine,
material, transfer, and surcharge costs, which are all part of the production
process.
5-7
ERP LN 6.1.00 Common Data
Cost Components
Field Description
Cost Type Identifies the nature of the production cost and links to a cost
component. The seven cost types available for selection are:
Surch. on Operation Costs: An additional cost or discount
associated with a routing operation.
Surch. on Material Costs: An additional cost or discount
associated with purchased material.
WIP Transfer Costs: Any costs that may be incurred when
transferring Work-In-Process (WIP) from one machine or work
center to another.
General Costs: Any additional administration costs, such as
freight charges. This cost type is linked to cost items.
Not Applicable: Cost components with this cost type are used
within project or service industries and are not applicable to
cost price calculation.
5-8
5 Cost Price Calculation
Cost Components
2. Create the Cost Component MC1 and CL1 to represent the new Operation
Rates for the manufacturing of the Chair Frame.
5-9
ERP LN 6.1.00 Common Data
Cost Components
The result is a new entry for Cost Component MC1 and CL1 both specified as an
Operation Cost. These new Cost Components will represent the labor and
machine costs, which are types of Operation Costs, used to produce the new
Chair Frame.
5-10
5 Cost Price Calculation
Cost Components
5-11
ERP LN 6.1.00 Common Data
Cost Components
5-12
5 Cost Price Calculation
Chart Details
The Chart details displays and maintains the detailed cost components linked to
a specific chart. If you link a chart to an item in the Items-Costing
(ticpr0107m000) session, to an item group in the Items-Costing Defaults
(ticpr0108m000) session, or to an assembly line in the Assembly Line Costing
Data (ticpr0115m000) session, the detailed cost components that you define in
this session are reported in the effective cost-component structure for a specific
item.
Each task and/or work center can have a unique Operation Rate Code consisting
of operation rates that are specific to that task and/or work center. Operation
Rate Codes are defined by currency in the Operation Rates Codes
(ticpr0150m000) session.
5-13
ERP LN 6.1.00 Common Data
Field Description
Operation Rate Code A code that identifies the operation labor/machine cost
rates. The rate code can be linked to a task or work center
depending on the CPR Parameter settings. This code can
also be linked to a cost price calculation code.
Currency The currency used to calculate the Operation Rate when
using this operation rate code.
5-14
5 Cost Price Calculation
5-15
ERP LN 6.1.00 Common Data
5-16
5 Cost Price Calculation
Typically, you should create one Price Calculation Code to represent and
calculate your Standard (or Actual) costs. Additionally, you can create one or
more Price Calculation Codes that are linked to different Operation Rate Codes
to simulate changes in operation costs (labor rate or machine rate changes) to
analyze the affect on your pricing.
5-17
ERP LN 6.1.00 Common Data
Field Description
Price Calculation Code Determines the cost-price calculation data that is used
to calculate a cost, valuation, or sales price. Cost
calculation data (such as, operation rates, surcharges,
subcontracting rates, and simulated purchase prices)
are stored under this code.
Calculation Code Type Determines how a cost, valuation, or sales price is
calculated. Two code types are available for selection:
Cost Price: Calculates only a cost or valuation price. A
valuation price may vary from the cost price and is used
for accounting purposes, such as inventory valuation.
Sales Price: Calculates sales prices. Warehouse
surcharges may not be defined for a sales price
calculation.
5-18
5 Cost Price Calculation
Field Description
Priority of Purchase Price Purchase prices will only apply if the code type is Cost
(Group box) Price. A priority determines the order of the selected
purchase price types when a cost price is calculated. A
purchase price type specifies the origin of the purchase
price .If a purchase price is not specified for the first
priority, then the search will continue to the second
priority, and so on, until the fourth and final priority has
been checked. If a purchase price cannot be determined
from the search priority, then the standard cost for the
item will be zero. Four purchase price types are
available:
Si (Simulated Purch. Pr.): A price calculation code
can be created and used to simulate a purchase
price. These prices are for a unique item and cost
price calculation code in the Simulated Purchase
Prices (ticpr1570m000) session.
Cp (Current Purch. Price): The current purchase
price is manually entered in the Item Purchase Data
(tdipu0101s000) session.
Ap (Average Purch. Price): The average purchase
price is automatically calculated by the system
based on all previous purchase receipts, when the
receipts are matched and approved in the Finance
Package.
Lp (Latest Purch. Price): The latest purchase price
is calculated based on the most recent purchase
receipt, after the receipts are matched and
approved in the Finance package.
Direct Costing Allows overhead costs to be included or excluded from
the cost price calculation. If this field is selected, then
overheads will be excluded from the cost price
calculation.
If the box is not selected, the overhead costs will be
included in the standard cost price of the item.
Business Example
A price calculation code will be used to calculate the actual cost price of all
manufactured items, including the chair you will manufacture. It is decided that
any additional costs that occur from machinery maintenance are to be
incorporated into the existing cost price calculation code
5-19
ERP LN 6.1.00 Common Data
1. Click the New icon and enter the values to define a new code.
5-20
5 Cost Price Calculation
You can now view your new price calculation code in the Price Calculation Codes
(ticpr1100m000) session
5-21
ERP LN 6.1.00 Common Data
Therefore, you must define a price calculation code to use for simulating the cost
price changes based on this new machine’s production rate.
Define a price calculation code for your new machine using these values
5-22
5 Cost Price Calculation
5-23
ERP LN 6.1.00 Common Data
You can also simulate costs for purchase items. This is a very effective
management tool when considering factors such as price fluctuations from
suppliers.
Start
No
End
5-24
5 Cost Price Calculation
Operation rates and item surcharges are used as the basis of cost price
calculations. Simulation prices for purchased items provide an insight into
possible cost or sales price implications. Cost price calculations can be used to
illustrate possible changes, in addition to actual changes.
Operation Rates
Operating costs are calculated based on the hourly operation rates linked to the
Tasks or Work Centers specified in an item’s routing. An operation rate typically
is defined with a dollar value used to calculate the per hour rate for labor,
machine, and production overhead costs. Once defined, operation rates for labor,
machine, or overhead costs are linked to a price calculation code and an
operation rate code. When the standard cost is calculated, the item routing is
referenced to identify each task or work center involved in the manufacturing of
the item.
5-25
ERP LN 6.1.00 Common Data
Operation Rates
Field Description
Type of Operation Costs The type of cost that will be linked to the Operation Rate.
Four operations costs types are available:
Labor: Operation rates are based on a labor
rate/cost.
Machine: Operation rates are based on a machine
rate/cost.
Overhead on Man Hours: Any overhead costs
associated with labor or man-hours. The overhead
costs are calculated by multiplying the number of
man-hours by the entered rate/surcharge.
Overhead on Machine Hours: The rate/surcharge
represents overhead costs, which are based on
man-hours. associated with a machine. The
overhead costs are calculated by multiplying the
number of machine hours by the entered
rate/surcharge
Rate The hourly rate applied to labor, machine, or overhead
costs. This rate is multiplied by the number of hours
required by the operation to calculate the total
production costs.
5-26
5 Cost Price Calculation
Field Description
Cost Component The operation rate is linked to a predefined cost
component to categorize production costs before
transferring them into the Finance module for analysis.
Variable Cost Adds the operation costs maintained in the Operation
Rates (ticpr1150s000) session to the valuation price of
an item, as a variable cost. The variable cost is then
considered when calculating the cost price of an item.
1. Click the New Group icon and enter the Price Calculation Code and
Operation Rate Code using the table values.
5-27
ERP LN 6.1.00 Common Data
Operation Rates
2. Click the New icon to enter the new Operation Rate using the table data:
5-28
5 Cost Price Calculation
Operation Rates
You have just created your new Operation Rate that is linked to Operation Rate
Code XXX. You can view the rate in the Operation Rates (ticpr1150m000)
session.
5-29
ERP LN 6.1.00 Common Data
Operation Rates
Item Surcharges
Surcharges are divided in to either item surcharges or Warehouse surcharges.
You can define surcharges by:
Item group- The surcharge applies to the cost price of all items in the defined
item group. If the Bookings Triggered By field in the Item Surcharges
(ticpr1110m000) session Receipt, the surcharges are added to the receipt
Valuation Price stored in the Item Calculated Valuation Prices (ticpr2540m000)
session.
Item- The surcharge applies to the cost price of the item. If the Bookings
Triggered By field in the Item Surcharges (ticpr1110m000) session is Receipt,
the surcharge is added to the receipt Valuation Price stored in the Item
Calculated Valuation Prices (ticpr2540m000) session.
5-30
5 Cost Price Calculation
BOM level. You must select the Surcharges by Warehouse check box in the
Items-Costing (ticpr0107m000) session if you want to have each warehouse/item
combination can have its own surcharge.
If no warehouse is specified, the surcharge applies to the item for all transactions
regardless of the warehouse it is in.
5-31
ERP LN 6.1.00 Common Data
Field Description
Price Calculation Code Determines the cost-price calculation data that is used
to calculate a cost, valuation, or sales price. Cost
calculation data (such as, operation rates, surcharges,
subcontracting rates, and simulated purchase prices)
are stored under this code.
Booking Triggered by The moment at which the surcharge is added to the
valuation price of the item or item group. Two Booking
Triggered By options are available:
Receipt: Surcharges are added to the valuation
price when the items are received into the
warehouse.
Issue: Surcharges are added to the valuation price
when an item is issued from the warehouse to work-
in-process or as material on a service order.
5-32
5 Cost Price Calculation
Field Description
Calculation Line type Determines how a surcharge is calculated. Three
calculation line types are available:
Surcharge: Directly applies a surcharge.
Subtotal: Calculates a sub total for all surcharges
made for reporting purposes only.
Cumulative Cost Price: Calculates a sub total for
all cost prices including material, operation, and
surcharge costs. This is only for reporting purposes.
Variable Cost Includes the surcharge as a variable cost. The variable
cost is then considered when calculating the cost price
of an item.
Entering surcharge data is only required if the Calculation Line Type field within
the General tab is set to Surcharge. The Surcharges tab provides the ability to
determine the method of the surcharge.
5-33
ERP LN 6.1.00 Common Data
Business Example
In order to recoup the tooling costs for the injection mold machine, a fixed
amount surcharge can be created and charged as an Surcharge against an Item
or Item group that use the Injection Mold machine. The surcharge amount must
be equal to the cost of the tooling.
5-34
5 Cost Price Calculation
1. Click the New Group icon and enter the New Group values:
Item Surcharges
2. Click the New icon and insert the new Surcharge data in the table:
5-35
ERP LN 6.1.00 Common Data
General
Field Input Value
Booking Triggered By Receipt
Warehouse 001
Sequence Number 10
Description Std Item Surcharge
Calculation Line Type Surcharge
Surcharges
Field Input Value
Surcharge Method Fixed Amount
Surcharge Amount $15.00
Surcharge Component 300
5-36
5 Cost Price Calculation
You can now view your new item surcharge that will be added to the standard
cost of the item.
Item Surcharges
5-37
ERP LN 6.1.00 Common Data
Field Description
Simulated Purchase Price The simulated purchase price and currency are
recorded twice. The price in this field is related to the
item itself. The amount in the Sim. Pur. Pr. Mul. Curr.
field is related to the price of the supplier.
Simulated Purchase Price The simulated purchase price and currency are
Multi Currency recorded twice. The price in the Simulated Purchase
Price field is related to the item itself. The amount in this
field is related to the price of the supplier.
5-38
5 Cost Price Calculation
Field Description
Cost Component The cost component to track the simulated price. This
must be of the type Material.
1. Click the New Group icon and enter the Cost Price Calculation Code SP1.
2. Click the New icon to enter the item data for the simulation using the table
data”
5-39
ERP LN 6.1.00 Common Data
Run the Calculate Standard Cost and Valuation Prices (ticpr2210m000) session
and view the new cost price.
4. Enter the item or range of items you wish to view the change using the
simulated purchase price and click the Calculate button.
5. The display will show the new price for CLOTH as $85.00.
5-40
5 Cost Price Calculation
Start
End
The costing information can be calculated based on two types of prices, cost
price and valuation price. The cost price uses Item Production Data, Bill of
Material, Routing, and Calculation Data to determine a fixed price. This price can
be used for simulation purposes and is known as the Fixed Transfer Price (FTP)
5-41
ERP LN 6.1.00 Common Data
Field Description
Price Calculation Code Determines how the cost price, valuation price, or sales
price is calculated. The code is linked to the Operation
Rate and determines the calculation.
The code defined in the CPR Parameters determines
the standard cost price. Other price calculation codes
are used for simulation purposes.
5-42
5 Cost Price Calculation
Field Description
Cost Price Calculation Indicates how the system goes through an items
Method structure when calculating the cost. The methods are:
Top down: The calculation is performed only to the
selected item and any item that occurs at a lower level
in a multilevel BOM.
Bottom Up: The calculation is performed only to the
selected item and any item above the selected item in
the BOM that could change price due to the change in
price of the selected item.
Single Level: The cost price is calculated for the
selected item. Cost prices of items in a lower level in the
BOM are not adjusted.
Only Items without a If the check box is checked, the cost and valuation
Standard Cost Price prices are calculated for items which have not already
had the cost price calculated. When a number of items
have been created, you can select this option and a
range of items, only the new items will have the cost
price calculated. Item within the selection range that
already have a cost price will not be re calculated.
Actualize Standard Cost If the check box is selected, the cost and/or valuation
and Valuation Prices prices are updated for the item. If not selected, you can
view the calculation results, but the cost prices will not
be updated in the data base for the item.
1. Enter your desired item or item range, but do not select the Actualize Cost
and Valuation Prices check box.
5-43
ERP LN 6.1.00 Common Data
Do not select the Actualize Cost and Valuation Prices check box unless you are
sure the results of the calculation are correct and you are ready to update the
standard cost price of the item.
The calculated cost price can be viewed before the cost is actualized.
5-44
5 Cost Price Calculation
During the actualization process, the cost component structure (consisting of the
aggregated and detailed cost components), the cost price, and the valuation
price are made effective. In other words, the structure and prices are stored for
an item for a certain date. After the actualization, the effective cost component
structure can be viewed, for example, in the Effective Cost Component Structure
by Assembly Line and Item (ticpr3161m000) session.
5-45
ERP LN 6.1.00 Common Data
If an item's cost component structure has changed, or the valuation price or cost
price for an FTP item, Warehouse Management adjusts the inventory value of a
warehouse. The inventory value adjustment processes the actual order price into
the inventory value of the items. The value correction is posted to Financials and
is stored under a revaluation order code. The revaluation order code is generated
automatically and can be viewed in the Item – Standard Costing Data
(ticpr3501m000) session. You can use the revaluation code in Warehouse
Management to track the valuation changes.
Business Example
A supplier has confirmed the new purchase price for granular plastic. An
alternative supplier cannot be found at a more competitive price and so the
decision is taken to accept the price increase. The cost price calculation for the
seat assembly for the chair must now be actualized in order to update the item’s
standard cost to reflect the new standard cost
5-46
5 Cost Price Calculation
The standard cost price for item SEAT_1 is $97.50. Materials are the
components of item SEAT_1 and consist of $17.50 and the Operation rates
consist of labor and machine operations from the routing and are $80.00.
5-47
ERP LN 6.1.00 Common Data
Define an operation rate code for your welding machine (to represent both the
machine and labor rates) using these values.
5-48
5 Cost Price Calculation
Operation Rates
5-49
ERP LN 6.1.00 Common Data
Work Centers
Calculate the cost price for item SEAT_1 again to view the changes to the cost
price calculation using the new machine and labor rates associated to operation
rate code XX1 (replace XX with your initials).
5-50
5 Cost Price Calculation
5-51
ERP LN 6.1.00 Common Data
Notice the operation rates for item SEAT_1 have changed to $67.50 using the
new Operation Rate Code XX1 you linked to the work center in the routing. When
the system recalculated the standard cost price, it used the new operation rates
and gave a new standard cost price. Remember the original operation rate was
$80.00 that came from the Operation Rate Code MAN.
From the Specific Menu select the Cost Prices Details option.
5-52
5 Cost Price Calculation
Notice the cost components are broken down into XXL and XXM representing
the individual costs for machine and labor rates you specified under Operation
Rate Code XX1. The total of the three cost components listed is the total
aggregated operation costs which are $67.50 as you saw in the Cost Prices sub
session.
If you only want to print calculations on the item level as specified in the Item
field, you must use the Print Cost Price Calculation by Item (ticpr2410m000)
session
5-53
ERP LN 6.1.00 Common Data
Field Description
Cost Price The date for which you want to print cost price calculation data.
Calculation Date
The cost-price calculation date is important to simulate
cost/valuation price calculations on a date other than the current
date. It can lie in the future or in the past. On the basis of this
date, the system automatically simulates the structure of the
product and the routing as they exist on the given cost
calculation date. The current date is shown by default.
5-54
5 Cost Price Calculation
Field Description
Economic Order If this check box is selected, the economic order quantity of the
Quantity Main Item main item is used to calculate the quantities of the sub-items.
The economic order quantity is entered in the Items – Ordering
(tcibd2500m000) session.
If this check box is cleared, you must enter a value in the Use
Order Quantity field. This value is used to calculate the
quantities of the sub-items.
Use Order Quantity The order quantity of the main item on which the cost price
calculation is based. You can only enter a value if the Economic
Order Quantity Main Item check box is not selected.
The default value of this field is the economic order quantity of
the main item as defined in the Items – Ordering
(tcibd2500m000) details session.
Economic Order This check box only applies to cost prices and valuation prices
Quantity Sub Items that are calculated with price calculation codes other than the
standard price calculation code in the Cost Price Calculation
Parameters (ticpr0100m000) session.
If this check box is selected, the cost/valuation prices of the sub-
items are based on the economic order quantity of the sub-
items. The system computes the cost/valuation price of the main
item using the sub-items' cost/valuation prices.
Example
Amount Ec.Order.Qty
Main Item Bicycle 1x 5
Sub-item Wheel 2x 15
Sub-item .... ...... etc
Cost price of Wheel based on 15 items is: 100
Cost price of Main Item:
2x Wheel at 100 = 200
Order quantity of Wheel is 5 x 2= 10
Cost price of Wheel is based on 10 items: 105
Cost price of Main Item:
2x Wheel at 105 = 210
Details by Cost If this check box is selected, the details of the cost/valuation
Component price calculation are printed by cost component.
Include Fixed Costs If this check box is selected, costs such as operation rates or
surcharges that you defined as fixed costs are printed.
5-55
ERP LN 6.1.00 Common Data
5-56
5 Cost Price Calculation
Lesson Review
In this lesson you learned how to:
5-57
ERP LN 6.1.00 Common Data
Review Questions
1. Price Calculation Code 001 is defined in the CPR Parameters. You are
calculating costs for a range of items using Price Calculation Code 002. You
can simulate the cost price for the items with Price Calculation Code 002,
then select the Actualize option to update the standard cost of these items if
you are satisfied with the simulation.
A. True
B. False
2. The Cost price breakdown for a manufactured item consists of: (Enter a Yes
or No)
3. Operation Rate Codes can be applied on the Operation or the Work Center or
on both the Operation and Work Center.
A. True
B. False
5-58
5 Cost Price Calculation
1. False (You can only Actualize the cost prices for items that are calculated
using the Actual Cost Price Calculation Code defined in the CPR parameters)
5-59
6
Business Partners
Lesson Objectives
After completing this lesson you will be able to:
6-1
ERP LN 6.1.00 Common Data
Start
Customer or
Customer Roles Supplier Roles
Supplier?
Define buyer information Define Supplying information
Sold-to Business Partners Buy-from Business Partners
(tccom4110s000) (tcom4120s000)
End
If the Business Partner will act as a Supplier and Customer to your organization,
then define all eight Business Partner Roles.
6-2
6 Business Partners
Business Partners
A Business Partner represents a party with whom you carry out business
transactions. You can also specify departments within your organization that act
as customers or suppliers between logistical companies or between enterprise
units and define these departments as business partners.
6-3
ERP LN 6.1.00 Common Data
Business Example
There are several manufacturing facilities that produce different parts for high-
speed trains. One facility assembles frames for the passenger seats. This facility
then ships the frames to another facility where the final assembly is completed.
This transaction generates internal invoices from the first to the second facility.
This transaction generates internal sales that must be recorded. By creating an
internal business partner associated with each Enterprise Unit, you can record
the invoice and transfer of goods from one facility to the other.
6-4
6 Business Partners
Business Example
Your company has two main manufacturing entities and each is financially
separate. On occasion, you transfer goods from one facility to the other, for
example; when company 100 runs low on fabric RAW.0001 you can supply
additional fabric RAW.0001 from company 101. To account for this transfer of
goods you create a Business Partner in company 100 that is affiliated to
company 101 and create a business partner in 101 that is affiliated to company
100. You can then place orders between the two business partners to record the
flow of goods and financial transactions between the two companies.
______________________________________________________________
6-5
ERP LN 6.1.00 Common Data
The Invoice-to business partner role can also have the status Doubtful. This
enables sales orders for the business partner with this status to be blocked.
When a check is made for the status of the business partner the sequence is to
check:
6-6
6 Business Partners
Field Description
Search Key Provides the general data for locating a business
partner record. This defaults from the Name, but can be
changed manually.
Parent Identifies the parent business partner this record is
related. This is used when a hierarchical role exists
between business partners and a parent-child
relationship exists.
Business Partner Status The status determines if transactions can be conducted
with the business partner as well as what type of
transactions. Available options:
Active
Inactive
Potential
The status is valid based on the date range entered.
6-7
ERP LN 6.1.00 Common Data
Field Description
Language Designates the language for correspondence with the
business partner.
Currency The currency for initial transactions with the business
partner for quotes and requests for quotes. The system
will then use the currency specified in the Invoice-to or
Invoice-from business partner roles.
One Time Business Partner Indicates this business partner is used to represent
temporary contacts. For example if you do not regularly
do business with an individual or several individuals, you
may create one or more one-time business partners to
record any transactions with these individuals.
6-8
6 Business Partners
Field Description
Internal Business Partner Indicates if this business partner is used to track goods
transfers and the associated financial transactions
between enterprise unites within your logistic company.
Affiliated Company Indicates if the business partner is affiliated. An affiliated
company business partner can conduct transactions
with other logistic companies in your organization. The
affiliated business partner is used to record and track
the sale, purchase, transfer of goods between logistic
companies.
Affiliated Company Number If you indicate the business partner is affiliated, you
specify the company number the business partner is
associated with. This is the company that you will
conduct goods and financial transactions with for this
business partner.
6-9
ERP LN 6.1.00 Common Data
Business Partner roles are defined within the General tab in the Business
Partners (tccom4100s000) session. Roles define the functions (such as Buy-
from, Ship-from, etc.) of the Business Partner that conducts business with your
organization. These roles can be related to buying and/or selling. You define
roles by selecting any of the Roles buttons. Roles define the business
relationship, customer, supplier (or both customer and supplier), and their
appropriate transactions. These transactions identify where billing, invoicing,
payments, shipping, etc. activities will occur. Because organizations are dynamic
in structure, different departments or offices in several locations may be involved
in one business transaction with your organization. Roles allow you to identify
each Business Partner’s function.
The graphic the logic used to assign roles to transactions (in this case a
Purchase Order) when a parent-child relationship exists. In reality, Parent A may
send the invoice because they are listed as an Invoice-from Business Partner,
while the Purchase Order was actually placed with the Buy-from (Child 1)
Business Partner. By defining different roles for each Business Partner, multiple
Business Partners can participate in one transaction.
The business partner's roles also enable you to address the correct office and
contact, for each part of a business transaction. For example, your customer's
sales office, accounts payable office, and warehouse can all be at different
locations or even in different countries. In the business-partner's role details you
define for each office or warehouse:
6-10
6 Business Partners
The status
The address
The contact
The calendar
Depending upon the roles defined you determine if a business partner acts as a
supplier or customer with your organization. If you define all eight roles, the
business partner can act a both a supplier and customer.
Customer Roles
Customer business partners with a status of Active must have all customer roles
defined for that customer or within the parent-child hierarchy if one exists for that
business partner.
Sold-to
Ship-to
Invoice-to
Pay-by
6-11
ERP LN 6.1.00 Common Data
Start
End
Business Example
Standard Chair Company will be added to the database. The new business
partner will be a customer. Since Standard Chair Company has two distribution
points and you may receive orders from either, you will enter a parent child
hierarchy with two business partner records. The main office will be business
partner CUS000019 and the secondary distribution office will be business partner
CUS000020.All invoices and payments will be through the main office, the
distribution office will only place orders and receive shipments. The business
partner records would be set up accordingly:
6-12
6 Business Partners
Supplier Roles
Supplier business partners with a status of active must have all the supplier roles
defined, either for that business partner record or within the parent-child
hierarchy in order to complete transactions for that business partner.
Buy-from
Ship-from
Invoice-from
Pay-to
6-13
ERP LN 6.1.00 Common Data
Start
End
1. Click the New icon and enter the Series CUS since A&C Inc. will be a
customer.
6-14
6 Business Partners
6. Define the Sold To, Ship To, Invoice To, and Pay By roles for the business
partner.
When the new customer record is saved, the system generated the Business
Partner code, CUS000008. Note the check boxes next to the roles associated
with a customer Business Partner are checked indicating the roles have been
defined.
6-15
ERP LN 6.1.00 Common Data
1. Click the New icon and enter the Series SUP since Dexter Supply Company.
will be a customer.
6. Define the Buy From, Ship From, Invoice From, and Pay To roles for the
business partner.
When the new supplier record is saved, the system generated the Business
Partner code, SUP000005. Note the check boxes next to the roles associated
with a supplier Business Partner are checked indicating the roles have been
defined.
6-16
6 Business Partners
6-17
ERP LN 6.1.00 Common Data
Define the Sold to, Ship to, Invoice to, and Pay by roles for the Business Partner.
What occurs when you try to save a business partner role when a required field
is not filled?
Define the Buy from, Ship from, Invoice from, and Pay to business partner roles.
What type of data commonly defaults from the business partner header to the
roles?
6-18
6 Business Partners
Define the Buy from, Ship from, Invoice from, and Pay to supplier roles as well as
the Sold to, Ship to, Invoice to, and Pay by customer roles.
6-19
ERP LN 6.1.00 Common Data
Lesson Review
In this lesson you learned to:
6-20
6 Business Partners
Review Questions
1. Which statement is correct regarding Business Partners
A. Business Partners require all eight roles defined in order to be valid for
use on an order.
2. A business partner with the status Potential means that the business partner
is available for placing orders, but the order will be placed on hold.
D. True
E. False
3. A Business Partner must have all the supplier or customer roles defined
even if there exists a parent child hierarchy.
A. True
B. False
6-21
ERP LN 6.1.00 Common Data
1. B
2. B (You can create quotes, but orders are not allowed to be created)
3. B (False: a business partner must have all the customer or supplier roles
defined for them self to be eligible for orders to be fully processed. If there is
a parent child hierarchy, then the customer or supplier roles need to be
defined only for the business partner executing that role.
6-22
7
People
Using the People package enables users to enter and process hours and
expenses. The costs from the processing of these hours and expenses can be
booked within the originating logistics packages consisting of:
Project
Manufacturing
Service
Quality Management
Financials
Lesson Objectives
After completing this lesson, you will be able to:
7-1
ERP LN 6.1.00 Common Data
Employee Dashboard
A session has been created to enable dynamic access to multiple sessions
dealing with employees and hours accounting. The session in used to access
multiple tasks from a single point. You can use this session to view and maintain
employee data.
You can carry out the following tasks from the dashboard:
Create, view and maintain employee-related data that is stored in the tables,
for example, data on employment, skills, etc.
When you select an employee, the information defined for that employee will be
displayed in the Details section of the dashboard.
Employee Dashboard
7-2
7 People
When you select the check box next to an employee name, the options under the
Employee Details become activated. You can then access these sessions
directly for data and hours entry.
7-3
ERP LN 6.1.00 Common Data
Start
End
This is the basic flow for establishing People Master Data is depicted. There are
additional master data sessions included for informational purposes.
7-4
7 People
People Parameters
The People Parameters (bpbdm0100m000) session defines the basic and default
data for the People package. The Process Labor Costs/Expenses tab enables
you to specify how the labor transactions are processed. The options for
processing are:
Direct: Hours are processed immediately after closing the hours accounting
session or after hours are entered and saved.
In Batches: Hours are processed using the Process Hours and Expenses
(bptmm1203m000) session.
Approval Required: Hours can only be processed once the hours are
approved manually using the Global (Undo) Approve Hours and Expenses
(bptmm1202m000) session.
7-5
ERP LN 6.1.00 Common Data
Field Description
Period Table Code The code represents the year and period you will use for
hours registration.
Default Labor Type The labor type that is used for recording assignments,
registering hours, and budgeting by default.
Availability Type The default availability to determine workdays used in
assignments and for budget hours.
Direct Time Reporting Indicates manufacturing hours for a task can be entered
directly. The task start date is set to the current date and
time stamp. When hours are entered for the next task.
The previous line is automatically closed.
Use Registration Indicates only users that have been authorized using the
Authorization Registration Authorizations (bpmdm0110m000) session
can enter hours.
Use Approval Authorization Indicates that only users authorized in the Approval
Authorizations (bpmdm0111m000) session can approve
hours and expenses.
7-6
7 People
Field Description
Approval Required Indicates the hours registered for the module can only
be processed once they have been manually approved
through the Global (Undo) Approve Hours and
Expenses (bptmm1202m000) session.
Employees – General
The Employees – General (tccom0101m000) session is used to record the basic
employee data. The employee must be entered in this session before detailed
people data can be entered in the Employee – People (bpmdm0101m000)
session.
Employees – General
7-7
ERP LN 6.1.00 Common Data
Field Description
Employee Code representing the employee.
Language Language you will print the work instructions for the
employee.
Department The department assigned to the employee. This is used
for capacity planning for the department.
Logon Code The employee user logon is the code used to log into
the ERP application.
Labor Rate The rate used to specify the sales rate and cost rate for
this employee.
Cost Component The account where the costs associated with this
employee are recorded.
Calendar Code The calendar for this employee. Used to specify the
employee availability.
Define Employee
Define a new employee and specify the general information for the new
employee.
Create a record for the employee Sharon Stills using the employee code 4546.
The completed record now identifies Sharon Stills and the associated general
information.
7-8
7 People
Employees-General
Employees – People
This session is used to define data specific to the People package. You must first
define the employee in the Employees – General (tccom0101m000) session
where you define the general information for the employee, then you can define
the people related data in this session.
7-9
ERP LN 6.1.00 Common Data
Employees – People
Field Description
Address The address for the location of this employee.
Working Time Schedule The code used for hours accounting with this employee.
Employment The number of hours in the period the employee works.
This is based on the number of periods defined under
the period table code in the People Parameters
(bpmdm0100m000) session.
Employee Type Determines if the employee is and internal or external
employee.
7-10
7 People
For the employee 4546 record, define the People information indicating the
address, employment hours, and working time schedule.
The new record for employee 4546 is now entered and specifies the Working
Time Schedule and hours of employment. The employee is now available for
entering hours in the People package.
7-11
ERP LN 6.1.00 Common Data
Employees- People
User Profiles
User profiles provides the ability to assign specific start up views for the General
Hours (bptmm1111m200) session based on the User Login code for the
application. This starts the General Hours (bptmm1111m200) session in the
specified default view and for the default transaction type that employee
generally enters hours against.
The User Profile also allows specifying default information for the user login such
as Cost Components, Working Time Schedule, etc that will default to the hours
entry in the General Hours (bptmm1111m200) session.
7-12
7 People
Field Description
Startup Session Determines the default Hours Entry session to display
for the user when the Hours and Expenses
(bptmm1800m000) session is opened
Startup View Determines the key field sort sequence for the data
when the Hours and Expenses (bptmm1800m000)
session opens.
Startup Period Determines the Year and Period displayed as a default
when the Hours and Expenses (bptmm1800m000)
session opens.
7-13
ERP LN 6.1.00 Common Data
Business Example
Jeff Manard works in the service department and reports hours against service
orders. You define a User Profile for Jeff indicating his Startup Session is
Service Orders, and the Startup View is by Order, Year, Period. When Jeff
opens the General Hours (bptmm1111m200) session, he will be viewing Service
Orders by default.
Teams
Teams provide a way to group employees for planning and authorization
purposes. If you also assign roles to a team, all employees assigned to the team
have the authorizations that correspond to the roles.
When entering hours for a team, the hours entered can be distributed among the
team members. You can use this feature to achieve fast and consistent hours
entry for employees working together as a team.
Teams
Field Description
Team User defined code to represent the team
Labor Rate The code representing the Labor rate applying to the
Team.
7-14
7 People
Field Description
Calendar The default calendar for the team.
WTS (Working Time The Working Time Schedule applied to the team. This is
Schedule) optional.
Define a Team
You have several employees working in a single work center. These people are
performing the same duties. You will create a team WC1 to associate with each
employee in the work center.
2. Enter WC1 for the team name and use STD for the labor rate.
The Team WC1 is now created. You can now link employees to the team, and
assign roles to the team. When you enter hours, you can enter team hours and
distribute hours among the team members.
Teams
7-15
ERP LN 6.1.00 Common Data
The Team WC1 now contains two employees. The roles assigned to the Team
will now apply to the two employees.
Employees by Team
7-16
7 People
Roles
Roles specify an employee’s position and the associated authorizations granted
to perform specific processes, or to access specific data.
Once roles are defined, they can be assigned to either employees or teams.
Roles can be attached to an employee in the Roles by Employee
(tcpp0170m000) session accessed from the Specific menu in the Roles
(tcppl0160m000) session. Roles can be assigned to Teams in the Roles by
Team (tcppl0180m000) session accessed from the Specific menu in the Teams
(tcppl0140m000) session.
Roles
Field Description
Role The user defined code representing the role.
Description The user defined description regarding the role.
High Authorization Indicates the role and the employees linked to the role
or team have global action rights and can work on all
objects in Data Management without restrictions
7-17
ERP LN 6.1.00 Common Data
Only a user logged onto the system with Super User rights can assign a role as a
High Authorization role.
Define Roles
Define two new roles to assign to Manufacturing personnel. The new roles will be
MAN1 and MAN-OT.
3. Define the second role MAN-OT and select the High Authorizations check
box.
The new roles are now defined and can be linked to teams or employees.
Roles
7-18
7 People
The two new roles are now applied to the team WC1 and will apply to employee
codes 4545 and 4546.
Roles by Team
Skills
Skills represent specific knowledge or technical expertise a service engineer
needs to carry out Service applications. Service skills can be used as constraints
for planning service orders.
The Skills (tcppl0110m000) session is used to define the skills required and
applied within the Service and Quality Management packages. Once defined,
7-19
ERP LN 6.1.00 Common Data
Skills
Field Description
Rate The default Labor Rate used to record time against this
skill.
Labor Types
Labor Types classify the work and determine whether the work is regular or
overtime labor. Based on the kind of work and the hour type, labor types can be
used to specify surcharges so actual labor costs can be calculated.
The Labor Type (tcppl0130m00) session defines the various labor types and
surcharges for each labor type. Different rates can be applied for the same labor
being performed during regular work hours or for overtime hours. To do so,
define two labor types, one for regular hours and one for overtime.
Surcharges are percentages added for each labor type and must be entered as a
percentage to be recognized. To define a surcharge, from the Specific menu
7-20
7 People
select Labor Type – Surcharge from the Specific menu in the Labor Type
(tcppl0130m000) session.
Labor Rates
7-21
ERP LN 6.1.00 Common Data
Field Description
Labor Rate Code The code used to represent a particular labor type or
rate.
Time Unit The unit of measure used to represent the labor rate
code defined.
General Tasks
General tasks are either Absence or Indirect task types. General tasks only apply
to tasks that are not related to the costs of a specific order or project. General
tasks are used to record hours for employees outside those hours entered
against order transactions.
Hours recorded against a General Task are recorded in the General Hours
(bptmm1111m200) session.
7-22
7 People
General Tasks
Field Description
Task Type A general task is used to record hours that are not
against a project or an order. The two general task types
are:
Absence – Used for illness and appointments away
from work.
Indirect – Also called overhead. Used for
administration and general meetings.
Department The Department linked to the general task. This
department defaults to the General Hours
(bptmm1111m200) session when the task is entered.
Post to Finance Indicates if the costs are posted to the Financial
package for the general task.
7-23
ERP LN 6.1.00 Common Data
General Task
This session defines the codes that represent a working schedule. To this code,
you can link the actual Working Time Schedule defining the start and end times
for the labor as well as the labor rate that is used to record the work. With a
working time schedule, you can distribute hours among a single employee or an
entire team based on the Working Time Schedule Code and the associated
Working Schedule.
7-24
7 People
Field Description
Start Time The beginning time for the schedule time associated
with an individual labor type.
End Time The completion time for the schedule time associated
with an individual labor type.
Labor Type The default labor type used to record the labor for the
schedule time entry.
1. Insert a new record and create the new Working Time Schedule Code MF1.
7-25
ERP LN 6.1.00 Common Data
7-26
7 People
You have just defined that Monday work hours are regular hours from 8:00 a.m
until 5:00 p.m. and overtime is from 5:00pm until 9:00pm. This working time
schedule applies only to schedule code MF1. Repeating this for Tuesday through
Friday for the Working Time Schedule Code MF1 will define the entire week.
Assignments
Assignments are used to specify a list of predetermined tasks for ease of hours
entry for an employee. The employee can retrieve the assignments for a given
period and apply them for hours accounting.
Business Example
For the next month your company is conducting safety training courses for all
shop floor employees. The training sessions occur every Monday from 8:00am to
10:00 am. You can create an assignment and include a General Task for
training, where you specify the recurrence is weekly for two hours and apply the
Labor Rate Code for training. This assignment can be created for each shop floor
employee.
7-27
ERP LN 6.1.00 Common Data
Assignments (Overview)
7-28
7 People
Field Description
Transaction Type The assignment can apply to a specific task type or
order type. The Transaction types available are:
General Tasks
Project
PCS Project
Production
Assembly
Service Order
Depot Repair
For example: If you select Service Order, you will then
fill out the information under the Service Order tab
specifying Service Order specific information regarding
the assignment.
Pattern The frequency the assignment occurs.
Daily
Weekly
Monthly
Yearly
WTS The Working Time Schedule associated with this
assignment determines the hours accounting.
Start Date / End Date Specifies the date range the assignment will span. This
along with the pattern determines how often and the
duration the assignment is valid.
Create an Assignment
Define and assignment to represent a recurring 2 hr. Monday meeting for
employee 4545.
7-29
ERP LN 6.1.00 Common Data
3. Click the Recurrence button and enter the recurrence details for the Monday
meeting.
7-30
7 People
The assignment is now completed and can be applied during hours entry,
7-31
ERP LN 6.1.00 Common Data
Assignments Result
Employee – General
Field Input Value
Employee XX45 (Replace XX with your initials)
Name Jean Jones
Language ENG
Department PUR1
7-32
7 People
Employees – General
Employee-People
Field Input Value
Employee XX45 (Replace XX with your initials)
Address Code ADD0000001
Gender Female
Employment 40.00 hrs
Employee Type Internal
First Employment Date Current Date
7-33
ERP LN 6.1.00 Common Data
Employees – People
General Task
Field Input Value
General Task MT1
Description Department Meeting
Task Type Indirect Task
Department PUR1
7-34
7 People
General Task
Click the Recurrence button and enter the recurrence details for the Monday
meeting.
7-35
ERP LN 6.1.00 Common Data
Assignments
7-36
7 People
Hours Entry
Once you have entered the master data, you can enter hours in one of the
following ways:
In the hours accounting, you can enter hours for a single employee or team. In
the latter case, you can distribute the hours entered among the members of the
team using the Distribute Team Hours option. In the case of a production order,
you can also enter machine hours. Note that although the systems enables fast
entry of general hours and project hours, you cannot use working time
schedules.
The general process for entering hours is to use the Hours and Expenses
(bptmm1800m000) session.
The start session for Hours and Expenses is based on the user login and the
user profile for that user.
To change the Transaction Type for the Hours and Expenses (bptmm1111m200)
session, from the Specific menu select the transaction type desired, such as
production order hours, service order hours, projects, general hours.
Business Example
For an employee that regularly reports hours against production orders, set the
startup session option to Production in the User Profiles (bpmdm0102m000)
session.
7-37
ERP LN 6.1.00 Common Data
General Hours
7-38
7 People
General Hours
Field Description
Employee The employee to enter hours and expenses against.
Year/Period Identifies the period you will enter hours against.
Start Date Beginning date of the period to enter hours.
End Date The ending date of the current period you are entering
hours against.
Employee 4545 Jeff Manton needs to record hours for a team meeting he
attended. Enter the hours for the team meeting.
The new Group Entry for employee 4545 for 2004, period 32 is created
7-39
ERP LN 6.1.00 Common Data
2. Click the New icon and enter the line to record a 1 hour meeting on Monday
and Tuesday.
The new entry for task MT (Department Meeting) for 1 hour Monday and
Tuesday is created.
1. From General Hours click on the Production Orders icon to access the
Production Order Hours (bptmm1120m000) session.
2. Insert the New Group record for employee 4545 for the year and period for
entering the production order.
The new Group Record is created for Employee 4545 for the proper period and
year.
7-40
7 People
3. Click the New icon and enter the details for the Production order time entry.
4. Enter the production order SNB000001 for Operation 10, Task 400.
5. Enter 3 hours for Labor and Machine time for task 400 for the production
order.
The second half of the line entry displays the status of the entry and displays the
hours were entered manually by the user with logon code user2
7-41
ERP LN 6.1.00 Common Data
Enter hours for a general task to record employee 4545 attending a meeting.
7-42
7 People
The globally registered hours are entered. You can view the hours posted for the
employee in the General Hours (bptmm1111m200) session.
7-43
ERP LN 6.1.00 Common Data
Enter 4 hours of meeting attendance for employee XX45 (replace XX with your
initials) using the General Hours (bptmm1111m200) session.
General Hours
7-44
7 People
Assignments
Copy Hours
Start
End
Enter the hours for the team to register attending the 4 hour training session.
2. Insert a New Group record and enter the team code, the year and period then
select the applicable transaction type(s).
7-45
ERP LN 6.1.00 Common Data
Team Hours
7-46
7 People
total or a number of hours for each day, and distribute these hours. If no error
report appears, the distributed team hours line's Hours Distribution Done check
box will be selected. All team members will be able to see the exact number of
hours as entered for the team. Changes can then still be made.
1. Open the session and from the View menu, select Sort by then the option
Team, Year, Period
2. To find your record enter the team code, the year and period then select the
applicable transaction type(s),
3. From the Specific menu select Distribute Team Hours to start the Distribute
Team Hours (bptmm1220m000) session.
4. Enter the Team, Year and Period, and the type of hours to Distribute
(General Task, Project, etc) to select your desired hours.
7-47
ERP LN 6.1.00 Common Data
Each team member then receives an 4-hour line. The team members can edit or
approve these hours.
6. View the Hours for Employee 4545 who is a member of team MN1.
7-48
7 People
Access the Employees by Team session from the Specific Menu from the Teams
session.
Enter 2 hours for the team meeting for team XX1 (Replace XX with your initials)
7-49
ERP LN 6.1.00 Common Data
Hours Entry
Field Input Value
Task TR
Description Training
Cost Component 400
Department CWC1
Labor Type REG
Monday 2 hrs
Enter the Team, Year and Period, and the type of hours to Distribute (General
Task, Project, etc) to select your desired hours.
7-50
7 People
Use Assignments
Assignments are used to enter hours for pre set tasks.
7-51
ERP LN 6.1.00 Common Data
Use Assignments
5. View the hours entered in the Use Assignments for the employee.
7-52
7 People
7-53
ERP LN 6.1.00 Common Data
Use Assignments
7-54
7 People
Note you cannot enter Working Time Schedule Hours for a Project or a General
Task transaction type.
The Working Time Schedule must be defined for the employee in the Employees
– People (bpmdm0101m000) session.
General tab
Field Input Value
Employee 4546
Production Check the check box
WTS MF1
Date Start date Monday of current week, To date Friday of
current week.
Time 8:00 until 17:00
Labor Time 8 hrs
Manufacturing tab
Field Input Value
Production Order SNB000003
7-55
ERP LN 6.1.00 Common Data
2. Click Update and post the hours against the employee according to the
Working Time Schedule.
Copy Hours
Copying hours enables saving time for entering the same hours across multiple
days or periods for an employee or a range of employees.
Copy hours for employee 4545 from year/period 2004/39 to Year/Period 2004/40
for the production hours worked on production order SNB000003.
1. Insert the Source information for the employee 4545 and the Year/Period you
will be copying from.
7-56
7 People
2. Enter the Target employee who will receive the new hours from the copy
function. In this case, enter employee 4545 and the Year/Period 2004/40.
7-57
ERP LN 6.1.00 Common Data
When the copy is complete, you can view the results of the copy of hours in the
Hours and Expenses (bptmm1111m200) session and looking at the Production
Orders display option for employee 4545 and week 40.
7-58
7 People
7-59
ERP LN 6.1.00 Common Data
Hours Check (Regular Time): The employee actual hours are compared with
the employment hours. An error report is generated if the number of hours
worked is less or greater than the Employment Hours.
Approve Transactions: The hours transactions are approved for the selection
range.
Undo Approve Transactions: All transactions within the range that are
approved will be unapproved.
The Process Hours and Expenses (bptmm1203m000) processes and posts the
hours to the financial module. Hours can be processed by individual employee
or by ranges.
Approve Hours
Approve the hours for employee 4545 for the production hours worked in the
Year/Period 2004/40.
7-60
7 People
Process Hours
Process the approved hours for employee 4545.
The hours are processed and are now posted to the financial module.
7-61
ERP LN 6.1.00 Common Data
Lesson Review
In this lesson you learned to:
7-62
7 People
Review Questions
1. The use of Approvals for Hours Accounting is required when using the
People package.
A. True
B. False
A. True
B. False
3. The Hours and Expenses session can be modified within the User Profile to
enable customized startup views based on the user.
A. True
B. False
4. In the Assignments session you can specify particular tasks and the interval
in which they occur.
A. True
B. False
7-63
ERP LN 6.1.00 Common Data
3. A (True: the User Profile determines the start view for the Hours and
Expenses session and can be modified for each user)
7-64