Generating Reports of Financial Transactions

PeopleSoft Cost Management includes these reports to assist with the accounting and PeopleSoft Cost Management review:

  • Accounting Register (INS7050).

  • Inventory Value (INS7000).

  • Transaction Register (INS7100).

  • Item Cost Profiles (CMS2000).

  • Items with Overridden Profiles (CMS2001).

  • Items with no Profiles (CMS2002).

  • Inventory On Hand Value (CMS2010).

  • WIP Value History (CMS2018).

  • Movement by Receipt Line (CMS2015).

  • Movement by Depletion Line (CMS2016).

  • On Hand Balance Validation (CMS9010).

Page Name

Definition Name

Usage

Floor and Ceiling Values Page

CM_VALUE_REF

To establish floor and ceiling values, use the Floor and Ceiling Values (CM_VALUE_REF_PGRP) component. These values are used when you run the Inventory On Hand Value report (CMS2010).

On Hand Value Report Page

RUN_CMS2010A

RUN_CMS2010

RUN_CMS2011

Lists on-hand quantity and value at the summary or detail level. The report can also store snapshots of previously generated report data for historical reporting.

On Hand Value Report-Selection Criteria Page

RUN_CMS2010

Enter the data selection criteria for the on-hand value report.

On Hand Value Report-Other Criteria Page

RUN_CMS2011

Define additional criteria for the on-hand value report.

Use this component to run the On Hand Value report, which shows on-hand quantity and value at the summary or detail level. This report can be used for items with cost profiles having any cost method. This report displays transactions that have been costed and posted to accounting lines as well as transactions that are posted to the general ledger.

The report can also store snapshots of previously generated report data for historical reporting. In addition, you can also use it to compare the on-hand value by using floor and ceiling costs or last price used.

Select Report Options

Use the On Hand Value Report page (RUN_CMS2010A) to lists on-hand quantity and value at the summary or detail level.

The report can also store snapshots of previously generated report data for historical reporting.

Navigation:

Cost Accounting > Inventory and Mfg Accounting > Reports > Inventory Value History

Field or Control

Description

Print, Don't Store Snapshot

Print the report that is to be generated, but do not store a snapshot of the report data for subsequent reprinting.

Print, Store Snapshot

Print the report that is to be generated, and store a snapshot of the report data for subsequent reprinting.

Don't Print, Store Snapshot

Generate the report and store a snapshot of the data, but do not print a report.

Print Stored Snapshot

Reprint a previously stored snapshot of the report.

Purge Stored Snapshot

Delete a previously stored snapshot of the report.

To print or purge a previously stored snapshot, select a process instance by number, business unit, or as of date.

Enter Selection Criteria

Use the On Hand Value Report-Selection Criteria page (RUN_CMS2010) to enter the data selection criteria for the on-hand value report.

Navigation:

Cost Accounting > Inventory and Mfg Accounting > Reports > Inventory Value History > Selection Criteria

On the Selection Criteria tab: Select a Currency Code. Select a specific cost book to report on, or select All to include all of the books in the business unit. Select All, None, or a specific single cost profile group that is associated with the cost book. None applies to all items that have no association with a cost profile group. Select All or a specific cost profile that is associated with the book.

Also on the Selection Criteria tab: Select either All or Range (for a range of items). For an item range, enter the from item ID and the to item ID. Select an item group and an item family.

Complete the Selections on the Other Criteria tab

Use the On Hand Value Report-Other Criteria page (RUN_CMS2011) to define additional criteria for the on-hand value report.

Navigation:

Cost Accounting > Inventory and Mfg Accounting > Reports > Inventory Value History > Other Criteria

  • Consigned Inventory Only: Include only consigned items.

  • Exclude Consigned Inventory: Include only owned items.

  • Include Consigned Inventory: Include both owned and consigned items.

If its included, consigned inventory appears at the bottom of the items for each book.

  • The Sort option enables you to sort the On Hand Value report by several different methods.

  • Enter a storage area to limit the report to a specific storage area that is within the business unit.

  • Select the Include zero On Hand Qty Items check box to include items with no quantity in the report.

  • Select the as of date for which you are requesting the on-hand value. Select a system date or choose an accounting period.

  • Cost comparison: These options are only available for detail reports.

    The choices are:

    • None

      No cost comparison.

    • Floor and Ceiling

      Compare floor and ceiling costs with the unit cost. You maintain floor and ceiling costs in the Floor and Ceiling Values page.

    • Last Price Used

      Compare the last price used on a voucher or purchase order with the unit cost.

  • Report Type - Select Summary, or select Detail. The summary report shows totals by business unit, book, and item. Select to report by either Cost Category or Cost Element.