Periodic Costing

This chapter covers the following topics:

Overview of Periodic Costing

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 Costing is an option that enables you to value inventory on a periodic basis. There are three principal objectives of Periodic Costing:

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.

Uses

You may want to use Periodic Costing if:

Major Features

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:

  1. 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.

  2. 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.

Periodic Cost Updates

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.

Requirements

In order to use Periodic Costing, the following requirements must be met:

Terms

Cost Owned Transactions

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:

Cost-Derived Transactions

Cost-derived transactions are transactions that are transacted at the newly computed average unit cost of the period.

Examples:

Periodic Rates Cost Type

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 (Periodic Incremental LIFO only)

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 (Periodic Incremental LIFO Only)

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.

Periodic Costing Methods

Cost Management provides two Periodic Costing methods:

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.

Periodic Average Costing

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.

Calculating Periodic Item Cost

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 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)

Variance Generated (Quantity > 0 , Inventory Value < 0)

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 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 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

Periodic Incremental LIFO

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.

Market Value

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.

Periodic Incremental LIFO Calculations

Cost Management calculates Periodic Incremental LIFO in this manner:

Using Both Costing Methods

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.

Periodic Cost Setup

Using Periodic Costing requires that you first install a perpetual cost method. See Setup

Choosing Periodic Cost Method

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.

Ledger

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.

Setup Steps

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:

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.

Step 1: Defining Organization Cost Group

Each organization cost group must be associated with a legal entity.

To define an organization cost group

  1. Navigate to the Organization Cost Group window.

    the picture is described in the document text

  2. Enter a name for the Org Cost Group.

  3. Enter a description for the Org Cost Group.

  4. Select the legal entity to associate with the Org Cost Group.

  5. Enter the Item Master Organization ID.

  6. Save your work.

Step 2: Creating Cost Types and Periodic Rates Cost Types

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

  1. Navigate to the Cost Types window.

  2. 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.

  3. Save your work.

Step 3: Associating Organization with an Organization Cost Group

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:

To associate an organization with the organization cost group

  1. Navigate to the Org Cost Group/Cost Type Associations window.

    the picture is described in the document text

  2. Select the appropriate legal entity.

  3. Navigate to the Org Cost Group Associations tab.

  4. Select the organization cost group.

  5. 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.

  6. Save your work.

Step 4: Associating Cost Type with Legal Entity

To associate the cost type with legal entity and select cost method

  1. Navigate to the Org Cost Group/Cost Type Association window.

  2. Select the appropriate legal entity.

  3. Navigate to the Cost Type Associations tab.

    the picture is described in the document text

  4. Select the Cost Type.

  5. Select a value for the Cost Method.

    The available values are:

    Incremental LIFO

    Periodic Average

  6. Select the Ledger.

  7. Select the Periodic Rates Cost Type.

  8. 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).

  9. 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.

  10. 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.

  11. Save your work.

  12. 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).

Step 5: Setting Accounting Options (Optional)

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:

To set your accounting options

  1. Navigate to the Cost Type Associations Accounting Options window.

    the picture is described in the document text

  2. 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.

  3. Select an Accounting Library. The options are:

    • US GAAP

    • PAC Brazil

    Note: Landed Cost Management (LCM) related accounting is only supported for US GAAP.

  4. Check Post entries to GL if you wish to post your Periodic Cost distributions to the General Ledger.

    This enables options for additional options.

  5. 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.

  6. Save your work.

Step 6: Assigning Periodic Accounts

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:

To assign periodic accounts

  1. Navigate to Periodic Account Assignments.

  2. Select your legal entity and cost type association.

  3. Select the cost group.

  4. Choose the MTL Account tab to assign accounts for the category.

    the picture is described in the document text

  5. In the category column, select item family and class.

  6. Select accounts for the following:

    • Material

    • Material Overhead

    • Overhead

    • Resource

    • Outside Processing

    • Expense

    • Bridging

    • Non-Invoice Sales orders

    • Non-Invoiced Revenue

  7. Choose the Cost Group Accounts tab to assign variance accounts.

  8. Select an account for Cost Variance.

  9. 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

  10. 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.

    the picture is described in the document text

  11. 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.

Periodic Cost Processing

The following list is the procedure for processing Periodic Costs:

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

Processing Periodic Acquisition Costs

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:

To run the Periodic Acquisition Cost Processor

  1. Navigate to Periodic Acquisition Cost Processor concurrent window. The Parameters window displays.

    the picture is described in the document text

  2. 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

  3. 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.

  4. Choose OK.

  5. Choose Submit on the Request window to process this request.

Processing Periodic Acquisition Cost Adjustments

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:

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

  1. Navigate to Periodic Acquisition Cost Adjustment Processor concurrent window. The Parameters window displays.

    the picture is described in the document text

  2. 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

  3. Choose OK.

  4. Choose Submit on the Request window to process this request.

Running the Periodic Cost Processor

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

  1. Navigate to Periodic Cost Processor concurrent window. The Parameters window displays.

  2. 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

  3. 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.

  4. Choose OK.

  5. Choose Submit on the Request window to process this request.

Processing Periodic Cost Distributions

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:

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

  1. Navigate to Periodic Cost Distributions concurrent window. The Parameters window displays.

  2. Select the following parameters.

    • Legal Entity

    • Cost Type

    • Cost Group

    • Period

  3. Choose OK.

  4. Choose Submit on the Request window to process this request.

