This chapter discusses how to:
This chapter discusses how to:
Generate a balance sheet.
Generate the profit and loss report.
Generate a cash flow statement.
Generate a changes in equity report.
Generate the Petty Cash Book report.
This section provides an overview of the balance sheet for Russia, lists prerequisites, and discusses how to:
Print a balance sheet.
Set processing options for Balance Sheet.
The Russian government requires that you produce a balance sheet report at the end of each accounting period. JD Edwards EnterpriseOne provides the Balance Sheet (R74R9030) to generate a report in PDF format. The system also populates the F74R9030 table when you run the Balance Sheet report.
The report can show amounts for one account, a group of accounts, or a formula based on previous rows. You determine the amounts that appear on the report when you use the G/L Reports Setup program (P74R9020) to create the format for the report.
When you run the Balance Sheet report, the system reads the F0902 table and populates the first column of the report with the balance forward amount of the current year, and populates the second column with the balance for the account as of the end of the accounting period specified in the processing options.
The system accesses the values in processing options to determine whether to scale the amounts that it prints, the ledgers and subledgers to use, and whether to print the report title that was defined in the Setup G/L Reports program.
Verify that the report format, row descriptions, and other information that the system uses to print the report exist in the F74R9020, F74R9021, F74R9022, and F74R9023 tables.
Select General Ledger (G74R09), Balance Sheet.
Processing options enable you to specify the default processing for reports.
Defaults
1. Fiscal Year and 2. Period Number |
Enter the fiscal year and period number for which to run the report. If you leave these processing options blank, the system uses the current year and period for the company that you specify in the Company Number processing option. |
3. Company Number |
Specify the number of the company for which to run the report. If you leave this processing option blank, the system uses company 00000. |
4. Ledger Types (LT1, LT2, LT3) |
Enter up to three ledger types for which to run the report. The values that you enter must exist in the UDC table 09/LT. |
5. Subledger |
Specify the subledger for which to run the report or enter * to run the report for all subledgers. Leave this processing option blank to suppress subledger information. |
6. Subledger Type |
Specify the subledger type for which to run the report. The value that you enter must exist in the UDC table (00/ST. |
7. Scale Factor |
Specify the scaling factor that the system uses when printing numerical values on the report. The value that you enter must exist in UDC table 74R/SF. If you choose to scale numerical values, the system divides the numerical values on the report by the scaling amount that you specify. For example, suppose that the amount for an account in the F0902 table is 23,929. If you choose to scale the amount by a factor of 1000, the system divides 23,929 by 1000, rounds to the nearest whole number, and prints 24 on the report. |
1. Report Name |
Specify the format that the system uses to print the report. The format that you specify must exist in the F74R9020 table. |
2. Report Title |
Specify the title that prints on the report. |
3. Report Title Continuation |
Specify additional text that prints with the title of the report. |
This section provides an overview of the Profit and Loss report for Russia, lists a prerequisite, and discusses how to:
Print the profit and loss report.
Set processing options for Profit and Loss (R74R9010).
The Russian government requires that you produce a Profit and Loss report (R74R9010) at the end of each accounting period. The Profit and Loss report is generated in PDF format. The report shows year-to-date balances of groups of accounts as well as previous year balances.
When you run the Profit and Loss report, the system reads the F0902 table to obtain the balances to print on the report. It also reads tables F74R9020, F74R2021, F74R2022, and F74R2023 to obtain information about the report column and row names to print, as well as other information about the layout of the report. The system produces a report and writes records to the F74R9010 table.
The Profit and Loss report has two sections:
Report Section |
Description |
Profit and Loss Statement |
The Profit and Loss Statement section of the report has two columns. The first column contains the sum of each period of the current year's balances. For example, if you run the report for the accounting period ending June, 2006, the first column shows the sums of the accounts from January, 2006 through June, 2006. The second column shows the sum of the same periods balances of the previous year. |
Explanation of Incomes and Losses |
The Explanation of Incomes and Losses section of the report contains four columns. There is a column for Income and a column for Expenses for the current year and for the previous year. Accounts with negative balances appear in the Expenses column. Accounts with a positive balance appear in the Income column. |
The system accesses the values in processing options to determine whether to scale the amounts that it prints, the ledger and subledgers to use, and the title to print on the report.
Verify that the report format, row descriptions, and other information that the system uses to print the report exist in tables F74R9020, F74R9021, F74R9022, and F74R9023.
Select General Accounting (G74R09), Profit and Loss.
The processing options for this report are the same as those for the Balance Sheet (R74R9030).
See Setting Processing Options for Balance Sheet (R74R9030).
This section provides an overview of the Cash Flow report, lists prerequisites, and discusses how to:
Print the cash flow statement.
Set processing options for Cash Flow (R74R9050).
The Russian government requires that you produce a cash flow report at the end of each accounting period. The Cash Flow statement (R74R9050) shows the starting balances of a group of accounts as well as the activity in the correspondence accounts. When you generate the Cash Flow statement, the system prints a report in PDF format and populates the F74R9050 table.
The report can show amounts for one account, a group of accounts, or a formula based on previous rows. You determine the amounts that appear on the report when you use the G/L Reports Setup program (P74R9020) to create the format for the report. If, when you create the report format, you define a row type as ACC (Accounts Only) or as AGR (Accounts Group), the system writes balances from the F0902 table to populate the starting balances on the report. The first column of the report shows the amount for the current fiscal year, and the second column shows the amount of the previous fiscal year. If you define a row type as AC2 (Correspondence - Account), the system populates the report with Period activity amounts (Periods 01 through 12) from the F74R9002 table.
The system accesses the values in processing options to determine whether to scale the amounts that it prints, the ledger and subledgers to use, and whether to print the report title the was defined in the Setup G/L Reports program.
Verify that the report format, row descriptions, and other information that the system uses to print the report exist in tables F74R9020, F74R9021, F74R9022, and F74R9023.
Select General Ledger (G74R09), Cash Flow.
The processing options for this report are the same as those for the Balance Sheet (R74R9030).
See Setting Processing Options for Balance Sheet (R74R9030).
This section provides an overview of the Changes in Equity report, lists prerequisites, and discusses how to:
Print the Changes in Equity report.
Set processing options for Changes in Equity (R74R9040).
The Russian government requires that you produce a changes in equity report at the end of each accounting period. The Changes in Equity report (R74R9040) shows the progress of several equity accounts. The report shows the balance, period activity, year-end adjustments as shown in accounting periods 13 and 14, and the starting balances for current and previous year.
When you generate the Changes in Equity report, the system prints a report in PDF format and populates the F74R9040 table.
Verify that the report format, row descriptions, and other information exists in the F74R9020, F74R9021, F74R9022, and F74R9023 tables.
Select General Ledger (G74R09), Changes in Equity.
The processing options for this report are the same as those for the Balance Sheet (R74R9030).
See Setting Processing Options for Balance Sheet (R74R9030).
This section provides an overview of the Petty Cash Book report and discusses how to:
Run the Petty Cash Book report.
Set processing options for Petty Cash Book (R74R5004).
Many transactions in Russia, including payroll and reimbursement for expenses, are paid in cash. Because of the transitory nature of cash, the Russian government requires additional steps to assure accurate accounting of cash transactions.
The Petty Cash Book report (R74R5004) contains one or more pages for each day of the year in which petty cash transactions take place. The pages list the transactions for the day. All pages are numbered consecutively by date; there cannot be any skipped numbers. This report satisfies the legal need for printing Russian Petty Cash Book. Transactions which are posted to the JD Edwards EnterpriseOne General Accounting system and transactions for which you have printed a cash issue note or a cash receipt note appear on the Petty Cash Book report.
When you run the Petty Cash Book report, the system reads records in F74R0100, F0901, and F0911 tables and summarizes the data by the GL date of the records.
The Petty Cash Book report lists:
Document number of the cash issue and cash receipt documents.
Name of person who received or issued the cash.
Corresponding account.
Issue amount.
Beginning and ending balance of the account.
Cash payroll transaction.
You use the Cash Book report to reconcile the Petty Cash Issue and Petty Cash Receipt documents against petty cash accounts.
Select Cash Desk Transactions (G74RCASH), Cash Book Report.
Processing options enable you to specify the default processing for reports.
Selection
Company |
Specify the company for which to run the report. If you leave this processing option blank, the system searches records for company 00000. |
Business Unit |
Specify the business unit for which to run the report. If you leave this processing option blank, the system selects records for all business units associated with the company that you specify in the Company processing option. |
Start Date and Through Date |
Specify the beginning and ending of the date range that the system uses to select records to process. |
Accounting
Petty Cash Account Number |
Specify the account number of petty cash transactions. |
Russian Account Analysis Category |
Specify the petty cash account. |
Petty Cash Book Document Type |
Specify the document type of the outbound petty cash transactions that you want to process. The value that you enter must exist in the UDC table 74R/CD. |
Detail Lines per Page |
Specify the number of detail lines that print on each page. The maximum number of lines that you can use is determined by the page size. For example, for a standard letter size page, you can print up to 47 lines. |
Ledger Type |
Specify a value that exists in the Ledger Type (00/LT) UDC table that the system uses to select records. |
Print Fields
Cashier Full Name and Accountant Full Name |
Specify the name of the cashier and the name of the accountant responsible for the Cash Book. |
Print Header Page |
Specify whether the system prints a header page. Values are: Blank or N: Do not print the header page. Y: Print the header page. |
Print Footer Page |
Specify whether the system prints a footer page. Values are: Blank or N: Do not print the footer page. Y:Print the footer page. |
Number Leaf for Month |
Specify the month that prints in the footer of the report if you set the Print Footer Page processing option to Y. |
Start Page Number |
Specify the starting page number that the system prints on the report. |
Report Name |
Specify the title that the system prints on the report. Leave this processing option blank to append the text that you enter to the text "Petty Cash for." For example, if you enter March 31, 2007, the system prints Petty Cash for March 31, 2007 on the report. Enter 1 to print the text "Loose Leaf of Cash Book" on the report. |
Foreign Currency |
Specify the currency in which to print the report. Values are: Blank or N:Print the report in the domestic currency. Y:Print foreign currency specified for the account in the F0901 table. |
Print Voided Documents |
Specify whether to print voided documents on the report. Values are: Blank or N: Exclude voided documents. Y: Include voided documents. |
Language
Report Language Preference |
Specify the language in which the system prints the report. The value that you enter must exist in UDC table 01/LP. |
You use the JD Edwards EnterpriseOne Fixed Assets system to set up depreciation for Russia. A Russian-specific depreciation method is provided, along with two Russian-specific formulas.
You must run the depreciation calculations for fixed assets on a monthly basis. Depreciation in Russia is calculated by dividing the net book value by the actual remaining asset life periods.
If you post additional costs to a fixed asset, you must add the additional cost to the original cost, subtract the accumulated depreciation, and then divide that sum by the remaining life of the asset. For example, if the original cost of the asset is 120,000 euros and the asset life is 12 months, the first month's depreciation is 10,000 euros. If you post an additional cost of 50,000 euros to the fixed asset during the second month, the calculation for depreciation would be (120,000 + 50,000 - 10,000) / 11 = 14,545.56.
Depreciation is calculated by using this formula:
(Original Cost + Additional Cost + Accumulated Depreciation - Salvage Value) divided by Actual Remaining Asset Life Periods
To set up depreciation for Russia, complete these steps:
Add RU (Russian Depreciation Method - 74R) to the Depreciation Method (12/DM) UDC table.
Use the Depreciation Formula Revisions program (P12853) to add the basis formula, RU1: (Basis [Cst-Svg] -74R). The formula is: 01+22+02-07.
Use the Depreciation Formula Revision program to add the depreciation formula, RU2: (SL [Period] - 74R). The formula is: 10/03.
Use the Depreciation Rules Revision program (P12851) to create a new depreciation rule for each Asset Life period that you define. Enter a Computation Direction of P and enter the Asset Life in periods.
Use the Depreciation Default Coding program (P12002) to add codes for each major accounting class.
See Also
Setting Up Depreciation Default Values
Setting Up Depreciation Formulas
Verifying Depreciation Information
Updating Global Depreciation Rules
Setting Up Depreciation Spread Patterns
This section provides an overview of revaluation codes for Russia, lists a prerequisite, and discusses how to create revaluation codes.
You use the Revaluation Code by Class program (P74R45010) to associated revaluation codes to the asset type for a fixed asset.
See Also
Setting Up Revaluation Indexes
Automatic Accounting Instructions
Form Name |
FormID |
Navigation |
Usage |
Work With Revaluation Code |
W74R5010A |
Fixed Assets (G74R12), Revaluation Codes |
|
Revaluation Code Review |
W74R5010B |
Select a record and click Add on the Work With Revaluation Code form. |
Access the Revaluation Code Review form.
Company |
Enter the company for which you revalue an asset. |
Major Accounting Class |
Enter the accounting class to which the asset belongs. The value that you enter must exist in the Major Accounting Class (12/C1) UDC table. |
Major Equipment Class |
Enter the subcategory to which the asset belongs. The value that you enter must exist in the Major Equipment Class (12/C2) UDC table. |
Revaluation Code |
Enter the index that you use to revalue the asset. The code that you enter must exist in the Revaluation Index (12/RI) UDC table. |
This section provides an overview of the additional information that you enter for fixed assets for Russia, lists a prerequisite, and discusses how to enter additional information
You use the Work With Additional Information program (P74R5100) to enter information about the fixed assets that the system uses when you print legally required documents for fixed assets. The system opens the forms that you need to complete after you add or modify data in the Asset Master Information program (P1201).
Verify that Localization Country Code in the User Display Preference is set to RU (Russia).
Form Name |
FormID |
Navigation |
Usage |
Work With Fixed Assets Additional Information |
W74R5100A |
Fixed Asset Master Information (G1211), Master Information Complete the necessary information, then click OK. |
|
Fixed Assets Additional Information - Revision |
W74R5100B |
Select a record on the Work With Fixed Assets Additional Information form and click Select. |
Access the Fixed Assets Additional Information - Revision form.
Date of Manufacturing |
Enter the date on which the asset was placed in service. |
Date of Modernization |
Enter the date on which the asset was upgraded or modernized. |
Doc Name of Placement |
Enter the name of contains the information about the asset being purchased or placed in service. |
Doc Number of Placement |
Enter the legal number from the document that contains the information about the asset being purchased or placed in service. |
Date of Placement |
Enter the date of the contains the information about the asset being purchased or placed in service. |
Actual Periods |
Enter the number of periods that the asset has been in service. |
Depreciation Amount |
Enter the amount that the system adds to the account balance of the associated account balance. Enter negative numbers by entering a minus sign (–) before or after the amount. |
Net Book Value |
Enter the net book value that the system prints on the Fixed Asset Card document. |
Membership of Share Holding |
Enter the name of the shareholder for a joint venture. |
Share Percentage |
Enter the percentage of the asset owned by the shareholder in a joint venture. |
Presence of Jewels |
Enter an explanation if the assets are jewels. |
Unit of Measure as Input |
Enter the unit of measure for the asset. The value that you enter must exist in the Unit of Measure (00/UM) UDC table. |
Quantity |
Enter the quantity of the asset. |
Actual Weight |
Enter the weight of the asset. |
Item Characteristics |
Enter a description of the asset. |
This section provides an overview of the additional lot information you must enter for Russia and discusses how to:
Set processing options for Set Up Item - Custom Declaration Number (P7464108).
Enter additional lot information.
After you enter lot information by using the Lot Master program (P4108), the system displays the forms for the Set Up Item - Custom Declaration Number program (P7464108). You enter customs information for foreign items for Russia in the Lot Additional Information program. The system determines that an item is a foreign item by comparing the Country of Origin field in the F4108 table with the Country Code field of the address book number of the Business Unit in table F4108. If both fields are different and are not blank, the system identifies the item as foreign.
When you enter the customs information, the system updates the F4108 table with the status code, according to the values set in the processing options.
Form Name |
FormID |
Navigation |
Usage |
Lot Master Revisions |
W4108A |
Lot Control (G4113), Lot Master Revisions. Select Add on the Work With Lot Master form. |
Select Add on the Work With Lot Master form. |
Work With Lot Additional Information |
W7464108A |
Click OK on the Lot Master Revisions form. |
Select an existing lot record. |
Lot Additional Information |
W7464108B |
Select a record on the Work With Lot Additional Information form and click Select. |
Add customs information. |
Use these processing options to specify default values for the program.
General
1. Update Status Code |
Specify whether the system updates the status code in the Status Code field (data item LOTS) in the F4801 table. Enter 1 to update the Status Code. Leave this processing option blank to suppress updating the status code. |
2. Enter Status Code |
Enter the code that the system uses to update the Status Code field (data item LOTS) in the F4801 table when you set the Update Status Code processing option to 1. |
3. Status Code Search |
Specify the status of the lot that the system uses to select records. The value that you specify must exist in the Lot Status Codes (41/L) UDC table. |
Access the Lot Additional Information form.
Customs Declaration Nbr (Customs Declaration Number) |
Enter the Declaration Number from the customs form. |
Customs Dispatch Date |
Enter the date of the customs form. |
Customs Code |
Enter the code that describes the customs classification for the lot. The code that you enter must exist in the Customs Code (74/CU) UDC table. |