Docstoc

Fin masterdata

Document Sample
Fin masterdata Powered By Docstoc
					                      [2009]


  [Training topics & Exercises on
General Ledger – ERP Ln Finance]




                      [Venugopal Pulluri]
                      [coServesolutions]
                      [April 2009]
General Ledger (GLD)

   (1) Master Data
              (a) GLD Parameters – Group Company, Company –
                  NOTE: Don’t change any setup
              (b) Basic Data setup: defining periods, chart of accounts, dimensions,
              Transaction types etc.
Note: Use the coding structure as discussed and specific to NPC process only
PERIODS:

Menu: Finance/General Ledger/Master Data/General Ledger structure
Session: tfgld0105m000 Periods
Create New Year and Periods for Fiscal and Tax types

From Specific of Periods select End Dates by Fiscal year
Session tfgld0106s000 and give dates

From Specific of Periods Select Period status
Session: tfgld0107m000 Period Status.
Status with Open for all Periods of Fiscal and Tax types

CHART OF ACCOUNTS

Menu: Finance/General Ledger/Master Data/General ledger structure
Session: tfgld0508m000 Chart of Accounts

Create Some Ledger accounts: with the coding structure we discussed.
   - Salaries account                      P&L Account
   - General Expenses account              P&L Account
   - Sales Account                         P&L Account
   - Stock Account                         Balance Sheet
   - Invoices to be Received               Balance Sheet
   - Debtors Account                       Balance Sheet
   - Invoice Receipts                      Balance Sheet

DIMENSION CODES

Menu: Finance/General Ledger/Master Data/General ledger structure
Session: tfgld0510m000 Dimensions

Create Dimensions for Business Unit (Dimension type 1)
   - SC
   - CB
   - EC
Also create some dimensions for Cost center / Employees
                                                                               2|Page
GLD Exercises
LINK Range of Dimensions for a Ledger Accounts

Menu: Finance/General Ledger/Master Data/General ledger structure – Chart of
accounts – Specific – Dimension ranges
Session: tfgld0509m000 Dimension Ranges by Ledger Accounts

For Sales Account link the cost centers from Marketing 1 to Marketing 3. That means no
other cost center to be used for that ledger account/


TRANSACTION TYPES

Menu: Finance/General Ledger/Master Data/General ledger processing
Session: tfgld0511m000 Transaction Types

Create Some Transaction types

Journal Vouchers

      Journal Vouchers (tfgld1103s000).
      Journal Vouchers (Multiple Lines) (tfgld1115m000).
      Journal Vouchers for Reporting Currencies (tfgld1125s000)

The Journal Vouchers (tfgld1103s000) session is the most detailed session for entering
ledger transactions. You can enter five dimensions, a tax code, two units, and so on.

The Journal Vouchers (Multiple Lines) (tfgld1115m000) session is an overview session
in which you can enter transaction lines.

You can use the Journal Vouchers for Reporting Currencies (tfgld1125s000) session to
create journal vouchers with a zero transaction amount and with amounts in the reporting
currencies only. In a multi company structure, you can use this functionality to manually
eliminate currency differences in the general ledger.

Sales Invoices and Sales Credit Notes

      Main session: Sales Invoices (tfacr1110s000).
      Next session: Sales Invoice Transactions (tfacr1111s000).

Sales Corrections
For corrections on invoices:

      Main session: Sales Invoice Corrections (tfacr2110s000).
      Next session: Sales Invoice Transactions (tfacr1111s000).

For linking credit notes to several sales invoices:
                                                                              3|Page
GLD Exercises
      Main session: Business Partner - Credit Notes (tfacr2120m000).
      Next session: Assign Credit Notes to Invoices (tfacr2121m000).

For indicating that an invoice is doubtful or no longer doubtful

      Doubtful Sales Invoices (tfacr2140m000).

Purchase Invoices and Purchase Credit Notes
If the purchase invoice type is Cost Invoice:

      Multi-line
         o Main session: Purchase Invoices (tfacp1110s000).
         o Next session: Purchase Invoice Transactions Multi-line (tfacp1120m000).

       Single line

           o   Main session: Purchase Invoices (tfacp1110s000).
           o   Next session: Purchase Invoice Transactions (tfacp1120s000).

If the purchase invoice type field is Invoice Related to Purchase Orders:

      Main session: Purchase Invoices (tfacp1110s000).
      Next session: Matched Purchase Invoice/Statement Line Transactions
       (tfacp1133s000).

Purchase Corrections
For corrections on purchase invoices:

      Main session: Purchase-Invoice Corrections (tfacp2110s000).
      Next session: Purchase Invoice Transactions (tfacp1120s000).

For linking credit notes to several purchase invoices:

      Main session: Assign Credit Notes to Invoices (tfacp2120m000).
      Next session Next session Next session Assign Invoices to Credit Notes
       (tfacp2121s000).

Opening Balance

      The Opening Balances (tfgld1105s000) session

Cash
For cash transactions and bank transactions (multiline):

      Main session: Bank Transactions (tfcmg2500m000).
      Next session: Cash Management Transactions (tfcmg2120s000).
                                                                                4|Page
