Accounting HW

zon5008

sp15_classic_rocker_exercises.pdf

Home >Business & Finance homework help >Accounting homework help >Accounting HW

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Classic Rockers Case

Student Exercises (MM, PP, SD, FI/CO)

Classic Rockers Case: Processing Transactions through the

Logistics and Support Processes of SAP with an Emphasis on Internal Control

Ronny Daigle Fawzi Noman Ross Quarles

Version 1.0

6/1/2013

Sam Houston State University Huntsville, Texas

Acknowledgements: The authors thank Kimberly Omura, Chris McMillan and Matt Williams for helpful edits of this case.

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Chapter 2: Procurement Logistics (MM)

EXERCISE MM01: CREATE GENERAL LEDGER RECONCILIATION ACCOUNT (ACCOUNTS PAYABLE) A sub ledger account is used wherever there is a high volume of transactions. The information is summarized for the general ledger into a reconciliation account. The sub ledger can be an Accounts Receivable or Accounts Payable account. The reconciliation account for Accounts Payable must be set up before business can be carried out with vendors.

Accounting  Financial Accounting  General Ledger  Master Records  G/L

Accounts  Individual Processing  Centrally Enter the following information:

1. G/L Account: 30000_ _ _

2. Company Code: Classic Rockers, Inc. Value: ______________

 (CREATE)

Type/Description TAB

3. Account Group: Reconciliation Accounts

4. Select Balance sheet account

5. Short Text: AP Recon_ _ _

6. G/L Acct Long Text: Accounts Payable Reconciliation_ _ _

Control Data TAB

7. Account currency: United States Dollar Value: ______________

8. Recon. account for acct type: Vendors

Create/bank/interest TAB

9. Field status group: Reconciliation accounts Value: ______________

 (SAVE)

 Back to the SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM02: CREATE VENDOR MASTER ACCOUNTING RECORDS You keep track of permanent data as Master Records in the SAP R/3 System.

Accounting  Financial Accounting  Accounts Payable  Master Records  Create

1. Vendor: Leave blank 2. Company Code: Classic Rockers, Inc. Value: ______________ 3. Account group: Vendor (int. number assgnmnt) Value: ______________

4. If any entry is displayed in the Reference field – REMOVE IT

 (ENTER)

5. Name: Turned Spindles, Inc._ _ _ 6. Search term: ______________ (your own creation, such as your user number) 7. Postal Code: ______________ (your own creation) 8. City: ______________ (your own creation) 9. Country: USA Value: ______________ 10. Region: Texas Value: ______________ 11. Language: English

12. Click on the More Fields button (located on the right side) of the Street Address section. 13. Tax Jurisdictn: TX0000000

 (ENTER)

Note: Page forward past views that are not needed using page forward icon

Control N/A

Payment transactions N/A

Accounting information Accounting 14. Recon. account: Your Accounts Payable Recon. Account Value: ______________

Payment transactions Accounting 15. Payt Terms: Payable immediately Due net Value: ______________

16. Chk double inv.:  Chk double inv. Correspondence Accounting N/A

 (SAVE)

17. Record the account (Vendor) no.___________________________

You may need to hit the enter key more than once to get to the next field you wish to fill. This depends on the screen layout, your font size and the size of your monitor.

 Back twice to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM03: CREATE VENDOR MASTER PURCHASING RECORDS This exercise creates the purchasing views for the previously created vendor.

Logistics  Materials Management  Purchasing  Master Data  Vendor 

Purchasing  Create Create a purchasing view for your Turned Spindles, Inc._ _ _ vendor.

1. Vendor: Turned Spindles, Inc._ _ _ Value: ______________

2. PurchasingOrganization: CRPurchasing Dept. Value: ______________

3. Account group: Vendor (int. number assgnmnt) Value: ______________

 (ENTER)

4. Order currency: United States Dollar Value: ______________

5. Terms of paymnt: Payable immediately Due net Value: ______________

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM04: CREATE VENDOR MASTER RECORDS CENTRALLY This exercise demonstrates creating all the views for a vendor at one time, as opposed to creating certain views at specific points in time, such as in MM02 and MM03.

Logistics  Materials Management  Purchasing  Master Data  Vendor  Central

 Create Create all views for a new vendor called Happy Bottoms_ _ _.

1. Leave vendor field blank (system will generate the new number, just as it did in MM02) 2. Company Code: Classic Rockers, Inc. Value: ______________ 3. PurchasingOrganization: CRPurchasing Dept. Value: ______________ 4. Account group: Vendor (int. number assgnmnt) Value: ______________

 (ENTER) 5. Enter the vendor’s name Happy Bottoms_ _ _ 6. Search term: ______________ (your creation, such as your user number) 7. Postal code: ______________ (your creation) 8. City: ______________ (your creation) 9. Country: USA Value: ______________ 10. Region: Texas Value: ______________

11. Click on the More Fields button (located on the right side) of the Street Address section. 12. Tax Jurisdictn: TX0000000 13. Language: English

 (ENTER)

Note: Page forward past views that are not needed using page forward icon Control N/A Payment transactions N/A Accounting information Accounting

14. Recon. account: Your Accounts Payable Reconciliation Value: ______________ Payment transactions Accounting

15. Payt Terms: Payable immediately Due net Value: ______________

16. Chk double inv.:  Chk double inv. Correspondence Accounting N/A Purchasing data

17. Order currency: United States Dollar Value: ______________ 18. Terms of paymnt: Payable immediately Due net Value: ______________

 (SAVE) 19. Record Account (Vendor) #__________________

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM05: CREATE MATERIAL MASTER FOR RAW MATERIALS This will register the raw materials in the system. Each function has specific views that contain relevant data.

READ ENTIRE EXERCISE BEFORE STARTING YOUR INPUT.

Logistics  Materials Management  Material Master  Material  Create (Special)  Raw Material

Enter the following information using the information from the list below:

1. Industry sector Retail

Defaults Industry Sector Industry sector: Retail

 (ENTER)

Defaults Views

2. Select the following views: (click on the small box on the left end of the line item) Basic Data 1

Purchasing General Plant Data / Storage 1 Accounting 1 Costing 1

3. Select  Create views selected

 (ENTER)

Defaults Organizational Levels

4. Enter Plant Classic Rockers Manufacture Pt in both the Plant field and the “Copy from”

field.

5. Leave Stor. Location blank (storage locations to be created automatically)

 (ENTER)

Continued on next page

Top Menu Bar

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

6. The following steps refer to data from the table shown after the last step

a. Insert material name from table below

b. Press button to bring up the Basic Data 1 view

c. Insert information below for the material in the Basic Data 1 view

 (ENTER)

d. Insert information below for the material in the Purchasing view

 (ENTER)

 (ENTER) To bypass the General Plant Data / Storage 1 view (no entries required)

e. Insert information below for the material in the Accounting 1 view

 (ENTER)

f. Insert information below for the material in the Costing 1 view

 (SAVE) [You will be taken to the Create Raw Materials Initial Screen]

Tabs => Basic Data 1 Purchasing Accounting 1 Costing 1

M a te

ri a l

(n a m

e )

D e s c

ri p

ti o

B a s e U

n it

o f

M e a s u

M a te

ri a l

G ro

u p

G ro

s s

W e ig

h t

N e t

W e

ig h

W e ig

h t

u n

P u

rc h

a s in

G ro

u p

V a lu

a ti

o n

C la

s s

M o

v in

p ri

c e

W it

h Q

S tr

u c tu

M a te

ri a l

o ri

g in

Wood Kit_ _ _ Wood Kit_ _ _ each

Raw & Op Supp

25 25 US

pound CRPurchasing

Group 3000 $35.00 X X

 Back to SAP Easy Access Menu

DATA

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM06: CREATE MATERIAL MASTER FOR TRADING GOODS This will register the trading goods in the system. Each function has specific views that contain relevant data.

READ ENTIRE EXERCISE BEFORE STARTING YOUR INPUT.

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

Enter the following information using the information from the list below:

1. Industry sector Retail

Defaults Industry Sector Industry sector: Retail

 (ENTER)

Defaults Views

2. Select ONLY the following views: Basic Data 1 Purchasing

General Plant Data / Storage 1 Accounting 1 Costing 1

3. Select Create views selected

 (ENTER)

Defaults Organizational Levels

4. Enter Plant Classic Rockers Manufacture Pt in both the Plant field and the “Copy from” field

5. Leave Stor. Location blank (storage locations to be created automatically)

 (ENTER)

Continued on next page

Top Menu Bar

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

6. The following steps refer to data from the table shown after the last step

a. Insert material name from table below

b. Press button to bring up the Basic Data 1 view

c. Insert information in the table for the material in the Basic Data 1 view

 (ENTER)

d. Insert information in the table for the material in the Purchasing view

 (ENTER)

 (ENTER) To bypass the General Plant Data / Storage 1 view (no entries required)

e. Insert information in the table for the material in the Accounting 1 view

 (ENTER)

f. Insert information below for the material in the Costing 1 view

 (SAVE) [You will be taken to the Create Trading Goods Initial Screen]

Tabs => Basic Data 1 Purchasing Accounting 1 Costing 1

M a te

ri a l

(n a m

e )

D e s c

ri p

ti o

B a s e U

n it

o f

M e a s u

M a te

ri a l

G ro

u p

G ro

s s

W e ig

h t

N e t

W e

ig h

W e ig

h t

u n

P u

rc h

a s in

G ro

u p

V a lu

a ti

o n

C la

s s

M o

v in

P ri

c e

W it

h Q

S tr

u c tu

M a te

ri a l

o ri

g in

Cushion_ _ _ Cushion_ _ _ each

Trading &

Finished 4 4

US pound

CRPurchasing Group

3100 $ 15.00 X X

 Back to SAP Easy Access Menu

