Oracle E-Business Suite 12 Financials Cookbook

Oracle E-Business Suite 12 Financials Cookbook

By : Yemi Onigbode

Buy this Book

Oracle E-Business Suite 12 Financials Cookbook

By: Yemi Onigbode

Buy this Book

Overview of this book

Oracle EBS Financials Suite is a solution that provides out-of-the-box features to meet global financial reporting and tax requirements with one accounting, tax, banking, and payments model and makes it easy to operate shared services across businesses and regions. Have you ever wondered how the EBS Financials modules integrate with each other, and do you want to know how this is done quickly? If so, this book is for you. You may have read about what EBS financials does, but with this book on your work desk you will see how to do it. The Oracle E-Business Suite 12 Financials Cookbook will enable you to taste the core functionalities of the main modules using bite size recipes. Each recipe is organized in a way that will enable you to learn the core steps to perform in a key business scenario; it then dives deeper into concepts and scenarios. Discover scenario-based recipes, designed to help you understand how the end-to-end processes within EBS R12 Financials modules are linked together, through touch points. With each chapter, this book develops a full business end-to-end scenario to cover the financial modules. You will start by creating items in Inventory, and then purchase items in Procurement. Then you will move on to entering supplier invoices and paying them in Payables and creating and managing assets. See how items are sold and shipped to customers in Order Management, and how funds are received from customer in Receivables. Manage cash and transfer transactions to General Ledger, and then close periods.

Oracle E-Business Suite 12 Financials Cookbook

Credits

About the Author

About the Reviewer

www.PacktPub.com

Preface

Free Chapter

Creating Items in Inventory

Introduction

Creating Items

Exploring Item attributes

Creating Item templates

Exploring Item controls

Adjusting Items in Inventory

Classifying Items

Purchasing Items in Procurement

Introduction

Raising requisitions for Items

Approving requisitions

Creating suppliers

Creating purchase orders

Receiving Items

Reviewing procurement accounting transactions

Paying Supplier Invoices in Payables

Entering invoices

Entering a prepayment

Entering credit memos

Applying holds to an invoice

Canceling an invoice

Paying invoices

Creating a payment process template

Voiding a payment

Reviewing payables accounting transactions

Managing Assets

Reviewing asset accounting

Selling Items to Customers in Order Management

Introduction

Creating customers

Entering sales orders

Adding Items to price list

Reviewing Order Management workflow

Creating Drop Ship orders

Creating Back-to-Back orders

Receiving Funds in Receivables

Reviewing Receivables' accounting transactions

Managing Cash

Introduction

Creating bank accounts

Entering bank statements

Reconciling bank statements

Creating cash forecasting

Reviewing accounting transactions

Defining Transactions for the General Ledger

Introduction

Defining the chart of accounts

Setting up the ledger

Defining Subledger accounting

Defining E-Business Tax

End of Period Processing

Closing the General Ledger

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Adjusting Items in Inventory

Item quantities can be adjusted in Inventory. In this recipe, we will use miscellaneous transactions to adjust Items. Let's try to enter transactions on some of the controls we have set up. We will try and enter a Miscellaneous Transaction for five paper widgets into Inventory.

How to do it...

1. Navigate to Transactions | Miscellaneous Transactions.
2. In the Type field, select Miscellaneous receipt from the list of values.
3. Click on the Transaction Lines button to enter the receipt.
4. Search for the PRD20001 Item in the Item field.
5. Select the Subinventory list of values and the field should be automatically populated with ACME-FG.
6. In the Locator field, enter A1.1.2.
7. The system should display an Error message to indicate that an invalid locator has been entered.
8. Click on OK and enter A1.1.1 the system should accept this value.
9. Enter a value of 5 in the Quantity field.
10. In the account field, enter 01-000-1410-0000-000. This is the account that will be charged for the Inventory transaction.
11. Select the Lot / Serial button.
12. Enter the Lot number LN10001.
Note
The expiration date is generated based on the setting in the Item definition.
13. Enter the quantity of 5.
14. Click on the Serial button.
15. Enter SN10001 in the Start Serial Number field and press Tab on the keyboard.
16. The SN10005 should be automatically populated in the End Serial Number field.
17. Click on the Done button.
18. Click on the Done button again in the next screen.
19. Save the record.