Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 3 Create a Master Material Record for a Trading Good Next we start the processing steps that are involved in a purchasing transaction. For

Task 3 Create a Master Material Record for a Trading Good

Next we start the processing steps that are involved in a purchasing transaction. For the example that we use, the company is going to order a good that is not presently part of our inventory. In addition, we have not previously purchased goods from the vendor that we selected to supply the good. That means that we have to create a master record for the material and a master record for the vendor.

Remember, as discussed previously, these steps are typically completed by more than one person so that proper segregation of duties is maintained.

The material master record contains all the data required to define and manage a material. In SAP this is formally part of the Materials Management (MM) module. However, some important accounting information is also contained within this record. For example, product cost and pricing information and also tax information are contained within the material master record.

The master record consists of individual views and the individual views are presented in the form of tabbed pages. These views are organized on a functional or departmental basis. Each department has its own view that permits easy access and maintenance. In other words, data is integrated from engineering, manufacturing, sales and distribution, purchasing, accounting and other departments. This master data is used as a source of data for purchase order processing throughout the procurement cycle. For simplicity, we are ordering a finished good that we will subsequently sell. Just a reminder: When you see an XX enter your assigned SAP number.

Create a Material Master record for a Finished Product

Logistics Materials Management Material Master Material Create (Special) Trading Goods (MMH1)

Create Trading Goods: Initial Screen

Field

Input

Material (Number)

OLHTXX

Industry Sector

Retail

Click on the Select Views button on the application tool bar

Select the following views:

Basic Data 1

Purchasing

General Plant Data/Storage 1

Accounting 1

Click on Continue (Enter)

Organization Level pop-up window

Field

Input

Plant

DLXX (Dallas)

Storage Location

TGXX (Trading Goods)

Click on Enter

Basic Data 1(screen):

Field

Input

Material description (This is the field to the right of the material number.)

Special Edition Olympic Helmet XX

Base Unit of Measure

EA

Material Group

SFTY

Gross Weight

8

Weight Unit

OZ

Net Weight

9

Click on Enter

You should receive an error message regarding net weight.

3.1 What type of application control is used on the field Net Weight?

ENTER YOUR ANSWER IN BLACKBOARD

3.2 What type of application control is used on the field Base Unit of Measure?

ENTER YOUR ANSWER IN BLACKBOARD

Change the net weight to 8.

Click on Enter

Purchasing:

Field

Input

Purchasing Group

NXX

Click on Enter

Plant Data/Storage 1

No information is needed here.

Click on Enter

Accounting 1:

Field

Input

Valuation class

3100 (trading goods)

Price Control

S (stanadard price=S, moving average=V)

Moving Price

32

Standard Price

30

The SAP terminology is a little confusing in this part of the process. What we would normally term cost, they term price. That is, by their terminology, price (not cost) is what we paid for the good.

Click on Enter

Click on Yes when asked to Save

ENTER YOUR ANSWER IN BLACKBOARD

Write down the message on the status bar.

Task 4 Create a Vendor Master Record

We will buy our trading good from this vendor.

Logistics Materials Management Purchasing Master Data Vendor Central Create (XK01)

Create Vendor: Initial Screen

Field

Input

Vendor

VendorXX

Company code

USXX

Purchasing organization

USXX

Account group

LIEF

Click on Enter

Create Vendor: Address

Field

Input

Title

Company

Name

Your last name XX

Search term 1/2

XX

Street/house number

Glenn 304

Postal code/City

95929 Chico

Country

US

Region

CA

Language

English

As an experiment, enter the time zone EST.

(Note: You may need to expand the street address to see all the above fields.)

Click Next Screen or Enter to go to next view

Note the error and then change the time zone back to the correct value of PST and click the enter icon.

ENTER YOUR ANSWER IN BLACKBOARD

4.1 What application control was applied on the field "Time Zone", that caused the system to know that your entry was wrong? (Name the application control method)

Create Vendor: Control

No Information needs to be entered

Click Next Screen or Enter

Create Vendor: Payment Transactions

No Information needs to be entered

Click Next Screen or Enter

Create Vendor Contact Persons

Enter your name as the contact name.

Click Next Screen or Enter

Create Vendor: Accounting Information Accounting

Field

Input

Rec. Account

300000 (payables trade accounts)

Sort Key

001 (posting date)

Cash mgmnt group

A1 (domestic pmt.)

4.2 The "Reconciliation Account" is very important, as it links each vendor's subsidiary ledger to the general ledger so that the sum of the subledgers will equal exactly the total in the General Ledger.

This is a GREAT internal control mechanism! How would classify this control? (Hint: Chapter 7 Control Plans)

ENTER YOUR ANSWER IN BLACKBOARD

Click Next Screen or Enter to go to the next view

Create Vendor: Payment Transactions Accounting

Field

Input

Payt Terms (payment terms)

0001 (payable immediately)

Tolerance group (in payment terms)

GBI

4.3 This tolerance group is used to reduce the risk of an expensive fraud. What type of application control is tolerance group?

Hint: Create an additional session (SystemCreate Session) and look at transaction code SPRO

Select: SAP Reference IMG

Expand: Financial Accounting

