| Period Close Reconciliation Report (CSTRPCRE) (文档 ID 295182.1) |
 转到底部
|
|
|
***Checked for relevance on 05-Nov-2013***
Period Close Reconciliation Report:(Available 11.5.10, Executable CSTRPCRE)
This concurrent program and report is used to create summarized transaction records. It displays the differences between accounted value and inventory in the Discrepancy column. The inventory value is used as the baseline for calculation for the next period summarization values. The Period Close Reconciliation report can be run at any time during the period or automatically during the Period Close Process by setting the profile option CST:Period Summary to either automatic or manual. If it is generated for an open period, you are creating a simulation, or snapshot of the period. If the program is run for an accounting period that is not in a Closed status, the report reads directly from a temporary table, The simulation status is indicated in the report title.
The navigation path to launch the Period Close Reconciliation Report is as follows: Cost > Report > Value
(If the report is not available in the lov the report will need to be added to the following Request Groups, see note 145436.1): CST_VALUE_REPORTS CST_VALUE_REPORTS_AVG CST_VALUE_REPORTS_STD CST_VALUE_REPORTS_WMS
Advantages of Report: -Discrepancies will be shown by Item and Subinventory or by Item and Cost Group for easier resolution. -Errors in prior periods will not propagate to the next period.
Column Descriptions
Cost Group (Only available if organization is Average, FIFO/LIFO cost type or WMS/PJM enabled): An attribute of a project which allows the system to hold item unit costs at a level below the inventory organization.
Cost Group Description (Only available if organization is Average, FIFO/LIFO cost type or WMS/PJM enabled): Description of Cost Group
Subinventory Code (Only available if organization is Standard cost type): The name of the Subinventory.
Subinventory Description (Only available if organization is Standard cost type): Subinventory Description
Item: Inventory Item
Account Value: The valuation when calculated using previous adjusted summarization data + distribution information from MTA.
Onhand Value: The valuation when calculated using current values from MOQ - quantities and costs from MMT.
Discrepancy: The difference between Account Value and Onhand Value
Report Parameters
Sort Option(required field): Choose from one of the Following: -Cost Group / Subinventory, item -Item, Cost Group / Subinventory -Discrepancy, Cost Group / Subinventory -Account Value, cost Group / Subinventory, Item -Onhand Value, cost Group / Subinventory, Item
Period(required field): The current open accounting period and any previously summarized periods can be selected.
Run To Date: The ending date for records to summarize. This value enables you to choose a date, for reconciliation purposes, where a discrepancy occurred in an open period.
Cost Group From: This field allows specifying the starting Cost Group for running a range of Cost groups.
Cost Group To: This field allows specifying the end Cost Group for running a range of Cost groups.
Subinventory From: This field allows specifying the starting Subinventory for running a range of Subinventories.
Subinventory To: This field allows specifying the end Subinventory for running a range of Subinventories.
Item From: This field allows specifying the starting Item for running a range of Items.
Item To: This field allows specifying the starting Item for running a range of Items Currency (required field): Select the currency for that organization.
Exchange Rate (required field): Select the exchange rate for that organization.
Sample Report of a Standard Cost Organization:
Report Type: By Subinventory Sort Option: CG/Sub, Item Period: Mar-02 Run To Date: 03-MAR-02 Subinventory From: To: Item From: To: Currency: SGD Exchange Rate: 1 Singapore Distribution Center (SGD) Report Date: 04-JAN-05 16:05:26 Mar-02 (01-MAR-02 to 03-MAR-02) Period Close Reconciliation Report Simulation
Sample Report of a Non Standard organization: New Orleans Manufacturing (USD) Report Date: 03-JAN-05 17:21:41 Period Close Reconciliation Report Report Type: By Cost Group Sort Option: CG/Sub, Item Period: Apr-03 Run To Date: 30-APR-03 Cost Group From: To: Item From: To: Currency: USD Exchange Rate: 1 New Orleans Manufacturing (USD) Report Date: 03-JAN-05 17:21:41 Apr-03 (01-APR-03 to 30-APR-03) Period Close Reconciliation Report
***** End of Report *****
Trouble Shooting:
Discrepancies can be caused by back dating transactions. Oracle does allow customers the ability to back dating transactions but they need to understand that it may cause discrepancies. Review Document 291005.1 on back dated transactions as well as running the available script to verify if back dated transactions exist.
Data corruption where Onhand quantity does not match with the values in the MTL_MATERIAL_TRANSACTIONS can also cause discrepancies. A script to identify any data corruption can be found in ITS under the Inventory button, the script is also available in Document 291005.1.
The Reconciliation report will show discrepancies by Item and Subinventory or Item and Cost Group. Reviewing transaction and distributions in the time period where the discrepancies occurred will also help in resolving discrepancies issues.
ReferencesNOTE:145436.1 - CSTRAIVA - All Inventories Value Report - Average Costing Does Not Appear on the Menus for Any Inventory Responsibilities |