Exercise Workbook For Student 36: SAP B1 On Cloud - AIS

SAP B1 on Cloud – AIS
EXERCISE WORKBOOK
FOR STUDENT 36
FIT ACADEMY l GF King’s Court Bldg II., Chino Roces cor. Delarosa Sts., Makati City 1200, Philippines l Telephone Number: 63.2.759.4348 l www.fitacademy.ph
Page 1 / 40
SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Table of Contents
1. Basic Navigation......................................................................................................................................... 4
Exercise 1.1................................................................................................................................................ 4
Exercise 1.2................................................................................................................................................ 4
2. BP and Item Master Data...........................................................................................................................5
Exercise 2.1................................................................................................................................................ 5
Exercise 2.2................................................................................................................................................ 6
Exercise 2.3................................................................................................................................................ 7
3. Purchase Process....................................................................................................................................... 8
Exercise 3.1................................................................................................................................................ 8
Exercise 3.2................................................................................................................................................ 9
Exercise 3.3.............................................................................................................................................. 10
Exercise 3.4.............................................................................................................................................. 11
Exercise 3.5.............................................................................................................................................. 13
4. Sales Process............................................................................................................................................ 14
Exercise 4.1.............................................................................................................................................. 15
Exercise 4.2.............................................................................................................................................. 17
Exercise 4.3.............................................................................................................................................. 18
Exercise 4.4.............................................................................................................................................. 19
Exercise 4.5.............................................................................................................................................. 20
5. Inventory Management........................................................................................................................... 21
Exercise 5.1.............................................................................................................................................. 21
Exercise 5.2.............................................................................................................................................. 22
Exercise 5.3.............................................................................................................................................. 24
Exercise 5.4.............................................................................................................................................. 26
Exercise 5.5.............................................................................................................................................. 27
Exercise 5.6.............................................................................................................................................. 28
Exercise 5.7.............................................................................................................................................. 29
Exercise 5.8.............................................................................................................................................. 30
Exercise 5.9.............................................................................................................................................. 31
Page 2 / 40

Exercise 5.10................................................................................................................................................ 32
6. Accounting Cycle......................................................................................................................................33
Exercise 6.1.............................................................................................................................................. 33
Exercise 6.2.............................................................................................................................................. 34
Exercise 6.3.............................................................................................................................................. 35
Exercise 6.4.............................................................................................................................................. 36
Exercise 6.5.............................................................................................................................................. 37
Exercise 6.6.............................................................................................................................................. 38
Exercise 6.7.............................................................................................................................................. 39
Exercise 6.8.............................................................................................................................................. 40
Page 3 / 40

1. Basic Navigation
Exercise 1.1
Fill each blank with the appropriate words or terminologies that will make the statements correct.
1. The ______________ displays at the top of the screen. It contains the Windows standard menu (File,
Edit, Wwindow, Help) as well as generic SAP Business One functions.
2. The _____________ is a collection of icon buttons that grant you easy access to commonly-used
functions.
3. Navigation in SAP Business One is done using the _____________. It arranges the functions of the
individual applications in a tree structure.
4. The users of SAP Business One are defined in the _____________ window.
5. Accessing SAP Business One on Cloud is done using _____________ like Google Chrome, Mozilla
Firefox or Safari.
Exercise 1.2
Identify the terminologies being described by each sentence.
1. This is a business management software that allows an organization to use a system