DATA

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM07: CREATE MATERIAL MASTER FOR FINISHED PRODUCTS This will register the finished products in the system. Each function has specific views that contain relevant data. The steps for adding the Material Master for finished products mirrors those for adding raw materials and trading goods performed in the previous two exercises. The basic process involves setting the Industry Sector, the Default Views, the Organizational Level, and inputting the data in the required tabs. You will, of course, be dealing with finished products rather that the other two types of materials. Use the previous two exercises as guides to set up the appropriate views, sectors, levels, and for inputting the data below. NOTE: the prices of finished goods are STANDARD prices (not moving average, which is the type of price for both raw materials and trading goods in the two previous exercises).

Logistics  Materials Management  Material Master  Material  Create (Special)  Finished Product Enter the following information: 1. Material: from table below

2. Industry sector: Retail

 (ENTER)

3. Select the following views: (Deselect any others that may be showing) Basic Data 1 Accounting 1

Costing 1

 (ENTER)

4. When the Organizational levels screen appears, press to bypass

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

5. Enter the information from the table below on the views selected

Tabs => Basic Data 1 Accounting 1 Costing 1

M a te

ri a l (n

a m

e )

D e s c

ri p

ti o

B a s e U

n it

o f

M e a s u

M a te

ri a l G

ro u

G ro

s s

W e ig

h t

N e t

W e

ig h

W e ig

h t

u n

V a lu

a ti

o n

C la

s s

S ta

n d

a rd

P ri

c e

W it

h Q

S tr

u c tu

M a te

ri a l o

ri g

Rocker_ _ _ Rocker_ _ _ each Trading

& Finished

30 30 US pound 7920 $140.00 X X

 SAVE when all data above is entered on the appropriate screen

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM08: CREATE PURCHASING INFO RECORDS These records reflect a relationship between a specific vendor and a material. When the material is being ordered, the vendor to supply that material will automatically be determined because of the established relationship (and resulting master record).

Logistics  Materials Management  Purchasing  Master Data  Info Record  Create

Enter the following information:

1. Vendor: Happy Bottoms_ _ _ Value: ______________

2. Material: Material name from table below (use drop down to find)

3. Purchasing Org.: CRPurchasing Dept. Value: ______________

4. Plant: Classic Rockers Manufacture Pt Value: ______________

5. Info category: Standard

 (ENTER)

6. Select then input data for that material

7. Repeat until all material records in table are created (after each save you will be returned to the Create Info Record Initial Screen where you input the next material name and related data

Material Pl. Deliv. Time Standard Qty Net Price

Cushion_ _ _ 1 1 $ 15.00 Save

Wood Kit_ _ _ 1 1 $ 35.00 Save

(SAVE after each material as indicated)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM09: CREATE PURCHASE REQUISITION FOR STOCK ITEMS Create a request for an initial supply of stock items.

Logistics  Materials Management  Purchasing  Purchase Requisition  Create Do not be concerned if the left panel on the screen gives an error message such “This program cannot display the webpage.” This will not interfere with the completion of this exercise.

If the Item overview section is not expanded, click on the icon to left of Item Overview to expand the section of the screen. Enter the following information in the Item Overview Screen

1. Requisition all Raw Materials and Trading Goods

 (ENTER) 2. Review the information pulled from the Master Data. If receiving a message at the bottom of

the screen regarding as to whether the delivery date can be met, ignore it and proceed with

the exercise.

Continued on next page

Material Quantity Delivery Date Stor. Loc.

Cushion_ _ _ 1000 (Future date,

such as a week from today)

Shipping

Wood Kit_ _ _ 1000 (Future date,

such as a week from today)

Warehouse

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

3. PRINT THE SCREEN (IF REQUIRED BY YOUR

INSTRUCTOR)

 (SAVE)

4. Record the new purchase requisition number.____________________

 BACK TO SAP EASY ACCESS MENU.

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM10: CREATE PURCHASE ORDER Accept the requisition to order populate the stock items.

Logistics  Materials Management  Purchasing  Purchase Order  Create  Vendor Unknown

1. Order Type: Standard PO Value: ______________ 2. Purchasing Group: CRPurchasing Group Value: ______________

3. Select 4. Enter your Reference purchase requisition number.

 (ENTER)

5. Click on the green select all button.

6. Click on the button to copy the details from the purchase requisition into your new purchase order

7. Verify material prices through each item – prices should agree with those entered in MM05 and MM06

8. Click on the green select all button 9. Select

o If a warning about existing sources will be lost appears, click on (ENTER)

10. Click on the green select all button

 (GENERATE)

11. If asked if delivery date can be met, click enter to bypass

12. If Header Panel is not visible, click on to open display

13. On Header panel, click on conditions tab

14. Record the order Net Value ________________________

 (SAVE)

15. Save anyway past the error message indicating that there are system messages (click on SAVE on error message). This message appears because no output devices (i.e. Printer, FAX) were found to communicate this PO to the vendor.

16. If asked about creating a new PO or adding to an existing PO, create a new PO!

17. Record the new purchase order number_________________________

 back to SAP Easy Access menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM11: CREATE A GOODS RECEIPT Receive the stock items into inventory and record a temporary liability before the vendor invoice is received.

Logistics  Materials Management  Inventory Management  Goods Movement 

Goods Receipt  For Purchase Order  PO Number Known Enter the following information:

Settings  Default Values

1. Select Propose the OK Function in Future

2. Select Propose All Items

3. Click to accept these values

 Click to bypass any information messages if received

4. Enter the PO number from MM10 in the field to the right of Purchase order and click . Your PO number should appear and turn red on the left column.

 (EXECUTE)

 Select or (SAVE)

5. Record the material document number_______________________

 back to SAP Easy Access menu

6. Make the following selections (in comparison to the selections made at the beginning of this exercise, you have already selected the selections highlighted in red):

Logistics  Materials Management  Inventory Management  Material Document  Display

7. If not already entered, enter your Material Doc. Number from step #5

8. Click The screen shows a detail of your material receipt. Note the reference to your PO number on the screen.

Continued on next page

Top Menu Bar

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

9. Click .

The resulting screen shows the accounting document view of the transaction just recorded. Note the positive entries (debits) to inventory accounts and similar negative entries (credits) to account 31000000 – GR/IR-000. The total of the debits (credits) should equal the amount entered for step 14 of MM10. Compare and make sure they agree. Account 31000000 is for “Goods Receipt/Invoice Receipt”. This is a temporary liability account that accrues a liability at the time goods are received, as opposed to recording the liability when the invoice is received (see MM12). The GR/IR account is useful at this point for three reasons. First, the GR/IR account allows the inventory liability to be recorded in the accounting records in a more timely manner, as opposed to waiting until the invoice is received. The invoice may accompany the inventory and then forwarded to the accounts payable function in accounting, which may be located at a different physical location than where the inventory is received (especially in organizations that use SAP). Alternatively, the invoice may be sent to the corporate location for accounting while the inventory is sent to an operational location. While the use of a GR/IR account weakens the strength of using the invoice to accurately record the amount of the liability, a properly designed ERP system should allow accurate liabilities to be recorded at the time of receiving based on the accuracy of purchase order prices. Second, the GR/IR account allows inventory to be immediately recorded – thereby maintaining an effective audit trail (i.e., control) over inventory. The failure to record inventory received in a timely manner can increase the risk of loss or theft. Third, the GR/IR account allows other processes such as production (PP) and sales and distribution (SD) to operate more effectively and efficiently by not hindering their activities. As will be seen in the PP and SD tutorials, these inventory items will be respectively used in production and/or sold to customers. Entering the inventory into the system at the actual time of receipt allows those processes to be more efficient and effective. The use of a GR/IR account is therefore an operational control at the time of inventory receipt. In Exercise MM12, you will record the actual vendor invoice for the goods received, reclassifying the liability from this temporary account into your accounts payable reconciliation account.

10. Click . The resulting view is slightly different, showing the general ledger view of your accounting document and the entry made.

11. Click .

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Note that the popup screen identifies your user name as the one who entered this transaction. With this reference as well as other references such as the PO number (see step 8), SAP appears to have a good audit trail of transactions processed.

12. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR) (FIRST MOVE THE POP UP SCREEN TO THE BOTTOM SO THE SCREEN BEHIND CAN BE VIEWED IN YOUR SCREEN CAPTURE, AS WELL)

13. Click

14. back twice to SAP Easy Access menuInstructor note: Check T169P (OMRL) & T169V (SM30)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE MM12: CREATE AN INVOICE RECEIPT Enter the Vendor invoice for the stock item order and reclassify the temporary liability recorded in MM11 to your accounts payable reconciliation account.

Logistics  Materials Management  Logistics Invoice Verification  Document Entry

 Enter Invoice

Enter the following information:

1. Invoice date: Today's date

