Exercise Workbook For Student 8: SAP B1 On Cloud - AIS
Exercise Workbook For Student 8: SAP B1 On Cloud - AIS
Exercise Workbook For Student 8: SAP B1 On Cloud - AIS
EXERCISE WORKBOOK
FOR STUDENT 8
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 / 38
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 3.1..............................................................................................................................................7
3. Purchase Process.....................................................................................................................................8
Exercise 3.1..............................................................................................................................................8
Exercise 3.2..............................................................................................................................................9
Exercise 3.3............................................................................................................................................10
Exercise 3.4............................................................................................................................................12
Exercise 3.5............................................................................................................................................13
4. Sales Process.........................................................................................................................................14
Exercise 4.1............................................................................................................................................14
Exercise 4.2............................................................................................................................................15
Exercise 4.3............................................................................................................................................16
Exercise 4.4............................................................................................................................................18
Exercise 4.5............................................................................................................................................19
5. Inventory Management.........................................................................................................................20
Exercise 5.1............................................................................................................................................20
Exercise 5.2............................................................................................................................................21
Exercise 5.3............................................................................................................................................22
Exercise 5.4............................................................................................................................................23
Exercise 5.5............................................................................................................................................24
Exercise 5.6............................................................................................................................................25
Exercise 5.7............................................................................................................................................26
Exercise 5.8............................................................................................................................................27
Exercise 5.9............................................................................................................................................28
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 2 / 38
Exercise 5.10.............................................................................29
6. Accounting Cycle...................................................................................................................................30
Exercise 6.1............................................................................................................................................30
Exercise 6.2............................................................................................................................................31
Exercise 6.3............................................................................................................................................32
Exercise 6.4............................................................................................................................................33
Exercise 6.5............................................................................................................................................34
Exercise 6.6............................................................................................................................................35
Exercise 6.7............................................................................................................................................36
Exercise 6.8............................................................................................................................................37
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 3 / 38
1. Basic Navigation
Exercise 1.1
Fill each blank with the appropriate words or terminologies that will make the statements correct.
1. The Menu Bar displays at the top of the screen. It contains the Windows standard menu (File, Edit,
W window, Help) as well as generic SAP Business One functions.
2. The Tool Bar 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 Modules Menu. It arranges the functions of the
individual applications in a tree structure.
4. The users of SAP Business One are defined in the User- Setup window.
5. Accessing SAP Business One on Cloud is done using Web Browsers like Google Chrome, Mozilla
Firefox or Safari.
Exercise 1.2
Identify the terminologies being described by each sentence.
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. Private Cloud
3. This is also known as External Cloud, is available to the public where data are created and stored on
third-party servers. Public Cloud
4. This is a key feature of cloud computing where resources can be accessed anywhere (except on
limitations set by company's internal control). Location Independence
5. This the place where SAP, a European multinational software corporation, was founded in 1972.
Waldorf Germany
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 4 / 38
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 5 / 38
Exercise 2.2
Header
Code: SU00008
BP Type Vendor
Name Daisy Flower Shop
Group General Suppliers
General
Tel No: 95958484
Mobile Phone: 98585747463
E-Mail [email protected]
Contact Person
Contact ID: JE-011
First Name: Jeggs
Title: Mr.
Middle Name: Alcantara
Last Name: Manalo
Address: Metro Manila
Telephone No: 56421524
Mobile Phone: 95421325412
E-Mail [email protected]
Payment Term
Payment Terms: Net 60
Price List: Regular Purchase Price
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 6 / 38
Exercise 3.1
Add the following items on the Item Master Data:
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 7 / 38
3. Purchase Process
Exercise 3.1
Perform the whole purchase process on this transaction:
Input the required information, use the selection list when available:
Vendor: SU00008
Name: Daisy Flower Shop
Posting Date: Date Today
Item No: IM00036
Quantity: 12 each
Click Add to save the document. Screenshot the complete relationship
map
Input the screenshot of your output here:
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 8 / 38
Exercise 3.2
Perform the whole purchase process on this transaction:
Input the required information, use the selection list when available:
Vendor: SU00008
Name: Daisy Flower Shop
Posting Date: Date Today
Item No: IM00037 and IM00038
Quantity: 39 each
Click Add to save the document. Screenshot the complete relationship
map
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 9 / 38
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 10 / 38
Exercise 3.3
Perform the whole purchase process on this transaction:
Input the required information, use the selection list when available:
Vendor: SU00008
Name: Daisy Flower Shop
Posting Date: Date Today
Item No: IM00036, IM00039 and IM00040
Quantity: 12 each
Click Add to save the document. Screenshot the complete relationship
map
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 11 / 38
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 12 / 38
Exercise 3.4
Perform the whole purchase process on this transaction:
Input the required information, use the selection list when available:
Vendor: SU00008
Name: Daisy Flower Shop
Posting Date: Date Today
IM00037, IM00038, IM00039 and
Item No: IM00040
Quantity: 47 each
Click Add to save the document. Screenshot the complete relationship map
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 13 / 38
Exercise 3.5
Perform the whole purchase process on this transaction:
Input the required information, use the selection list when available:
Vendor: SU00008
Name: Daisy Flower Shop
Posting Date: Date Today
IM00036, IM00037, IM00038, IM00039 and
Item No: IM00040
Quantity: 24 each
Click Add to save the document. Screenshot the complete relationship map
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 14 / 38
4. Sales Process
Exercise 4.1
Perform the whole sales process on this transaction:
Input the required information, use the selection list when available:
Vendor: CU00008
Name: Reinee
Posting Date: Date Today
Item No: IM00036
Quantity: 10 each
Click Add to save the document. Screenshot the complete relationship
map
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 15 / 38
Exercise 4.2
Perform the whole sales process on this transaction:
Input the required information, use the selection list when available:
Vendor: CU00008
Name: Reinee
Posting Date: Date Today
Item No: IM00037 and IM00038
Quantity: 37 each
Click Add to save the document. Screenshot the complete relationship
map
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 16 / 38
Exercise 4.3
Perform the whole sales process on this transaction:
Input the required information, use the selection list when available:
Vendor: CU00008
Name: Reinee
Posting Date: Date Today
IM00036, IM00039 and
Item No: IM00040
Quantity: 10 each
Click Add to save the document. Screenshot the complete relationship
map
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 17 / 38
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 18 / 38
Exercise 4.4
Perform the whole sales process on this transaction:
Input the required information, use the selection list when available:
Vendor: CU00008
Name: Reinee
Posting Date: Date Today
IM00037, IM00038, IM00039
Item No: and IM00040
Quantity: 45 each
Click Add to save the document. Screenshot the complete relationship
map
Input the screenshot of your output here:
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 19 / 38
Exercise 4.5
Perform the whole sales process on this transaction:
Input the required information, use the selection list when available:
Vendor: CU00008
Name: Reinee
Posting Date: Date Today
IM00036, IM00037, IM00038,
Item No: IM00039 and IM00040
Quantity: 22 each
Click Add to save the document. Screenshot the complete relationship
map
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 20 / 38
5. Inventory Management
Exercise 5.1
Add the following warehouses:
Warehouse Code W5 W6 W7 W8
City Navotas City Paranaque City San Juan City Taguig City
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 21 / 38
Exercise 5.2
Add the following items managed by batches:
Header
Item No. B00008
Description JBL X44
Item Group Speakers
Unit Price 4,000
Manage Item By Batches
Management Method On every Transaction
Item No. B0008A
Description Afficionado 58
Item Group Perfumes
Unit Price 250
Manage Item By Batches
Management Method On every Transaction
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 22 / 38
Exercise 5.3
Add the following items managed by serial number:
Header
Item No. SN00008
Description Lenovo Ideapad C340 14
Item Group Laptop
Unit Price 18,098
Manage Item By Serial Numbers
Management Method On every Transaction
Item No. SN0008A
Description Lenovo Ideapad 130 15
Item Group Laptop
Unit Price 13,794
Manage Item By Serial Numbers
Management Method On every Transaction
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 23 / 38
Exercise 5.4
Goods Receipt
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 24 / 38
Exercise 5.5
Goods Receipt
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 25 / 38
Exercise 5.6
Goods Issue
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 26 / 38
Exercise 5.7
Goods Issue
IM00038 50
IM00039 20
IM00040 50
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 27 / 38
Exercise 5.8
Create period and volume discounts for the following items:
IM00036
10 days 15% 25 20%
IM00037
Create Sales Order for CU00008 with items IM00036 and IM00037
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 28 / 38
Exercise 5.9
Create period and volume discounts for the following items:
IM00038
20 days 20% 30 25%
IM00039
Create Sales Order for CU00008 with items IM00038 and IM00039
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 29 / 38
Exercise 5.10
Create period and volume discounts for the following items:
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 30 / 38
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
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 31 / 38
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.
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 32 / 38
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.
Submit the screenshot of the journal voucher created and the transaction journal report .
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 33 / 38
Exercise 6.4
Generate the General Ledger as of the date of the latest transaction.
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 34 / 38
Exercise 6.5
Generate the Trial Balance as of the end of the year.
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 35 / 38
Exercise 6.6
Generate the Balance Sheet as of the end of the year.
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 36 / 38
Exercise 6.7
Generate the Income Statement as of the end of the year.
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 37 / 38
Exercise 6.8
Perform Period End Closing for the year 20XX.
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 38 / 38