Friday 14 August 2015

what are open and close posting periods in sap fico

OPEN AND CLOSE POSTING PERIODS


 Fiscal year : April 2008 – March 2009 – F.Y 2008
August 2008 – March 2009
5,2008 – 12,2008

Open means: from               August 2008

Close means: to                   March 2009

Company codes       : AML              ASL                AIL

All company codes
Fallow the same
Open and close periods
Option 1
A)           Define posting periods
Variant …………… X
B)           Assign posting period
Variant to company codes
X……….AML
X……….ASL
X……….AIL
C)           Define open and close periods for variant X
For X,5 2008 – 12,2008
Option-2

Each company code
having separate open
And close posting period  variant                         X                     Y                     Z

Assign posting period variant to company codes
                                                                        X to AML        Y to ASL        Z to AIL

Period for variant

July 2008-March 2009  April 2008 to March 2009         Sep. 2008 to Sep. 2008

For  X                                                 For Y                                      For Z
04,2008                                              12,2008                                  06,2008

In this step we are defining which periods are open for posting.

Define variants for open posting periods:

Path : SPRO – Financial accounting global setting – Document – posting periods-Define variants for open posting periods(OB52)

 Select new entries button

Variant                       Name
AML                            posting period variant for AML

Ctrl+S, press enter in save

Assign posting period variant to company code:

Path : SPRO-Financial Accounting- Financial accounting global settings- Document – posting periods – assign posting period  variant company code.(OBBP)

Select position button

Give the company code      AML
For company code AML assign variant AML select save button or Ctrl+ S
Press enter to save in your request.

Define open and closed posting periods for variant::

Path:  SPRO – Financial accounting Global settings – Document – Posting periods- open and close posting periods.(OB52)

Select  new entries button.

Vare                            : Select AML
Account type (A): Select +   (valid for all accounts type)
From Account                       Blank
To account                            Blank
From period one (1)             1
Year                                        2008
To period                               12
Year (Fiscal year)                 2008
From period2                                    13
Year                                        2008
To period                               16
Year                                        2008

Second column is option (from period 2)
Authorization group (Au.Gr):                     Blank

Select save button or Ctrl+S

Select your request and press enter to save in your request.

Authorization Group:

This screen is required every month in production client nobody will have access for customization areas.

The same screen is given at user level when it is available at user level, the users will misuse.

SAP has given authorization group.

BASIS Administrator gives authorization group say X and X will be assigned to user IDs manager accounts and deputy manager accounts.

When we open the system with the above user IDs then only we can change the periods at the user level.

Posting periods entry at end user area:

Path: Accounting –Financial accounting –General Ledger - Environment –Current settings-open and close posting periods ( Transaction code :S_ALR_87003642)


Select position button
Posting period variant: AML
Enter


Document type and no. ranges
In normal accounting, account person only will pass all the entries. He will get voucher no’s continuously. In SAP voucher we call it as document.
           
FI Accounts Person     MM Stores Person           SD Sales Person
Material Receipt                                                       1
Payment                    2                     
Sales                                                                                                              3
Receipt                      4

To get document number serially SAP has given document type

Doc.type                    SA                               RE                              RV
No.Range                  01                                02                                03

No.Range interval   1-100000                   100001-200000        200001-300000

We are getting the document no’s continuously by seeing the document number we can tell where it is generated.

In a year 100000 vouchers are consumed system gives a message we give available numbers 300001-400000

Path:SPRO-Financial accounting-Financial accounting Global settings –Document –Document Header-Define Document Types (Tr.code:OBA7)

Select position button
Document type select                     : SA
GL Account document
Enter
Select type                                        :SA
Select details button (Ctrl+Shift+F2)
Number range                                  :01
Select number range information button            2010
Give the company code                  : AML
Select change intervals button (↓)
Select interval button
No. range                                          :01
Year                                                    :2008
From number                                    :1
To Number                                        :100000
Current number                               :0
Deselect external(Ext) check box

If we select external check box, we have to give at the time of  posting what should be the document number.
Select press enter.
Select save button or Ctrl+S
Ignore warning message press enter

Number range interval can’t be transported to production client – what ever number for development client for testing.

1.      Consultant is an outsider – he does not know how many document numbers are required for each area.
2.      All the departments want to have 1—100000 which is not possible. In live environment, before going live all the department heads sit together and decide for production client.

What should be FI document number
What should  be MM document number
What should be SD document number.

SAP have given two options.

Option1: Year specific                                          Option 2: Common to all years

01-2007-1-100000   500000  500001                   01-9999-1-100000
01-2008-1-100000   3000        3001                      53000-53001-53002



1st Entry
Date:24.09.2008                                           9999 means any year
Posting date:24.09.2008                             in 2nd option we don’t know how many

2nd Entry
Entry date:29.09.2008                                 Documents we have posted for each year
Posting date:31.03.2008

Note: companies follow 1st option.



Field status variant and field status groups:

At the time of posting on screen we get around 70 fields. Fields are quality, text (Narration), business area, value date

Debit               70        Filed
Credit              70        Filed
                       ------
                       140      Filed
                       ====
 If we start filling up all the fields it takes so much time to post one document.

SAP has given a facility to make any filed as

1.         Suppress       2.         Required                   3.                     Optional

1.         Suppress: The filed will not be visible on screen a the time of posting.

2.         Required:  We have to enter values to the field compulsory. The field value will appear with question mark or tick mark-without entering the values we can not go to next screen.

3.         Optional: The field will be visible on screen our choice to enter values or not the fields selection is not common to all accounts. It depends on the account what we are using. In case of sales account quantity filed is required. In case of  repairs account quantity filed is not required, we have 1000 accounts – we have to create 1000 scenarios. In stead of creation of 1000 scenarios SAP have given field status groups.


Filed status Group               Suppress required optional

Repairs A/c                                       General

Equity share capital
Sales A/c                                           materials quantity select
Purchase A/c
Cash A/c                                            Bank Accounts
Bank A/c                                            cost Accounts

  1. When we create accounts we have to assign field status group.
  2. For filed status group we is field is suspected and which filed is optional.
  3. At the time of posting by the user-he gives the account number the screen will appear based on the fields selection to the field status group which is assigned in account number.
  4. Filed status groups are created under field status variant and field status variant is assigned to company code / codes.

Afterwards:

Cash account                       Dr
            To Equity share capital

Bank accounts
            |
Value date text Business area
            |
Required Entry

General
            ^
Text        Business area
            |
Required entry

Screen layout at the time of posting

Path:SPRO- Financial accounting – Financial global settings – Document –Line item-Controls- Define  filed status variants.

Select field status variant 1000 that is IDES group
Select copy as button (F6)
Change filed status variant (FSTV) to AML
Change field status name to field status VAR for AML
Press enter
Select copy all button
We get a message number of dependent entries copies 47
Enter
Select save button or Ctrl+ S
Select your request and press enter to save in your request.
Select field status variant   :           AML
Double click on field status groups folder
Double click field status on G001 that general (with, text, allocation)
Double click on General data
Text make it required entry filed
Select next group button
Select next page or page down button two times.
Business areas make it as required entry field
Save
Double click on field status group G005
That is Bank A/c obligatory value date
Double click on General data
Text make it as required entry field
Select next group button
Select next page or page down button two times.
Business area make it as required entry field.
Select next group button two times,
Value date make it as required entry filed.
Save.

Value date( Effective date):

Term loan from IDBI            :20.09.2008
Deposit by us in our bank    :22.09.2008
Document date                    :22.09.2008
Posting date                         :22.09.2008

In SAP we have interest calculations, Interest calculations in our book from 22.09.2008 where as IDBI calculates from 20.09.2008. There will be mismatch.

Interest calculations:
Value date                             :Required entry filed
Document date                     :22.09.2008
Posting date                          :22.09.2008
Value date:                            20.09.2008 field is modifiable after posting .
In our books also interest will be calculated from 20.09.2008

Value date                             :31.08.2008
DOC & POS

Assign company code to field status variant :

Path: SPRO-Financial accounting-Financial accounting  Global settings-Document – Line time-Controls-Assign company code to field status variants.

Select position button
Give the company code      :AML
Enter
For company code               :AML
Assign field status variant :AML
Select save button or Ctrl+ S
Press enter to save in your request










No comments:

Post a Comment