If your company has recently expanded or undergone a change in management, you might need to change the way it tracks and reports on the job information.
This chapter contains the following topics:
|
Note: Although the program to update category codes globally appears on the Advanced & Technical Operations menu with the other programs listed in this chapter, it is part of the process to assign alternate sequences. |
This section provides an overview of updating the Draw Reporting Master table when account information has changed and discusses how to run the Update BU/OBJ/SUB/CO F0901>F51911 program (R51806).
If you change any part of the account information, the account assigned to the company or the business unit (job number) or object and subsidiary account then you must update the existing account information for the Draw Reporting Master table by running Update BU/OBJ/SUB/CO F0901>F51911 (R51806). Otherwise, the system will not be able to retrieve and update the accounts correctly for draws that occur after the change.
When you run the R51806 program, the system:
Retrieves the first record in table F51911.
Using the short account ID assigned to the F51911 record, locates the corresponding record in table F0901.
Updates the company, business unit, object, and subsidiary fields in table F51911 with the values from the corresponding record in F0901.
|
Note: This program is specific for correcting the account information on records in the Draw Reporting Master table only. To update the account changes in the Account Ledger (F0911) and Account Balances (F0902) tables, run the Update BU.Obj.Sub to Jrnl Ent program (R09806). |
Select Advanced & Technical Operations (G5131), Update BU/OBJ/SUB/CO F0901>F51911.
This section provides an overview of the Method of Computation Conversion program (R519901) and discusses how to:
Update the method of computation.
Set processing options for Method of Computation Conversion (R519901).
If you need to change the method of computation on all of the accounts for a specific job, or on a specific account across several jobs or projects, rather than locating an updating the method of computation on each individual account, you can run the Method of Computation Conversion program (R519901) to update the globally update the accounts.
You use data selection to specify the accounts to select for update, or to specify the method of computation to update, or both. You use processing options to specify the method of computation that you want to assign. For example, you might want to update all of the accounts that are assigned method F to method D, or you might want to change the method of computation for cost type 1341 for all jobs, or you might want to select records with cost type 1341 that are assigned method of computation F.
When you run the R519901 program, the system selects the records from the Account Master table (F0901) and updates them with the method of computation from the processing option. Additionally, the system updates the balances for projected final values (HA and HU ledger) in the Account Balances table (F0902) based on the new method of computation. The system also prints a report of the selected records and the computation method that was originally assigned, so that if you do make an error, you have the information to correct it.
Select Advanced & Technical Operations (G5131), Method of Computation Conversion.
Processing options enable you to specify the default processing for programs and reports.
Specify the new computation method to assign to the accounts specified using data selection. The system updates the Method of Computation field (CCT) in the Account Master table (F0901) with the value that you enter, and recalculates projected final values (HA and HU ledgers).
This section provides an overview of the Recalculation Projections Program (R51803) and discusses how to:
Run the Recalculate Projections program (R51803).
Set processing options for Recalculate Projections (R51803).
You run the Recalculate Projections program (R51803) when you suspect that projected final values are incorrect, or as part of the integrity reporting process. The system selects the records from the Account Master table, locates the corresponding records from the Account Balances table, and recalculates projected final (estimate to completion) values (HA and HU ledger). The program has processing options to limit the selection of records to a specific fiscal year and range of periods. Use data selection to further limit the record to selection to specific jobs or accounts, as necessary. You also have the option to print a report of the transactions that the system selected and the final calculations, however, the report does not list all of the transactions on which the calculations were based.
Select Advanced & Technical Operations menu (G5131), Recalculate Projections.
Processing options enable you to specify the default processing for programs and reports.
Specify the range of period numbers to use to select records to process. The system uses the period range in conjunction with the Fiscal Year Range processing options to select records.
If you leave the period range processing options blank, the system selects records for the current period based on the fiscal date pattern that is assigned to the company for the job.
Specify the range of fiscal years to use to select records to process. The system uses the fiscal year range in conjunction with the Period Range processing options to select records.
If you leave the fiscal year range processing options blank, the system selects records for the current fiscal year based on the fiscal date pattern that is assigned to the company for the job.
Specify whether to print a report of the transactions updated. The report lists each account and the newly calculated projected final values. Values are:
Blank: Print the report.
1: Do not print the report.
This section provides an overview of deleting projected final information and discusses how to set processing options for Delete Job Cost Projections (R51997).
If you had set the JD Edwards EnterpriseOne Job Cost constant to generate the audit trail records for the projected final ledgers (HA and HU) and you want to remove them, you can run the Delete Job Cost Projections program (R51997). Based on the data selection that you specify, the system removes the Account Ledger (F0911) records for the HA and HU ledgers. You can remove the corresponding projected final ledger records from the Account Balances table (F0902).
You must access the R51997 program through the Batch Versions application. Access batch versions and then enter R51997 in the Batch Application field.
Processing options enable you to specify the default processing for programs and reports.
Specify whether to delete the corresponding balances for the HA and HU ledgers from the Account Balances table (F0902). Values are:
Blank: Delete the F0902 balances for the HA and HU ledgers.
1: Retain the F0902 balances for the HA and HU ledgers.
This section provides an overview of the Job Cost Purge process, lists prerequisites, and discusses how to run the Job Cost Purge program (R51840).
You can use either of two methods to remove JD Edwards EnterpriseOne Job Cost transactions from the system. One method is to summarize and purge data using these JD Edwards EnterpriseOne General Accounting programs:
Summarize Transactions (R09811)
Purge Prior JEs (R09911)
The other method is to purge all Account Ledger (F0911) and Account Balance (F0902) records for the job using the Job Cost Purge program (R51840). Depending on the information that you want to retain, you can select the method that best suits your business needs.
You can purge Account Ledger (F0911) transactions for a job that is not closed if you summarize the transactions first using the Summarize Transactions program (R09811). The Summarize Job Transaction program creates a new transaction for each account by period to represent the total amount of the transactions for the period of time specified. For example, if there are 100 transactions entered for account 5001.02200.1341 for period 6 of 2008, the system generates one record with a document type of BF for account 5001.02200.1341 with the summarized amount.
After you summarize transactions, you can purge them from table F0911 using the Purge Prior JEs program (R09911). The purpose of creating summarized records is to maintain an audit trail between F0911 detail records and the F0902 balance records, which is critical if you ever need to repost account balances. Both the Summarize Transactions and Purge Prior JEs programs rely on AAI ranges that you set up to specify the eligible accounts. These processes are described in detail in the JD Edwards EnterpriseOne General Accounting guide.
When you no longer want to retain any accounting records for the job, you can purge the records by running the Job Cost Purge program (R51840). When you run the Job Cost Purge program, the system:
Selects job master records (F0006) that are assigned a posting edit code of P.
Locates all transactions for the job form the Account Ledger (F0911) and Account Balance (F0902) tables for all accounts and all ledgers, across all fiscal years, that are associated with that job (including any records summarized using program R09811)
Writes the records to the corresponding purge tables (F0911P and F0902P).
Removes records from the tables F0911 and F0902.
You can use data selection to limit the purge to a specific job, or fiscal year, or ledger type. Otherwise, the system selects the records to remove based solely on those jobs in which the posting edit code is P. The purge program does not have associated processing options.
After you purge jobs, you can save the F0911P and F0902P tables to a tape or other media type for storage. If you want to remove the actual job and related accounts from the Business Unit Master (F0006) and Account Master (F0901) tables, you must additionally purge any accounts payable and accounts receivable transactions associated with the job.
Before you purge transactions, you must:
Perform a backup of the system files that you are going to purge.
Assign a posting edit code of P to the jobs that you want to purge. You must assign the posting edit code to the job (business unit), on the Job Master Revisions form, not to the account.