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.
The Australian Inventory Internal Charges report lists all stock accounting transactions incurred during a selected period, enabling:
Customers to report on their stock expenditure
Management to review expenditure for selected customers, periods and items
Reconciliation between stock issues and returns against the General Ledger
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.
Enter the earliest date that you want to report on.
Enter the latest date that you want to report on.
Enter the first account that you want to report on.
Enter the last account that you want to report on.
Enter the first item that you want to report on.
Enter the last item that you want to report on.
Enter the category set that you want to report on.
Enter the first category that you want to report on.
Enter the last category that you want to report on.
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
Import Requisitions creates two requisition types:
Purchase Requisitions
Internal Requisitions
Internal requisitions are produced in unit of issue and purchase requisitions are produced in unit of purchase.
Before you can define requisition types, you must:
Set the profile option JA: Australian Materials Management at the responsibility level.
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.
If a single valid shipment line exists for the quotation line, the price will be taken from the shipment line.
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.
If there are no valid shipment lines the price will be taken from the quotation line.
If there is no price on the quotation line, the price will be 0.
A valid shipment line must have:
The same unit of measure as the quotation line
Today's date fall between its effective start date and its effective end date
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.
The four pricing rules are demonstrated in this example. Follow each of the four products through the pricing process.
Rule 1 is demonstrated using product S1000
Rule 2 is demonstrated using product S2000
Rule 3 is demonstrated using product S3000
Rule 4 is demonstrated using product S4000
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 |
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.
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:
Company — Cost Center — Account
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
Use the Australian Automatic Accounting window to define how Import Requisitions generate your account numbers for internal requisitions with a delivery type of Inventory.
Before you can define automatic accounting, you must:
Set the JA: Australian Auto Accounting profile option at the responsibility level.
Set the GL: Ledger Name profile option at the responsibility level to create an Australian automatic accounting rule for this GL ledger.
To define Automatic Accounting:
Navigate to the Australian Automatic Accounting window.
Enter the name of the ledger for which you wish to create your automatic account numbers in the Ledger field.
Enter Replenishment Expense as the account type in the Type field.
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:
MTL_SYSTEM_ITEMS to make AutoAccounting use the item replenishment expense account
MTL_SECONDARY_INVENTORIES to make AutoAccounting use the subinventory replenishment expense account
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
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.
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:
Check the Allow Revaluations check box.
Do not check the Revalue Accumulated Depreciation check box.
Do not check the Amortize Revaluation Reserve check box.
Do not check the Retire Revaluation Reserve check box.
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.
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.
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
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.
Enter the asset book name.
Enter an asset category or leave the parameter blank to report on all categories.
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.
Enter the end date for the asset sales.
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 |
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
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.
Enter the unique reference number of the revaluation.
Enter the asset book name.
Enter an asset category or leave the parameter blank to report on all categories.
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. |
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