2. Reference: 567 (the invoice # from the physical invoice shown above)

3. Amount: 50000 (from the physical invoice shown above)

4. Currency (the field to

the right of Amount): United States Dollar Value: ______________

5. Company Code: Classic Rockers, Inc. Value: ______________

6. PO number: Your purchase order number from exercise MM10

(PO # input in Purchase Order/Scheduling Agreement in middle of screen)

 (ENTER)

Your resulting screen shows information from your purchase order created in MM10

7. Tax code: XI()

 (ENTER)

Continued on next page

INVOICE #567 7/16/2013 Happy Bottoms_ _ _ ITEMS: QUANTITY PER PRICE:

CUSHION_ _ _ 1,000 $ 15.00 $ 15,000.00 WOOD KIT_ _ _ 1,000 $ 35.00 $ 35,000.00 TOTAL $ 50,000.00

Thank you for your order

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

8. Use the button to see if the postings are correct

Your resulting popup screen shows the line detail of the invoice being entered. Specifically note the G/L column. The first line refers to your accounts payable reconciliation account linked to this vendor. The amount shown on that line is negative, indicating a credit to your accounts payable reconciliation account. The other two lines are to the Goods Receipt/Invoice Receipt account, which is referred to in MM11. In that exercise you credited this account to accrue a temporary liability at the time goods were received. In this exercise, you debit this account to remove the temporary liability and reclassify it to your accounts payable reconciliation account and record the payable within the accounts payable subsidiary records. In this entry, one line is the reclassification of the temporary liability for Cushions and the other is for Wood Kits. Further note that the purchase order number is shown to the right of reclassified amounts. SAP provides an audit trail linking the purchase order to the recording of the invoice.

9. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

 (POST)

10. Record the document number________________

 back to SAP Easy Access menu

11. Click to close the “branches” of the “tree” to return to the basic menu view

12. Make the following selections:

Accounting  Financial Accounting  General Ledger  Account  Display Balances

13. Enter the account number of your accounts payable reconciliation account in the first field to the right of Account Number

14. Click to execute

15. The resulting screen shows a credit in the amount of your invoice to your account during the current month. Double-click that line.

16. On the resulting G/L Account Line Item Display screen, double-click on one of the items of the transaction, such as document number, document date or amount

The resulting pop-up screen provides detail about this part of the entry made by you. Scroll to the bottom of the pop-up screen. Note your user name as the one who recorded the entry. After scrolling, your screen should look like that on the next page. Again, SAP provides an audit trail for this transaction processed.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

17. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

18. Click

19. back three times to SAP Easy Access menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Chapter 4: Sales Logistics (SD)

EXERCISE SD01: CREATE GENERAL LEDGER RECONCILIATION ACCOUNTS (ACCOUNTS RECEIVABLE) A sub ledger account is used wherever there is a high volume of transactions. The information is summarized for the general ledger into a reconciliation account.

Accounting  Financial Accounting  General Ledger  Master Records  G/L

Accounts  Individual Processing  Centrally Enter the following information:

1. G/L Account: 11000_ _ _

2. Company Code: Classic Rockers, Inc. Value: ______________

 (CREATE)

Type/Description TAB

3. Account Group: Reconciliation Accounts

4. Select Balance sheet account

5. Short Text: AR Recon_ _ _

6. G/L Acct Long Text: Accounts Receivable Reconciliation _ _ _

Control Data TAB

7. Account currency: United States Dollar Value: ______________

8. Recon. acct for acct type: Customers

Create/bank/interest TAB

9. Field status group: Reconciliation accounts Value: ______________

 (SAVE)

 Back to the SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD02: CREATE CUSTOMER We have already created business partners (Vendors) in both FI and MM. Since we are in SD territory now, we will create general and sales views for the customer. Remember when we created vendors centrally in MM04? Here the same function is named Complete, indicating that we would include not only the Sales and Distribution views, but the Materials Management and Financial views, as well.

Logistics  Sales and Distribution  Master Data  Business Partner  Customer 

Create  Complete The table below shows three customers – you will create a master record for each. Perform this ENTIRE exercise (all 37 steps) for EACH customer, ONE customer at a time. Enter the following information: 1. Account group: Sold-to party

2. Customer: leave blank

3. Company code: Classic Rockers, Inc. Value: ______________

4. Sales Organization: Classic Rockers Value: ______________

5. Distribution Channel: as listed in the table below for each customer – begin this

exercise by entering for the first customer listed

6. Division: Standard Value: ______________

 (ENTER)

We will create the following customers:

 Old Tyme Furniture HQ_ _ _ Sarasota, FL Dist.Ch: Direct

 Sunny Porch Pastimes_ _ _ Sunnyland, AZ Dist.Ch: Direct

 Stephanie’s Designs_ _ _ Conroe, TX Dist.Ch: Wholesale

Address:

7. Name: Customer’s name (see list in table above)

8. Search term: Enter a term unique to your group (your creation, such as your

user number)

9. Postal Code: Customer’s zip code (your creation)

10. City: Customer’s city (from table above)

11. Country: USA Value: ______________

12. Region: Customer's State (from table above) Value: ______________

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

13. Click on the More Fields button located to the right side of the Street Address section. 14. Transportation zone: Enter appropriate Transportation zone, based on comparison of

customer’s state with zone choices – use drop down to display choices (the value entered is used for route determination)

15. Tax Jurisdictn: _ _0000000 (State code plus 7 zeroes)

16. Language: English

17. Select

Account Management:

18. Recon. account: Your A/R Reconciliation Account Value: ______________

19. Sort key: Posting date Value: ______________

Payment Transactions:

20. Terms of payment: Payable immediately Due net Value: ______________

21. Select

Sales:

22. Sales Office: Enter a representative Sales Office (use drop down to display)

23. Sales Group: Enter a representative Sales Group (use drop down to display)

24. Currency: United States Dollar Value: ______________

25. Cust. pric. proc.: Standard Value: ______________

26. Cust. Stats. Grp: ‘A’ Material Value: ______________

(This field helps determine which data are updated in the Logistics Information System)

Shipping:

27. Delivery Priority: Normal item Value: ______________

28. Check Order Combination

29. Shipping Conditions: standard Value: ______________

used for both shipping point determination and route determination

30. Delivering Plant: Classic Rockers Manufacture Pt Value: ______________

used for shipping point determination

31. Max.partial deliveries: 9 (default)

Billing Documents:

32. Incoterms: Free on board Value: ______________

33. Description field to the right: Receiving Dock

34. Terms of payment Payable immediately Due net Value: ______________

35. Acct assgmt group: Domestic Revenues Value: ______________

36. Tax classification: Exempt (for each category) Value: ______________

 (SAVE)

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

37. Repeat steps 1-36 for each of the new customers and record the customer numbers of the new customers

NOTE: When you start Stephanie’s Designs be sure to change the distribution channel to the appropriate code

Old Tyme Furniture HQ ________________

Sunny Porch Pastimes ________________

Stephanie’s Designs ________________

When final customer created, remain on the Create Customer initial screen and turn to the next exercise

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD03: CREATE A GOOD RECIPIENT (SHIP-TO PARTY) Old Tyme Furniture has a distribution center/branch office, where we ship goods. We create a specific “ship-to” customer for this separate address.

Logistics  Sales and Distribution  Master Data  Business Partner  Customer 

Create  Complete Enter the following information: 1. Account group: Goods recipient (hey, it’s different than before)

2. Customer: Leave blank

3. Company code: Classic Rockers, Inc. Value: ______________

4. Sales Organization: Classic Rockers Value: ______________

5. Distribution Channel: Direct (it’s different than before) Value: ______________

6. Division: Standard Value: ______________

 (ENTER) Address tab:

7. Name: Old Tyme Furniture Reg Dist Cntr_ _ _

8. Search term: Enter a term unique to you (your creation, such as your user

number)

9. Postal Code: Customer’s zip code (make one up)

10. City: Las Vegas

11. Country: USA Value: ______________

12. Region: Nevada Value: ______________

13. Transportation zone: Region West Value: ______________

14. Language: English

15. Click on the More Fields button located to the right side of the Street Address section.

16. Tax Jurisdictn: NV0000000

17. Select

Account Management:

18. Recon. account: Accounts Receivable Reconciliation_ _ _Value: ______________

19. Sort key: Posting date Value: ______________

Payment Transactions:

20. Terms of payment: Payable immediately Due net Value: ______________

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

21. Select Shipping:

22. Delivery Priority: Normal Item Value: ______________

23. Check Order Combination

24. Shipping Conditions: standard Value: ______________

for both shipping point & route determination

25. Delivering Plant: Classic Rockers Manufacture Pt Value: ______________

used for shipping point determination

26. Max.partial deliveries: 9 (default)

Billing Documents:

27. Tax classification: Exempt (for each category) Value: ______________

 (SAVE)

28. Record the new “Ship-to” Customer number_________________

 Click on to return to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD04: ASSIGN NEW SHIP-TO PARTY This step will add the newly created ship-to account number to the Partner Functions of the sold-to party. The master customer record for Old Tyme Furniture Headquarters is already set up in your company. Now you have to change the “ship to” data in the master to reflect that items will NOT be shipped to the headquarters but to the regional distribution center in Las Vegas. When you originally set up the headquarters master record, it had to be set up so that all partner functions (sold-to, bill-to, payer, and ship-to) were for the headquarters. Now that the regional distribution center has been set up, all shipments will go there so the Ship-to party must be changed.

Logistics  Sales and Distribution  Master Data  Business Partner  Customer 

Change  Complete Enter the following information: 1. Customer: Old Tyme Furniture HQ_ _ _ Value: ______________

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Division: Standard Value: ______________

 (ENTER)

5. Select (if required)

6. Select tab.

7. On the row for Ship-to party, change the number to the number of your Old Tyme Furniture Reg Dist Cntr_ _ _

 (ENTER) The Old Tyme Furniture Reg Dist Cntr_ _ _ should now show as the Ship-to party for this customer. Your screen should look like that on the next page.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

8. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

 (SAVE)

 to return to SAP Easy Access menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD05: CREATE SALES VIEWS FOR TRADING GOODS The views for all materials in the material group TRADE, already created in an earlier material management exercise, must now be “extended” to include the sales views to make the materials sellable. Additionally, the materials must have sales views created (extended) for:

 The distribution channels where they will be sold: Direct and Wholesale

 All storage locations

Logistics  Sales and Distribution  Master Data  Products  Material 

Trading Goods  Create

Enter the following information:

Defaults Organizational Levels

Copy from…

1. Plant: Classic Rockers Classic Rockers

Manufacturing Pt Manufacturing Pt

2. Sales Org: Classic Rockers Classic Rockers

3. Distr. Channel:* Direct Direct

 (ENTER)

Defaults Views

4. Select only these views: Sales: Sales Org. Data 1

Sales: Sales Org. Data 2

Sales: General/Plant Data

Check

 (ENTER)

Continued on next page

Top Menu Bar

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

5. Create the following Materials:

Cushion_ _ _

Enter material name and select the button.

You will make 2 entries (1 for WH and 1 for DI). Check your work when you are through to ensure that all are correct.

Sales: sales org. 1 View

6. Division: Standard Value: ______________

7. Delivering Plant: Classic Rockers Manufacture Pt Value: ______________ Tax Data (You may need to expand column)

8. Tax Jurisdict. Code: UTXJ Exempt Value: ______________

9. County Sales Tax: UTX2 Exempt Value: ______________

10. City Sales Tax: UTX3 Exempt Value: ______________

 (ENTER)

Sales: sales org. 2 View

11. Matl statistics grp: ‘A’ materials Value: ______________

 (ENTER)

Sales: General/Plant View

12. Trans. Grp: On pallets (for route determination) Value: ______________

13. LoadingGrp: Handcart (for shipping pt determination) Value: ______________

 (SAVE)*

*Remember to change the defaults from Direct to create the Wholesale views for all the materials when you are creating the materials for the Wholesale distribution channel

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD06: CREATE SALES VIEWS FOR FINISHED PRODUCTS

Logistics  Sales and Distribution  Master Data  Products  Material  Other

Material  Create Just as you created sales views for both direct and wholesale Cushion products, you will do so again in this exercise for Rocker. You will perform this exercise twice, once for each channel. 1. Material: Rocker_ _ _

2. Create both Direct and Wholesale Distribution Channels, one at a time

Use the button to switch from Direct to Wholesale after Direct is created or vice versa. The system will tell you if the material is already maintained for either of the distribution channels.

3. Select the button.

Sales: sales org. 1 View

4. Division: Standard Value: ______________

5. Delivering Plant: Classic Rockers Manufacture Pt Value: ______________

Tax Data

6. Tax Jurisdict Code: UTXJ Exempt Value: ______________

7. County Sales Tax: UTX2 Exempt Value: ______________

8. City Sales Tax: UTX3 Exempt Value: ______________

 (ENTER)

Sales: sales org. 2 View

9. Matl statistics grp: ‘A’ materials Value: ______________

 (ENTER)

Sales: General/Plant View

10. Trans. Grp: On pallets (for route determination) Value: ______________

11. LoadingGrp: Handcart (for shipping pt determination) Value: ______________

 (SAVE)*

*Remember to change the defaults from DI to create the WH views (or vice versa) for all the materials

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD07: CREATE MATERIAL PRICES This step creates material prices that any customer would pay, without any considerations or discounts. Prices are defined by Sales Organization and Distribution Channel.

Logistics  Sales and Distribution  Master Data  Conditions  Create

(At new screen) Prices  Material Price Enter the following information:

1. Select (click on) Cnty SOrg. DChl Material ReSt

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Enter the following materials and prices:

 (ENTER)

The system will automatically enter the material descriptions and units of currency and measure

 (SAVE)

5. Click on Material Price

6. Select Cnty SOrg. DChl Material ReSt

7. Sales Organization: Classic Rockers Value: ______________

8. Distribution Channel: Wholesale Value: ______________

9. Enter the following materials and prices:

 (ENTER)

The system will automatically enter the material descriptions and units of currency and measure

 (SAVE)

If you are on the Create Condition Records screen you can remain where you are for the next exercise

Condition type

Material Amount

(for DI)

Price Cushion_ _ _ $ 35.00

Price Rocker_ _ _ $ 140.00

Condition type Material Amount (for WH)

Price Cushion_ _ _ $ 25.00

Price Rocker_ _ _ $ 115.00

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD08: CREATE CUSTOMER SPECIFIC MATERIAL PRICE In this exercise, a specific customer receives special pricing with a specific validity period. If you are already on the Create Condition Records screen you can avoid the following

drill down by clicking on and moving to the steps below If you are not on that screen, select the following:

Logistics  Sales and Distribution  Master Data  Conditions  Create

(At new screen) Prices  Individual Prices Enter the following information:

1. Select CnTy SOrg. DChl Customer Material

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Customer: Sunny Porch Pastimes_ _ _ Value: ______________

5. Enter the following materials and prices:

Condition type Material Amount

Price Cushion_ _ _ $ 32.00

Price Rocker_ _ _ $ 132.00

 (ENTER)

The system will automatically enter the material descriptions and units of currency and measure

 (SAVE)

Stay where you are for the next exercise

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD09: CREATE CUSTOMER DISCOUNT This example shows a value discount being created. This is also an example of a pricing scale. This condition type is currently set for 'Item condition', but could be changed to 'Header condition' in the IMG. If you are already on the Create Condition Records screen you can avoid the following drill

down by clicking on and moving to the steps below If you are not on that screen use the following path:

Logistics  Sales and Distribution  Master Data  Conditions  Create

(At new screen) Conditions  By Customer Enter the following information:

1. Select CnTy SOrg. DChl Customer ReSt

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Condition type: Customer Discount Value: ______________

5. Customer: Old Tyme Furniture HQ_ _ _ Value: ______________

 (ENTER)

6. Select the line item (click on the box to the left of the line to select)

7. Click on the scales button to give the customer a discount of 5% for order values between $500 and $1500 and a discount of 10% for orders larger than $1500

Table Row Scale value Amount

First 500.00 5 Second 1500.00 10

 (ENTER)

The system will show the percentage amounts as negative, due to it being a percentage discount on price based on the size of the sale. While the percentage amounts could have been typed in with a negative value in front or at the end of the amount, SAP automatically records amounts entered into that field as negative.

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD10: CREATE CUSTOMER MATERIAL INFO RECORD When a customer wishes to order materials from us using a different naming convention than we do, we can set up a Customer Material Info Record which allows us to enter materials by the customer's specific naming convention. SAP will translate these materials into our material names, which enables the customer and our sales rep to communicate clearly.

Logistics  Sales and Distribution  Master Data  Agreements  Customer Material

Information  Create Enter the following information: 1. Customer: Stephanie’s Designs _ _ _ Value: ______________

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Wholesale Value: ______________

 (ENTER)

4. Enter the material numbers for the following materials and the customer material number as indicated:

Material no. Cust. material

Cushion_ _ _ SC1001

Rocker_ _ _ SC1002

 (ENTER)

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD11: CREATE AN ITEM PROPOSAL In situations where a customer often places an order with the same line items, an Item Proposal (order 'template') can be created with the standard line items and quantities already filled in. We can then pull the standard items in as we create the sales order by referencing the Item Proposal. The Item Proposal can be used to create sales orders for many customers.

Logistics  Sales and Distribution  Master Data  Products  Item Proposal  Create Enter the following information: 1. Item Proposal Type: Item Proposal Value: ______________

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Division: Standard Value: ______________

 (ENTER)

5. Item Proposal: leave blank

6. Description: 50 Rocker Pack_ _ _

NOTE: For the next two steps, feel free to use the F4 function key on your keyboard or the look-up button to the right of the field to call up an SAP calendar and double click on the requested date for each respective field

7. Valid-from date: Today’s date Value: ______________

8. Valid-to date: A month from today Value: ______________

9. Enter the following materials and target quantities:

Material Target quantity

Rocker_ _ _ 50

Cushion_ _ _ 100

 (ENTER)

 (SAVE)

10. Record the item proposal number _____________________

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD12: ASSIGN ITEM PROPOSAL TO CUSTOMER Now that the item proposal has been created, we can reference it in the customer master of one or more customers. Whenever we ask for an Item Proposal in a sales order for a customer to whom it has been assigned to, the system will default this Item Proposal.

Logistics  Sales and Distribution  Master Data  Business Partner  Customer 

Change  Complete Enter the following information: 1. Customer: Old Tyme Furniture HQ_ _ _ Value: ______________

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Division: Standard Value: ______________

 (ENTER)

5. Select (if needed)

Sales Tab

6. Item proposal: Enter the number of the newly created item proposal from SD11

Value: ______________

 (SAVE)

 back to the SAP Easy Access menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD13: CREATE AN INQUIRY A sales representative needs to find out about material pricing for a customer.

Logistics  Sales and Distribution  Sales  Inquiry  Create Enter the following information: 1. Inquiry Type: Inquiry Value: ______________

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Division: Standard Value: ______________

 (ENTER)

5. Inquiry: leave blank (system will assign a number)

6. Sold-To Party: Sunny Porch Pastimes_ _ _ Value: ______________

7. Ship-To Party: Will automatically fill in later

8. PO Number: Enter this exercise number (EX 13) as a reference number

9. PO date: leave blank

10. Valid from : Today’s date Value: ______________

11. Valid to: A month from today’s date Value: ______________

12. Material and Order Quantities:

Material Order Quantity

Rocker_ _ _ 150

Cushion_ _ _ 100

 Click (ENTER) and then select an item.

13. Select: (Item conditions) notice the special pricing for Sunny Porch Pastimes. Refer back to values entered in SD07 and SD08 to see where these prices originated.

 (BACK)

CHECK AVAILABILITY

14. Select the line with Cushion_ _ _

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

 Environment Availability

15. Note the quantity Value: ______________

and location (if available) of available inventory (ATP quantity) Value: ______________

 (BACK)

 (SAVE)

16. Record the inquiry number ________________________

 (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD14: CREATE SALES ORDER REFERENCING AN INQUIRY If the customer decides to place an order, we can create the order referencing the inquiry. At this point items may be added, deleted or changed.

Logistics  Sales and Distribution  Sales  Order  Create Enter the following information: 1. Order Type: Standard Order Value: OR

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Division: Standard Value: ______________

5. Select

INQUIRY TAB

6. Enter the number of the Inquiry you just created

7. Select

Note the data on the screen, including the net value of the sales order being $23,000

8. PO number: Enter this exercise # (EX 14) to simulate the customers purchase order

ITEM OVERVIEW TAB

9. Select Cushion_ _ _ (Check the box to the left of the line item)

10. Click on the schedule lines button on the bottom of the screen

The system has determined the quantity available on the delivery date, and confirmed the schedule line

 (BACK)

We can check the pricing on the material, for example:

11. Select Rocker_ _ _

12. Click and note the pricing

 (BACK)

We can also adjust quantities for our sales order. For example:

The customer has requested that the quantity Rocker_ _ _ be increased to 175.

13. Change the quantity to 175 on this item

 (ENTER)

 (ENTER again, to acknowledge the warning that the “Reference quantity” of 150 was changed to 175 each)”

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

14. Verify that the quantity increased correctly, as well as the net value of the sales order now being $26,300

15. Record the Sales Orders Net Value $______________

 (SAVE)

16. Record the sales order number (referred to as “standard order” at bottom of screen) ________________________

 (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD15: CHECK STOCK STATUS This step allows you to obtain current availability of product.

1. Open a new session (or System  Create session)

Keep this session open at the end of the exercise for later use!

Logistics  Materials Management  Inventory Management  Environment  Stock

 Stock Overview Enter the following information: 2. Material: Chose a material from your sales order

3. Plant: Classic Rockers Manufacture Pt Value: ______________

4. Display version: All stock types Value: ______________

 (EXECUTE)

5. Note the quantity in the “Unrestricted use” column

6. Double click on the line with your Plant’s stock

A pop-up window is displayed showing the details of the inventory by stock type at the

plant

7. Note the “Unrestricted use” quantity – it should be the same as that noted in step #5

above

8. Note “Sales orders” quantity

9. Note the ‘Schd. for delivery’ quantity – it should be zero

10. Exit the detailed display window

11. Now go to your other session, and leave this session open (Alt + Tab)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD16: CREATE DELIVERY FOR SALES ORDER At this time, you’re ready to make delivery on a customer order. Creating the delivery brings your order to the point where stock availability is re-determined, and the quantity of ordered items is moved to a 'scheduled for delivery' status.

Logistics  Sales and Distribution  Shipping and Transportation  Outbound

Delivery  Create  Single Document  With Reference to Sales Order Enter the following information:

1. Shipping point: Classic Rockers Ship Point Value: ______________

2. Selection date: Enter a date 7 days from today

3. Order: Sales order number (from exercise SD14)

 (ENTER)

The system defaults the items and quantities from the sales order that are scheduled to be delivered

4. Complete the following for each line item on the outbound delivery

a. Click on the line item (box to left of line item number to select entire row)

b. (DETAILS)

c. Picking Tab:

i. Verify system selected: Plant = Classic Rockers Manufacture Pt

ii. Storage Location for: Cushion_ _ _ Shipping

Rocker_ _ _ Shipping

 (BACK AFTER EACH PICKING TAB ENTRY)

5. When all line items checked for Plant and correct Storage Location shown

 (SAVE)

6. Record the outbound delivery document number ____________________

 (EXIT back to SAP Easy Access Menu)

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

To recheck the stock status (see previous exercises):

7. Switch back to your other session that is still on the Stock overview

 (BACK)

8. Check the material number and check the plant number

 (EXECUTE) again 9. Double click on the line with your Plant’s stock.

A pop-up window is displayed showing the details of the inventory by stock type at the

plant

10. Note the “Unrestricted use” quantity – it should be unchanged (and same as that on Stock

Overview: Basic List screen)

11. Note “Sales orders” quantity – it should now be zero

12. Now check the ‘Schd. for delivery’ quantity – it should now have a balance equal to that

which used to be the “Sales orders” quantity noted in SD15

13. Return to your first session by using Alt-Tab

14. (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD17: PICKING MATERIALS ON DELIVERY NOTE The picking of materials function will indicate the quantity of the proposed materials per delivery.

Logistics  Sales and Distribution  Shipping and Transportation  Outbound

Delivery  Change  Single Document 1. Enter the delivery note number from exercise SD16.

 (ENTER)

The material delivery quantity is proposed

2. Enter Pick quantity to match the proposed delivery quantity

Pick Qty = Deliv. Qty

3. Check / Enter the storage location that contains each inventory line item

NOTE: check stock status if you do not remember

 (SAVE)

Return to your second session using Alt-Tab. and

4. Recheck the stock status of the materials

Note that no change has occurred in the stock status - the quantities are still in the “Schd. for delivery” stock type field

5. Return to your first session and (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD18: POST GOODS ISSUE Creating the post goods issue reduces unrestricted stock to reflect the inventory shipped. It also indicates a change of ownership of the goods. These goods have left your plant and are now owned by your customer.

Logistics  Sales and Distribution  Shipping and Transportation  Outbound

Delivery  Change  Single Document 1. Enter the delivery note number from exercise SD16

2. Select

The system returns a message indicating the delivery note is now an outbound delivery

To recheck the stock status (see earlier exercises):

3. Switch back to your other session that is still on the Stock overview

4. Click to refresh this screen Note that the quantity in the “Unrestricted use” column has now decreased by the amount per the shipment 5. Double click on the plant line Note that the quantity in “Unrestricted use” has decreased, consistent with that on the Stock Overview: Basic List main screen. Also note that the quantity in “Schd. for delivery” is now zero.

6. Close the popup screen and until you have closed out your second session

7. Return to your first session and (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD19: BILLING THE CUSTOMER Once the 'post goods issue' has been generated, you can bill your customer for those goods.

Logistics  Sales and Distribution  Billing  Billing Document  Create The first field under Document should default to the last delivery document created – the delivery document number from exercise SD16. If the field does not default to that document, then enter in the field.

 (EXECUTE)

The system displays the customer and the materials on the delivery with total values to be billed. The amount billed should agree with that given in SD14, Step 14.

1. Record the total amount billed to the customer $____________________

 (SAVE)

The billing document number is displayed at the bottom of the screen

2. Record the document number ________________________

 (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD20: REVIEW DOCUMENT FLOW

SAP allows us to see a whole transaction from beginning to end (i.e., its audit trail). For instance, we have created an order with reference to a quotation, then to a delivery, post goods issue and billing. To examine the flow, any one of those document numbers can be referenced, and the document flow will show an audit trail of all documents tied to that number.

Logistics  Sales and Distribution  Sales  Inquiry  Display

1. Inquiry: Inquiry number from exercise SD13

2. Select from Top Menu Bar: Environment  Display document flow The system displays a list of documents associated with the quotation. Your screen should look similar to that shown below.

3. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

4. Click on the line of the “GD goods issue: delvy ##########”

5. Select

The system displays the material document with a goods movement “601”, which is the movement type for goods issue to a delivery note

6. Select to view the data entry view postings for this goods movement

Note the two negative (credit) amounts to Inventory (Finished and Trading) that combine to $26,000.00. Likewise, there are two positive (debit) amounts to Cost of Goods Sold that combine to $26,000.00. $24,500.00 is the cost of Rocker sold, while $1,500.00 is the cost of Cushion sold.

7. Select and you will see a very similar display of data as seen on the Accounting Document

8. Click twice to return to the Document Flow. Click on the Invoice line and select

The system displays such data as each inventory item sold, the amount, net value sold of each and cost of each

9. Select to view the data entry view postings for the invoicing

Note the positive (debit) of $26,300.00 to your customer, as well as the two negative (credit) amounts to Sales Revenue. The first is from selling Rocker and the second is from selling Cushion.

10. Select

Note the similarity in the entry from the previous screen. However, this screen primarily differs by showing the debit being recorded to your AR Reconciliation account created in Exercise SD01. You linked your account to this customer in Exercise SD02.

11. Click to show the document header. You should see key data such as the user who entered this document, the reference (purchase order), document, posting and entry dates, and posting period.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Move the document header so the General Ledger View can be seen. Your screen should look like that shown in the screenshot below.

12. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

 Close the document header and (BACK) until you return to the Document Flow screen

 It can be seen from the document flow that:

A. The entire document flow is now shown.

i. Inquiry - highlight this line and select then

ii. Order - highlight this line and select then

iii. Delivery - highlight this line and select then

iv. Picking - n/a

v. GD goods issue - highlight this line and select then

vi. Invoice - highlight this line and select then

vii. Accounting document - highlight this line and select then

B. The business cycle is complete except for collection which is processed by Financial Accounting (FI). This is why the Accounting document shows as “Not cleared”.

NOTE: You can view the document flow from the “Display Sales Order” or “Display Delivery” screens, as well

 (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD21: CREATE SALES ORDER USING ITEM PROPOSAL

Old Tyme Furniture HQ calls in a weekly sales order, which normally has the same materials and quantities. We will use the item proposal that we assigned to this customer earlier in the tutorial.

Logistics  Sales and Distribution  Sales  Order  Create

Enter the following information:

1. Order Type: Standard Order Value: OR

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Direct Value: ______________

4. Division: Standard Value: ______________

 (ENTER)

5. Standard Order: leave blank

6. Sold-To Party: Old Tyme Furniture HQ_ _ _ Value: ______________

7. Ship-To Party: leave blank

8. PO Number: Enter this exercise number (EX 21)

9. PO date: leave blank

 (ENTER)

10. Click the Item overview tab

11. To find the item proposal for this customer, select:

In the pop-up window, the system copies the number of the item proposal for this customer

12. Select

13. Change the Order Quantity for Cushion_ _ _ to 200

14. Review the Availability screen for Cushion_ _ _

 (BACK)

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Review the pricing options:

15. Select the line item Cushion_ _ _

16. Click and note the pricing

The material pricing includes the 10% discount from the customer-specific material pricing record for >$1500. Check the pricing for Cushion_ _ _ to verify this discount is applied.

 (BACK)

17. Verify that the net value of the sales order is $12,600

18. Record the Sales Orders Net Value $______________

 (SAVE)

19. Record the sales order number ___________________________

 (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE SD22: CREATE SALES ORDER USING CUSTOMER INFO RECORD The customer Stephanie’s Designs always uses their own material numbers for the items they buy from us. In an earlier exercise, we created a customer info record with Stephanie’s Designs’ material numbers and our material number equivalents. We can now create a sales order using their part numbers.

Logistics  Sales and Distribution  Sales  Order  Create 1. Order Type: Standard Order Value: OR

2. Sales Organization: Classic Rockers Value: ______________

3. Distribution Channel: Wholesale Value: ______________

4. Division: Standard Value: ______________

 (ENTER)

5. Enter the sold-to party number for Stephanie’s Designs_ _ _

6. Enter a purchase order number - the number of this exercise (EX 22)

 (ENTER)

7. Select Ordering party tab

A new field appears in the Sales Order line item: “Customer material no.”

8. Enter the following customer materials and quantities:

Customer Material Numb Order Quantity Material

(Leave blank)

SC1001 30

SC1002 20

 (ENTER)

The system references the customer material numbers and copies our equivalent material number and all relevant data. Your screen should look like that on the next page.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

9. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

 (SAVE)

10. Record the sales order number _________________________

 (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Chapter 5: Accounting/Controlling (FI/CO)

EXERCISE FI/CO01: CREATE GENERAL LEDGER B/S ACCOUNT We will create a bank account manually. A bank account is an asset account located in the Balance Sheet. In this exercise you create a General Ledger Account to be added to your Chart of Accounts and Company code.

Accounting  Financial Accounting  General Ledger  Master Records  G/L

Accounts  Individual Processing  Centrally

Enter the following information:

1. G/L Account: 10000_ _ _

2. Company Code: Classic Rockers, Inc. Value: ______________

 (CREATE)

Type/Description TAB

3. Account Group: Balance sheet accounts

4. Select Balance sheet account

5. Short Text: Bank_ _ _

6. G/L Acct Long Text: Bank_ _ _

Control Data TAB

7. Account currency: United States Dollar Value: ______________

8. Only balances in local crcy  Only balances in local crcy

9. Line item display  Line item display

10. Sort key: Posting date Value: ______________

Create/bank/interest TAB

11. Field status group: General balance sheet accounts Value: ______________

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO02: CREATE GENERAL LEDGER GR/IR ACCOUNT This account is used for invoice verification

Accounting  Financial Accounting  General Ledger  Master Records  G/L

Accounts  Individual Processing  Centrally Enter the following information:

1. G/L Account: 31000_ _ _

2. Company Code: Classic Rockers, Inc. Value: ______________

 (CREATE)

Type/Description TAB

3. Account Group: Balance sheet accounts

4. Select Balance sheet account

5. Short Text: GR/IR-_ _ _

6. G/L Acct Long Text: Goods Receipt/Invoice Receipt-_ _ _

Control Data TAB

7. Account currency: United States Dollar Value: ______________

8. Check Only balances in local crcy

9. Tax category: All tax types allowed Value: ______________

10. Posting without tax allowed:  Posting without tax allowed

11. Open item management:  Open item management

12. Line item display :  Line item display

13. Sort key: Posting date Value: ______________

Create/bank/interest TAB

14. Field status group: Material management GR/IR accounts Value: ______________

15. Post automatically only:  Post automatically only

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO03: CREATE P/L ACCOUNTS Both a rent expense account and utilities expense account are to be created in your chart of accounts using a reference account. Using a reference account copies much of the detail data from the reference account to the account being created thus saving time making repetitive entries and increasing the accuracy of data entry for those data items that do not have to be edited for the new account.

Accounting  Financial Accounting  General Ledger  Master Records  G/L

Accounts  Individual Processing  Centrally Enter the following information:

1. G/L Account: 78000_ _ _

2. Company Code: Classic Rockers, Inc. Value: ______________

3. Click on

4. G/L Account: Labor Value: ______________

Hint: When looking up the Labor account, use the G/L account description in chart accounts tab

5. Company Code: Classic Rockers, Inc. Value: ______________

 (ENTER)

6. Change the Short Text description to Rent Expense_ _ _

7. Change the GL Account Long Text description Rent Expense – Your Last Name

8. All other settings remain unchanged

 (SAVE)

9. G/L Account: 75000_ _ _

10. Company Code: Classic Rockers, Inc. Value: ______________

11. Click on

12. G/L Account: Labor Value: ______________

13. Company Code: Classic Rockers, Inc. Value: ______________

 (ENTER)

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

14. Change the description to Utilities_ _ _

15. Change the GL Account Long Text description Utilities – Your Last Name

16. All other settings remain unchanged.

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO04: CREATE GENERAL LEDGER P&L ACCOUNTS To process billing we will need Profit & Loss Statement accounts for Sales Revenue and Sales Discounts

Accounting  Financial Accounting  General Ledger  Master Records  G/L

Accounts  Individual Processing  Centrally

Enter the following information:

1. G/L Account: 60000_ _ _

2. Company Code: Classic Rockers, Inc. Value: ______________

 (CREATE)

Type/Description TAB

3. Account Group: Profit and loss accounts

4. Select P&L statement acct

5. Short Text Sales Revenue

6. G/L Acct Long Text: Sales Revenue_ _ _

Control Data TAB

7. Account currency: United States Dollar Value: ______________

8. Posting without tax allowed:  Posting without tax allowed

9. Line item display:  Line item display

10. Sort key: Posting date Value: ______________

Create/bank/interest TAB

11. Field status group: Revenue accounts Value: ______________

12. Post automatically only:  Post automatically only

 (SAVE)

* Repeat steps 1-12 substituting the following:

1. G/L Account: 61000_ _ _

5. Short Text Sales Discount

6. G/L Acct Long Text: Sales Discount_ _ _

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO05: RUN GL ACCOUNTS REPORT This report will give you a summary of all accounts assigned to your company code.

Accounting  Financial Accounting  General Ledger  Information System 

General Ledger Reports  Master Data  G/L Account List  SAP Minimal Variant Enter the following information:

1. Company code: Classic Rockers, Inc. Value: ______________

 (EXECUTE)

2. Review the list of accounts

3. Scroll down to your bank account and PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR). See example screenshot below for G/L Acct 10000998. Find your bank account.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

4. Scroll down to your Sales Discount account and PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR). See example screenshot below for G/L Acct 61000998. Find your sales discount account.

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO06: CREATE PRIMARY COST ELEMENTS Primary cost elements: are costs that arise through the consumption of goods and services that originate from outside the company. They represent the link between FI and CO. This exercise creates the linkage between FI cost elements (GL accounts in FI) and the cost element categories to which they will link in CO.

Accounting  Controlling  Cost Element Accounting  Master Data  Cost Element

 Individual Processing  Create Primary IF REQUESTED, SET CONTROLLING AREA TO CLASSIC ROCKERS AND CLICK ON

ENTER

Create Primary cost elements for the listed expense accounts (use the following data to create these cost elements):

1. Cost Element: 75000_ _ _

2. Valid From: 01/01/20yy to: 12/31/9999

 (ENTER)

3. Name: Utilities_ _ _

4. Description: Utilities_ _ _

5. CElem category: Primary costs/cost-reducing revenues Value: ______________

 (SAVE)

6. Cost Element: 78000_ _ _

7. Valid From: 01/01/20yy to: 12/31/9999

 (ENTER)

8. Name: Rent Expense_ _ _

9. Description: Rent Expense_ _ _

10. CElem category: Primary costs/cost-reducing revenues Value: ______________

 (SAVE)

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO07: CREATE VENDOR MASTER RECORD Classic Rockers has rented new office space. The accountant in charge is requested to create a new vendor account for the real estate company.

Accounting  Financial Accounting  Accounts Payable  Master Records  Create 1. Vendor: Leave blank

2. Company Code: Classic Rockers, Inc. Value: ______________

3. Account group: Vendor (int. number assgnmnt) Value: ______________

 (ENTER)

4. Name: Ross’ Rockin Rentals_ _ _

5. Search term: Lease

6. Postal Code: 54321

7. City: (your creation)

8. Country: USA Value: ______________

9. Region: Texas Value: ______________

10. Language: English

11. Click on the More Fields button (located on the right side) of the Street Address section.

12. Tax Jurisdictn: TX0000000

 (ENTER three times)

13. Recon. account: Your Accounts Payable Reconciliation Value: ______________

 (ENTER)

14. Payt Terms: Payable immediately Due net Value: ______________

15. Chk double inv.:  Chk double inv.

 (SAVE)

16. Record the Vendor Account no.___________________________

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO08: G/L DOCUMENT ENTRY

You receive the utility bill for the month for the plant and it must be paid immediately. The bill is for $1,000. The expense must be recorded in the General Ledger. It will be initially charged to the Administration cost center and charged out to manufacturing cost centers later.

Accounting  Financial Accounting  General Ledger  Posting  Enter G/L Account Document

Enter the following information: 1. Document Date: Today’s date Value: ______________

2. Currency: United States Dollar Value: ______________

3. Company Code: Classic Rockers, Inc. (will default) Value: ______________

4. G/L acct: Your Utilities Account Value: ______________

5. D/C: Debit

6. Amount in doc. curr.: 1000

7. Cost center: Administration Value: ______________

On Next Line Enter:

8. G/L acct: Bank_ _ _ Value: ______________

9. D/C: Credit

10. Amount in doc. curr.: 1000

 (ENTER)

Note at the top right of the screen that total debits equal total credits

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

11. Use the button to see if the postings are correct in amount and to the correct accounts – see example below

 (SAVE)

12. Record the document number.____________________________________

 back to the SAP Easy Access menu – reply Yes to the do you want to exit editing message

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO09: DISPLAY ACCOUNT BALANCES (OR LINE ITEMS)

Accounting  Financial Accounting  General Ledger  Account  Display Balances (New) Enter the following information: 1. Account Number: Your Utilities Account Value: ______________

2. Company Code: Classic Rockers, Inc. Value: ______________

3. Fiscal Year: Current year Value: ______________

 (EXECUTE)

4. Examine the line items – yours should look similar to that shown below, with your activity happening in the month in which you performed the previous exercise

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

5. Double-click on the line item of the current period. The resulting screen displays the G/L View, with a reference to your document number from FI/CO08.

6. Double-click on the document number. The resulting pop-up screen displays key aspects of the transaction. Scroll to the bottom to note your user name as the one who entered the transaction.

7. Move the pop-up screen so that the data from the G/L Account Line Item Display G/L View can be seen behind it. See example below.

8. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

(BACK THREE TIMES) to the SAP Easy Access menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO10: POST VENDOR INVOICE Ross’ Rockin Rentals_ _ _ has sent the invoice for the first month’s rent of $350. Please post the invoice using the accounts you have created in your Company code.

Accounting  Financial Accounting  Accounts Payable  Document Entry  Invoice Enter the following information:

1. Vendor: Ross’ Rockin Rentals_ _ _ Value: ______________

2. Invoice date: Today’s date Value: ______________

3. Amount: 350

If your Company Code did not default in, Select Edit  Set Company Code and enter yours.

4. G/L account: Your Rent Expense Account Value: ______________

5. D/C: Debit

6. Amount in doc. curr.: 350

7. Cost center: Administration Value: ______________

 (ENTER)

Note that the balance shown in the top right of the screen is zero, meaning that the invoice amount equals the amount(s) distributed to general ledger account(s) selected

Continued on next page

INVOICE #123 Ross’ Rockin Rentals_ _ _

CURRENT Month Rent

Total $350.00

Thank you

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

8. Use the button to see if the postings are correct in amount and to the proper accounts. See below for example.

 (SAVE)[Do NOT use either of these two buttons

.] 9. Record the document no._________________________________

 (EXIT) respond Yes to the do you want to exit editing question

INSTRUCTOR NOTE: USE OBC4 TO CHANGE THE DEFAULT FIELD STATUS SETTING FOR PAYMENT TERMS FROM SUPPRESSED TO OPTIONAL IF THE PAYMENT TERMS FIELD IS NOT AVAILABLE

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO11: DISPLAY ACCOUNT BALANCES (AND/OR LINE ITEMS)

Accounting  Financial Accounting  General Ledger  Account  Display Balances (New) Enter the following information:

1. Account Number: Your Rent Expense Account Value: ______________

2. Company Code: Classic Rockers, Inc. Value: ______________

3. Fiscal Year: Current year Value: ______________

 (EXECUTE)

4. Double-click on the line item of the current period. The resulting screen displays the G/L View, with a reference to your document number from FI/CO10.

5. Double-click on the document number. The resulting pop-up screen displays key aspects of the transaction. Scroll to the bottom to note your user name as the one who entered the transaction. Close the pop-up screen.

To Display the Vendor account balance and line item

6. Create another session by the button or (System Create session)

Accounting  Financial Accounting  Accounts Payable  Account  Display Balances

7. Vendor: Ross’ Rockin Rentals_ _ _ Value: ______________

8. Company code: Classic Rockers, Inc. Value: ______________

9. Fiscal year: Current year Value: ______________

 (EXECUTE)

10. Double click on period balance to see document detail – see next page for example

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Note the document number on your screen. It is the same as that noted in step 4 of this exercise, as well as that noted in FI/CO10. You can click on the line and find out more information about the document, such as the user who recorded it. The current screen shows the accounts payable side of the entry from FI/CO10 while the first session shows the rent expense side of the entry.

11. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

Feel free to use Alt + Tab to switch back and forth between the two sessions, seeing each side of the transaction

When through analyzing, go back to the first session, leaving the second session open

 BACK TO SAP EASY ACCESS MENU.

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO12: POST OUTGOING PAYMENT The invoice of Ross’ Rockin Rentals_ _ _ is now due for payment. You are requested to clear the invoice amount by posting an outgoing payment using the bank account (no. 10000_ _ _) of your chart of accounts.

Accounting  Financial Accounting  Accounts Payable  Document Entry 

Outgoing Payment  Post

Enter the following information:

1. Document Date: Today’s date Value: ______________ Bank data:

2. Account: Bank_ _ _ Value: ______________ 3. Amount: 350 4. Text: Invoice #??? (the number in FI/CO10)

Open item selection: 5. Account: Ross’ Rockin Rentals_ _ _ Value: ______________

6. All other settings remain unchanged.

7. Select 8. Double click on the USD Gross Amount to be assigned (may not be required if there was

only one open item to be processed)

9. Check that the not assigned balance is zero.

 (SAVE) 10. Record the document no._______________________ Go Back to the other session you have open (Alt Tab) or open one if you do not have another

one open by clicking

Accounting  Financial Accounting  Accounts Payable  Account  Display/Change Line Items

Enter the following information: 11. Vendor account: Ross’ Rockin Rentals_ _ _ Value: ______________ 12. Company code: Classic Rockers, Inc. Value: ______________ 13. Select Cleared items

 (EXECUTE)

Your resulting screen should look similar to that shown on the next page

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Your document numbers should agree to yours from this exercise and FI/CO10. You can click on either document number to find out more information about the document, such as the user who recorded it.

Note that the balance has been paid

14. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

Close this second session when you are finished noting that the balance has been paid

 Exit to the SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO13: POST OUTGOING PAYMENT

The invoice of Happy Bottoms_ _ _ (created in the Procurement Logistics exercises) is due for payment now. You are requested to clear the invoice amount by posting an outgoing payment using the bank account (no. 10000_ _ _) of your chart of accounts.

Accounting  Financial Accounting  Accounts Payable  Document Entry 

Outgoing Payment  Post

Enter the following information:

1. Document Date: Today’s date Value: ______________

Bank data:

2. Account: Bank_ _ _ Value: ______________

3. Amount: The invoice amount from MM12

4. Text: Invoice #??? from MM12

Open item selection:

5. Account: Happy Bottoms_ _ _ Value: ______________

6. All other settings remain unchanged.

7. Select

8. Examine the Not Assigned balance at the bottom. If balance is something other than zero, double click on Amount under USD Gross to apply. Ensure full amount is applied.

 (SAVE)

9. Record the document no._______________________

 back to SAP Easy Access menu (respond Yes to the end editing menu)

Accounting  Financial Accounting  Accounts Payable  Account  Display/Change Line Items

Enter the following information:

10. Vendor account: Happy Bottoms_ _ _ Value: ______________

11. Company code: Classic Rockers, Inc. Value: ______________

12. Select Cleared items

 (EXECUTE)

Continued on next page

13. Review for Open items

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

The screen should show that the invoice has been paid (the first line item entry), referring to your document number from above. The second line item is from when you recorded the invoice in Exercise MM12. Note the document number for that line, and compare it to the document number from your second screenshot from completing Exercise MM12. You can click on either document number to find out more information about the document, such as the user who recorded it.

 Exit to the SAP Easy Access menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO14: RECEIVE PAYMENT FROM CUSTOMER A sale to a Sunny Porch Pastimes_ _ _ was processed and billed in the Sales Logistics system. That customer has now received the invoice and sends you payment. The payment will be posted to his G/L account.

Accounting  Financial Accounting  Accounts Receivable  Document Entry  Incoming Payments Enter the following information:

1. Document Date: Today’s date Value: ______________

2. Company Code: Classic Rockers, Inc. Value: ______________ Bank data:

3. Account: Bank_ _ _ Value: ______________

4. Amount: The amount billed in SD19

Open item selection:

5. Account: Sunny Porch Pastimes_ _ _ Value: ______________

6. Select

7. If “not assigned” amount is not equal to 0.00, then double click on the “USD Gross amounts” until the “not assigned” amount equals 0.00

 (SAVE)

8. Record the document number for this posting ________________

 Back to SAP Easy Access Menu

Logistics  Sales and Distribution  Sales  Inquiry  Display

9. Enter your inquiry number (from the sale in SD13 to Sunny Porch Pastimes_ _ _)

10. Select Menu: Environment  Display document flow

The resulting screen (see example on next page) shows the audit trail from the original customer inquiry through the accounting document noting that the invoice has “cleared”, which means it has been paid by the customer

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Go back and compare your screen to the screen capture made when performing Exercise SD20, step 2. That screen capture shows the accounting document for the invoice as “Not cleared”. The SD20, Part B states that “Not cleared” means collection has not occurred.

11. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR) The collection on the invoice can be viewed via the Line Item Display, similar to what was done in exercises FI/CO11 through 13 when looking at the Line Item Display of certain vendor invoices (except in this particular situation, you are selecting Accounts Receivable and not Accounts Payable).

You are encouraged to refer to instructions in prior exercises and modify to provide the Customer Line Item Display that shows customer collection in this exercise. Feel free to analyze the data throughout the audit trail.

 (EXIT back to SAP Easy Access Menu)

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO15: CREATE DISTRIBUTION CYCLE Distribution accomplishes the charging of primary costs from a collection cost center to all of the cost centers that benefit from the incurrence of that primary cost. Periodically, usually at the end of the month, the primary cost element will be allocated (charged) to the receiving cost objects. The distribution process distributes the balance(s) from the original sender(s) to the receivers. The original sender account is credited and the original receiver account is debited by the distribution. In this manner the distributed primary cost retains its identity in the receiving cost object’s expense list. In this exercise, you will distribute your rent expense that you recorded in total to administration to finance; human resources; sales; marketing; purchasing; and administration.

Accounting  Controlling  Cost Center Accounting  Period-End Closing  Single

Functions  Allocations  Distribution

1. Extras Set Controlling Area

Classic Rockers (if requested) Value: ______________

Enter the following information:

2. Period: 1 (January) to 12 (December) Value: ______________

3. Fiscal Year: Current year Value: ______________

4. Extras Cycle Create

a. Cycle DST_ _ _

b. Starting date: 01/01/20yy

 (ENTER) 5. Text: Monthly Distributions Note: Make sure Indicators field does not have “Iterative” checked!

6. Select: 7. Segment Name and Description: Rent and Distribution of Rent

Segment Header Tab: Accept defaults Senders/Receivers Tab:

8. Sender: (under From column) a. Cost Center Administration Value: ______________ b. Cost Element Rent Expense_ _ _ Value: ______________

Continued on next page

9. Receiver: (under Group column)

a. Cost Center CRHeadquarters Group Value: ______________

Top Menu Bar

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Receiver Tracing Factor Tab:

10. Var. portion type: Actual Statistical Key Figures

11. Click on to acknowledge message to maintain fields for statistical key figures

Selection criteria (below section for Tracing factors)

12. Stat. key fig in From column.: CRSQFT Value: ______________

 (BACK) to the “Execute Actual Distribution: Initial Screen” (Three times)

 Save when asked whether to save cycle.

13. Enter cycle DST_ _ _

14. Start Date 01/01/20yy

 (EXECUTE) the distribution cycle with the Test run indicator checked

15. Double click on the warning indicator

Note: IF THIS IS NOT THE FIRST MONTH OF THE YEAR, you should expect warning messages indicating that the system cannot find input data for the months previous to the current month

 on the warning message to exit the message

16. Double click on the Monthly Distributions line

17. Review the resulting screen (an example is shown on the next page), which shows the proposed allocation of your rent expense to particular cost centers:

A010 Finance

A020 Human Resources

A030 Sales

A040 Marketing

A050 Purchasing

A060 Administration

The reason it is proposed at this time is because you just performed a test run of the allocation

Continued on next page

If the top part of the screen is showing an error message of “This program cannot display the webpage”, please disregard. It will not interfere with the exercise being performed.

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

The amounts that have been allocated to each of these departments are based on square footage values that your instructor set up in SAP. In step #12 of this exercise, you chose square footage as the statistical measure for distributing rent expense.

18. You can double-click on any line to find out further information about the distribution. Do so on the line for A030, and scroll down to see, among other things, your user name and the object type (the name of the cost center, which in this case is Sales). Compare to the example screenshot on the next page.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

19. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

20. After the distribution cycle has been executed such that it looks like that above, close the

popup box, click and click on YES to exit the list. Click again and reply YES to leave the list. You should now be on the Execute Actual Distribution: Initial Screen.

21. Remove the check from the Test run indicator

 (EXECUTE) the distribution cycle again and check it out by repeating the reviewing steps above. After review back out to the SAP Easy Access Menu.

 Back to SAP Easy Access Menu

NOTE: The first time in the system may trip an error indicating that you must execute report RX811XST. This can be accomplished from the Error dialog box by double clicking on the proceed button (red lettering at bottom of error message). Click on the line item message and drop down in error message until highlighted red run report visible.

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO16: REVIEW ACTUAL LINE ITEM REPORT This exercise allows you to see how the rent expense cost element has been distributed to the various receiving cost objects using the statistical key figure set up as the basis for the distribution.

Accounting  Controlling  Cost Center Accounting  Information System 

Reports for Cost Center Accounting  Line items  Cost Centers: Actual Line Items IF REQUESTED, SET CONTROLLING AREA TO CLASSIC ROCKERS AND CLICK ON

ENTER

1. Cost Center Finance to Administration Value: ______________

2. Cost Element Rent Expense_ _ _ Value: ______________

3. Posting Date 01/01/YYYY to Last day of current month/year

 (EXECUTE)

Review the report, noting your rent expense account and vendor – see below for an example. Rent expense is still recorded in your rent expense account, but now allocated among cost centers consuming that expense based on some specified manner.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

If the top part of the screen is showing an error message of “This program cannot display the webpage”, please disregard. It will not interfere with the exercise being performed. 4. Double-click on any line item amount other than the one for $350.00 in Cost Center

A060 Administration. The resulting screen describes the item as a “Monthly Distribution” and identifies your user name as the one who created the distribution.

5. Select to return to the prior screen. Select Yes on the resulting exit screen. 6. Double-click on the line item amount for $350.00 in Cost Center A060 Administration.

The resulting screen shows the Data Entry View of your document, with a posting to your vendor. The document number should agree with that from FI/CO10. You can

click to see the entry being recorded to your Accounts Payable Reconciliation account.

7. Click . A Document Header pop-up screen appears. Move it so that your screen looks similar to that below. Note on your pop-up screen the reference to your user name. As a continued reinforcement of the importance of the audit trail throughout the tutorials, note the consistent documentation of the user name associated with all transactions.

 Exit from the pop-up screen and Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO17: CREATE ASSESSMENT CYCLE

With assessment both primary and secondary postings can be allocated. You can define cost allocation by assessment if the composition of costs is not important for the receiver – for example, receiver cost centers rarely require detailed breakdowns of cafeteria costs. In our case, certain charges from the local utility company on our plant are known to be exclusively attributable to the Manufacturing cost centers. Therefore, once a month the utility charges are assessed from the Administration cost center to the Manufacturing cost centers.

Accounting  Controlling  Cost Center Accounting  Period-End Closing 

Single Functions  Allocations  Assessment

1. ExtrasSet Controlling Area

Classic Rockers (if requested) Value: ______________

2. Period: 1 (January) to 12 (December) Value: ______________

3. Fiscal Year: Current year Value: ______________

4. Extras Cycle Create

o Enter ASM_ _ _

o Starting date: 01/01/20yy

 (ENTER)

5. Text: Monthly Assessments

Note: Make sure Indicators field does not have “Iterative” checked.

6. Click

7. Segment Name: Utilities

8. Text: Assessment of Utilities

Segment Header Tab:

9. Assessment CEle: Assessed Costs Value: ______________

Receiver tracing factor (still on Segment Header Tab):

10. Receiver rule: Fixed percentages

Continued on next page

Top Menu Bar

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Senders/Receivers Tab:

11. Sender (under From column):

a. Cost Center: Administration Value: ______________

b. Cost Element: Utilities_ _ _ Value: ______________

12. Receiver (under Group column):

a. Cost Center: CRManufacturing Group Value: ______________

Receiver Tracing Factor Tab:

13. Cost Ctr Portion/percent

P010 50

P020 25

P030 25

 (SAVE)

 (BACK) to the “Execute Actual Assessment: Initial Screen” – 3 times

14. Respond “Yes” to “Do you want to save the cycle?”

15. Enter cycle ASM_ _ _

16. Starting date 01/01/20yy

 (ENTER)

 (EXECUTE) the assessment cycle with the Test run indicator checked

17. Double Click on Monthly Assessments on “Actual Assessments Basic List”

The resulting screen (see next page for example) shows the proposed allocation of utilities expense on the plant to particular manufacturing cost centers, based on the percentages entered in step #13:

P010 Assembly Line

P020 Warehouse

P030 Receiving Area

The reason it is proposed at this time is because you just performed a test run of the allocation.

Compare your screen to that on the next page for agreement. If the top part of the screen is showing an error message of “This program cannot display the webpage”, please disregard. It will not interfere with the exercise being performed.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

Consistent with documentation of other transactions in SAP, you can double-click on a line and learn further information about the assessment, including identification of the user who created the assessment. Feel free to do so.

18. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

 (BACK)

19. After the assessment cycle has been executed without any errors, remove the check from the Test run indicator

 (EXECUTE) the assessment cycle again

 Back to SAP Easy Access Menu

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

EXERCISE FI/CO18: REVIEW ACTUAL LINE ITEM REPORT Review how the utility expenses have moved from cost center to cost center as assessed costs with no indication as to coming from the utilities cost element 750000.

Accounting Controlling Cost Center Accounting  Information System

Reports for Cost Center Accounting Line Items  Cost Centers: Actual Line Items IF REQUESTED, SET CONTROLLING AREA TO CLASSIC ROCKERS AND CLICK ON

ENTER

1. Cost Center: Administration to Receiving Area Value: ______ ______

2. Cost Element: Assessed Costs Value: ______________

3. Click on 4. Open Documents/Objects folder and scroll down list until you find User Name

5. Select User Name and click 6. User Name: CRUSER-_ _ _ Value: ______________

7. (SAVE)

8. (EXECUTE) The resulting screen (see next page for example) shows the actual allocation of your utilities expense to the three manufacturing departments: P010 Assembly Line P020 Warehouse P030 Receiving Area Compare your screen to that on the next page for agreement. If the top part of the screen is showing an error message of “This program cannot display the webpage”, please disregard. It will not interfere with the exercise being performed. Consistent with documentation of other transactions in SAP, you can double-click on a line and learn further information about the assessment, such as the user who created the assessment. Feel free to do so.

Continued on next page

FOR ACADEMIC USE ONLY ALL MATERIALS FROM SAP LIBRARY ADAPTED WITH PERMISSION OF SAP AMERICA UNIVERSITY ALLIANCE

9. PRINT THE SCREEN (IF REQUIRED BY YOUR INSTRUCTOR)

Back to SAP Easy Access Menu