FI CO Table Mapping

FI CO Master Data

STEP-1: Create a allocation cost element
Accounting>>Controlling>>Cost Element Accounting>>Master Data>>Cost Element>>Individual Processing>> Create Secondary
T code: KA06

Enter your controlling area in the pop up screen for ‘Set Controlling Area’
Cost element <enter cost element unique number>
Valid from <first day of the current year>
Click on Master Data button
Name < Enter name of the cost element>
Description <enter description>
Cost element category <43>
<Save>

STEP-2: Create activity type
Accounting>>Controlling>> Cost Center Accounting>> Master Data>> Activity Type>> Individual Processing>> KL01 – Create
T code: KL01
Activity Type <enter unique activity ID>
Valid from <first day of the current year>
Click on Master Data button
Name <enter name of the activity>
Description <enter description of the activity>
Activity Unit <select HR>
Cost center categories < *>
Activity type category <3>
Allocation cost element <enter cost element, created in step-1>
Price indicator <3>
<Save>

STEP-3: Enter activity price
Accounting>>Controlling>> Cost Center Accounting>> Planning>> Activity Output/Prices>>Change
T code: KP26
Version <0>
From period <1> to period <12>
Fiscal Year <2009.>
Cost center <enter the sender cost center ID>
Activity type< enter the sender cost centre activity type, defined in step-2>
Select the radio button for Form Based option
Click on <Period screen>
Enter activity price for all periods in the presented screen in the column for fixed price.

STEP-4: Enter Sender activities
Accounting>>Controlling>> Cost Center Accounting>> Actual Postings>>
Sender Activities>> Enter
T code: KB51N
Sender cost centre<Sender cost centre>
Sender activity type<sender’s activity created in step-2>
Total Quantity<total activity quantity of the sender>
<Save>

STEP-5: Create SKF and enter SKF for the current period for at least 2 receiver cost centers.
T. code KK01 and KB31N

STEP-6: Create cycle and segment
Accounting>>Controlling>> Cost Center Accounting>> Period-End Closing>> Current Settings>> Define Indirect Activity Allocation
Cycle<unique ID for cycle>
Start date <first day of your fiscal year>
Hit <Enter>
Text <description>
Click on <Attach Segment>
Segment name<unique name>
Description<description>
Rule <Posted quantities>
Shares in % <100>
Confirm defaulted radio button for <Actual value>
Receiver Tracing Factor<Variable Portion>
Variable portion type<select Actual Statistical Figures>
Click on Sender/Receivers Tab
Sender:
Cost center <enter sender cost center>
Activity type<select activity type created in step-2>
Receiver:
Cost centre: From—To <enter receiver cost centres or Group
Click on Receiver Tracing Factor Tab
Variable portion type <Actual Statistical Figures>
Selection criteria:
Statistical key figure <select SKF created in step-5>
<Save>

STEP-7: Execute indirect activity cycle and segment:

Accounting>>Controlling>> Cost Center Accounting>> Period-End Closing>> Single function>> Allocations>>Indirect Activity Allocation

T code: KSC5

Period From –To <current period>
Fiscal year<current fiscal year>
Flag for Test Run
<Execute>
Review the results and if results correct, remove the test run flag and again execute in production mode.
Confirm postings in sender and receivers cost centers line item report.
T code KSB1

By: erpgenie.com

STEP-1: Create allocation cost element

Accounting>>Controlling>>Cost Element Accounting>>Master Data>>Cost Element>>Individual Processing>> Create Secondary
T code: KA06
Enter your controlling area in the pop up screen for ‘Set Controlling Area’
Cost element <enter cost element unique number>
Valid from <first day of the current year>
Click on Master Data button
Name < Enter name of the cost element>
Description <enter description>
Cost element category <43>
<Save>

STEP-2: Create activity type
Accounting>>Controlling>> Cost Center Accounting>> Master Data>> Activity Type>> Individual Processing>> KL01 – Create
T code: KL01
Activity Type <enter unique activity ID>
Valid from <first day of the current year>
Click on Master Data button
Name <enter name of the activity>
Description <enter description of the activity>
Activity Unit <select HR>
Cost center categories < *>
Activity type category <1>
Allocation cost element <enter cost element, created in step-1>
Price indicator <3>
<Save>

