Check whether FI period opened or not

You can find this from the Current Settings (Environment menus) in FI.

For example :- Accounting ->Financial Accounting -> General Ledger -> Environment -> Current Settings
-> Open and Close Posting Periods.

Using FB02 FB03 - Change/Display Financial Accounting documents

All business transactions posting are stored in the Financial Accounting Modules as accounting documents.

FBV1 FBV2 FBV3 - Create/Change/Display Parked Document

Parked Document are incomplete accounting documents which are stored for later postings.

Configure the document line layouts

• O7Z1 - Define line layout for document change/display

O7V1 - Select default line layout for document change/display by transaction codes.

Return to :-

Define Number Range and Document Types

FBN1 - Number Ranges for Accounting Documents

• Each document type need to have a number range assigned to it.
• If you define an external number range, the users or user exits have to supplied the document number to SAP.

OBA7 - Define documents type

• Double click on the documents type to view or change the settings.

OBU1 - Change the default document type and posting keys

• Here you can view or change the default document type and posting keys used as per FI transaction.

FBL3 - Display G/L Account Line items

Configure the options :-

• O7Z3 - Maintain line layouts
• O7R1 - Maintain totals variants
• O7S7 - Maintain sort variants
• OB55 - Maintain work lists values

Maintains fields for G/L account in line items level in fi

A common posting error occurs when a field in the G/L field staus group is required and the same field in the MM movement type field status group is suppressed. To avoid this, keep as many fields optional and make the important fields required or suppressed.

OBC4 - Maintain Field Status Variants

• Select the Field Status and click "Field Status Groups".
• Double click on the Field status Groups to control the fields to be Suppress, Required or Optional.

To maintain the Field Status Group in your G/L account.

FS02 - Edit G/L Account Centrally

Click strips tabs Create/bank/interest

Maintain field :- Field Status Group

Fast FI entry screens for each user

Fast FI entry screens for each user

3.0x

O7E6 - Maintain screen variants

You have to assign the Fast entry screen in the parameters for each users.

SU01 - Maintain users

Click the Parameters tabstrips

e.g. Parameters FZ5 Value SAP01 - FI: Document Parking Fast Entry (G/L Accts) Line Layout

Posting keys Configuration

Posting keys Configuration

OB41 - Define Posting Keys

Determine whether a line item entry is a debit or credit and the field status for the transaction.

Other attributes

Sales-Related - Tick if it is used when invoicing a customer.

Special G/L - Tick if the posting key is used for special G/L transactions such as down payments. You need a valid special G/L indicator which must be entered on the line item when posting with this keys.

Reversal Posting Key - auto assign a reversal keys.

Payment Transaction - Tick if the posting keys is used for any type of incoming, outgoing, clearing, or residual postings of payments.

what is the Difference between Posting key and Field status group

What is the difference among Account group, Posting key and Field status group in terms field status?

Account group defines:

a. lenght of gl account number
b. no. ranges of the gl account numbers
c. field status of the GL account master data in the company code segment.(which fields to appear when you create a gl account) (to control...double click on your GL account group in Screen transaction code OBD4)

Posting key defines:

