Saturday 15 August 2015

what is foreign currency and how to post it in sap fico


FOREIGN CURRENCY TRANSACTIONS


1. Check exchange rate type


Bank buying              Exports                                   G type
Bank selling              Imports / Expenditure              B type

Average rate MM /SD users type

Path : SPRO-SAP Net weaver- General Settings – Currencies – Check exchange rate types

 Select position button 
Exchange rate type: B  (enter B)
Enter

Define translation rates for currency translation:

Giving conversion factors for two currencies:

            USD   1          :           INR 1
            JPY 100         :           INR 1              JPY=Japanese - Yen
            ERO 1            :           INR1
            GBP1             :           INR1               GBP=Great Britain  -Pound
  ITL1               :           INR1               ITL=Italian -Lira
 JPY   100        :           INR1   37Rs

            (Or)

1                      :           0.01    0.37

Once we follow one conversion factor follow continuously for all the years. Don’t change in between if we change in between it gives wrong results.

This is given at client level and not at company code level (Client 800)

Path: SPRO – SAP Net weaver- General settings – Currencies – Define translation
 ratios for currency translation

Ignore the message select yes button.
Select new entries button


Exchange rate type              From              To       valid (from)    Ratio (from)   Ratio (to)
G (Bank buying)                   USD               INR     01.10.2008    1                      1
B (Bank selling)                    USD               INR     01.10.2008    1                      1
M (Average rate)                  USD               INR     01.10.2008    1                      1

Select save button or Ctrl+S
Press enter to save in your request.

Enter exchange rates:


Path: SPRO- SAP Net weaver- General settings- currencies – Enter exchange rates

Forex Table
We can enter Daily quotations / Week end quotations / Month end quotations.

For each day end for each type we can enter only one rate.

Select new entries button

Exchange type          Valid from      R         From currency          Director quotation       To
G                               10.10.2008    1          USD                           47.00                        INR
B                               10.10.2008    1          USD                           47.50                        INR
M                              10.10.2008    1          USD                           47.10                        INR

Press enter and save in your request.


Exchange rates entry at the End User Area: 

Path: Accounting – Financial accounting – General ledger-Environment – Current settings – Enter translation rates (S_BSE_68000174)


Foreign currency postings for end user area:


SCENARIO :1                                                                       SCENARIO 2

When exchange rate is not entered at                 When exchange rate is entered at the
the time of posting.                                                  Time of posting

    1. IF we don’t enter the rate at the time of posting, it takes rate from Forex table

    1. If take the latest date rate
01.10.2008                                      45
10.10.2008                   47

Enter date      :15.10.2008
Posting date  :09.10.2008

    1. To enter default exchange rate type based on document type.
General ledger posting                               : SA  Bank selling rate
Purchase INV posting (FI purchases)         :KR  Bank selling rate
MM Purchases                                            :RE   Bank selling rate

Sales invoice posting (FI Sales)                   DR Bank buying rate
SD sales                                                       RV Bank buying rate

If we do not specify system takes average rate.

  1. To enter default exchange rate type B (Bank selling rate) for document type
‘SA’

Use the Tr. Code is OBA7

Select type                                        : SA
Select details button
Under default values exchange rate type for foreign currency documents. Select B (Bank selling rate)
Save

  1. Posting of expenditure in USD F-02

Give the document  date    : To days date
Type                                       : SA
Company code                     :AML
Currency                               : USD
Rate                                        : Blank
Posting key                           :40
Account                                 : 400100 (salary)
Enter
Give the amount                     :1000
Business area                         : AMLH
Text                                      : Salary payment     
Enter
Posting key                            : 50
Account                                 :200100 (cash account)
Enter
Amount                                  : *
Business area                          : AMLH
Text                                       :+
From the menu select Document ->Simulate

To view in INR
Select display currency button
Save


When exchange rate is extend at the time of posting

Expenditure posting Tr.Code is F-02

Document date                        : To days date
Type                                      : SA
Company code                        : AML
Currency                                : USD
Rate                                       :50
Posting key                             :40
Account no.                            :400100 (salary account)
Enter
It gives the warning message exchange rate 50 deviates from table rte 47.50 by 5.26%
Ignore the warning message press enter
Amount                                  :10000 USD
Business area                          : AMLH
Text                                        : Salary payment
Enter
Posting key                              :50
Account no.                              :200100 (Cash account)
Enter
Amount                                    :*
Business area                            :AMLH
Text                                         :+
From the menu select Document ->Simulate and save


No comments:

Post a Comment