Skip Headers

Oracle Financials for Asia/Pacific User Guide
Release 12.1
Part Number E13419-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Australia

Oracle Inventory

Associate Subinventories and Locations

Use the Australian Subinventory and Location Associations window to associate subinventories with specific deliver-to locations. This association is used in Enter Replenishment Counts to default the deliver-to location for a subinventory.

The relationship between deliver-to locations and subinventories is one to one, and unique. That is, a deliver-to location can be associated with one subinventory, and a subinventory may be associated with only one deliver-to location. Only the subinventories of the inventory organization to which the deliver-to location is attached (in the Define Locations window) are eligible for association.

Australian Inventory Internal Charges Report

The Australian Inventory Internal Charges report lists all stock accounting transactions incurred during a selected period, enabling:

These internal charges include stock transactions processed directly using the Inventory Account Transaction window as well as those processed by means of the Oracle Inventory Order Cycle against internal sales orders.

Use the Standard Request Submission windows to submit the Australian Inventory Internal Charges report.

Report Parameters

Start Date

Enter the earliest date that you want to report on.

End Date

Enter the latest date that you want to report on.

Account Low

Enter the first account that you want to report on.

Account High

Enter the last account that you want to report on.

Item Low

Enter the first item that you want to report on.

Item High

Enter the last item that you want to report on.

Category Set

Enter the category set that you want to report on.

Category Low

Enter the first category that you want to report on.

Category High

Enter the last category that you want to report on.

Column Headings

This table shows the column headings.

In this column... Oracle Inventory prints...
Accounting Flexfield The accounting flexfield. Oracle Inventory sorts the Internal Charge report in account order and prints the accounting flexfield at the start of each block of transactions charged to that account. The cost center name is also displayed next to this.
Transaction Date The date of the accounting transaction.
Pick Slip The pick slip number under which the issue transaction took place. This applies to internal sales order issues only.
Item Description The description of the item in the transaction.
Item The item number of the item in the transaction.
UOM The primary unit of measure of the item in the transaction.
Qty Rec'd The quantity received in the primary unit of measure.
Unit Cost The unit cost of the item in the primary unit of measure.
Total Cost The total transaction cost charged against the nominated account.
Break Total A sub-total of all transactions charged against the nominated account, as well as a grand total of all transaction charges against the selected account range.

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Oracle Purchasing

Import Requisitions

Import Requisitions creates two requisition types:

Internal requisitions are produced in unit of issue and purchase requisitions are produced in unit of purchase.

Prerequisites

Before you can define requisition types, you must:

Purchase Requisitions

If the requisition type is Purchase, Oracle Purchasing checks for a valid AutoSource rule. The number one ranked supplier and the lowest sequence numbered document for that supplier are used as the quotation.

The unit of measure on the quotation line becomes the unit of measure on the supplier-sourced requisition line. The quantity is converted to this unit of measure and rounded to the nearest integer.

Pricing Rules

  1. If a single valid shipment line exists for the quotation line, the price will be taken from the shipment line.

  2. If there are multiple valid shipment lines for the quotation line, the price will be taken from the shipment line that has a quantity closest to the order quantity.

  3. If there are no valid shipment lines the price will be taken from the quotation line.

  4. If there is no price on the quotation line, the price will be 0.

A valid shipment line must have:

If there is no valid AutoSource rule, the unit of measure on the requisition line is the primary unit of measure and the price is the list price for the item.

Example

The four pricing rules are demonstrated in this example. Follow each of the four products through the pricing process.

This table shows the requisition line for each product:

Item Unit of Measure Quantity System Date
S1000 Each 100 1.JAN.00
S2000 Each 200 1.JAN.00
S3000 Each 300 1.JAN.00
S4000 Each 400 1.JAN.00

This table shows the quotation for product S1000:

Item Unit of Purchase Price
S1000 Box 10 00

This table shows the shipment lines for product S1000:

Quantity Unit of Purchase Price Effective
10 Box 10 80 1.JAN.00 - 1.DEC.00
1 Box 100 75 1.JAN.00 - 1.DEC.00

This table shows the quotation for product S2000:

Item Unit of Purchase Price
S2000 Box 10 00

This table shows the shipment lines for product S2000:

Quantity Unit of Purchase Price Effective
5 Box 10 80 1.JAN.00 - 1.DEC.00
10 Box 10 50 1.AUG.00 - 1.DEC.00
20 Box 10 40 1.JAN.00 - 1.DEC.00

This table shows the quotation for product S3000:

Item Unit of Purchase Price
S3000 Box 10 100

This table shows the shipment lines for product S3000:

