FBB1 Realized foreign currency valuation process / Realized month end foreign currency valuation process / How to process for realized foreign currency valuation

Introduction:

Before creating Financial Statements, we have to perform Foreign Currency Valuation process. This document especially for foreign currency bank account valuation purpose which have to proceed in the month end and it is realized amount (No need to reverse to the next month). So at the month end, there could be some revenue or expense due to exchange rate fluctuations which would be reflected in the Financial Statements.

Scenario:

As an example (please see the below mentioned screenshot), for GL 40440070, devided with local currency amount and dollar amount, per dollar rate is showing BDT 131.08 BDT. Supporse current moth end dollar rate is BDT 78. So we need to get some adjustment entry. As per calculation we have to adjust BDT 1,226,145.51 to meet the dollar rate BDT 78.

Process:

Step -1

Go through T.Code FBB1

Value Field

Field Name	Description	Values
Doc. Date	Document Date	Example : 31.07.2016
Company Code	Company Code	Example : 1100
Posting Date	Posting Date	Example : 31.07.2016
Currency	Currency	Example : USD
Posting Key	Two-digit numeric key that determines the way line items are posted. This key determines several factors including the account type, type of posting (debit or credit) and layout of entry screens.	Example : 40
Account	GL account number	Example : 70030450

Step -2

For GL 70030450 – Realized Forex Loss

Value Field

Field Name	Description	Values
Amount in LC	Amount in local currency	Example : 1,226,145.51
Amount in DC	Amount in Document Currency	Example : 0
Cost Center	Cost Center Code	Example : 1101101000
Posting Key	Two-digit numeric key that determines the way line items are posted. This key determines several factors including the account type, type of posting (debit or credit) and layout of entry screens.	Example : 50
Account	GL account number	Example : 40440070

Step -3

For GL 40440070 – SIBL, Dhaka – FC a/c balance

Value Field

Field Name	Description	Values
Amount in LC	Amount in local currency	Example : 1,226,145.51
Amount in DC	Amount in Document Currency	Example : 0
Profit Center	Profit Center Code	Example : 110110

Step -4

Click “Display currency” button

Step -5

After click “Display currency” botthon then local currency will be appear.

Click the Save button to save this document. 

SAP Step by Step guide line for T.code creation through SE93 / How to create T.Code

SAP Step by Step guide line for T.code creation through SE93


Step -1 : Write your transaction code . Example here : ZVLEDGER

Step: 2

-         -  Mention Short text

-          - Select “Program and selection screen (report transaction)” from “Start object” option.

- Then press save button

Step – 3

-          From program option please mention problem name . Example : ZVLEDGER

-          From classification option , please mention “professional user Transaction”

Then press Save button

Job scheduling for daily / weekly / Monthly

As a example, go through T.Code KO8G. Select the highlighted area for background process.

Click    from execute the process. After click below screen appear.

Mention Job name. Date and time no need to mention. Then click the   button.

 After that below screen will appear.

Please click the  button.

After that, please go through T.Code SM37 , then below screen will appear.  For status option, consider only “Planned” option.

Then click   button for execution after that below screen will appear. First select the arrow option then click “Release” option.

After click “Release” option below window will appear. Please click the arrow indicate button.

After click that below screen will show you.  You have to now mention date and time. Please click the arrow indicate “Period Values” button.

After click, will offer you , job execute frequency. We are selecting here “Weekly”

Then we will click Save Button.

Now we will see the job schedule.

Click button for execute. After that below screen will appear. Click the highlighted area.

Then below screen will appear. In the highlighted area, we can see that job frequency has been mentioned as “Weekly “, mean this job will be executed weekly. 

MC.9 and Inventory GL balances Mis match problem / Error in inventory MC.9 / Negative stock value in MC.9 / fico inventory and gl balances problem

Please maintain the below mention check list for get good result.

Checklist:

1) Ensure offline backup finished.
2) Run the SAP system
3) lock all the sap users.
4) Hold the background jobs(using BTCTRNS1)
5) Run Progam RMCSISCP
6) Copy S032 000 version to 001 version
7) make sure data are coppied (check using SE16n)
8) Delete S032 000 version data
9) Ensure 000 version data deleted (using SE16n)
10) Run program RMCBNEUB to Setting up the inventory information structures
11) Run Program RMCBNEUA for Setting up the data from material documents
12) Run program RMCBNERP to setup accounting documents.
13) check the values of Mc.9 & FS10n
14) Release background jobs (Using BTCTRNS2)

15) Unlock the SAP users.


Before process.

From FS10N (GL - 131000- Raw Material) Balance 1,022,854,187.12

MC.9    balance 981,428,111.35






Differ = 1,022,854,187.12 - 981,428,111.35 = 41,426,075.77

As per Note 0000079083, we have followed this procedure.

     1.  Making a backup copy (Use program RMCSISCP)
      

   Below message appear in the screen.

   2.  Deleting the data in version '000' (Using program RMCSISCP)

    

   After processing below message appear.

3. Setting up the inventory information structures (Use program RMCBNEUB)

4. Setting up the data from material documents (movement information structures)

Using program RMCBNEUA

5. Setting up the data from accounting documents (movement information

structures)

After Process

Inventory Balance (T.code - MC.9) 1,022,835,257.82

GL – 131000 (T.code FS10N)  Raw Material Balance 1,022,854,187.12

Differ =1,022,854,187.12 - 1,022,835,257.82 = 18,929.3 only 18,929.3 differ