a. whether the line item is a debit or credit
b. to which type of account the amount should be posted to(ex: when you use posting key 40, you will be able to post to gl accounts. When you use Posting key 01, you will be only able to post to customer account.
c. document screen layout during posting of a document. (which feilds to appear in a document...double click on the posting key and select field status and make the entries as required /optional etc)

Field status group defines:

Document screen layout during posting of a document. (which feilds to appear in a document...double click on the field status group and select fields and make the entries as required /optional etc)

LOGIC: you assign field status variant to the company code, FSV is a bundle of field status groups.

ex: in FSG G001 you have made the text as required entry...you assigned the field status group g001 to cash account..so when you use cash account and try to post a document it will definitely prompt you to enter the text (text made as required.)

Both FSG and PK control the same feilds in a document.There is no dominance between FSG and Posting keys..but we should know the allowed combinations....

If text is made required in PK and suppressed in FSG..the system will issue a error msg..Rules for PK...and FSG....is set incorrectli for SGTXT field.

Permissable combinations:

Pk R/S O/S R/o R S O

FSG S/R S/O o/r R S O

Result e SD RD NP NP NP

R= required
s= suppressed
e=error
SD= Suppressed dominates
Rd= required dominates
np=no problem.

Inter company Postings within the Organization

When you want to post a single transaction to one or more company codes. This done when company wants to keep track of payables and receivables separately.

OBYA - Prepare Cross-Company Code Transactions

Transaction BUV - Clearing between company codes

Posted in 1000
Cleared against 2000

Receivable Payable
Debit posting kye 40 Credit posting key 50
Account debit 12300 Account credit 45600

Receivable Payable
Posted in 2000
Cleared against 1000

Receivable Payable
Debit posting kye 40 Credit posting key 50
Account debit 12300 Account credit 45600

To cut down the number of G/L accounts, use the same G/L accounts for both company codes.

Posted in - Company Code Which Is Being Posted To

Tolerance posting for users posting accounting documents

To control the total maximum amounts of accounting documents posted by users.

Create and assign them each to a tolerance group.

e.g.
Posting documents up to $20,000 and clear customer and vendor accounts up to $10,000.
Percentage amounts of Cash discount allow per line item.
Revenue or Payment differences e.g. Amount $1,000 up to a maximum of 90.0%
Cash Discount Adjustment - amounts up to $10 of the total difference

OBA4 - Define Tolereance Groups for users
The default Null groups for Company code 0001 have been created by SAP.
Usually, most users will used the Null groups which allows them to post up to a certain amounts.
For higher amounts posting, assign them to certain higher level users who has a higher authority.

OB57 - Assign users to Tolerance Groups

Configure the Automatic account determination

To allows the system to determine the correct G/L account to post to by considering the type of transaction and other factors.

FBKP - Configure automatic account determination

• Double click on the Group item
• Double click on the Procedures item

Tax Automatic Account Assignment in fico

Account determinations are separated via processing keys that the system uses for different transactions.

OB40 - Define Tax Accounts

• Double click on the Process key (the first screen is the rules). Once you set the rules, it cannot be changed unless all the account determinations are first erased. For certain rules, the indicator that are greyed out as it cannot be maintained.
• Click the Accounts button for the Accounts Assignment Screen.
• Click the Posting keys for assign the Posting keys (Debit/Credit).
At the Posting keys screen, the note "Posting keys are independent of chart of accounts" means that if it includes more than one chart of accounts, the debit/credit posting keys set here will be valid for all the charts of accounts.

Copy G/L Accounts Master records from one client to another

Tested in 4.6x

OBY2 - Copy Company code

RFBISA10 - Copy G/L Account Master Data from Source Company Code: Send

Allows you to copy G/L accounts from one company code to another within a client. The files is first written to the application server of the clients.

When you are ready to send the G/L accounts to the clients in the other environments, the Basis people must transfer the file to the proper path on the application server for that environment.

After the file have been created, run the program :-

RFBISA20 - Copy G/L account master data in target company code: Receive

This program is run in the client in which you are transferring the G/L accounts.

I tried to copy g/l accts through t.code oby2. I unchecked test run and saved it. Now when I try to create an invoice I don't see those g/l accounts that were copied to the other company code.

There are two ABAP programs are there to copy GL accounts from one company code to another. they are RFBISA10 (send) and RFBISA20 (receive).

We run this at SA38. If the target company code is with in the same client then just give the target company code then it will
copy all the GL Master records in to the target Company Code. If it is in another Client then we can create a file then later upload with RFBISA20. I will tell you how. Remember in target company code, you should define Account Groups Fields Status etc., before transfer. OK.

Step 1: Go to T.Code SA38 type RFBISA10 and execute the it will ask the Source Company Code and Target Company Code. Give them if it is in same client. It will be copied.

If suppose, your target comapny code is in another client. Go to SA38 the type RFBISA10 and execute then give your source company code and now give a name for your file. and execute. it will create a file and saves it on to your system. It give the location where it has saved soon after u execute. remember or write it on a paper.

Step 2: Now Logoff from your client and logon to your target client and go to SA38 and type RFBISA20 and execute then it will ask the location of the file then give the locaton where your file was stored then execute. Your Master records will be copied.

FS10 - Account Display Balances in fi

FS10 - Account Display Balances

• The account balance displays the following:

· the opening balance (carry forward balance from the previous year)
· the total of all transactions for each posting period, broken down into debit and credit postings (transaction figures)

From these figures the system also calculates for the account balance display function the following:
· the balance per posting period
· the accumulated balance of the account

What is SAP Account Group?

What is SAP Account Group?

Account groups determine which fields you can configure on the G/L master record.

The standard SAP require at least two account groups, one for balance sheet accounts and one of the profit and loss accounts.

OBD4 - Define Screen layout per account group (G/L Accounts)

• Double click on the line items.
• You can define the fields as Suppress, Requried Entry, Optional Entry or Display

After the definition, you can check it with FSP3 - Chart of Accounts display.

Retained Earnings Accounts

Retained Earnings Accounts

Tested in 4.6x

OB53 - Define Retained Earnings Account

Most companies use one retained earnings account. For this reason, X can be used as the key.

In the chart of accounts you enter X in the P+L statement account type field, and for account determination you enter the retained earnings account under the key X.

FSP0 - Edit G/L account - Chart of accounts

Material Ledger/Actual Costing: Revaluating COGS in fi

Material Ledger/Actual Costing: Revaluating COGS

For the techy bits .. I'm on 4.7 (with IS-Oil) and I'm trying to see how to make use of ML for stock valuation...

I pretty much got everything so far
- single-level price determination (calculating the actual price within a depot where product is bought into)
- multi-level price determination (calculating the actual at e.g. service stations getting supplied from the depots)

...when posting the closing entries remaining inventory is now valuated at the "right" price (meaning the newly calculated actuals) at month-end, price differences from the depots are carried over to the service stations to calculate the value of the closing inventories there

Only thing that I can't seem to get right is the revaluation of the GI for Sales (Cost of Goods Sold: COGS) out of the service stations (e.g. via MvmtType 601)

According to the SAP documentation that should be possible:
Quote:
Release Notes 4.7: As of Release 4.70 you can revaluate comsumption for the actual period using actual prices. In particular, this enables you to valuate the cost of goods sold using actual prices. In earlier Releases it was only possible to use the results from actual costing to valuate materials already delivered to the warehouse.

Somehow though, the price differences that should be charged to COGS still remains as an Not Allocated Consumption under the respective material...

Anybody ever tried that? ...and made it work??? What setting am I missing?

-----------------------------------------------------------

Yes, it works on 4.7 (without IS-Oil, but i think this is not essential).
Customising for this functionality is under IMG menu items: Actual Costing/Material Ledger -> Material Update -> Define Movement Type Groups of Material Ledger, Assign Movement Type Groups of Material Ledger, Define Material Update Structure.

Don't forget also to set "Revaluate consumption" check box in ML closing costing run "Post closing" step's parameters screen.

-----------------------------------------------------------

That could be it ! I do not have this option (P_RECONS or PXCOBL) on the Post Closing screen when maintaining the variant! There is only the option for Revaluate materials.... any idea what controls this option field on the selection screen? To me the ABAP look like this parameter should be invisible depending on the result of the call of Code:

CALL METHOD
l_badi_instance->check_active
IMPORTING
e_active = l_active

in FORM RUN_AT_SELECTION_SCREEN_OUTPUT?!

Another question: do you have other step in the Actual Costing Run then the following

Selection
Determine Sequence
Single-Level Pr. Determination
Multilevel Pr. Determination
Post Closing
Mark Material Prices

Shouldn't there be an entry for Revaluate consumptions?

-----------------------------------------------------------

Is the SAP R/3 Enterprise Extension Set "EA-FIN Financials Extension" activated in your system?

You can find "Activation Switch for SAP R/3 Enterprise Extension Set" item at the top of IMG menu tree. As I remember, we also had lost several functionality items related to revaluation, before we had activated EA-FIN. There was a SAP consultation, to activate EA-FIN to have revaluation of consumption option:

"The Revaluation of Consumption in release 4.7 (Enterprise) belongs to the Extension "EA-FIN" (Financials Extension). In order to use any new functionality belonging to an Extension, you have to activate the corresponding Extension.
Please start the customizing (transaction SPRO) and execute the function "SAP Reference IMG" (or your corresponding customizing). At the very top you find the function "Activation Switch for SAP R/3 Enterprise Extension Set". Please execute it. Set the flag "Active" at the Appl.
"EA-FIN" and save your work.
Now you have activated all functionality of the Financials Extension, including the Revaluation of Consumption.

Some system table entries were not shipped in Enterprise release, for unknown reasons.

Please apply the note 631395 to create the missing entries."

Step for End Year Closing for SAP FI

Step for End Year Closing for SAP FI

I would like to know steps or T-CODE for end year closing.

1) With TC: F.16 we can carry forward the balance to next year.
2) With TC: OBH2 copy the number ranges to next year
3) Open next year periods by selecting the Posting Period Variant.
4) Then test by posting the transaction in F-02

Hope I am clear. If any more doubts please let me know.

Ashok

How about TC : OB52, when we can't run that steps?

Tonny

Check List:
In order to arrive at correct profit or loss for the month following checklist can be followed:

Month end closing Activities

1) All the expenses including amortization, prepaid expenses, Preliminary expenses and accruals have been booked.

2) Complete Bank Reconciliation

3) Make sure that Sum of Inter company balances is Zero

4) Suspense Accounts should be cleared regularly.

5) Ensure that all documents related to MM & SD have been entered in system.

6) Ensure that all billing documents are released to accounting.

7) Calculate Overheads on all process Orders (CO43)

8) Technically complete all process orders which are fully processed (CORM).

9) Calculate Variance (KKS1)à (Relevant only if Standard cost is calculated).

10) Settle all process orders which are technically complete (CO88).

11) Close All settled Process Orders

12) Close MM period (Transaction Code: MMPV).

13) Carry out GR/IR clearing (F.13) transaction

14) Depreciation Run (AFAB) has been carried out for the month

15) Close FI Posting period after the month end closing activity is over.

Year end closing Activities

1) Calculate production work in progress on process orders which are not technically complete.

2) Carry out Assessment cycle for Cost Centers.

3) All month end closing Activities should be carried out.

4) Carry Forward Balances to next year