Quantity Unit of Purchase Price Effective
1 Box 100 50 1.JAN.00 - 1.DEC.00
2 Box 100 30 1.AUG.00 - 1.DEC.00

This table shows the quotation for product S4000:

Item Unit of Purchase Price
S4000 Box 10  

This table shows the final requisition line for each product:

Item Unit of Measure Quantity Price
S1000 Box 10 10 80
S2000 Box 10 20 40
S3000 Box 10 30 100
S4000 Box 10 10 0

Internal Requisitions

If the requisition type is Internal, Oracle Applications retrieves the unit of issue for the item in the source organization on the requisition line. If no unit of issue exists, the primary unit of measure is used. The quantity ordered and unit price are converted to the new unit of measure.

Internal Requisition Accounting

Imported requisitions use AutoAccounting to determine the account combinations for internal requisitions with a delivery type of Inventory. Each segment of the account is derived from the subinventory replenishment account, the item replenishment account, or a constant.

For example, if your accounting structure is:

you may decide that your AutoAccounting definition is:

Accounting Structure Definition
Company 01
Cost Center MTL_SECONDARY_INVENTORIES
Account MTL_SYSTEM_ITEMS

This definition says that the replenishment account is generated using 01 for the Company value, the Cost Center value is taken from the destination subinventory, and the Account value is taken from the item.

Suppose you have an item X1000, with a replenishment expense account of 01-000-3100. If you order item X1000 to be delivered to WARD-1 with a replenishment expense account of 01-200-5000, then AutoAccounting will generate an account combination of 01-200-3100 on the requisition line. If AutoAccounting cannot generate an account, then the default is the AP accrual account defined in Oracle Inventory.

Note: To achieve consistent accounting between internal requisitions that are imported and internal requisitions that are entered via Enter Requisitions, the FlexBuilder rules for Enter Requisitions must be set up to reflect the AutoAccounting rules that you have set up.

Related Topics

Overview of Setting User Profiles, Oracle Applications System Administrator's Guide

Define Automatic Accounting

Use the Australian Automatic Accounting window to define how Import Requisitions generate your account numbers for internal requisitions with a delivery type of Inventory.

Prerequisites

Before you can define automatic accounting, you must:

To define Automatic Accounting:

  1. Navigate to the Australian Automatic Accounting window.

  2. Enter the name of the ledger for which you wish to create your automatic account numbers in the Ledger field.

  3. Enter Replenishment Expense as the account type in the Type field.

  4. In the Segments region, Oracle Subinventory Replenishment automatically defaults each segment name in the Segment field. Select the name of the table that you want to use to automatically default the segment value in the Table Name field. If you want to use a constant value for this particular segment, leave the Table field blank. You can choose:

  5. If you have entered a table name in the previous field, leave the Constant field blank. If you want to always use the same value for this segment, regardless of the user or item, enter the value in the Constant field.

Related Topics

Overview of Setting User Profiles, Oracle Applications System Administrator's Guide

Oracle Assets

Assets Revaluation

Set up default revaluation rules for each asset book to control revaluation in Australian Assets. When you save a revaluation, Oracle Assets assigns a mass transaction number to the revaluation. You can report on the transaction numbers for the specific revaluations that you want to control the processing of revaluation and to review the results of previous revaluations.

Defining Revaluation Rules

To comply with revaluation requirements, it is recommended that you set up asset books and revaluation rules in Australian Assets and follow this setup in the Accounting Rules tabbed region of the Book Controls window:

You also need to set rules for revaluing fully depreciated, or reserved, assets at this level. You can override these rules for each revaluation and for each individual asset in the revaluation.

Revaluing Assets

You can override the rules for revaluing fully depreciated assets when you set up a particular revaluation in the Mass Revaluation window.

When you set the revaluation movement percentage for an asset category or individual asset, the percentage should be based on the asset cost and the adjustment needed to move the asset cost to the new revalued amount.

Reporting Revaluation

The standard Oracle Assets reporting is based on each revaluation, not life-to-date revaluation movements for an asset or asset category. The standard revaluation reports are the Mass Revaluation Preview report and the Mass Revaluation Review report.

Use the Australian Assets Revaluation report and the Australian Revalued Asset Sales report for Australian revaluation requirements. For more information, see Australian Assets Revaluation Report and Australian Revalued Asset Sales Report.

Related Topics

Entering Accounting Rules for a Book, Oracle Assets User Guide

Revaluing Assets, Oracle Assets User Guide

Asset Management in a Highly Inflationary Economy (Revaluation), Oracle Assets User Guide

Mass Revaluation Preview and Review Reports, Oracle Assets User Guide