STEP-3: Set Planner Profile
Accounting>>Controlling>> Cost Center Accounting>> Planning>> Set Planner Profile
T code: KP04
Select <SAPALL> in the pop up screen for ‘Set Planner Profile’
Click on green check mark

STEP-4: Create 3 new cost centers (T code-KS01) and post transactions in one of this cost center in current date. This cost center you will use as sender cost center and the other two cost centers you will use as receiver cost centers.

STEP-5: Enter activity price
Accounting>>Controlling>> Cost Center Accounting>> Planning>> Activity Output/Prices>>Change
T code: KP26
Version <0>
From period <1> to period <12>
Fiscal Year  <2009.
Cost center <enter the sender cost center ID>
Activity type< enter the sender cost centre activity type, defined in step-2>
Select the radio button for Form Based option
Click on <Period screen>
Enter activity price for all periods in the presented screen in the column for fixed price.

STEP-6: Enter Activity Allocation

Accounting>>Controlling>> Cost Center Accounting>> Actual Postings>> Activity Allocation>>Enter
T code: KB21N
Sender cost centre <sender cost centre that provides the activity>
Sender Activity Type<select sender’s activity type>
Receiver cost center-1<Receiver cost centre that receives the activity>
Total quantity<Quantity of the activity>
Receiver cost center-2<Receiver cost centre that receives the activity>
Total quantity<Quantity of the activity>
<Post>
STEP-7: Confirm the allocation postings in receiver and sender cost centers in cost center line item report. T code-KSB1

By : erpgenie.com

Very helpful 200 pages FI / CO Configuration guide.

http://sharingmatrix.com/file/3568144/sap-fico-configuration-guide.pdf

By: SAP FICO Configuration Guide @ sapdocs.info

Why should I do foreign currency valuation?

Foreign currency valuation is done for ascertaining the gain or loss occurred in an account balance/account payment due to fluctuations in foriegn exchange rate. Account balances and open items posted in foriegn currencies are required to be valuated at a particular date before preparing the financial statements to present a fair picture of the transactions.

To carry out a foreign currency valuation, you must first make certain settings in Customizing. You make the settings in Customizing under Financial Accounting > General Ledger Accounting/Accounts Receivable and Accounts Payable > Business Transactions > Closing > Valuating > Foreign Currency Valuation.

- You must define the exchange rates.

- You must also define a valuation method. (Choose Define valuation methods.)

- You must also define the expense and revenue accounts for exchange rate differences from valuations. For payables and receivables accounts you must also define the financial statements adjustment accounts. To do this, choose Automatic postings for foreign currency valuations.
If you want to carry out a parallel valuation, you must also have defined a valuation area. Choose Define valuation areas.

- The exchange rate differences from the parallel valuation are posted in this valuation area. If you carry out a parallel valuation with a different valuation method to the first valuation, you do not have to reverse the postings from the first valuation. This information is then available for subsequent closing operations, for example, Transferring and Sorting Receivables and Payables

The following describe how to carry out foreign currency valuation using the reports, and how to post valuation differences.

You can also make this posting manually. From the SAP Easy Access screen, choose Accounting > Financial accounting > General ledger > Document entry > Valuate foreign currency.

To carry out a foreign currency valuation, from the SAP Easy Access screen, choose Accounting > Financial accounting > General ledger/Accounts receivable/Accounts payable > Periodic processing > Closing > Valuate > Foreign currency valuation.

By: www.sap-basis-abap.com

How to configure FICO Reconciliation

In Co, we create Recon accts to keep Fi gl in balance with CO. Not all transactions affect FI gls, best example of it is internal order settlements, they use secondary cost elements and does not affect your G/l accts. To update FI side of it we maintain recon accts. These are primarily for cross company, cross functional and cross business area transactions.

The number of recon accts to be defined is dependant on various factors, like how your management wants to see the reports.. whether they want to classify the cost based on CO object class or by Co types etc..

However the basic config you got to follow is:

