Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle E-Business Suite 12 Financials Cookbook

You're reading from   Oracle E-Business Suite 12 Financials Cookbook Take the hard work out of your daily interactions with E-Business Suite financials by using the 50+ recipes from this cookbook

Arrow left icon
Product type Paperback
Published in Aug 2011
Publisher Packt
ISBN-13 9781849683104
Length 384 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Yemi Onigbode Yemi Onigbode
Author Profile Icon Yemi Onigbode
Yemi Onigbode
Arrow right icon
View More author details
Toc

Table of Contents (15) Chapters Close

Oracle E-Business Suite 12 Financials Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
1. Preface
1. Creating Items in Inventory 2. Purchasing Items in Procurement FREE CHAPTER 3. Paying Supplier Invoices in Payables 4. Managing Assets 5. Selling Items to Customers in Order Management 6. Receiving Funds in Receivables 7. Managing Cash 8. Defining Transactions for the General Ledger 9. End of Period Processing

Creating Item templates


An Item template is a set of attributes that enable the 'quick' creation of an Item. In this recipe, we will create an Item template that can be used to create many similar Items. We will copy from the Finished Good template to our new template called ACME Finished Good.

Getting ready

Log in to Oracle E-Business Suite and select the Inventory responsibility.

How to do it...

Let's list the steps required to create an Item template:

  1. 1. Navigate to Setup | Items | Templates.

  2. 2. Select the Inventory Organization.

  3. 3. From the Find Item Templates form, click on New button or press Alt+N.

  4. 4. In the Template field, enter the name of the new template; for example, enter ACME Finished Good.

  5. 5. In the Description field, enter a suitable description, for example, enter ACME Finished Good Template.

  6. 6. Select Copy Template from the Tools menu.

  7. 7. We can use this form to select the attributes groups that we want to copy from the Finished Good template.

  8. 8. Click on the Apply button.

  9. 9. Click on the Done button.

  10. 10. In the dialog box presented to us, with the message "Do you want to save the changes you have made?", click on the Yes button.

How it works...

Item templates can be created from scratch. To make the template creation process easier, Oracle has provided us with a number of seeded templates as a starting point to copy from. We can also combine templates and manually amend the attributes to define our template. When we copy from an existing template, we have choices that determine how the copy will occur.

The three main choices are as follows:

  1. 1. Overwrite: All selected attribute values are copied to the new template and any values that we have manually created will be overwritten.

  2. 2. Append: Attributes that have no value will be copied across to our template. This mode is useful if you are using a combination of templates.

  3. 3. Overwrite Not Null: Only the selected attributes that contain values will be copied.

There's more...

Let's amend the template to allow us to automatically populate the template with some default values. Let's create an Item and apply the amended template to the Item.

Amending the template

Let's search for the template and amend the templates to include some of the default values:

  1. 1. Search for the ACME Finished Good template by navigating to Setup | Items | Templates.

  2. 2. Enter ACME Finished Good in the Template field and click on the Find button.

  3. 3. Click on the Open button to view the template.

  4. 4. In the Attributes Group region, select Purchasing and enter some default values, for example:

    • Default Buyer: Stock, Ms. Pat

    • Input Tax Classification Code: VAT-15%

    • Taxable: Yes

    • Allow Description Update: Yes

    • Receipt Required: Yes

  5. 5. Save the template.

  6. 6. In the Attributes Group region, select Receiving and enter some default values, for example:

    • Over-Receipt Qty Action: Warning

    • Receipt Routing: Direct Delivery

    • Days Early Receipt Allowed: 5

    • Days Late Receipt Allowed: 2

    • Receipt Date Action: Warning

  7. 7. Save the template.

  8. 8. In the Attributes Group region, select Invoicing and enter some default values, for example:

    • Accounting Rule: Immediate

    • Payment Terms: Immediate

  9. 9. Save the template.

Creating an Item and applying the template to the Item

Let's create an Item and apply the template to the Item:

  1. 1. Navigate to Items | Master Items.

  2. 2. Enter the Item code and description.

  3. 3. Select Copy From in the Tools menu.

  4. 4. Click on the Apply button.

  5. 5. Click on the Done button. This action will validate the template created.

  6. 6. Click on the Purchasing tab to review the default values of the attributes assigned automatically by the template.

  7. 7. Save the Item.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime