【正文】 lidated debit amount of the report item(account) + Total debit amount of all adjustment entries。 IAS support FILE FORMAT amp。s equity Note 4 Employee pensation costs Note 5 interest expense Note 6 Ine before ine taxes Note 7 Ine taxes Note 8 Cash and cash equivalents Note 9 Accounts receivable Note 10 Inventories Note 11 Prepaid expenses and other current assets Note 12 Property, plant, and equipment Note 13 Investments Note 14 Intangible and other assets Note 15 Accounts payable and accrued liabilities Note 16 Debt Note 17 Deferred ine taxes Note 22, 23, 24 Auditing required reports Shortterm investment report Notes receivable report Other receivable report Shortterm loan report Notes payable report In addition to the system changes, the following reports must be developed and produced System Design for FMIS Modification 24 New data files and associated processes Chapter 6 System Design for FMIS Modification 25 Reporting system Transaction System F1 Internal transaction data file and associated processes P1. Modification to voucher entry in transaction system need to be done. Currently the transaction table has a field to record customer/vendor codethat is only used for A/R or A/P. The system needs to be modified to make the customer/vendor code applicable for all internal transaction types. The system should make customer/vendor code entry mandatory for all internal transactions. P2. When counterpart codes of all internal transactions have been recorded, transaction system will be able to export data of internal transactions and transfer the data up to the higher levels. P5. The reporting system must have facilities for users to query, view and print the internal transaction data and the elimination entries. This report is the key input for the users in the elimination process. Users create elimination entries based on the information contained in the internal transaction table. To facilitate the creation of this report, table T5 (Account pairs) is needed to record the account “pairs” for the offseting accounts. This process must also be able to print elimination report which pares the internal transactions with the elimination entries that has been done. The elimination report must be reported to the higher level as a control report to ensure that eliminations are done properly at the level where it is performed. P13. As part of the consolidation process, the system will filter the internal transactions and roll up the internal transactions information that has not been eliminated by ignoring all the internal transactions within the accounting entity and its lower entities, and roll up the remaining internal transactions without aggregation. The internal transaction data file is a key input to the consolidation process. F1 Internal transaction data file P2 Produce internal transactions data file P1 For internal transactions, enter customer/ supplier code Transaction DB T4 Internal Transaction P13 Export remaining internal transaction Internal transaction reports amp。 elimination reports amp。 Ending balance ? Loans Analysis Report ? Director’s remuneration report Salaries, allowances and other benefits Contribution to retirement benefit scheme System Design for FMIS Modification 9 FMIS also need to produce certain information that is required to facilitate annual audit. Business requirements for annual audit The required information for accounts receivable, longterm equity investment, longterm nonequity investment has been listed in disclosure requirement. The only remaining items for annual audit are listed below: ? Shortterm investment Investment type, investee, security type, par value, historical cost, rate, due date, interest receivable or dividends receivable, premium /discount and its amortisation ? Notes receivable Notes type, par value, rate, drawer, due date ? Other receivable Debtor, amount, post due days ? Assets revaluation Assets class, book value before revaluation, book value after revaluation ? Shortterm loan Loaner, amount, rate, due date ? Notes payable Owner, par value, rate, due date System Design for FMIS Modification 10 Gap analysis Chapter 2 System Design for FMIS Modification 11 Changes in financial reporting process PetroChina needs to implement a large scale change in its financial reporting process. Current ? Consolidation is done by the auditors using spreadsheets and manual data collection and manipulation ? FMIS report is not pliant with PRC accounting standard for jointstock pany. ? IAS report is produced by the auditors using manual method ? Reporting is done for the whole CNPC with the current org structure ? Use current chart of accounts Future ? Consolidation will be done by PetroChina accountants as part of the regular accounting process using FMIS ? FMIS report will be pliant with PRC accounting standard for jointstock pany. ? AS report is produced by Petrochina accountants using FMIS ? Reporting structure for PetroChina will be separated from the old CNPC. New org structure will be put in place ? New chart of accounts will be in effect System Design for FMIS Modification 12 Systems issues The following systems issues are identified as critical to the ability for PetroChina to be able to do consolidation and produce the required reports REQUIREMENT ? Reconciliation of transactions that occurs across different accounting entities. ? Some detailed information need to be passed up the corporate reporting structure. SYSTEM ISSUE ? This is difficult to do with the current FMIS since FMIS treats each accounting entity as independent from other accounting entities. ? This is not possible in the current FMIS si