book

Oracle E-Business Suite 12 Financials Cookbook

Name: Oracle E-Business Suite 12 Financials Cookbook
Author: Yemi Onigbode
ISBN: 9781849683104

by Yemi Onigbode

August 2011

Intermediate to advanced

384 pages

6h 47m

English

Packt Publishing

Read now

Unlock full access

Oracle E-Business Suite 12 Financials Cookbook
Table of Contents
Oracle E-Business Suite 12 Financials Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Support files, eBooks, discount offers and moreWhy subscribe?Free access for Packt account holdersInstant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for

Conventions
Reader feedback
Customer support
ErrataPiracyQuestions
1. Creating Items in Inventory
Introduction
Creating Items
Getting readyHow to do it...How it works...There's more...Assigning Items to inventory organizationsAssigning Items to categoriesSee also
Exploring Item attributes
How to do it...
Creating Item templates
Getting readyHow to do it...How it works...There's more...Amending the templateCreating an Item and applying the template to the Item
Exploring Item controls
Getting readyHow to do it...There's more...Storing Items by SubinventoriesStoring Items by locatorsIdentifying Items by lot controlTracking Items using serial controlControlling Items using revisions
Adjusting Items in Inventory
How to do it...There's more...Searching for Items
Classifying Items
How to do it...How it works...There's more...Viewing the Item Categories structureViewing the values in the structureCreating catalogsAssigning a catalog description to an ItemSearching for Items using catalog attributes
2. Purchasing Items in Procurement
Introduction
Raising requisitions for Items
Getting readyHow to do it...How it works...There's more...Smart formsAccounting codesCopying a requisitionCorrecting a requisitionCanceling a requisitionSee also
Approving requisitions
Getting readyHow to do it...How it works...There's more...Reviewing the employee setupReviewing the Position HierarchyReviewing the document typesReviewing the approval groupsReviewing the approvals assignment
Creating suppliers
Getting readyHow to do it...How it works...There's more...Creating a contactCreating a bank accountReviewing the accounting detailsReviewing the purchasing optionsSetting the receiving optionsSetting the payment details
Creating purchase orders
Getting readyHow to do it...There's more...Using Blanket Purchase Agreements (BPA)Viewing the agreement in iProcurementUsing Contract Purchase Agreements (CPAs)Using the contract in iProcurementReviewing the purchasing optionsApproving purchase orders and agreementsSee also
Receiving Items
Getting readyHow to do it...There's more...Express ReceivingReturning ItemsCorrecting receiptsViewing receiptsReviewing receiving options
Reviewing procurement accounting transactions
How to do it...How it works...There's more...The Receiving Inventory AccountInventory AP Accrual AccountExpense AP Accrual AccountMaterial Cost AccountPO Distribution Charge AccountFinancial optionsSee also
3. Paying Supplier Invoices in Payables
Entering invoicesGetting readyHow to do it...How it works...See also
Entering a prepayment
Getting readyHow to do it...There's more...Entering a quick invoice for a prepaymentApplying a prepayment to an invoice
Entering credit memos
Getting readyHow to do it...
Applying holds to an invoice
Getting readyHow to do it...H ow it works...There's more...Reviewing invoice management holdsSee also
Canceling an invoice
Getting readyHow to do it...
Paying invoices
Getting readyHow to do it...How it works...
Creating a payment process template
Getting readyHow to do it...There's more...Creating a scheduled payment
Voiding a payment
Getting readyHow to do it...There's more...Stopping a payment
Reviewing payables accounting transactions
Getting readyHow to do it...How it works...There's more...Creating accounting transactions for multiple invoicesSee also
4. Managing Assets
Introduction
Adding assets
Getting readyHow to do it...How it works...There's more...Manually entering assetsAdding assets to the CIP assetMass posting of assetsMerging assetsSee also
Adjusting assets
Getting readyHow to do it...There's more...Adjusting Expense Accounts and LocationsAdjusting assets categoriesAdjusting asset valuesTransferring costs
Depreciating assets
Getting readyHow to do it...How it works...There's more...Reviewing depreciation methodsReviewing prorate conventionsSee also
Retiring assets
Getting readyHow to do it...There's more...Partial retirementCalculating gains and lossesMass retirements
Reviewing asset accounting
How to do it...How it works...There's more...See also
5. Selling Items to Customers in Order Management
Introduction
Creating customers
Getting readyHow to do it...How it works...There's more...Adding a customer siteAdding contactsAdding profile details
Entering sales orders
Getting readyHow to do it...How it works...There's more...Entering orders quicklySee also
Adding Items to price list
Getting readyHow to do it...How it works...There's more...Applying a discount to the priceViewing modifiersMass adding of Items to a price listAdjusting the price of ItemsSee also
Reviewing Order Management workflow
How to do it...How it works...There's more...Transaction Types
Creating Drop Ship orders
How to do it...How it works...See also
Creating Back-to-Back orders
How to do it...How it works...See also
Creating a return
How to do it...See also
Applying holds
How to do it...See also
Releasing orders
Getting readyHow to do it...How it works...There's more...Viewing the Pick Slip reportSee also
Shipping orders
Getting readyHow to do it...How it works...There's more...Generated reports
Creating invoices
Getting readyHow to do it...How it works...See also
6. Receiving Funds in Receivables
Introduction
Creating an invoice
Getting readyHow to do it...How it works...There's more...Generating accountingEntering Quick TransactionsEntering depositsEntering a credit memoSee also
Adjusting invoices
Getting readyHow to do it...How it works...There's more...Adjusting revenue
Entering receipts
Getting readyHow to do it...How it works...There's more...Miscellaneous receiptsReversing receiptsSee also
Managing debt
Getting readyHow to do it...
Reviewing Receivables' accounting transactions
Getting readyHow to do it...How it works...See also
7. Managing Cash
Introduction
Creating bank accounts
Getting readyHow to do it...There's more...Creating transaction codesSee also
Entering bank statements
Getting readyHow to do it...How it works...There's more...Entering bank statements manually
Reconciling bank statements
Getting readyHow to do it...How it works...There's more...Manual reconciliationEntering AR receiptsEntering AP paymentsReversing transactionsSee also
Creating cash forecasting
Getting readyHow to do it...
Reviewing accounting transactions
Getting readyHow to do it...There's more...Viewing Transactions in General LedgerSee also
8. Defining Transactions for the General Ledger
Introduction
Defining the chart of accounts
Getting readyHow to do it...How it works...There's more...Entering Flexfield valuesEntering natural account values
Setting up the ledger
How to do it...There's more...Reviewing the calendarDefining the ledger optionsCreating the reporting currencyAssigning the Balancing Segment Values (BSV) to the ledgerDefining the operating unitsAssigning the ledger to a responsibilityOpening the first general ledger periodCreating journals
Defining Subledger accounting
How to do it...How it works...See also
Defining E-Business Tax
Getting readyHow to do it...See also
9. End of Period Processing
Introduction
Closing Payables
Getting readyHow to do it...There's more...Reconciling PayablesOpening the next periodClosing AssetsSee also
Closing Purchasing
Getting readyHow to do it...How it works...
Closing Receivables
Getting readyHow to do it...There's more...Closing Order ManagementSee also
Closing Inventory
Getting readyHow to do it...
Closing the General Ledger
Getting readyHow to do it...See also
Index

Content preview from Oracle E-Business Suite 12 Financials Cookbook

Entering bank statements

Bank statements are downloaded from the bank to a local directory. Once the file is received, the bank account balance and statement information can be loaded into the bank statement open interface tables, using the bank statement loader program or a custom loader program. The files can also be loaded automatically using an interface program or using the XML Gateway. Bank statements can also be entered manually.

In this recipe, we will look at how to enter bank statements.

Getting ready

The bank statement shown next has been loaded into the open interface table:

Date	Transaction	Description	Credit	Balance
		Opening Balance		0.00
03-Mar-11	Payment	Fixture Expert Inc	3,092.26	3,092.26
06-Mar-11	Deposit ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Publisher Resources

ISBN: 9781849683104Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Oracle E-Business Suite 12 Financials Cookbook

by Yemi Onigbode

Entering bank statements

Getting ready

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.