This chapter contains these topics:
You need to update the accounts and ledgers in your system if you change your chart of accounts, frequently add new pieces of equipment, and so on, for your organization.
From Equipment/Plant Management (G13), enter 27
From Advanced Operations (G1331), choose Fixed Assets Global Updates
From Advanced Operations (G1231), choose Update Company #, BU/Obj/Sub - F1202
You must update company numbers and account numbers in the Item Balances table (F1202) when the company numbers and account numbers in the Item Balances table do not match those in the Account Master table (F0901). Company and account numbers in the Item Balances table might not match those in the Account Master table if you change an existing account number or company for an account within the fixed asset (FX) range.
Run the Update Company Number, Business Unit/Object/Subsidiary program any time that you change an existing account in your chart of accounts. For example, run this program when you:
Change the object or subsidiary of an existing account
Assign existing accounts to a different business unit
Assign an existing business unit to a different company
Note:
You do not have to run this program when you add an account number. You run this program only when you make changes to existing account numbers.The Update Company Number, Business Unit/Object/Subsidiary program updates information from the Account Master table based on the system-assigned, short account ID number. The program does not update accounts in the Item Master table (F1201).
When you update company and account numbers, the system submits the job directly to batch.
From Equipment/Plant Management (G13), enter 27
From Advanced Operations (G1331), choose Fixed Assets Global Updates
From Advanced Operations (G1231), choose Repost Ledger
You can repost damaged account balances in the Item Balances table (F1202) to restore system integrity. You should run the repost only if you have no other means of restoring account information. For example, run the repost if account balance information is damaged as a result of hardware failure.
The Repost Ledger program reposts only the transactions that include all of the following:
A valid period number.
A code that indicates a post to both the general ledger and equipment.
A valid equipment number that exists in the Item Master table (F1201).
A transaction ledger type set up in Item Setup Default Coding, if one doesn't already exist in the Item Balances table.
A transaction account number in the Account Master table (F0901). The account number must be within the FX range of accounts in the automatic accounting instructions.
Period postings for individual equipment. The transaction must not be a balance forward record and cannot be summarized by period and account.
Caution:
The Repost Ledger program clears all summarized account balances to zero. Do not use this program if your system includes item balance records without general ledger transactions, as in the case of summarized depreciation computations or beginning balances created without an audit trail.When you select Repost Ledger, a caution message appears. Proceed with the post. A versions list appears. The versions list contains DEMO versions that you can run, or copy and modify to suit your needs. When you run a version, Processing Options Revisions appear before the system submits the job for processing.
Verify that the following procedures are complete:
· All transactions are posted first to the general ledger and then to equipment.
· All depreciation and transfer transactions are posted first to equipment and then to the general ledger.
Verify that no one accesses the general accounting or fixed asset tables. The program is unable to update accounts that are locked by other system applications. Any accounts that a user accesses elsewhere in the system will not be updated.
See Also:
JD Edwards World Technical Foundation Guide for more information about running, copying, and changing a DREAM Writer version
From Equipment/Plant Management (G13), enter 27
From Advanced Operations (G1331), choose Fixed Assets Global Updates
From Advanced Operations (G1231), choose Refresh Item Number in F0911
If you change the symbol you use to identify the item number for equipment, you must run the Refresh Item Number in F0911 program. Run this update to ensure that all posted account ledger transactions contain the current item number format.
The item number and the symbol used to identify it are stored in the Account Ledger table.
When you run Refresh Item Number in F0911, the job is submitted directly to batch.