Select: Financial Accounting Global Settings

Expand and select: Document

Expand and select: Tolerance Groups

Select the green check mark next to: Define Tolerance Groups for Users

Highlight your company code and then select details

ENTER YOUR ANSWER IN BLACKBOARD.

Click Next Screen

Create Vendor: Correspondence Accounting

No information needs to be entered

Click Next Screen

Create Vendor: Purchasing Data

Field

Input

Order currency

USD

Terms of Paymnt

0001

4.4Based on the payment terms, when is our payment due to this vendor? (Hint: use F4 search)

ENTER YOUR ANSWER IN BLACKBOARD

Click Next Screen

Create Vendor: Partner Function

No information needs to be entered

Click on Save .

ENTER YOUR ANSWER IN BLACKBOARD

Write down the message on the status bar.

Task 5 Create an Information Record for the Vendor/Material

The creation of a material and a vendor will allow us to order those goods from that vendor. However, as an additional control, we can define the relationship between the good and the vendor. In SAP this is done by creating an information record. That is the next step in the process.

Create an Information record for Vendor/Material

Logistics Materials Management Purchasing Master Data Info Record Create (ME11)

Create Info Record: Initial Screen

Field

Input

Vendor

VendorXX

Material

OLHTXX

Purchasing Org.

USXX

Plant

DLXX

Click on Enter

Create Info Record: General Data

Click on Purch. Org. data 1

Create Info Record: Purch. Org. data 1

Field

Input

Pl.Deliv.Time

2 (days)

Purch. group

NXX

Standard qty.

10

Minimum qty

5

Net price

30

The above data defines the relationship between the material and the vendor.

Click Save .

Write down the Information Record number shown on the status bar. ______________________

Task 6 Check Status of Various Accounts

The power of an ERP system is that the business transactions are simultaneously recorded in all of the affected areas of the business in real time. In order to understand this, we want you to determine which accounts should be affected by the transactions that follow. In this case the following accounts should be checked:

Check inventory in materials management

Check inventory in the general ledger

Check cash in the general ledger

Check accounts payable in the general ledger

Check goods received/invoice received account in the general ledger

Check accounts payable in the subsidiary ledger

These checks should be done after each step of the transaction. I would suggest that you open a series of SAP sessions to do this checking and then refresh the screen after each business transaction task.

Check the status of various accounts

- Check MM inventory: Transaction: MMBE, (Stock Overview)

Be sure to check the detailed status report to see important changes to inventory. Double click on your material or scroll to the right to see all fields in the inventory inquiry screen.

- Check GL Cash, GL Inventory, GL AP and Goods Received/Invoice Received: Transaction: S_ALR_87012291, (Line Item Journal) or S_ALR_87012284, (Financial Statements)

The company code is USXX and use todays date (or the date of transaction) as the posting date

- Check A/P sub-ledger: Transaction: FBL1N (Vendor Line Item Display)

Check your values for each of these accounts after each step noted.

*** I will be only grading the ending balances, but using this table will help you find any errors you make as you move through the project. ***

MM Inventory Quantity

GL Inventory

GL Cash

GL A/P

GR/IR

Vendor Subledger

After task 5

0

$0

$0

$0

$0

$0

After task 7

0

$0

$0

$0

$0

$0

After task 9

50

$1500

$0

$0

($1500)

$0

After task 11

50

$1500

$0

($1500)

$1500

($1500)

After task13

50

$1500

($1500)

$1500

$0

$1500

LOOK->> Note: on some of the above transactions if there is no value in the account, you may get an error message when trying to display the balance. This is normal and simply means that the balance in the account is zero.

Task 7 Create a Purchase Order to Buy the Trading Good

Now that the master data has been entered into the system, we are ready to process a purchasing transaction.

Create a Purchase Order

Logistics Materials Management Purchasing Purchase Order Create Vendor/Supplying Plant Known (ME21N)

Create Purchase Order

Field

Input

(Field will be defaulted)

Standard purchase order

Vendor

VendorXX

Document date

Today date

Note: If the screen looks like the following, click on Header and Item Overview icons to expand those areas.

When you expand your view, an error message will tell you to enter the organizational data and redirect you to the Org. Data page.

If you are not redirected to the org. data page, click on the Org. Data tab page, enter the following data:

Field

Input

Purchasing org.

USXX

Purchasing group

NXX

Company code

USXX

Click Enter .

Hint: If you get an error message regarding the purchasing group, hit Enter again and enter the data for the purchasing group.

Item overview area

Field

Data

Material

OLHTXX

P.O. Quantity

50

Delivery date

Todays date

Plant

DLXX

Storage location

TGXX

Click Enter .

ENTER ANSWER IN BLACKBOARD

7.1 When you click on enter, the price is automatically filled in on the purchase order. In what Task did you define this data? (See task ## listed on page 3..) What type of application control is being used here?

ENTER YOUR ANSWER IN BLACKBOARD

7.2 Note the warning at the bottom of the screen regarding the delivery date. What kind of application control is this warning?

Click Save . Write down the purchase order number ___________________.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

Students also viewed these Databases questions

Question

finding entry-level positions;

Answered: 1 week ago