1. Activate Recon accts (if you have created CO area newly, it would be active).
use T.code: KALA

2. Assignment of Recon document type to the Controlling area.
T.code: OKKP

3. Creating clearing accts (that you want to us! e for reconciliation. During FI-Co recon.. inter company clearing accounts will be automatically credited or debited and now you need to create offset acct which will show up in P&l acct).
Acct determination set up thru T.code: OBYA

4. Maintain accts for Automatic Recon posting.
T.code OBYB

5. Assign Number ranges to Recon activity.
Tcode OK13

By : Radha Krishna                                         

SAP FI CO SD WE02 Display IDOCS

What is Debit note and Credit note?

Debit Memo – It is a sales document used in complaints processing to request a debit memo for a customer. If the prices calculated for the customer were too low, for example, calculated with the wrong scaled prices, you can create a debit memo request. The debit memo request can be blocked so that it can be checked. When it has been approved, you can remove the block. It is like a standard order. The system uses the debit memo request to create a debit memo.

Credit Memo – A transaction that reduces Amounts Receivable from a customer is a credit memo. For eg. The customer could return damaged goods. A debit memo is a transaction that reduces Amounts Payable to a vendor because, you send damaged goods back to your vendor.

Credit memo request is a sales document used in complaints processing to request a credit memo for a customer. If the price calculated for the customer is too high, for example, because the wrong scale prices were used or a discount was forgotten, you can create a credit memo request. The credit memo request is blocked for further processing so that it can be checked. If the request is approved, you can remove the block. The system uses the credit memo request to create a credit memo.

As mentioned above, creating a credit or debit memo request enables you to create credit or debit memos based on a complaint. For this first create a sales document with the order type for a credit or debit memo request. You can create the debit or credit memo requests in the following ways:
– Without reference to an order
– With reference to an existing order
Here you enter which order the complaint refers to.
– With reference to an invoice
Here you enter which invoice the complaint refers to.
In all cases, you specify the value or quantity that should be in the credit or debit memo

You can block the credit or debit memo request from being billed in Customizing. Go to Sales -> Sales Documents -> Sales document header -> Define sales document type and select the billing block field in the billing section. This request can later be reviewed along with similar ones, – if necessary, by another department. The request for a credit or debit memo can then be approved or rejected.  

To create  Credit / Debit Memo request: 
- Use the same procedure that you use for Creating Sales Orders i.d  T Code  VA01
- Give Order Type  as CR for Credit Memo  and DR for Debit Memo reuest

While creating  the request you have to enter Customer Number, Reason for the request. and Material and its quantity.  Once the  credit or debit memo request is released you can create credit or debit memo.  The credit memo request  will be automatically blocked  for checking with Billing Block 08 (to check credit memo) & 09 (to check debit memo) for the sales order type “CR” .

If it is not so you can customize the block for credit memo requests in Customizing for SD when you define the order type Sales and Distribution -> Sales -> Sales Documents -> Sales Document Header -> Define sales document types.  The release of  block is  allowed to be removed only by the people who are authorized for it. If the amount is within acceptable limit the block is automatically released otherwise all the people assigned to this job receive a work item in their integrated inbox for release.

If the complaint is not automatically blocked by the settings in Customizing, you can set a delivery or billing block manually.
- Logistics -> Sales and distribution -> Sales.
- Choose Order -> Change.
- Enter the number of the sales document, or use a matchcode to search for it.
- Choose Enter.
- If all the items have been blocked, choose Select all.
- If only some items should be blocked, select the corresponding items.
- Choose Edit -> Fast change of… -> Delivery block or Billing block.
- Enter the delivery or billing block for the header or individual items.
- Choose Copy.
- The system copies (or deletes) the delivery or billing block in all the selected items.
- Save your document.

Tips by : Rajendran

 1.   Cost of Goods Sold    Dr 100   (T-Key GBB)
To Inventory Account Cr 100   (T-Key BSX)

The automatic entries are posted to inventory accounts through T-keys to which GL accounts are assigned. These T-keys are assigned to movement types in MM. Please refer to T-code OMWN and OMWB for proper understanding. 

By : Kishore