To submit the Period Reconciliation concurrent program and report:This concurrent program and report is used to create summarized transaction records, the final step in closing your accounting period. 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. 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 Closed status, the report reads directly from a temporary table, The simulation status is indicated in the report title.
Note: The function 'get_prd_cls_zeroval_option' is provided in the hook CST_Common_hooks. This function is called from the period close reconciliation report with the parameters 'organization_id' and 'acct_period', and allows customers to configure behavior at the:
Organization level
Organization and Period level
Instance level
Customers are required to enter logic to return values of '1' or '0' based on their business requirements.
A return value of '0' summarizes all items.
A return value of '1' removes items that have zero on-hand quantity in the period being summarized, and will not display on the report.
However, if these items have zero on-hand quantity, but through a possible discrepancy have non-zero accounting in the period, then this discrepancy will be highlighted. Each time the period end summarization is processed, the configuration of the hook at that time determines whether the report displays zero-quantity items or does not display zero-quantity items.
To submit the Period Reconciliation concurrent program and report:Navigate to the Period Close Reconciliation Report Request window to display the Parameters window.
In the Sort Option field, select how the results are to be sorted on the report.
Your choices are by Cost Group, Subinventory, or Item - in any sort combination.
In the Period field, the current open accounting period displays.
You can enter previously summarized periods to review the data.
In the Run to Date field, enter 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.
In the Cost Group From and To fields, you have the option to specify a range of cost groups.
In the Subinventory From and To fields. you have the option to specify a range of subinventory locations.
In the Item From and To fields. you have the option to specify a range of items.
In the Currency and Exchange Rate fields, select the currency used for this Inventory Organization and the exchange rate defined.
Choose OK to display the Request window.
Choose Submit to submit this request.
