Rebuilding a Commitment Audit Trail
Select Commitment Setup/Rebuilds (G43B411), Create Commitment Audit Trail.
Alternatively, select Encumbrance Setup/Rebuilds menu (G43C411), Create Encumber. Audit Trail.
If you locate data inconsistencies between any of these tables, you can correct the commitment audit trail:
F4311
F43199
F0902
To correct the commitment audit trail, you must purge the current commitment audit trail to prevent duplicating the commitment amounts in the new commitment audit trail. Purge only records in the F43199 table with a ledger type of PA and a next status and last status of blank. Select the data dictionary alias:
Ledger Type (LT)
Next Status (NXTR)
Last Status (LTTR)
Important: Use caution when selecting records to purge. The F43199 table contains records for the Purchasing ledger (blank ledger type), Change Order ledger (CO ledger type), rollovers (RO ledger type), and commitment records (PA/PU ledger type). If you purge purchasing ledger, change order, and rollover ledger records, you cannot recover the records.Note:You can use selection criteria to narrow the scope of information that the system purges and uses to create the new audit trail. For example, you can use account numbers, contract numbers, or order numbers. The selection criteria that you use to purge the audit trail must be the same criteria that you use to create the new audit trail. If they are not, unpredictable results may occur.
After you purge the F43199 table, you must create a new commitment audit trail. The system creates the new commitment audit trail from records in the F4311 table for both open and closed orders. Open orders have records in the audit trail for the original commitment amount and any amounts that have been partially relieved. All partially relieved records for each order are summarized into one relief record. Closed orders have two records posted in the commitment audit trail: one record for the original commitment amount and another for the commitment relief.
After you create the new commitment audit trail, run Repost Committed Costs (R00932) to repost the PA ledger records in the Account Balances table. The system adds the new information in the audit trail and posts these amounts to the Account Balances table.