(With TC: F.16 we can carry forward the balance to next year.

With TC: OBH2 copy the number ranges to next year
Open next year periods by selecting the Posting Period Variant.
then test by posting the transaction in F-02)

Rehan Ansari

We don’t use TC:OB52 for end year closing?

Tonny

I have replied partly to your query. sorry for that. I have sent you the opening new year reords.
The closing procedure is as follows: -
1. Carry forward Vendor & Customer Balances: TC: F.07
2. Assets:
i) TC: OB 52 - for assets 2 years can be openned at a time.
ii) check which year is closed: TC: OAAQ
iii) Close the year 2004: TC: AJAB
Note: Unless depreciation for all the months is posted for all the assets you cannot close the year.
iv) Open year 2005: TC: AJRW

Hope the above clears your doubt.

SAP FI Month End and Year End Activities

SAP FI Month End and Year End Activities

1 - Maintain Activity prices - KP26

2 - Release of Standard Cost Estimate - CK40N

3 - MM period close and open - MMPV

4 - FI period open

5 - Parked documents to be posted - FBV0, MIRO

6 - Reposting of Inter Office CC - KB61

7 - Bank Reconciliation

8 - Update Section Code where missing - J1INPP

9 - Maintain GRIR clearing - F.13

10 - Provision for current month - FB50

11 - Depreciation entry - FB50

12 - Exchange rate - To be Updated

13 - Revaluation of foreign currency open items - F.05

14 - Recognition of Inventory at Bonded warehouse - FB50

15 - Maintain Statistical Key Figures - KB31N/KP46

16 - Variance Calculation of Process Orders - KKS1

17 - Settlement of variances - CO88

18 - Assessment cycles - Aux/WH CC to Main CC - KSU5

19 - Assessment cycles - Functional CC to SBU CC - KSU5

20 - Assessment cycles - SBU CC to COPA - KEU5

21 - Profit Center Reposting - 9KE0

22 - Balance Sheet Adjustment calculation - F.5D

23 - Transfer Profit Center to AR & AP - 1KEK

24 - Transfer Inventory to PCA - 1KEH

25 - Assessment Cycle - Dummy PC to SBU PC - 3KE5

26 - Check for "Delivery made, not Invoiced" - VF03

27 - Match GL and PCA - KE5T

28 - Match PCA and PA

29 - Top Down Distribution in COPA - KE28

30 - Reclassification of GL balances

31 - Balance Carry forward (Year End Only) - F.16

32 - PCA Balance Carry forward (Year End Only) - 2KES

33 - Transfer to FI - 1KE8

what is the Difference Between Profit Centre Accounting and Profitability Analysis

Difference Between Profit Centre Accounting and Profitability Analysis

In simple words:

- Profit Center is particular division,branch/product line for which you want to find out the financial result.
- COPA is more to do with specific business segments like, for a particular product line in a sales area how much is the profit?

Profitability Analysis allows Management the ability to review information with respect to the company’s profit or contribution margin by business segment. Profitability Analysis can be obtained by the following methods:

- Account-Based Analysis which uses an account-based valuation approach. In this analysis, cost and revenue element accounts are used. These accounts can be reconciled with FI (Financial Accounting).

- Cost-Based Analysis uses a costing based valuation approach as defined by the User.

Profit Center Accounting provides visibility of an organization’s profit and losses by profit center. The methods which can be utilized for EC-PCA (Profit Center Accounting) are period accounting or by the cost-of-sales approach.

Profit Centers can be set-up to identify product lines, divisions, geographical regions, offices, production sites or by functions. Profit Centers are used for Internal Control purposes enabling management the ability to review areas of responsibility within their organization.

The difference between a Cost Center and a Profit Center is that the Cost Center represents individual costs incurred during a given period and Profit Centers contain the balances of costs and revenues.