of integrated applications to manage the business. It aims to serve as a backbone for your whole
business.
2. This is also known as Internal Cloud, is a cloud based infrastructure operated exclusively for a single
organization with all data protected behind an internal firewall.
3. This is also known as External Cloud, is available to the public where data are created and stored on
third-party servers.
4. This is a key feature of cloud computing where resources can be accessed anywhere (except on
limitations set by company's internal control).
5. This the place where SAP, a European multinational software corporation, was founded in 1972.
Page 4 / 40

2. BP and Item Master Data

Exercise 2.1
Header
Code: CU00036
BP Type Customer
Name Aaron
Group Small Accounts
General
Tel No: 98378276
Mobile Phone: 90298567456
E-Mail [email protected]
Contact Person
Contact ID: AW-239
First Name: Abigail
Title: Ms.
Middle Name: Revilla
Last Name: Aguilar
Address: Catanduanes
Telephone No: 43853792
Payment Term
Payment Terms: Net 60
Price List: Sales Price Student 36
Add the information above on the Business Partner Master Data

Copy and paste the ADDED Business Partner Master Data here:
Page 5 / 40

Exercise 2.2
Header
Code: SU00036
BP Type Vendor
Name Ruby Rugby Shop
Group General Suppliers
General
Tel No: 21354682
Contact Person
Contact ID: SR-672
First Name: Selena
Title: Mrs.
Middle Name: Miller
Last Name: Jones
Address: Masbate
Telephone No: 33214578
Payment Term
Payment Terms: Net 30
Price List: Base Price
Add the information above on the Business Partner Master Data
Copy and paste the ADDED Business Partner Master Data here:
Page 6 / 40

Exercise 2.3
Item
Item No. Description Unit Price
Group
IM00176 Acer X118 DLP Projector Items 16200
IM00177 FSP Aurum 500W Power Supply Items 3250
Sennheiser MKH416-P48U3 Super-Cardioid Shotgun Tube Condenser
IM00178 Items 99900
Microphone
IM00179 SECURE 500W AVR WITH METER Items 777
IM00180 Intel Pentium CPU Items 16925
Add the following items on the item master data:

Copy and paste the LIST of Item Master Data here:
Page 7 / 40

3. Purchase Process
Exercise 3.1
Perform the Purchasing Process (Purchase Order > Goods Receipt PO > AP Invoice> Outgoing Payments)
using the details below:
Input the required information, use the selection list when available:
Vendor: SU00036
Name: Ruby Rugby Shop
Posting Date: Date Today
Item No: IM00176
Quantity: 51 each
Click Add to save the document. Screenshot the complete relationship
map.
Copy and Paste the screenshot of the RELATIONSHIP MAP here:
Page 8 / 40

Exercise 3.2
Vendor: SU00036
Item No: IM00177 and IM00178
Quantity: 61 each
map.
Page 9 / 40

Exercise 3.3
Vendor: SU00036
Item No: IM00176, IM00179 and IM00180
Quantity: 71 each
map.
Page 10 / 40

Exercise 3.4
Vendor: SU00036
IM00176, IM00177, IM00178 and
Item No: IM00179
Quantity: 81 each
Click Add to save the document. Screenshot the complete relationship map.
Page 11 / 40

Page 12 / 40

Exercise 3.5
Vendor: SU00036
IM00176, IM00177, IM00178, IM00179 and
Item No: IM00180
Quantity: 91 each
Click Add to save the document. Screenshot the complete relationship map.
Page 13 / 40

3.6.
3.7
3.8
Page 14 / 40

3.9
4. Sales Process
Exercise 4.1
Perform the Sales Process (Sales Order > Delivery > AR Invoice> Incoming Payments) using the details
below:
Note: If the quantities of the items are insufficient, proceed with the Goods Receipt PO first in order for
the stock data to have sufficient quantity.
Vendor: CU00036
Name: Aaron
Item No: IM00176
Quantity: 5 each
map.
Page 15 / 40

Page 16 / 40

Exercise 4.2
below:
Vendor: CU00036
Name: Aaron
Quantity: 10 each
map.
Page 17 / 40

Exercise 4.3
below:
Vendor: CU00036
Name: Aaron
IM00176, IM00179 and
Item No: IM00180
Quantity: 15 each
map.
Page 18 / 40

Exercise 4.4
below:
Vendor: CU00036
Name: Aaron
IM00176, IM00177, IM00178
Item No: and IM00179
Quantity: 25 each
map.
Page 19 / 40

Exercise 4.5
below:
Vendor: CU00036
Name: Aaron
IM00176, IM00177, IM00178,
Quantity: 20 each
map.
Page 20 / 40

5. Inventory Management
Exercise 5.1
Add the following warehouses:
Warehouse Code WT1 WU1 WX1 WY1
Warehouse Name Dumaguete Siquijor Zamboanga Guimaras
Location Dumaguete Siquijor Zamboanga Guimaras
Street No. Konoha Akatsuki Meliodas Elizabeth
City Dumaguete Siquijor Zamboanga Guimaras
Country Philippines Philippines Philippines Philippines
Copy and paste the screenshot of WAREHOUSE LIST here:
Page 21 / 40

Exercise 5.2
1. Add the following items below managed by batches:
2. Create a Goods Receipt PO for the items below using your Vendor with 100 quantities per item.
3. Configure the items managed by batch at your own disposal
4. Create a Delivery of the items using your Customer with 10 quantities per item
Header
Item No. B00036
Description EVGA 450 BV 450W
Item Group Power Supply’s
Unit Price 2020
Manage Item By Batches
Management Method On every Transaction
Item No. B0036A

Description Cooler Master MWE 550 V2 -450W
Item Group Power Supply’s
Unit Price 2,500
Manage Item By Batches
Copy and paste the screenshots (3) of the following:

1. ADDED ITEM MASTER DATA WINDOW here:
2. ADDED Goods Receipt PO
3. ADDED Delivery
Page 22 / 40

Page 23 / 40

Exercise 5.3
1. Add the following items below managed by Serial:
2. Create a Goods Receipt PO for the items below using your Vendor with 10 quantities per item.
3. Configure the items managed by Serial at your own disposal
4. Create a Delivery of the items using your Customer with 10 quantities per item
Header
Item No. SN00036
Description ACER Predator 17
Item Group Laptop
Unit Price 94,990
Manage Item By Serial Numbers
Item No. SN0036A

Description ACER Predator Triton 300
Item Group Laptop
Unit Price 51,999
Manage Item By Serial Numbers
Copy and paste the screenshots (3) of the following:

1. ADDED ITEM MASTER DATA WINDOW here:
2. ADDED Goods Receipt PO
3. ADDED Delivery
Page 24 / 40

Page 25 / 40

Exercise 5.4
Goods Receipt
Increase in inventory item because of freebies from suppliers
Item No: Quantity

IM00176 30
IM00177 30
Copy and paste the screenshot of processed Goods Receipt Window here:
Page 26 / 40

Exercise 5.5
Goods Receipt
Increase in inventory item due to unaccounted items in the warehouse
Item No: Quantity

IM00178 55
IM00179 45
IM00180 35
Page 27 / 40

Exercise 5.6
Goods Issue
Decrease in inventory item due to discovered theft in the warehouse
Item No: Quantity

IM00176 2
IM00177 1
Copy and paste the screenshot of processed Goods Issue Window here:
Page 28 / 40

Exercise 5.7
Goods Issue
Decrease in inventory item due to warehouse fire
IM00178 6
IM00179 5
IM00180 9
Page 29 / 40

Exercise 5.8
1. Create period and volume discounts for the following items
2. Create Sales Order to check whether the configured period and volume discounts of the items
will take effect
Item No. Period Period Discount Volume Volume Discount
IM00176
17 days 10% 40 5%
IM00177
Create Sales Order for CU00036 with items IM00176 and IM00177
Copy and paste the screenshot of Sales Order here:
Page 30 / 40

Exercise 5.9
will take effect
IM00178
5 days 15% 60 20%
IM00179
Create Sales Order for CU00036 with items IM00178 and IM00179
Page 31 / 40

Exercise 5.10
will take effect
IM00180 20 days 25% 30 20%
Create Sales Order for CU00036 with items IM00180
Page 32 / 40

6. Accounting Cycle
Exercise 6.1
Record the following transactions using the Manual Journal Entry:
On March 30, 20XX, the company issued ordinary share capital worth of P 500,000, payment received
and deposited on its GBP Bank Account 1
Dr. GBP Bank Account 1 P 500,000
Cr. Ordinary Share Capital P 500,000
Copy and paste the screenshot of the TRANSACTION JOURNAL REPORT here:
Page 33 / 40

Exercise 6.2
Record the following transactions using the Manual Journal Entry:
On April 15, 20XX, the company recorded a Salary Expense worth of P 250,000, paid for through the
company’s GBP Bank Account 1.
Dr. Salaries and Wages P 250,000
Cr. GBP Bank Account 1 P 250,000
Page 34 / 40

Exercise 6.3
Create the following entries in journal entry through the journal vouchers.
On April 10,20XX, the company will pay a total of P 15,000 from the Petty Cash fund for transportation
related expenses. This transaction is still subject to supervisor’s approval.
Dr. Travel Costs – Other P 15,000
Cr. Petty Cash Fund P 15,000
Page 35 / 40

Exercise 6.4
Generate the General Ledger as of the date of the latest transaction.
Copy and paste the screenshot of the GENERAL LEDGER here:
Page 36 / 40

Exercise 6.5
Generate the Trial Balance as of the end of the year.
Copy and paste the screenshot of the TRIAL BALANCE here:
Page 37 / 40

Exercise 6.6
Generate the Balance Sheet as of the end of the year.
Copy and paste the screenshot of the BALANCE SHEET here:
Page 38 / 40

Exercise 6.7
Generate the Income Statement as of the end of the year.
Copy and paste the screenshot of the INCOME STATEMENT here:
Page 39 / 40

Exercise 6.8
Perform Period End Closing for the year 20XX.
Copy and paste the screenshot of the closing entries generated by the system using TRANSACTION
JOURNAL REPORT here:
Page 40 / 40

Exercise Workbook For Student 36: SAP B1 On Cloud - AIS

Uploaded by

Copyright:

Available Formats

Exercise Workbook For Student 36: SAP B1 On Cloud - AIS

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Exercise Workbook For Student 36: SAP B1 On Cloud - AIS

Uploaded by

Copyright:

Available Formats

SAP B1 on Cloud – AIS

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

1. This is a business management software that allows an organization to use a system

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

2. BP and Item Master Data

Add the information above on the Business Partner Master Data

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Add the following items on the item master data:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Copy and Paste the screenshot of the RELATIONSHIP MAP here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Warehouse Code WT1 WU1 WX1 WY1

Warehouse Name Dumaguete Siquijor Zamboanga Guimaras

Location Dumaguete Siquijor Zamboanga Guimaras

Street No. Konoha Akatsuki Meliodas Elizabeth

City Dumaguete Siquijor Zamboanga Guimaras

Country Philippines Philippines Philippines Philippines

Copy and paste the screenshot of WAREHOUSE LIST here:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Item No. B0036A

Copy and paste the screenshots (3) of the following:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Item No. SN0036A

Copy and paste the screenshots (3) of the following:

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Increase in inventory item because of freebies from suppliers

Item No: Quantity

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Increase in inventory item due to unaccounted items in the warehouse

Item No: Quantity

SAP Basic 9.1 printed on 12/11/2021 9:09 AM

Decrease in inventory item due to discovered theft in the warehouse