Making Item Cost Inquiries

In the Item Cost Inquiry window, you can list items by the following:

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

  1. Navigate to the Item Cost Inquiry window.

    the picture is described in the document text

  2. Query for desired cost item information, including LIFO item cost for possible entry of market value in the current period.

    the picture is described in the document text

  3. Enter a market value in place of the LIFO item cost if it is appropriate.

  4. Save if you have entered a market value.

See: Periodic Incremental LIFO and Periodic Incremental LIFO Business Example

Viewing Material and Receiving Transactions

The Viewing Material and Receiving Transactions window enables you to view those transactions, per cost type, that have been:

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

  1. Navigate to Material and Receiving Transactions. The Find Transactions window appears.

    the picture is described in the document text

  2. Enter search criteria in the Find Transactions window.

  3. Choose Find to initiate the search.

    the picture is described in the document text

    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.

Viewing WIP Transactions

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

  1. Navigate to WIP Transactions. The Find WIP Transactions window appears.

    the picture is described in the document text

  2. Select the following required criteria:

    • Legal Entity

    • Cost Group

  3. Enter any additional optional criteria.

  4. Choose Find to initiate the search.

    the picture is described in the document text

    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.

Closing Periodic Cycle

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:

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:

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:

To view or change the status of periodic accounting periods

  1. Navigate to the Periodic Accounting Periods window.

    the picture is described in the document text

  2. Select the legal entity and cost type.

  3. Choose Change Status and select one of the following options:

    • Change future to open

    • Change open to closed

      This activates the period close program.

  4. Choose Process Status to view the current processing status of the period.

    the picture is described in the document text

    If necessary, close Periodic Accounting Periods, complete any necessary processing, and begin again.

  5. 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.

Transferring to General Ledger

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

  1. Navigate to Transfer to General Ledger.

    the picture is described in the document text

  2. Select Transfer Periodic Cost Distributions to GL.

  3. 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.

  4. Choose Submit.

Writing Off Accruals

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:

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

  1. Navigate to Accrual Write-Offs. A Find Write-Offs window appears.

  2. 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).

  3. Enter additional search parameters (optional).

    the picture is described in the document text

  4. Enable the following, if desired:

    • AP-PO Write-Offs Only

    • Miscellaneous Write-Offs Only

  5. Click the Find button to initiate the search.

  6. Select the Write-off checkboxes for those transactions that you want to write off.

  7. Enter any reasons and comments.

  8. Save your work.

Copying Periodic Costs

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.

Requirements

In order to use the copying Periodic Costs feature, the following conditions must be met:

To copy costs from a Periodic Cost type to a managerial cost type

  1. Navigate to Copy Periodic Costs.

  2. Select Copy Item Period Cost.

  3. 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)

  4. Submit request.

Importing Periodic Costs

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

  1. Navigate to Import

  2. Select Period Cost Import Manager

  3. Select a parameter for:

    Delete Interface Rows After Import

  4. Submit the request

Updating Periodic Costs

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:

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:

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

  1. Navigate to the Update Periodic Cost window.

  2. Enter the following parameters:

    • Legal Entity

    • Cost Type

    • Org Cost Group

    • Transaction Date

    • Item Master Organization

      the picture is described in the document text

  3. 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.

  4. Select the Accounts tab and enter the following accounts:

    • Material

    • Material Overhead

    • Resource

    • Outside Processing

    • Overhead

    • Expense - enter if Adjustment Quantity is specified

      the picture is described in the document text

  5. Enter a change in item cost or value.

  6. Enter an Adjustment Quantity for Landed Costs.

  7. Click the Cost Elements button to view Update Periodic Cost Details.

    the picture is described in the document text

  8. Save your work.

Periodic Incremental LIFO Business Examples

The following three tables present different possible scenarios for XYZ company's inventory of material x using Periodic Incremental LIFO.

Example 1: Typical

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: When Inventory is Depleted

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: Use of Market Value

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

Reports

The following reports are available in Periodic Costing:

eAM Report for Estimates and Actuals

The PAC eAM Report for Estimates and Actuals displays the estimates versus actuals bucketed into the EAM cost elements.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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.

Periodic Acquisition Cost Report

Use this Periodic Costing report to analyze the acquisition cost for each receive transaction.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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.

Periodic Incremental LIFO Valuation Report

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.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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

Periodic Accrual Reconciliation Report

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:

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.

Report Submission

In the Submit Requests window, select the report name. You can choose either report. The parameters are the same.

Report Parameters

Sort By

Choose either of the following options:

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

Periodic Accrual Write-Off Report

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.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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

Periodic Inventory Value Report

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.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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.

Periodic Item Cost Change Report

Use this report to outline the periodic item cost calculation in a given period for an item.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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.

Periodic WIP Value Report

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.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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.

Periodic Material and Receiving Distribution Summary Report

Use this report to view material and receiving transaction accounting distributions summarized.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

Legal Entity

Select a legal entity

Sort By

Choose one of the following sort options:

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.

Periodic Material and Receiving Distribution Details Report

Use this report to view detailed accounting distribution information of both material transactions and receiving transactions.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

Sort Options

Choose one of the following sort options:

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.

Periodic WIP Distribution Details Report

Use this report to view the detailed accounting distribution information of WIP transactions for a specific legal entity, cost type, and period combination.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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:

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.

Periodic WIP Distribution Summary Report

Use this report to view Work in Process transaction accounting distributions summarized.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

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.