(RUS) Working With General Ledger Reporting, Fixed Assets, and Inventory Management for Russia

This chapter discusses how to:

Click to jump to parent topicGenerating a Balance Sheet

This section provides an overview of the balance sheet for Russia, lists prerequisites, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Balance Sheet for Russia

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.

Click to jump to top of pageClick to jump to parent topicPrerequisite

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.

Click to jump to top of pageClick to jump to parent topicPrinting a Balance Sheet

Select General Ledger (G74R09), Balance Sheet.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Balance Sheet (R74R9030)

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.

Print

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.

Click to jump to parent topicGenerating the Profit and Loss Report

This section provides an overview of the Profit and Loss report for Russia, lists a prerequisite, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Profit and Loss Report for Russia

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.

Click to jump to top of pageClick to jump to parent topicPrerequisite

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.

Click to jump to top of pageClick to jump to parent topicPrinting the Profit and Loss Report

Select General Accounting (G74R09), Profit and Loss.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Profit and Loss (R74R9010)

The processing options for this report are the same as those for the Balance Sheet (R74R9030).

See Setting Processing Options for Balance Sheet (R74R9030).

Click to jump to parent topicGenerating a Cash Flow Statement

This section provides an overview of the Cash Flow report, lists prerequisites, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Cash Flow Report

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.

Click to jump to top of pageClick to jump to parent topicPrerequisite

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.

Click to jump to top of pageClick to jump to parent topicPrinting the Cash Flow Statement

Select General Ledger (G74R09), Cash Flow.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Cash Flow (R74R9050)

The processing options for this report are the same as those for the Balance Sheet (R74R9030).

See Setting Processing Options for Balance Sheet (R74R9030).

Click to jump to parent topicGenerating the Changes in Equity Report

This section provides an overview of the Changes in Equity report, lists prerequisites, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Changes in Equity Report

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.

Click to jump to top of pageClick to jump to parent topicPrerequisite

Verify that the report format, row descriptions, and other information exists in the F74R9020, F74R9021, F74R9022, and F74R9023 tables.

Click to jump to top of pageClick to jump to parent topicPrinting the Changes in Equity Report

Select General Ledger (G74R09), Changes in Equity.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Changes in Equity (R74R9040)

The processing options for this report are the same as those for the Balance Sheet (R74R9030).

See Setting Processing Options for Balance Sheet (R74R9030).

Click to jump to parent topicGenerating the Petty Cash Book Report

This section provides an overview of the Petty Cash Book report and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Petty Cash Book Report

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:

You use the Cash Book report to reconcile the Petty Cash Issue and Petty Cash Receipt documents against petty cash accounts.

Click to jump to top of pageClick to jump to parent topicRunning the Petty Cash Book Report

Select Cash Desk Transactions (G74RCASH), Cash Book Report.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Petty Cash Book (R74R5004)

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.

Click to jump to parent topicSetting Up Depreciation

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:

  1. Add RU (Russian Depreciation Method - 74R) to the Depreciation Method (12/DM) UDC table.

  2. Use the Depreciation Formula Revisions program (P12853) to add the basis formula, RU1: (Basis [Cst-Svg] -74R). The formula is: 01+22+02-07.

  3. Use the Depreciation Formula Revision program to add the depreciation formula, RU2: (SL [Period] - 74R). The formula is: 10/03.

  4. 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.

  5. Use the Depreciation Default Coding program (P12002) to add codes for each major accounting class.

See Also

Setting Up Depreciation Rules

Setting Up Depreciation Default Values

Setting Up Depreciation Formulas

Verifying Depreciation Information

Updating Global Depreciation Rules

Setting Up Depreciation Spread Patterns

Click to jump to parent topicCreating a Revaluation Code

This section provides an overview of revaluation codes for Russia, lists a prerequisite, and discusses how to create revaluation codes.

Click to jump to top of pageClick to jump to parent topicUnderstanding Creating a Revaluation Code

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

Click to jump to top of pageClick to jump to parent topicForms Used to Create a Revaluation Code

Form Name

FormID

Navigation

Usage

Work With Revaluation Code

W74R5010A

Fixed Assets (G74R12), Revaluation Codes

Select a record.

Revaluation Code Review

W74R5010B

Select a record and click Add on the Work With Revaluation Code form.

Modify a record.

Click to jump to top of pageClick to jump to parent topicCreating a Revaluation Code

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.

Click to jump to parent topic(RUS) Entering Additional Information for Fixed Assets in Russia

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

Click to jump to top of pageClick to jump to parent topicUnderstanding Additional Information for Fixed Assets

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).

Click to jump to top of pageClick to jump to parent topicPrerequisite

Verify that Localization Country Code in the User Display Preference is set to RU (Russia).

Click to jump to top of pageClick to jump to parent topicForms Used to Enter Additional Information for Fixed Assets

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.

Select an existing record.

Fixed Assets Additional Information - Revision

W74R5100B

Select a record on the Work With Fixed Assets Additional Information form and click Select.

Add additional asset information.

Click to jump to top of pageClick to jump to parent topicEntering Fixed Asset Additional Information

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.

Click to jump to parent topic(RUS) Entering Additional Lot Information

This section provides an overview of the additional lot information you must enter for Russia and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Lot Information for Russia

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.

Click to jump to top of pageClick to jump to parent topicForms Used to Enter Additional Lot Information for Russia

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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Set Up Item - Custom Declaration Number (P7464108)

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.

Click to jump to top of pageClick to jump to parent topicEntering Additional Lot Information for Russia

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.