This chapter contains these topics:
You can purge all of the obsolete or unnecessary contracts from your system to free space and to make your system more efficient.
After you purge your contract information, you can run an integrity report to verify the data in certain tables that the Subcontract Management system uses and that the data works together properly.
See Also:
Work with DREAM Writer in the JD Edwards World Technical Foundation Guide for information about running a DREAM Writer program
From Subcontract Management (G44), enter 27
From Advanced & Technical Operations (G4431), choose Purge Contract Information
You run the Purge Contract Information program to purge all information for specific contracts from your system. This frees space and makes your system more efficient. The program only purges information for a contract that has the Purge Code field set to Y in the Purchase Order Header table. The program purges the information in the Purchase Order Header File (F4301) and the Purchase Order Detail File (F4311) tables. You can choose to save the records you purge in a special purge library named JDExxxxxx (where xxxxxx is the current date). In addition, you can also purge the information in the Log Master table (F4303), the Contract Log Text table (F4304), and the Commitment Text table (F4404), and save the data in the purge library.
From Subcontract Management (G44), enter 27
From Advanced & Technical Operations (G4431), choose Integrity Report/Purge
After you purge your contract information, you should run the Integrity Report/Purge program to test the integrity of Subcontract Management tables and their relationship to each other.
This integrity report performs a series of tests to verify various fundamental relationships and conditions within the Subcontract Management System. Use the processing options and a DREAM Writer version to perform the integrity check that best suits your business needs.
You should review and set the Purge Options and Correction Option processing options for this report to meet your specific reporting needs. Each of these processing options allows you to purge or update a file, print a proof report, or exclude processing (skip verification) for a particular file.
The following describe each processing option you set and the integrity test the system performs:
Contract Header without Contract Detail records: The system reviews the Purchase Order Header File (F4301) and searches for contracts without Contract Purchase Order Detail table records (F4311). The report includes contract number, contract type, a description of the contract, and supplier and job related information. If you set the processing option to purge, the system deletes the F4301 records.
Contract Detail without Contract Header records: The system reviews the Purchase Order Detail table (F4311) and searches for distributions without Purchase Order Header File records (F4301). The report includes contract number, contract type, change number, account information, unit price and extended amount. If you set the processing option to purge, the system deletes the F4311 records.
Contract Log Details without Contract Header records: The system reviews the Log Master file (F4303) and searches for log records without Purchase Order Header File records (F4301). The report includes contract number, contract type, log type, pay status, supplier number, category codes and all dates. If you set the processing option to purge, the system deletes F4303 records.
Contract Log Text without Contract Log Detail records: The system reviews the Contract Log Text file (F4304) and searches for text records without Log Master table records (F4303). The report includes contract number, contract type, log type, and the associated text information. If you set the processing option to purge, the system deletes the log text F4304 records.
Contract Detail Text without Contract Detail records: The system reviews the Commitment Text table (F4404) and searches for text records without F4311 records. The report includes contract number, contract type, change number, line number, and the associated text information. If you set the processing option to purge, the system deletes the text F4404 records.
G/L Balances without Contract Detail records: The system reviews only PA and PU ledger types in the Account Balances file (F0902) and verifies that there are F4311 records with the same Account ID.
A/P Detail with Invalid Contract Number or Type records: The system reviews the Accounts Payable Ledger file (F0411) and searches for payment records with incorrect contract numbers or contract types from the F4301. The report includes voucher number, type, pay item, supplier number, original contract number and type, and new contract number and type. If you set the processing option to update, the system updates the A/P detail records with the information in the New Contract and Type column on the report.
Note:
Use caution when you set this processing option to run in update mode. If the New Contract and Type column is blank, the system clears the contract number and type fields in the F0411 records.