Australian Revalued Asset Sales Report

Use the Australian Revalued Asset Sales report to identify the net revaluation life-to-date movement for an asset category and the net position for the asset's point of sale. You can then record adjustments to the revaluation reserve for that asset and its net category movement via journal entries. This report helps you create manual journals in General Ledger to reflect the movement in the revaluation reserve due to the sale of assets.

The Australian Revalued Assets Sales report displays sales of revalued assets over a period of time, as well as the revaluation balance for an asset category or all asset categories. The report also provides a net revaluation position for the asset category at the start and end date of the period.

Use the Standard Request Submission windows to submit the Australian Revalued Asset Sales report.

Report Parameters

Asset Book

Enter the asset book name.

Category

Enter an asset category or leave the parameter blank to report on all categories.

Start Date

Enter the start date for the asset sales. The start date should be at least the day after the last revaluation for the category. It can be any date since, but should be consecutive over multiple reports to ensure that all sales are reported.

Finish Date

Enter the end date for the asset sales.

Column Headings

This table shows the column headings.

In this column... Oracle Assets prints...
Category The asset category
Asset Number The asset number
Description The asset description
Sale Date The date that the asset was sold
Asset Value The asset's value on the sale date
Total Previous Revaluation The total of the net revaluation movements for the asset on the sale date, reflecting the total revaluation movement at the previous revaluation

Row Headings

This table shows the row headings.

In this row... Oracle Assets prints...
Revaluation Position at start date The total net revaluation movement for all assets in the category at the start date of the report
Asset Sales The asset sales revaluation reserve total of all assets in the category sold during the date range
Adjusted Revaluation Position The adjusted revaluation position:
Adjusted Revaluation Position = Revaluation Position at Start Date - Asset Sales
Revaluations during the period Any revaluations during the period for the asset category
Revaluation Position at end date The total of the revaluation reserve for all assets in the category at the end date:
Revaluation Position at End Date = Adjusted Revaluation Position + Revaluations During the Period
Totals for Sub Category The above row headings for the specified subcategory

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Australian Assets Revaluation Report

Use the Australian Assets Revaluation report to help you post net revaluation movements within each asset category to either the Asset Revaluation Reserve or the Profit and Loss Statement accounts in General Ledger, depending on the previous net movements and postings for that asset category.

The Oracle Assets revaluation process posts the net movement to one account. The Australian Assets Revaluation report provides you with the split of the revaluation movement between the reserve account and the profit and loss account, based on previous movements.

The Australian Assets Revaluation report is a cumulative listing of all revaluations of the assets in the specified book or asset category up to the current revaluation. The current revaluation is reported separately. Only previous revaluations that were completed are included in the report. The separation of previous and current is required to determine the accounting treatment for the current revaluation.

The report is sorted by asset category and lists all assets in the category that were previously revalued or are being revalued in the current revaluation. Disposed assets are not included.

Use the Standard Request Submission windows to submit the Australian Assets Revaluation report.

Report Parameters

Transaction Number

Enter the unique reference number of the revaluation.

Asset Book

Enter the asset book name.

Category

Enter an asset category or leave the parameter blank to report on all categories.

Column Headings

This table shows the column headings.

In this column... Oracle Assets prints...
Category The asset category.
Asset Number The asset number.
Desc The asset description.
Original Cost + Adjusted Cost The original cost of the asset plus any cost adjustments, excluding revaluations.
Previous Revaluations The asset's revaluation reserve before revaluation.
Previous Depreciation Write Back The asset's depreciation reserve before revaluation.
Total Previous Value The asset's cost value before revaluation:
Total Previous Value = Original Cost + Adjusted Cost + Previous Revaluations - Previous Depreciation Write Back.
Cost Revaluation The asset's revaluation amount for the current revaluation.
Revaluation Percent The asset's revaluation rate expressed as a percentage.
New Depreciation Write Back The asset's depreciation reserve after the revaluation.
Revaluation Amount The revaluation amount charged to the revaluation reserve for this revaluation:
Revaluation Amount = Cost Revaluation + New Depreciation Write Back.
The total for each asset category is split between the profit and reserve values. The calculation of the split is based on previous movements of the revaluation reserve.
New Book Value The asset value after the revaluation.
New Revaluation Value The new revaluation reserve:
New Revaluation Reserve = Previous Revaluation + Revaluation Amount.

Row Headings

This table shows the row headings.

In this row... Oracle Assets prints...
<Page Total> The page totals
Profit The amount that you should post to the profit and loss count
Reserve The amount that you should post to the reserve account
Totals The report totals

Related Topics

Running Reports and Programs, Oracle Applications User Guide