Using the CM/AP Reconciliation Tool Set
The CM/AP Reconciliation tool set allows you to:
Run the CM/AP Reconciliation process (CM_APRECN) to match up PeopleSoft Cost Management entries for receipts against PeopleSoft Payable entries for receipts.
The CM/AP Reconciliation Summary provides inquiries into the receipts that do not offset each other, and drill-down capabilities through the details of those transactions. Also, there is an option to select receipts that should no longer be displayed on the reconciliation list. These receipts are designated by users as insignificant differences, or they are dealt with in some fashion, such as a manually entered journal entry. You can view and mark as reconciled the receipts having corresponding payables entries that do not balance to zero. You can also view and mark as reconciled the voucher entries that do not have corresponding costing entries but have been accounted for elsewhere.
Use the CM/AP Reconciliation Detail to view all detail information about PeopleSoft Payables transactions and PeopleSoft Cost Management transactions. You can also mark any discrepancies as reconciled.
Note: The CM/AP Reconciliation tool set does not perform reconciliation entries, but it does provide information necessary for you to understand and resolve reconciliation differences.
Page Name |
Definition Name |
Usage |
---|---|---|
CM_APRECN_REQ |
Run the CM/AP Reconcile process, after which you can use inquiry pages to find Payables transactions that you need to reconcile with PeopleSoft Cost Management transactions. |
|
CM_APRECN_INQ |
View summary information about discrepancies between Payables transactions and PeopleSoft Cost Management transactions. You can also mark the discrepancies as reconciled. ChartField security can be applied to this page. |
|
CM_APRECN_DETAIL |
View all detail information about Payables transactions and PeopleSoft Cost Management transactions from the request process. You can also mark any discrepancies as reconciled. ChartField security can be applied to this page. |
Use the CM/AP Reconcile page (CM_APRECN_REQ) to run the CM/AP Reconcile process, after which you can use inquiry pages to find Payables transactions that you need to reconcile with PeopleSoft Cost Management transactions.
Navigation:
This example illustrates the fields and controls on the CM/AP Reconcile process page. You can find definitions for the fields and controls later on this page.
![CM/AP Reconcile process page](img/i2a517932n-719c.png)
Use the CM/AP Reconcile process (CM_APRECN) to match PeopleSoft Cost Management accounting entries (that are posted to the general ledger) to a matching entry in Payables accounting line table. This process reports any entries that cannot be matched. After running the CM/AP Reconcile process, use inquiry pages to find Payables transactions that you need to reconcile with PeopleSoft Cost Management transactions. There are many causes of discrepancy; for example, maybe you did not voucher a receipt, or you entered a voucher for an amount that differs from the amount on the purchase order. Actions like these can then cause the system to, for instance, not voucher a receipt, not post a vouchered receipt to the voucher accounting lines, not pick up an accounting line with the journal generator, or to post a voucher to the liability account without a receipt.
Field or Control |
Description |
---|---|
Business Unit |
Enter your Inventory business unit. |
Account |
Enter the number (ChartField) of an accrued liability account. The system accepts the number of any account used by both PeopleSoft Cost Management and PeopleSoft Payables. |
Fiscal Year and Accounting Period |
Enter the time period to be used by this process. The system collects all receipts and vouchers from the first period of the fiscal year to the accounting period entered. Using this time period, the process:
|
Include Prior Fiscal Years |
Select this check box to include all outstanding receipts from the prior fiscal year that have not yet been vouchered (non-reconciled receipts). |
Delete All Previous Results |
Select if you want this run to delete the results of all previous runs. If the check box is not selected, only the data from the prior run of the selected Run Control ID and Request ID are deleted. |
Use the CM/AP Reconciliation Summary page (CM_APRECN_INQ) to view summary information about discrepancies between Payables transactions and PeopleSoft Cost Management transactions.
You can also mark the discrepancies as reconciled.ChartField security can be applied to this page.
Navigation:
This example illustrates the fields and controls on the CM/AP Reconciliation Summary page displaying costing entries without vouchers. You can find definitions for the fields and controls later on this page.
![CM/AP Reconciliation Summary page displaying costing entries without vouchers.](img/i2a517932n-713b.png)
This example illustrates the fields and controls on the CM/AP Reconciliation Summary page displaying vouchers without costing entries. You can find definitions for the fields and controls later on this page.
![CM/AP Reconciliation Summary page displaying vouchers without costing entries.](img/i2a517932n-7159.png)
This example illustrates the fields and controls on the CM/AP Reconciliation Summary page displaying costing entries with vouchers. You can find definitions for the fields and controls later on this page.
![CM/AP Reconciliation Summary page displaying costing entries with vouchers.](img/i2a517932n-71a3.png)
After you run the CM/AP Reconcile process, you can view summary information about discrepancies between the costing balance in PeopleSoft Cost Management and the voucher balance in PeopleSoft Payables. You can also mark the discrepancies as reconciled. Balanced receipt lines are marked as reconciled and do not appear on the summary page. This component can display the following information:
Vouchers without costing entries.
Costing entries without vouchers.
Costing entries with voucher balances.
Field or Control |
Description |
---|---|
Error OK |
Select this check box to mark the discrepancies as reconciled. The receipt line does not appear in future runs. |
Item |
Displays the item ID. |
Recv Unit |
Displays the receiving business unit attached to the receipt ID. |
Payables Total |
Displays the payables accounting entries summed to the voucher line. A blank in the this field indicates that the receipt was not vouchered. |
Inventory Total |
Displays the inventory accounting lines that are summed to the receipt schedule line. |
Difference |
Displays the absolute value of the difference between the Payables Total field and the Inventory Total field. |
Details |
Click this link to access the CM/AP Reconciliation Detail page where you can see the actual accounting entries for the receipt schedule line. |
AP Unit |
Displays the PeopleSoft Payables business unit. This field only displays if there are vouchers without costing entries. |
Voucher |
Displays the voucher ID. Select this link to access the Voucher Inquiry page within PeopleSoft Payables where you can review the status of the voucher and any payment information. This field only displays if there are vouchers without costing entries. |
ChartField security can be applied to this page.
Use the CM/AP Reconciliation Detail page (CM_APRECN_DETAIL) to view all detail information about Payables transactions and PeopleSoft Cost Management transactions from the request process.
You can also mark any discrepancies as reconciled.ChartField security can be applied to this page.
Navigation:
This example illustrates the fields and controls on the CM/AP Detail page. You can find definitions for the fields and controls later on this page.
![CM/AP Detail page](img/i2a517932n-7142.png)
After you run the CM/AP Reconcile process, use this page to view all detail information about Payables transactions and PeopleSoft Cost Management transactions from the request process. You can also mark any discrepancies as reconciled.
The Reconciled check box is selected if the receipt and voucher are balanced; it is deselected if the receipt and voucher do not balance. Select Reconciled if the discrepancy for this transaction is acceptable.
Inventory Accrued Liability
Use the Transaction tab on this page to view and reconcile accrued liability transactions that have corresponding voucher entries that do not balance to zero. Click the Accounting Line link to drill to transaction details on the Inventory Transaction Entries page.
Use the first Accounttab on this page to view account information for accrued liability transactions having corresponding voucher entries that do not balance to zero.
Vouchers
Use the Distribution tab to view and reconcile voucher distribution lines having accrued liability transactions that do not balance to zero. Click the Voucher link to see details on the Voucher Inquiry page.
Use the second Account tab to view account information for voucher entries that do not have corresponding costing entries.
ChartField security can be applied to this page.