GLD Exercises
For cash transactions and bank transactions (individual):

      Main session: Bank Transactions (tfcmg2100s000).
      Next session: Cash Management Transactions (tfcmg2120s000).

For anticipated payments:

      Main session: Anticipated Payments (tfcmg2110s000).
      Next session: Anticipated Payments (Details) (tfcmg2116s000).

For anticipated receipts:

      Main session: Anticipated Receipts (tfcmg2111s000).
      Next session: Anticipated Receipts (Details) (tfcmg2117s000).

To change the status of anticipated payments:

      Main session: Anticipated Payment Status (tfcmg2512m000).
      Next session: Anticipated Payments (Details) (tfcmg2116s000).

To change the status of anticipated receipts:

      Main session: Anticipated Receipt Status (tfcmg2513m000).
      Next session: Anticipated Receipts (Details) (tfcmg2117s000).

To assign unallocated payments or advance payments to purchase invoices:

      Main session: Assign Advance/Unallocated Payments to Invoices
       (tfcmg2131s000).
      Next session: Assign Unallocated/Advance Payments to Invoices
       (tfcmg2106s000).

To assign unallocated receipts or advance receipts to sales invoices:

      Main session: Assign Advance/Unallocated Receipts to Invoices
       (tfcmg2130s000).
      Next session: Assign Unallocated/Advance Receipts to Invoices
       (tfcmg2105s000).




                                                                           5|Page
GLD Exercises
   (2) Transaction Processing: creation of batch, transactions, finalization of
       batches etc.

Step 1: Start New Batch:

Menu: Finance/General Ledger/General Ledger Processing/Journal entry
Session: tfgld1101m000 Transactions

Create a Transaction with type for ex. Opening Balance XXX / Any JV Type

   -   Give some debit transactions of Balance Sheet type for Opening balances
   -   Give some credit transactions of Balance Sheet type for Opening balances
   -   Save the Batch

* To check the Non-Finalized Batch Print. Use session tfgld1401m000 (This is also
possible from Transactions print session)

Step 2: Finalize the Batch & Print Journal Report

Menu : Finance/General Ledger/General Ledger Processing/Finalization
Session : tfgld1519m000 Finalization Run number

   -   Create New finalization Run number for the year
   -   Then Press Select Batches
   -   It pops up the session tfgld1111s000
   -   Select the above created batch and change status of Select to Yes and finalize

Step 3: Reprint Journal Report

Menu: Finance/General Ledger/General Ledger Processing/Finalization
Session: tfgld1410m000 Reprint Journal Report
   - Select Batch and print to check the outcome of finalized batch.

   (3) Recurring JV

Recurring Journals
Menu: Finance/General Ledger/General Ledger Processing/Journal Entry
Session: tfgld1410m000 Recurring Journal

Create a Recurring JV Code. Go to Lines (tfgld1410m100)
Add the debit and credit account lines
Status – “Registered”
Instructions tab: Specific – Create Instructions
Approve Recurring JV – Save and Exit
From Specific of Recurring Journals – Generate Recurring Transaction Journals

                                                                               6|Page
GLD Exercises
   (4) Reverse Entry:

Menu: Finance/General Ledger/General Ledger Processing/Journal Entry
Session: tfgld1295m000 Reverse Entry

   -   Finalize the batch created above for Normal JV or the Recurring JV.
   -   Use this session to reverse that entry and view the transactions
   -   Finalize the new batch created

Note your Observations:

   (5) Write off Currency Differences:

Create one account with “Reqd. calc. curr. diff” option under Currency Analysis
Make one JV with Foreign currency transaction with old date in old period
Say – 10th Jan 2009. Note the exchange rate between foreign currency and SAR.

   -   See if the rate is changed on a subsequent date, Ex- 31st Jan 2009 or 28th Feb 2009
   -   Write off currency differences for your account as on that date and see the report
            o Session tfgld5201m000 (Finance-General ledger – Periodic processing –
                Period handling)
   -   If results are correct, then POST the differences.

   (6) Transaction Schedule:

Menu: Finance/General Ledger/General Ledger Processing
Session - tfgld0112m000
Create Schedule
   - Create schedule type of % or amounts or Factors
   - Maintain lines in tfgld0113s000 with Account, Dimensions, Amounts, Dr / Cr
   - Save and exit the schedule
   - Create JV batch
   - Complete the header of JV
   - In the lines – Specific – Choose “Create Transactions from Schedule”
   - Make if any changes required and then finalize the batch

   (7) Schedule for Automatic Transactions:

Menu: Finance/General Ledger/General Ledger Processing
Session: tfgld0130s000
   - Create the Base Transaction type and Ledger account –
   - Add the Additional Debit and Credit lines to be created with Account and
       dimension details
   - Create one JV for base Transaction type and account, Close the batch
   - Print Non-Finalized transactions – Observe the Transactions
   - Finalize the batch- See the difference in the transactions created
                                                                               7|Page
GLD Exercises

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:19
posted:7/12/2011
language:English
pages:7