This chapter covers the following topics:
As an option to the mandatory perpetual costing system, which uses either the standard or average or FIFO (First-In First-Out) or LIFO (Last-In First-Out) costing methods, Cost Management provides support for two methods of Periodic Costing:
Periodic Average Costing (PAC)
Periodic Incremental LIFO (Last-In First-Out)
Periodic Costing is an option that enables you to value inventory on a periodic basis. There are three principal objectives of Periodic Costing:
To capture actual acquisition costs based on supplier invoiced amounts plus other direct procurement charges required by national legislation or company policy
To capture actual transaction costs using fully absorbed resource and overhead rates
To average inventory costs over a prescribed period, rather than on a transactional basis
You must set up a perpetual costing method (standard or average or FIFO or LIFO) for each inventory organization that you establish in Oracle Inventory. In addition, you have the option to use Periodic Costing.
You can choose to create Periodic Costing distributions and send them to the General ledger after a Periodic Costing run. You can also disable the perpetual costing General Ledger transfer, electing instead to produce accounting entries only after a Periodic Costing run.
Prior to Release 12, the Periodic Cost Processor computed the assembly unit cost based on actual quantities issued to the job, and not Bills of Material (BOM) requirements. You now have the option to adopt BOM requirements in PAC costing. With the functionality for defining an item as lot-based made available in BOM, the Periodic Cost Processor supports lot-based components.
Oracle maintains the perpetual system and the periodic system (if one is enabled) separately and produces separate reports.
You may want to use Periodic Costing if:
You want to incorporate acquisition costs in your inventory valuation, possibly to set standards or update perpetual standard costs.
You are in a country with a fiscal requirement to transact and/or report on inventory costs using one or both Periodic Costing methods.
Periodic Costing lets you cost items from one or more inventory organizations on a periodic basis. This cost is based on invoice price if the invoice is available; otherwise, the purchase price is used for purchased items. For manufactured items, Periodic Costing is the sum of the actual cost of resources and materials consumed.
Acquisition Costing: The Periodic Costing processor uses acquisition costs (including additional charges such as freight, customs, and insurance) to value receipts and returns. If no invoice is matched to the receipt at the time the cost processor is run, the PO price is used. You can view receipts that use PO Cost and make any corrections necessary.
Full Absorption: Using periodic rates cost types, you can create rates that fully absorb resource and overhead costs. The Periodic Cost processor uses these rates to cost Inventory and Work in Process (WIP) transactions.
Shared Periodic Costs: You can share Periodic Costs across a group of inventory organizations within a Legal Entity. Perpetual cost methods for the individual organizations in the legal entity can be a mixture of standard cost and average cost.
Reports: In addition to inventory valuation reports, you can run reports to see the detailed cost of receipts and identify receipts that used the PO price instead of the invoice price.
Flexible use of Cost Methods: You can use either or both Periodic Incremental LIFO and Periodic Average Costing to cost the inventory transactions of a period. You can view the results and produce inventory valuation reports using either method.
Periodic Costing Distributions: You can choose to post periodic distributions or perpetual costing distributions to the General Ledger. While it is not recommended, you could also post both distributions to the General Ledger.
Full absorption of material and resource cost into the final assembly cost: Periodic Costing relieves the remaining job balance into the final assembly cost.
Relieve material charges using predefined (BOM) quantity or actual quantity: Customers can choose to relieve component charges using the quantity defined in the job's bill, or using the actual quantity of components issued to the job.
Scrap Absorption: For Scrap Absorption there are two solutions as follows:
If you choose to have the completion cost derived based on the job’s bill (standard quantity completion algorithm), then you can use the final completion flag to relieve the additional scrap value out of the job.
If you choose to have the completion cost derived based on actual material usage, then the scrap value will be automatically absorbed by completions performed after the scraps.
Support for Material Overhead Absorption Rules for PAC: You can define Material Overhead Absorption Rules for controlling material overhead absorption. See: To define material overhead absorption rules. These rules are respected in PAC as well.
eAM Support in PAC: You can associate eAM-enabled organizations to be included in the cost group setups so that you can use PAC.
You can manually change the periodic cost of an item by performing a periodic cost update.
Periodic Costing provides similar features to perpetual average costing, but with certain restrictions. See Updating Periodic Costs.
In order to use Periodic Costing, the following requirements must be met:
Only one master item organization exists for each organization cost group. Only one master item organization is recommended per database instance.
An organization cost group must be assigned to a single legal entity. A legal entity can contain several organization cost groups.
An inventory organization can be associated with only one organization cost group.
Frozen and average cost types cannot be used for Periodic Costing.
Cost types used for Periodic Costing must be multiorg and non-updatable.
Periodic Rates cost types must be multiorg and updatable.
Cost types used for Periodic Costing cannot be disabled.
Organization cost groups cannot be disabled.
The Actual Cost extension is not allowed for cost derived transactions, WIP Assembly Completion, and WIP Assembly return.
Oracle Bills of Material must be installed.
Cost owned transactions are transactions that carry their own costs and are used to compute an average unit cost, which is applied to cost derived transactions.
Examples:
PO receipt transactions
WIP completion transactions
Interorg transfers between cost groups
WIP labor/resource transactions
Cost-derived transactions are transactions that are transacted at the newly computed average unit cost of the period.
Examples:
Material issues
Issues to WIP
Returns to WIP
Returns from customer
Note: Returns from customer are only cost derived if they have no reference to sales orders. If they do reference sales orders, then they are costed at the original sales order issue cost.
A periodic rates cost type is the cost type that stores the material overhead, resource, outside processing, and overhead rates for a specific legal entity/cost type association. This is similar to the Average Rates cost type in perpetual average costing.
The periodic rates cost type is defined in cost setup like any other cost type. It is associated with a legal entity/cost type using the Org Cost Group/Cost Type Associations window. You can update the periodic rates cost type field. For example, you can update the periodic rates each period. Each legal entity/cost type combination can have its own periodic rates cost type or share a periodic rates cost type. See: Defining Cost Types.
Period end cost layers contain the recorded weighted average cost of all items purchased and produced in a period. Layers will remain in the system permanently.
Delta quantity refers to the net quantity of a year's production. For example, if 10 items were produced, 5 bought and 12 issued, the delta quantity is 3.
Cost Management provides two Periodic Costing methods:
Periodic Average Costing
Periodic Incremental LIFO Costing.
Determine your Periodic Costing methods in setting up. See: Choosing Periodic Cost Method
Oracle Cost Management requires that you use one of the perpetual accounting methods. However, you can choose to post either periodic distributions or perpetual costing distributions to the General Ledger. While it is not recommended, you can also post both distributions to the General Ledger. See: Processing Periodic Cost Distribution
Average Cost
For both Periodic Costing methods, (weighted) average costs are calculated in the following manner:
On a per item basis, within a period, cost owned transactions are costed first. Then the cost-derived transactions are calculated by averaging the accumulated amount and units for the period. This usually means that the system processes receipts into inventory before costing cost-derived transactions such as issues to jobs.
In Periodic Average Costing, the weighted average calculation adds the opening Inventory Value amounts and units to the current period's cost-owned transactions before calculating the cost-derived transaction costs.
Cost-derived transactions change quantities but not item unit costs.
The derived cost and the ending Inventory Value are used as the beginning Inventory Value of the next period.
Periodic item cost is not calculated for each cost-owned inventory transaction. It is calculated only after processing all the cost-owned transactions, which results in posting a variance once, not for every transaction. The application posts a variance only when quantity is zero or the cost is negative (when the Inventory Value is > 0 and Quantity is < 0, or vice versa) after processing all cost-owned transactions. Variance absorbs remaining inventory value, and the inventory value becomes 0.
No variance generated:
PO Receipt of 5 units @ $5 each
RTV of 4 units @ $6
Miscellaneous receipt of 10 units without cost
PO receipt 5@ $5 | Inventory Value 25, Quantity 5 |
RTV of 4@ $6 | Inventory Value 1, Quantity 1 |
Calculate Cost | Periodic Cost 1, Variance 0 |
Misc Receipt 10 | Inventory Value 11, Quantity 11 |
Variance Generated (Quantity = 0)
PO receipt of 5 units @ $5 each
RTV of 5 units @ 4 each
Periodic Cost update: New cost: $6
Miscellaneous receipt of 10 units without cost
Cost Update | Periodic Cost 6, Inventory Value 0 |
PO receipt 5 @ $5 | Inventory Value 25, Quantity 5 |
RTV of 5 @ $4 | Inventory Value 5, Quantity 0 |
Calculate Cost | Periodic Cost 6 (Period Beginning Cost), Variance 5, Inventory Value 0 |
Misc Receipt 10 | Inventory Value 60, Quantity 10 |
Variance Generated (Quantity > 0 , Inventory Value < 0)
PO receipt of 5 units @ $5 each
RTV of 3 units @ $9 each
Miscellaneous Receipt of 10 units without cost
PO receipt 5 @ $5 | Inventory Value 25, Quantity 5 |
RTV of 3 @ $9 | Inventory Value -2, Quantity 2 |
Calculate Cost | Periodic Cost 0, Variance –2, Inventory Value 0 |
Misc Receipt 10 | Inventory Value 0, Quantity 12 |
Variance Generated (Quantity < 0 , Inventory Value > 0)
PO receipt of 5 units @ $5 each
RTV of 6 units @ $4 each
Miscellaneous Receipt of 10 units without cost
PO receipt 5 @ $5 | Inventory Value 25, Quantity 5 |
RTV of 6 @ $4 | Inventory Value 1, Quantity -1 |
Calculate Cost | Periodic Cost 0, Variance 1, Inventory Value 0 |
Misc Receipt 10 | Inventory Value 0, Quantity 9 |
WIP Rework Transactions:
PO receipt of 5 units @ $5 each
RTV of 6 units @ $4 each
Non-rework completion of 3 units @ $6 each
Issue to rework job of 5 units
Completion from rework of 5 units @ $8 each
Miscellaneous Receipt of 10 units without cost
PO receipt 5 @ $5 | Inventory Value 25, Quantity 5 |
RTV of 6 @ $4 | Inventory Value 1, Quantity –1 |
Non-Rework Completion | Inventory Value 19, Quantity 2 |
Cost Calculation | Periodic Cost 9.5, Variance 0, Inventory Value 19 |
Rework Issue | Inventory Value -28.5, Quantity -3 |
Rework Completion | Inventory Value 11.5, Quantity 2 |
Cost Calculation | Periodic Cost 5.75, Quantity 2, Variance 0 |
Misc Receipt | Inventory Value 69, Quantity 12 |
The Periodic Incremental LIFO (last-in first-out) costing method provides support for periodic valuation of inventory for both fiscal and managerial reporting purposes.
With this costing method, the costs of the most recently acquired items are relieved from inventory first. This results in financial statements that match current costs with current revenues.
Periodic Incremental LIFO is useful for situations where the current replacement cost of inventory exceeds historical values.
Note: Periodic Incremental LIFO meets the statutory requirements for Italian manufacturing and distribution companies.
Periodic Incremental LIFO also allows valuation of inventory according to Lower of Cost or Market principles. To do this, you replace the calculated LIFO item cost with the market value, if the market value of an item is lower. The costing information generated can be used to produce detailed and summary LIFO costing reports, where required.
You use the Item Cost Inquiry screen to compare the calculated LIFO item cost with a published market value. See: Making Item Cost Inquiries.
For more information on calculating a LIFO item cost, See: Periodic Incremental LIFO Calculations.
If the market value is less than the calculated LIFO item cost, then you can enter that value along with a mandatory justification. This market value replaces the calculated LIFO item cost for quantities in all period cost layers and in the Incremental LIFO Valuation reports run at this time.
You can update and remove the market value and justification until the period is closed.
The inventory valuation that is carried forward is now based on that market value. Previous layers do not figure in future calculations, but they are not purged, so that you can still run reports from prior periods, for auditing purposes and to maintain historical records of Incremental LIFO quantities.
See: Periodic Incremental LIFO Business Example.
Cost Management calculates Periodic Incremental LIFO in this manner:
Items received into inventory are costed at the weighted average of the period in which they are received.
For any period where items received (purchased or manufactured) exceed items issued (or scrapped), a period cost layer is created to record the weighted average per item and the quantity.
In periods where items issued exceed items received, further issues are then made from prior existing period cost layers in LIFO order.
The inventory value at any point consists of the remaining items in the period cost layers at their average costs (that is, each year's remaining units at the average cost of that period), except where a market value has been used. See: Market Value.
Whenever a period ends with an inventory value of zero, prior period cost layers are no longer used in calculations, but the information remains available for historical purposes.
The LIFO item cost is calculated using an average calculation (inventory value/total quantity) for inventory valuation. The item cost is used for comparison to a potential market value.
Note: The LIFO item cost used for purposes of valuation differs from the item cost that might be removed from inventory.
You can run the cost processors and produce inventory valuation reports using both Periodic Costing methods. If changing Periodic Cost methods is permitted by the accounting rules of your country, you may then decide which report to submit. You can use the two periodic methods simultaneously by associating cost types designated for both Periodic Costing methods, with the same legal entity (See: Selecting an Item/Cost Type Association). To compare the values, run the Acquisition Cost processor, the Periodic Cost processor, and reports for the legal entity, using cost types designated for one method first, and the other method second. In Periodic Costing, the item cost is held at the cost type/organization cost group/period combination.
Using Periodic Costing requires that you first install a perpetual cost method. See Setup
In Periodic Costing, the cost type is associated with the Periodic Costing method. When you run the Periodic Cost processor and choose cost type, you implicitly choose a cost method.
If you enable distributions for a Legal Entity/Cost Type, then associate the same ledger that you used in the perpetual cost type.
If you enable distributions for a Legal Entity/Cost Type, then associate the same ledger that you used in the perpetual cost type.
If you do not enable distributions for a Legal Entity/Cost Type, then you can use a different ledger but the chart of account and currency must be the same as those used in the perpetual cost type.
In Periodic Costing, the item cost is held at the cost type/organization cost group/period combination.
There are six setup steps specific to Periodic Costing:
Defining the organization cost group.
Creating cost types and periodic rates cost types for use in Periodic Costing.
Associating the organization with an organization cost group.
Associating the cost type with the legal entity.
Setting accounting options (required if using Periodic Cost Distributions).
Assigning periodic accounts (required if using Periodic Cost Distributions).
The end result, once all these associations are set up, is a many-to-many relationship between organization cost groups and cost types through the legal entity.
Each organization cost group must be associated with a legal entity.
To define an organization cost group
Navigate to the Organization Cost Group window.
Enter a name for the Org Cost Group.
Enter a description for the Org Cost Group.
Select the legal entity to associate with the Org Cost Group.
Enter the Item Master Organization ID.
Save your work.
Oracle Cost Management Periodic Costing methods require the use of cost types and periodic rates cost types (similar to average rates cost type used in average costing for manufacturing). Both are created in the main setup window for cost types. Cost types for Periodic Costing must be multi-org and not updatable. Periodic rates cost types are not restricted. Any user defined cost type can be a periodic rates cost type if it is so designated in the Cost Type Association tab of the Org Cost Group/Cost Type Associations window.
To create cost types and periodic rates cost types
Navigate to the Cost Types window.
Create cost types and periodic rates cost types.
Cost types must be multi-org and not updatable. If you make these selections, then other options appear available, but are not.
Periodic rates cost types must be multi-org and updatable.
Save your work.
Once an inventory organization is associated with an Organization Cost Group and transactions have been processed, that association is permanent and exclusive.
An Organization Cost Group can be associated with one or more organizations.
Those inventory organizations which can be associated with an organization cost group meet the following qualifications:
The organization already belongs to the legal entity.
The organization is not associated with any other organization cost group.
To associate an organization with the organization cost group
Navigate to the Org Cost Group/Cost Type Associations window.
Select the appropriate legal entity.
Navigate to the Org Cost Group Associations tab.
Select the organization cost group.
Select the organizations you wish to associate with this cost group.
Only those organizations which met the qualifications listed above will be available for selection.
Save your work.
To associate the cost type with legal entity and select cost method
Navigate to the Org Cost Group/Cost Type Association window.
Select the appropriate legal entity.
Navigate to the Cost Type Associations tab.
Select the Cost Type.
Select a value for the Cost Method.
The available values are:
Incremental LIFO
Periodic Average
Select the Ledger.
Select the Periodic Rates Cost Type.
Select the Enable Iterative Periodic Average Costing indicator to enable the Iterative Periodic Average Costing (IPAC) processor at the legal entity and cost type level. If you leave this unchecked, then the application uses the standard periodic cost processor.
See: Iterative Periodic Average Costing (IPAC) and Setting Up Iterative Periodic Average Costing (IPAC).
Select the Material Relief Algorithm indicator to Use Pre-defined Materials, or Use Actual Materials.
If there have been no prior WIP transactions for the chosen Cost Type in all previous periods, then you can use the relief algorithm option to relieve material using the quantity that is actually used, or using the quantity defined in the BOM. If there are WIP related transactions based on actuals, then relief costs for all subsequent transactions cannot be based on BOM. The relief algorithm is only applicable for components. Resource and overhead are always relieved using the actual quantity.
Select the Restrict Documents by Process Upto Date indicator if you want to run partial period processing.
You can run a partial period by entering the date in the parameter Process Upto Date field in the periodic acquisition processors.
Save your work.
If you need to set accounting options, choose Accounting Options and follow the instructions in the next section. See Step 53: Setting Accounting Options
See: Setting Up Iterative Periodic Average Costing (IPAC) for setting the Iterative Periodic Average Costing (IPAC).
Using the Cost Type Associations Accounting Options window, you can set options pertaining to the creation of accounting entries (cost distributions) and posting (transferring) to General Ledger. If you do not Create Accounting Entries, you cannot post to the General Ledger from Periodic Costing, and therefore General Ledger options are unavailable to you.
You can choose to submit the Journal Import at the same time as the transfer to General Ledger or as a separate process.
You can check Allow Override at Program Submission which allows the user to change these options:
Journal Import
Transfer mode (detail or summary) .
To set your accounting options
Navigate to the Cost Type Associations Accounting Options window.
Check Create Accounting Entries if you wish to have Periodic Cost distribution entries created.
If you do not check this option, all the other options are unavailable to you. Exit from this window.
Select an Accounting Library. The options are:
US GAAP
PAC Brazil
Note: Landed Cost Management (LCM) related accounting is only supported for US GAAP.
Check Post entries to GL if you wish to post your Periodic Cost distributions to the General Ledger.
This enables options for additional options.
Make selections on the following options:
Allow Override at Program Submission.
Transfer to GL Interface. Choose one:
In Detail
Summarize by Accounting Date
Summarize by Accounting Period
Submit Journal Import.
Save your work.
This step is required if you are using the Periodic Cost Distributions Processor.
Periodic Cost Accounts are used during Periodic Cost distributions. The periodic accounting library may use these accounts to create accounting entries. Users can only specify these accounts if distribution is enabled for the legal entity cost type. There are two sets of accounts:
Cost group category level accounts: used to perform periodic inventory accounting based on categories defined in the master item organization for the cost group.
Cost group level accounts: used independently of the category to define variance and inventory offset accounts.
To assign periodic accounts
Navigate to Periodic Account Assignments.
Select your legal entity and cost type association.
Select the cost group.
Choose the MTL Account tab to assign accounts for the category.
In the category column, select item family and class.
Select accounts for the following:
Material
Material Overhead
Overhead
Resource
Outside Processing
Expense
Bridging
Non-Invoice Sales orders
Non-Invoiced Revenue
Choose the Cost Group Accounts tab to assign variance accounts.
Select an account for Cost Variance.
Select an adjustment account for Retroactive Price Adjustment Account if you are using the Retroactive Pricing functionality.
This account must be entered in your initial setup only.
Note: The application prevents retroactive price adjustment transactions when the Purchase Order is Landed Cost Management (LCM) enabled.
See: Retroactive Pricing
Enter a Landed Cost Absorption account and a Landed Cost Variance account when Landed Cost Management (LCM) is enabled for any of the inventory organizations that belong to PAC Cost Groups.
Save your work.
You can choose the Open button in the MTL Accounts tab to view the accounts in list format.
Note: Accounts are required when Landed Cost Management (LCM) is enabled for any of the inventory organizations that belong to the PAC cost group.
The following list is the procedure for processing Periodic Costs:
Optionally, for invoices matched to receipts of closed periods, you can submit the Periodic Acquisition Cost Adjustment Processor
Optionally, you can run the Periodic Cost Distributions Processor
Perform any other required activities such as cost copy, item cost inquiry, and Periodic Cost update
Run Reports
Partial Period Runs
You can submit the Periodic Acquisition Cost Processor, the Periodic Acquisition Cost Adjustment Processor, and the Periodic Cost Processor for the whole period or a partial period. A partial period run must always begin with the first day of the period. Any further partial period runs, or a complete run (the whole period) must also start with the first day of the period. Any processing runs after the first one will repeat the others in a specific period.
To enable this option, check the box for Restrict Documents by Process Upto Date on the Org Cost Group/Cost Type Associations window. You can run a partial period by entering the date in the parameter Process Upto Date. In order to complete processing and close the period, The entire period must be run for all cost groups in a legal entity. See: Associating Cost Type with Legal Entity
The Periodic Acquisition Cost Processor computes acquisitions from Oracle Purchasing and Oracle Payables. This concurrent program calculates costs of the receipt using the invoice price, or, if that is not available, the purchase order price.
Acquisition costs are the sum of the costs associated with the acquisition of the goods. They include material costs, freight, special charges, and non-recoverable taxes. The acquisition cost processor processes all receipt transactions that take place within a period for a particular cost group and cost type.
Note: When Landed Cost Management (LCM) is enabled, acquisition cost is based on landed costs computed by LCM product for the corresponding LCM enabled PO receipt.
For each receipt, the net quantity received is frozen at the end of the period. The costs are frozen based on the invoices matched to the receipt at the time of period close.
Resubmitting the Acquisition Processor
Acquisition processing can be resubmitted if additional matching invoices are received, provided the period is still open. If the period is closed, manual updates are made using the Periodic Cost Update program.
Resubmitting the Periodic Acquisition Cost Processor purges prior processing, including cost processor computations, accounting distribution entries, reconciliation information, and write off information.
Exchange Rates and Acquisition Costs
Exchange rates are handled in the following manner:
If the invoice is used, then the exchange rate at the invoice time is used.
If purchase order price is used and the match option is set to Match to PO, then the exchange rate at the time of the purchase order is used.
If purchase order price is used and the match option is set to Match to Receipt, then the exchange rate at the time of the receipt is used.
To run the Periodic Acquisition Cost Processor
Navigate to Periodic Acquisition Cost Processor concurrent window. The Parameters window displays.
Select information in the following parameters:
Legal Entity
Cost Type
Period
Process Upto Date - If you want to create a partial period run, enter the date for limiting records in the submission
Cost Group
The Run Option field is used when you want to regenerate a run that has started. Your options are:
Start - Regenerates the Periodic Acquisition Cost Processor concurrent program.
Resume - This option is only available when the processor is stopped because of errors. It enables you to resume the program from the beginning phase, to the phase where the error began.
Choose OK.
Choose Submit on the Request window to process this request.
You can transfer costs generated in closed accounting periods to your current open period. The invoice for a receipt in a closed period is used to generate a periodic cost update in the open period. Examples of such invoices from previous periods can include invoice price variances, and charges such as freight and tax. The new acquisition cost calculated represents what the acquisition cost would have been if the invoices had been received in the same period. Acquisition cost adjustments enable you to:
Create periodic cost update transactions to adjust the acquisition cost for a closed period
Use invoice accounting date to restrict invoice eligibility, and transaction date for return to vendor eligibility when you run the program
Run the Periodic Acquisition Cost Processor for historical periods
The Acquisition Cost Adjustment Processor can be continually resubmitted for the period that is open. Every time the Acquisition Cost Adjustment Processor is submitted, the amount posted is recalculated and the data for the latest run is retained. The data for previous run is deleted.
Note: The Acquisition Cost Adjustment Processor is not used for LCM enabled Purchase Orders.
To run the Periodic Acquisition Cost Adjustment Processor
Navigate to Periodic Acquisition Cost Adjustment Processor concurrent window. The Parameters window displays.
Select information in the following parameters:
Legal Entity
Cost Type
Period
Process Upto Date - If you want to create a partial period run, then enter the date for limiting records in the submission
Cost Group
Run Option - You can run the program for All Invoices, Particular Invoice, or Particular Receipt
Parent Receipt - This is the original receipt number before corrections were submitted
Invoice Number
Adjustment Account
Choose OK.
Choose Submit on the Request window to process this request.
The Periodic Cost Processor calculates the Periodic Cost for all asset items in asset subinventories. The Periodic Cost processor is run manually, by submission, not automatically.
The Periodic Cost Processor can be run using either the Periodic Average or Incremental LIFO algorithm. You can define different cost types for each and associate them with one appropriate cost method.
To run the Periodic Cost Processor
Navigate to Periodic Cost Processor concurrent window. The Parameters window displays.
Select information in the following parameters:
Legal Entity
Cost Type
Period
Process Upto Date - If you want to create a partial period run, then enter the date for limiting records in the submission
Cost Group
The Run Option field is used when you want to regenerate a run that has started. Your options are:
Start - Regenerates the Periodic Cost Processor concurrent program.
Resume - This option is only available when the processor is stopped because of errors. It enables you to resume the program from the beginning phase, to the phase where the error began.
Choose OK.
Choose Submit on the Request window to process this request.
The Periodic Cost Distributions Processor uses the accounts set up in Periodic Account Assignment to create accounting entries (distributions) which are copied to the manufacturing subledgers.
When Landed Cost Management (LCM) is enabled, accounting entries are generated based on landed costs for LCM enabled PO receipts. Unlike other PO receipt transactions, the difference between acquisition cost (calculated from Landed Cost) and PO price goes into the Landed Cost Absorption account instead of the IPV or ERV account.
Separate accounting events that include PAC Landed Cost Adjustment – Receipt, and PAC Landed Cost Adjustment – Delivery, are created from the perpetual landed cost adjustment transactions when the latest perpetual landed cost adjustment transactions are within the current PAC period for which the parent PO receipts are in the previous PAC period.
PAC Landed Cost Adjustment – Receipt, and PAC Landed Cost Adjustment – Delivery accounting events are not created when perpetual landed cost adjustment transactions are in the current PAC period for which parent PO receipts are also in the same PAC period.
When LCM is enabled, the application creates PAC Accounting Distributions for the new accounting events:
PAC Landed Cost Adjustment – Receipt
PAC Landed Cost Adjustment – Delivery
Options for the distribution processor are set in the Cost Type Associations Accounting Options window, which is chosen from the Cost Type Associations tab of the Org Cost Group/Cost Type Associations window. See: Setting Accounting Options.
Note: To use Periodic Distributions, your ledger for the cost type must be the same as for the perpetual costing method.
To run Periodic Distributions
Navigate to Periodic Cost Distributions concurrent window. The Parameters window displays.
Select the following parameters.
Legal Entity
Cost Type
Cost Group
Period
Choose OK.
Choose Submit on the Request window to process this request.
In the Item Cost Inquiry window, you can list items by the following:
Cost Group
Cost Type
Period
This window includes fields for entering market values and justifying the market values to be used with the Incremental LIFO costing method. These fields still appear when the method is periodic average costing, but are ignored.
Note: You must specify values for Legal Entity, Organization Cost Group, Cost Type, and Period in the Find Window (mandatory). Additionally, you can choose options for Item Category, Item Range, or Particular Item.
Entering Market Values (Incremental LIFO)
You can view the calculated inventory item cost per period in the Item Cost Inquiry window. Also, you can run and review the Incremental LIFO Valuation report.
If the market value of an item is less than the calculated LIFO item cost, then you may manually enter that value along with a mandatory justification. The market values replaces the LIFO item cost. You may update and delete the market value and it's justification while the period is open.
The Incremental LIFO Valuation report calculates the Inventory Value using the formula:
Inventory Value = Total Item Quantity x LIFO item cost |
If you enter a market value, the report uses this calculation:
Inventory Value = Total Item Quantity x Market Value |
For that particular point in time, this market value is applied to accumulated items. The totals for that point in time will be carried forward and calculated using the previous formula, considering the market value as if it were an item cost.
To perform an item cost inquiry or enter a market value
Navigate to the Item Cost Inquiry window.
Query for desired cost item information, including LIFO item cost for possible entry of market value in the current period.
Enter a market value in place of the LIFO item cost if it is appropriate.
Save if you have entered a market value.
See: Periodic Incremental LIFO and Periodic Incremental LIFO Business Example
The Viewing Material and Receiving Transactions window enables you to view those transactions, per cost type, that have been:
Processed by the Periodic Cost processor and the Periodic Acquisition processor
Distributed using the Periodic Costing Transfer to General Ledger. See: Transferring to General Ledger.
Transactions that have not been processed and distributed cannot be viewed.
These same transactions are viewable in the perpetual system.
Note: This feature differs from the corresponding feature in perpetual costing, in that you view transactions by organization and cost type. Perpetual costing is limited to the default cost type for the costing method (standard or average). For a discussion of the perpetual system feature, See: Viewing Material Transaction Distributions.
A transaction from receiving to inventory appears twice since it is both a receiving and an inventory transaction.
To view Material and Receiving Transactions
Navigate to Material and Receiving Transactions. The Find Transactions window appears.
Enter search criteria in the Find Transactions window.
Choose Find to initiate the search.
The Material and Receiving Transactions window displays six tabs:
Location
Intransit
Reason, Reference
Transaction ID
Transaction Type
Receipt Transaction
Note: You can view the accounting debits and credits, and the T-accounts from the Tools menu.
You can view WIP transactions from the Periodic Costing View WIP Transactions window.
If distributions were run, view by cost type.
For a discussion of the corresponding perpetual system feature, See: Viewing WIP Transaction Distributions.
To view WIP transactions
Navigate to WIP Transactions. The Find WIP Transactions window appears.
Select the following required criteria:
Legal Entity
Cost Group
Enter any additional optional criteria.
Choose Find to initiate the search.
The WIP Transactions window displays five tabs:
Job or Schedule Header
Operation, Quantities
Resource Information
Transaction Comments
Project
Note: You can view the accounting debits and credits, and the T–accounts from the Tools menu.
Periodic Accounting Periods displays accounting periods for the legal entity and the cost type, along with the status of the periods.
Unopened periods are labeled future. A period can be changed to open only if there are no other open periods. The current period is the open period in the Periodic Costing calendar for the cost type. Before the period can be closed, all cost groups associated with a legal entity must be processed by the acquisition cost processor and the Periodic Cost processor.
Before closing a period validate that:
All cost groups have been successfully processed up to the last phase (either the cost processing phase or the distribution phase, as the case may be).
No backdated transactions have been performed in any cost group since the last time the cost group was processed.
There are no pending transactions for the period in Inventory, Work in Process, or Receiving for the cost group.
There are no pending Landed Cost Adjustment interface records if any of the inventory organization is enabled with LCM.
The perpetual periods are closed.
The A/P period is closed.
Note: A period cannot be closed if only a partial period has been processed.
The A/R period is closed.
Note: The A/R period must be closed before the Costing period can be closed. The period cannot be closed until the concurrent request Create COGS Recognition Events is run to clear all events that may fall into the period you are trying to close.
For those periods with a status of open, processing status can be viewed from a window on the Periodic Accounting Periods window.
Accounting Period Status
The available statuses for a period are:
Future: Can not be changed back.
Open: Can only be opened if the previous period is closed and there are no other open periods. Can only be changed to closed.
Closed: Can only be changed to closed if the previous period is closed. Can only be changed to closed if the perpetual period has been closed. Cannot be changed.
Processing: Cannot be changed until processing is completed.
Error: Cannot process until the error is corrected.
Processing Status
The Process Status window shows any organization cost groups that are unprocessed by either the acquisition processor, Periodic Cost processor, or periodic distributions processor. Possible process statuses are:
Unprocessed: Unprocessed.
Complete: Fully processed.
Error: Cannot process until the error is corrected.
To view or change the status of periodic accounting periods
Navigate to the Periodic Accounting Periods window.
Select the legal entity and cost type.
Choose Change Status and select one of the following options:
Change future to open
Change open to closed
This activates the period close program.
Choose Process Status to view the current processing status of the period.
If necessary, close Periodic Accounting Periods, complete any necessary processing, and begin again.
Save your work.
Note: If the distribution option is enabled for a legal entity cost type, the General Ledger transfer should be run after period close.
The application performs a validation to check for pending Landed Cost Adjustment interface records. The PAC period cannot be closed until the inventory period is closed. Inventory period can be closed only when all pending transactions, including landed cost adjustment interface records, are cleared.
You can transfer your cost distributions to the General Ledger if you have checked the Post Entries to GL check box in the Cost Type Associations Accounting Options window. You have the option of transferring your cost distributions to the General Ledger for either Periodic or perpetual costing, or both.
However, Cost Management warns you of the possibility of inadvertently transferring both distributions to the General Ledger. The warning displays if there is at least one legal entity-cost type combination that has the Periodic Cost Post Entries to GL option checked, where the organization under that legal entity also has the perpetual cost GL transfer enabled.
For a discussion of General Ledger transfers in perpetual costing, See: Transfer Transactions to General Ledger.
To transfer Periodic Cost distributions to the General Ledger
Navigate to Transfer to General Ledger.
Select Transfer Periodic Cost Distributions to GL.
Select the following parameters:
Legal Entity
Cost Type
Period
Batch Name (Optional)
The system generates a batch name from the journal entry source, the Request ID, the group ID, and the Actual Flag (A (actual), B (budget), or E (encumbrance). If you wish, you can enter a name for your journal entry for easy identification. The system uses this name as the prefix to the generated name.
GL Transfer Mode
There are three choices:
In Detail
Summarized by Accounting Date
Summarized by Accounting Period
Submit Journal Import
Select Yes or No to determine whether the Journal Import is submitted during posting or later.
Choose Submit.
You can use the Periodic Accrual Write-Off window to write off entries that have accrued but have not been removed from the Periodic Accrual Reconciliation report because of problems such as:
Differences in quantities between receipts and invoices
Discrepancies in Supplier billing
Errors in Purchase Order to Purchase Order line matching
Inventory or WIP transactions posted to incorrect accrual accounts
You should run and review the Periodic Accrual Reconciliation Report and determine which transactions need to be written off. This report is run for a legal entity, cost type, cost group, period, and source. See: Periodic Accrual Reconciliation Report
The Accrual Write-Off function permits you to list a reason for the write-off and change the date from the system default to any date in the current accounting period.
To make an accrual write-off
Navigate to Accrual Write-Offs. A Find Write-Offs window appears.
In the Find AP and PO Write-Off Candidates, Find Miscellaneous Write_Off Candidates, or Find Write-Off Transactions windows, select an Operating Unit from the list of values (required).
Enter additional search parameters (optional).
Enable the following, if desired:
AP-PO Write-Offs Only
Miscellaneous Write-Offs Only
Click the Find button to initiate the search.
Select the Write-off checkboxes for those transactions that you want to write off.
Enter any reasons and comments.
Save your work.
You can copy costs from one Periodic Cost type to a destination perpetual cost type. For instance, you can copy your Periodic Cost ending balances to your standard cost beginning balances of the following period.
In order to use the copying Periodic Costs feature, the following conditions must be met:
The destination cost type must be multi-org.
The period for which costs are being copied has been processed successfully.
Appropriate unit of measure conversions must be made for copying cost from master item organization to individual child organization, since costs in CPIC are stored based on master item organization's primary unit of measure.
To copy costs from a Periodic Cost type to a managerial cost type
Navigate to Copy Periodic Costs.
Select Copy Item Period Cost.
Select the following parameters:
Legal Entity
Cost Type
Cost Group
Period
To Organization
To Cost Type
Material Subelement
Material Overhead Subelement
Resource Subelement
Outside Processing Subelement
Overhead Subelement
Copy Option
Range
Specific Item (Optional)
Category Set (Optional)
Specific Category (Optional)
Submit request.
Oracle Periodic Cost Open Interface provides an open interface for you to load Periodic Costs transactions from external applications or legacy systems and then import them into Cost Management.
If you have entered beginning balances for Periodic Costs using the Periodic Cost Open Interface, you can then import those costs using the Import Periodic Cost feature.
Note: This feature is only available for importing beginning balances and does not work after new transactions have been entered.
To import Periodic Costs
Navigate to Import
Select Period Cost Import Manager
Select a parameter for:
Delete Interface Rows After Import
Submit the request
Update Periodic Costs must be run for any items that have been updated using the average cost update. The main use of the Periodic Cost update is to update Invoice Price Variances (IPVs) that have been updated by average cost update.
Periodic Costing provides the same three types of updates as average costing, but with more restrictions on when the updates may be performed, as described below:
Percent Change: changes the periodic item cost by a given percentage. Performed at the beginning of the period.
New Periodic Cost: replaces the periodic item cost with the specified amount. Performed at the beginning of the period.
Inventory Value Change: changes the inventory values with a specified amount. Performed after all cost owned transactions and before any cost derived transactions.
Changes in the Update Periodic Cost window for all three types of updates is applied only against the Material Cost Element, and is not automatically proportioned across all cost elements and levels.
The first two types of updates are performed as the first transaction of the period. These types of updates overwrite beginning balances. The % change is mainly used in the event of a currency fluctuation. The new Periodic Cost is generally used to bring in beginning balances or where a legacy system did not come up with good results.
The inventory value change is performed after all cost owned transactions and before any cost derived transactions. It is generally performed to allow for unmatched invoices or for additional overhead or resources for a make item.
Note: You can also create Periodic Cost Update transactions using the following open interface tables:
MTL_TRANSACTIONS_INTERFACE
MTL_TXN_COST_DET_INTERFACE
Periodic cost updates for New Periodic Cost, Percent Change, and Inventory Value Change transactions are supported and are valid transactions that are created using Oracle open interface tables.
For additional detail on updating Periodic Costs, review the section on Average Cost Update (even if you are a standard cost user). See: Updating Average Cost.
To update Periodic Costs
Navigate to the Update Periodic Cost window.
Enter the following parameters:
Legal Entity
Cost Type
Org Cost Group
Transaction Date
Item Master Organization
In the Transaction Change tab, enter the following:
New Periodic Cost
% Change
Inventory Value Change
Adjustment Quantity
You can enter the adjustment quantity for Periodic Cost Update - Value Change.
If the on-hand at the time of cost processing is greater than the user-entered Adjustment Quantity, then the entire value change is applied to inventory valuation.
If the on-hand is less than the user-entered Adjustment Quantity, then only the proportionate value change is applied to the on-hand quantity. Inventory valuation is performed for the on-hand quantity based on proportionate value change. The left-off value goes to the Expense account that you specify.
Adjustment Quantity can be entered only for Periodic Cost Update - Value Change transactions. Adjustment Quantity cannot be entered for Periodic Cost Update - New Cost or percentage transactions.
Select the Accounts tab and enter the following accounts:
Material
Material Overhead
Resource
Outside Processing
Overhead
Expense - enter if Adjustment Quantity is specified
Enter a change in item cost or value.
Enter an Adjustment Quantity for Landed Costs.
Click the Cost Elements button to view Update Periodic Cost Details.
Save your work.
The following three tables present different possible scenarios for XYZ company's inventory of material x using Periodic Incremental LIFO.
Example 1 describes basic Periodic Incremental LIFO calculations.
Period | Delta Qty. | Weighted Average for year | LIFO Calculations: yearly quantities remaining at Weighted Average |
LIFO Item cost (total inventory/total quantity) |
1995 | +5 | 20 | 1995 5 * 20 =100 | 100/5 =20 |
1996 | +5 | 23 | 1995 5 * 20 =100 1996 5 * 23 =115 Total Qty. 10 Total Inv. 215 |
215/10 =21.5 |
1997 | -4 | 24 | 1995 5 * 20 =100 1996 1 * 23 = 23 Total Qty. 6 Total Inv. 123 |
123/6 =20.50 |
1998 | +3 | 25 | 1995 5 * 20 =100 1996 1 * 23 = 23 1998 3 * 25 = 75 Total Qty. 9 Total Inv. 198 |
198/9 =22 |
In the first year (1995), XYZ company purchased 100 units of material x. Five units (the delta) remain at the end of the year, and their various costs average out to 20.
Because there is only one year to consider, the total quantity is the same as the delta quantity for the year and the weighted average item cost is the same as the LIFO item cost. At the end of the year, the 5 remaining units constitute the initial LIFO period cost layer.
A new layer for 1996 of 5 units at weighted average cost 23 is added. Since the delta for the year is positive, the 1995 layer remains unchanged.
The LIFO item cost equals the total inventory divided by the total quantity.
In 1997, since the quantity on hand decreased by 4 units, no new layer is created for the year and the last 4 units were subtracted from the most recent year, 1996, at the weighted average cost of 23.
With a positive delta, a new layer for 1998 is added and the previous layers remain unchanged.
Example 2 describes when total inventory is depleted.
Period | Delta Qty. | Weighted Average for year | LIFO Calculations: yearly quantities remaining at Weighted Average |
LIFO Item cost (total inventory/total quantity) |
1995 | +5 | 20 | 1995 5 * 20 =100 | 100/5 =20 |
1996 | +5 | 23 | 1995 5 * 20 =100 1996 5 * 23 =115 Total Qty. 10 Total Inv. 215 |
215/10 =21.5 |
1997 | -10 | 24 | Total Qty. 0 Total Inv. 0 | N/A |
1998 | +3 | 25 | 1998 3 * 25 = 75 Total Qty. 3 Total Inv. 75 |
75/3 =25 |
In 1997, all units in inventory were issued. The total inventory valuation is 0.
If the total inventory is depleted, as in 1997, then the range of periods that are included in calculations restarts with the next period that includes a positive total inventory balance. The effect is seen in 1998, where only period cost layers for 1998 are used for calculation. Subsequent calculations will include period cost layers for 1998 and forward until the next time that the total inventory is depleted.
Example 3 illustrates a situation where a market value is used.
Period | Delta Qty. | Weighted Average for year | LIFO Calculations yearly quantities remaining at Weighted Average Or new market value and inventory |
LIFO Item cost (total inventory/total quantity) or new market value |
1995 | +5 | 20 | 1995 5 * 20 =100 | 100/5 =20 |
1996 | +5 | 23 | 1995 5 * 20 =100 1996 5 * 23 =115 Total Qty. 10 Total Inv. 215 |
215/10 =21.5 |
1997 | -4 | 24 | new market value 20.25 Total Qty. 6 Total Inv. 6 * 20.25 = 121.50 |
new market value 20.25 |
1998 | +3 | 25 | 1997 6*20.25 = 121.50 1998 3 * 25 = 75 Total Qty. 9 Total Inv. 196.50 |
196.50/9 =21.83 |
In the year 1997, the market value (20.25) is lower than the calculated LIFO item cost of 20.50 (see calculation in Example 1). This market value replaces the LIFO item cost in the 1997 and prior period cost layers.
Note: Period cost layers are removed from the above tables for the purposes of explaining the calculations; however, they still remain in the system for possible auditing purposes.
See: Periodic Incremental LIFO and Making Item Inquiries
The following reports are available in Periodic Costing:
The PAC eAM Report for Estimates and Actuals displays the estimates versus actuals bucketed into the EAM cost elements.
In the Submit Requests window, select the report name.
Legal Entity
Select a legal entity
Cost Type
Select a cost type
Cost Group
Select an organization cost group
From Work Order
Select a beginning work order
To Work Order
Select an ending work order
Range
Select a work order range. You can specify all work orders, specific work orders, or a range of work orders.
Use this Periodic Costing report to analyze the acquisition cost for each receive transaction.
In the Submit Requests window, select the report name.
Choose one of the following options:
Sort Options
receipt number | Purchase Order Receipt Number |
receipt line | Purchase Order Receipt Line Number |
parent distribution id | Invoice Distribution ID matched to the Receipt |
distribution number | Distribution Line Number |
Legal Entity
Select a legal entity
Cost Group
Select an organization cost group
Cost Type
Select a cost type
Period
Select a period
Item From / To (Optional)
To restrict the report to a range of assembly items, select a beginning and an ending item.
Use this report to view the final results of the Periodic Incremental LIFO calculation process. The report is used for fiscal purposes. The information in the report is added to the balance sheet as the inventory valuation at the end of the fiscal year.
In the Submit Requests window, select the report name.
Report Option
Choose one of the following options:
Detail | Report the item costs by item and period. |
Summary | Report the item cost of each item in the current period. |
Legal Entity
Select a legal entity
Cost Group
Select an organization cost group
Cost Type
Select a cost type
Period
Select a period
Item From / To (Optional)
To restrict the report to a range of items, select a beginning and an ending item.
See: Periodic Incremental LIFO and LIFO Business Example
Use this report to view detailed accounting entries in A/P accrual accounts for certain legal entity, cost type and organization cost group in a period.
The report is available in two versions:
Periodic Accrual Reconciliation Report
Periodic Accrual Rebuild Reconciliation Report
The Periodic Accrual Rebuild Reconciliation Report collects all accounting entries from appropriate subledgers and stores them in a temporary table. This accounting information resides in a temporary table and remains until you rebuild this information again.
The Periodic Accrual Reconciliation Report uses the information stored in the temporary table by the last Periodic Accrual Rebuild Reconciliation Report. When you specify Accrual Reconciliation Report, the report does not reselect this information. Instead, it merely reports using the pre-existing information. This feature saves you time, because you do not have to recreate the accrual information every time you submit a report. Typically, you specify the Accrual Rebuild Reconciliation Report at month end and use the Accrual Reconciliation Report for interim reports.
With the Application Technology Multi-Organization Access Control (MOAC), the SRS window for this report includes an Operating Unit List of Values that lists the Operating Units attached to the Responsibility’s Security Profile.
In the Submit Requests window, select the report name. You can choose either report. The parameters are the same.
Sort By
Choose either of the following options:
Item
Vendor
Title (Optional)
Enter a title
Legal Entity
Select a legal entity
Cost Type
Select a cost type
Cost Group
Select an organization cost group
Period
Select a period
Items From / To (Optional)
To restrict the report to a range of items, select a beginning and an ending item.
Vendors From / To (Optional)
To restrict the report to a range of vendors, select a beginning and an ending vendor.
Include All Transactions
Enter Yes or No to indicate whether you want to print zero balance purchase order line subtotals on the report. The report adds up all receipts and invoices by purchase order line. When you specify Yes and the net purchase order line amount is zero, the report prints all receipt or invoice entries for that line. When you specify No, the report considers the Transaction Amount Tolerance and Transaction Quantity Tolerance parameters. When you choose the Accrual Rebuild Reconciliation Report, the default is No. When you choose the Accrual Reconciliation Report, the default is Yes.
Tip: To minimize the size of the report, you should specify No for this option. However, if you want to see all accrual entries, you should specify Yes.
Transaction Amount Tolerance
If you selected No for Include All Transactions, specify the net amount below which purchase order line transactions are not included in the report.
Transaction Quantity Tolerance
If you selected No for Include All Transactions, then specify the net quantity below which transactions are not included. This condition is checked only if the transaction amount tolerance is satisfied.
Dynamic Quantity Precision
Select the quantity precision.
Include Written Off Transactions
Enter Yes or No to indicate whether you want to print written off entries on the report. When you specify Yes, an asterisk appears in the far right column to indicate a written off transaction. By selecting No, you decrease the report size. The default is No.
Aging Number of Days (Optional)
Enter the number of days you would like the report to group information. For example, if you enter 60, for 60 days, then the report first groups all purchase order lines that have the earliest transaction date in the past sixty days, and then groups the next set of lines with the earliest transaction date from 60 to 120 days, and so on. If you do not specify a number, then the report displays all receipts and invoices together. This report parameter helps you separate your older activity from your current activity. When you enter a number of days, a subheading appears on the report to indicate the to and from range of days for each group of information.
See: Writing Off Accruals
Use this report to list details for each Accrual Write-off Account Number. The details listed include the item number, PO Number, Source, organization, accrual amount, date, transaction quantity, unit price, and write off reason.
All the transactions that have been chosen for write off will be queried and presented in the report based on your criteria.
With the Application Technology Multi-Organization Access Control (MOAC), the SRS window for this report includes an Operating Unit List of Values that lists the Operating Units attached to the Responsibility’s Security Profile.
In the Submit Requests window, select the report name.
Legal Entity
Select a legal entity
Cost Type
Select a cost type
Cost Group
Select an organization cost group
Period
Select a period
Reason Code (Optional)
Enter a reason code
Title (Optional)
Enter a title
Print Comments (Optional)
Yes / No to print comments
Use this report to value inventory at the end of a period. This report is run for a particular legal entity, cost group, period, cost type, and category set combination.
In the Submit Requests window, select the report name.
Report Options
Choose one of the following options:
Detailed | Displays elemental costs |
Summary | Summarizes elemental costs |
Sort Options
Item | Sort by item name. |
Category | Sort by category, then by item name within the category. |
Legal Entity
Select a legal entity
Cost Type
Select a cost type
Period
Select a period
Cost Group
Select an organization cost group
Item From / To (Optional)
To restrict the report to a range of items, select a beginning and an ending item.
Category Set
Select a category set. The value of all items associated with this category set are reported. The category set defined for the costing functional area is the default.
Category From / To (Optional)
To restrict the report to a range of categories, select a beginning and an ending category.
Currency
Select a currency. You can run this report for any defined currency. When you enter a currency other than your ledger currency, the system converts item costs to the selected currency using the End of period rate you choose in the Exchange Rate field.
Exchange Rate
Choose an exchange rate. If you choose a currency other than your ledger currency, the most recent End of period rate is the default. However, you can choose any prior End of period rate.
Use this report to outline the periodic item cost calculation in a given period for an item.
In the Submit Requests window, select the report name.
Legal Entity
Select a legal entity
Cost Type
Select a cost type
Period
Select a period
Cost Group
Select a Cost Group
Category Set
Select a category set. The value of all items associated with this category set are reported. The category set defined for the costing functional area is the default.
Category Organization
Select the Category Organization
Category From / To (Optional)
To restrict the report to a range of categories, select a beginning and an ending category.
Item From / To (Optional)
If you selected Range of items in the Item Range field, select beginning and ending Item From and To values.
Use this report to view the value of jobs in an organization cost group at the end of a period. You can also view cost element level information that includes beginning balance, costs incurred, costs relieved, and ending balance.
In the Submit Requests window, select the report name.
Report Option
Period To Date | Report the value of jobs/schedules resulting from the activity in the specified period. Those values are displayed in the Beginning Balance, Cost Incurred, Cost Relieved, Variance Relieved and Ending Balance columns. The Ending Balance column displays the net total value at the end of the specified period. |
Cumulative To Date | Report the net total value of jobs/schedules resulting from all activity up to the end of the specified period. |
Legal Entity
Select a legal entity
Cost Type
Select a cost type
Period
Select a period
Cost Group
Select an organization cost group
Class Type (Optional)
Choose one of the following accounting class options:
Asset non-standard | To report costs for asset non-standard jobs. |
Expense non-standard | To report costs for expense non-standard jobs. |
Repetitive | To report costs for repetitive assemblies. |
Standard discrete | To report costs for standard discrete jobs. |
Job/Schedules From/To (Optional)
To restrict the report to a range of jobs or repetitive schedules, enter a beginning and ending job/repetitive schedule. You cannot specify a job/schedule range unless you first enter a value in the Class Type field.
For repetitive schedules, you are actually entering a repetitive assembly value, such as an item number. For discrete jobs, you are entering a job name.
Assemblies From/To (Optional)
To restrict the report to a range of assemblies, enter a beginning and an ending assembly. You cannot specify an assembly range unless you first enter a value in the Class Type field.
If you are reporting values for repetitive schedules, you do not need to enter both a job/schedule and assembly range unless you changed a repetitive assembly item number since you defined your repetitive assembly.
Currency Code
Enter the currency code in which you want to report your WIP inventory values. The system defaults the ledger currency from the ledger associated with your organization.
Exchange Rate
Choose an exchange rate. If you choose a currency other than your ledger currency, the most recent End of period rate is the default. However, you can choose any prior End of period rate.
Use this report to view material and receiving transaction accounting distributions summarized.
In the Submit Requests window, select the report name.
Legal Entity
Select a legal entity
Sort By
Choose one of the following sort options:
account and item
account and transaction type
account and source type
Organization Cost Group
Select an organization cost group
Cost Type
Select a cost type
Period
Select a period
Account From/To (Optional)
To restrict the display of accounting distributions, select a range of accounts.
Use this report to view detailed accounting distribution information of both material transactions and receiving transactions.
In the Submit Requests window, select the report name.
Sort Options
Choose one of the following sort options:
Account
Account and item
Item and account
Legal Entity
Select a legal entity
Cost Group
Select an organization cost group
Cost Type
Select a cost type
Period
Select a period
Accounts From/To (Optional)
To restrict the range of accounts, enter a beginning and an ending account.
Category Set (Optional)
Select a category set. The value of all items associated with this category set are reported. The category set defined for the costing functional area is the default.
Categories From/To (Optional)
To restrict the report to a range of categories, select a beginning and an ending category.
Items From/To (Optional)
To restrict the report to a range of items, select a beginning and an ending item.
Values From/To (Optional)
Enter beginning and ending transaction values to restrict the report to a range of transaction values.
Note: When you use this option, the report evaluates the transaction amounts in absolute value. Therefore, if you enter a from value of 100, the report selects all transactions with positive (debit) or negative (credit) values greater than or equal to 100. If you enter a to value of 100, the report selects all transactions with positive or negative values less than or equal to 100.
Transaction Source Type (Optional)
Choose one of the following options. In addition to the predefined source types listed below, you may have additional user-defined source types.
Account | Report general ledger account transactions. |
Account alias | Report account alias transactions. |
Cycle Count | Report cycle count transactions. |
Internal order | Report internal order transactions. |
Internal Requisition | Report internal requisition transactions. |
Inventory | Report inventory transactions. |
Job or Schedule | Report job or repetitive schedule transactions. |
Physical Inventory | Report physical inventory transactions. |
Purchase order | Report purchase order transactions. |
RMA | Report return material authorization transactions. |
Sales order | Report sales order transactions. |
Standard cost update | Report standard cost update transactions. |
Sources From/To (Optional)
Enter the beginning and ending source values to restrict the report to a range of source values for the transaction source type you specified.
Transaction Type (Optional)
Choose to display by transaction type or transaction source type.
Transaction Reason (Optional)
Enter a beginning and an ending transaction reason to restrict the report to a range of transaction reasons.
Currency
Select a currency. You can run this report for any defined currency. When you enter a currency other than your ledger currency, the system converts item costs to the selected currency using the End of period rate you choose in the Exchange Rate field.
Exchange Rate
Choose an exchange rate. If you choose a currency other than your ledger currency, the most recent End of period rate is the default. However, you can choose any prior End of period rate.
Use this report to view the detailed accounting distribution information of WIP transactions for a specific legal entity, cost type, and period combination.
In the Submit Requests window, select the report name.
Legal Entity
Select a legal entity
Cost Type
Select a cost type
Organization Cost Group
Select an organization cost group
Period
Select a period
Accounts From/To (Optional)
To restrict the range of accounts, enter a beginning and an ending account.
Organization
Select an organization
Job/Schedule (Optional)
Enter a specific job or schedule.
Line (Optional)
Enter a production line.
Assembly (Optional)
Enter an assembly.
Transaction Type (Optional)
Select a transaction type from the following:
Resource transactions
Overhead transaction
Outside processing
Cost update
Period close variance
Job close variance
Final completion variance
Department (Optional)
Enter a department name.
Activity (Optional)
Enter an activity.
Class (Optional)
Enter a WIP accounting class name.
Currency
Select a currency. You can run this report for any defined currency. When you enter a currency other than your ledger currency, the system converts item costs to the selected currency using the End of period rate you choose in the Exchange Rate field.
Exchange Rate
Choose an exchange rate. If you choose a currency other than your ledger currency, the most recent End of period rate is the default. However, you can choose any prior End of period rate.
Use this report to view Work in Process transaction accounting distributions summarized.
In the Submit Requests window, select the report name.
Legal Entity
Select a legal entity
Cost Group
Select an organization cost group
Organization Cost Type
Select an organization cost type.
Period
Select a period
Account From/To (Optional)
To restrict the display of accounting distributions, select a range of accounts.