Assignment of Accounts for Automatic Postings (MM to FI) in sap CO

*Assignment of accounts for automatic postings

Path :Up to account determination without wizard the path is same – Configure automatic postings  (Tr code is OBYC) (MM to FI Integration )

Select cancel button

Select account assignment button

Double click on transaction BSX inventory posting

Give your Chart of Accounts                         :BIL
enter

Select valuation modifier check box

Select valuation class check box

Save

Valuation modified     Valuation class                        Account

X                                 BIL1   RM local                      200121 Inventory RM local

X                                 BIL2   Finished products       200122 Inventory FG

Save

Press enter to save in your request

Select back arrow

Double click on transaction WRX GR/IR clearing account

Select valuation modifier check box

Select valuation class check box

Save

Valuation modifier                  :X

Valuation class                        :BIL1 RM local

Account no.                            :100520 GR/IR clearing local

Save

Press enter to save in your request

Select back arrow

Double click on GBB offsetting entry for Inventory posting

Select General modification check box

Valuation modifier check box

Valuation class check box

Save

Valuation modifier	General modification	Valuation class	Account
X	VBR  (consumption)	BIL1 RM local	400000 RM consumption local
X	ZOF (Production  receipt without production order)	BIL2 Finished products	300200 Increase / Decrease stocks FG
X	AUF with production	BIL2	300200
X	VAY (Delivery where sales account is created as revenue element Co implemented)	BIL2	300200
X	VAX Delivery where is sales account is not created as revenue element CO not implemented	BIL2	300200

Save

Press enter to save in your request

Document types and no.ranges (OBA7)

WE                  :Goods receipt

WA                 :Goods issue

RE                   :Grass invoice receipt

Tr code is OBA7

Select WE                  :Goods receipt

Select details button

Number rage               :50

Select number range information button

Company code            :BIL

Select change intervals button

Select interval button

No.range                     :50

Year                            :2008

From no.                      :800001

To no.                          :900000

Enter and save

Ignore the warning message press enter

Select back arrow 3 times

Select type WA Goods issue

Select details button

Number range             :49

Select no.range information button

Company code            :BIL

Select change intervals button

Select interval button

No.range                     :49

Year                            :2008

From no.                      :900001

To no.                          :1000000

Enter and save

Ignore the warning message  press enter

Select back arrow three times

Select RE gross invoice receipt

Select details button

No. range                    :51

Select no.range information button

Company code            :BIL

Select change intervals button

No.range                     :51

Year                            :2008

From no.                      :1000001

To no.                          :1100000

Enter and save

Ignore the warning message press enter

MM end user area

Creation of vendor master XK01

Give the company code          :BIL

Purchasing organization          :BILR

Account group                                    :BIL2 MM vendors for BIL

Enter

Give the name                         :Nagarjuna Steels Limited

Country                                   :IN

Select next screen button 3 times

Reconciliation account            :select 100501 Sundry credit RM

Sort key                                   :012 vendor

Select next screen button

Payment terms                                    :0001

Select next screen button 2 times

Order currency                        :INR

Select GR based invoice verification check box

Save

Creation of RM material master

Path :Logistics –Materials management –Material master-material-Create(Genral) –Immediately (Transaction code                        +)

Material                       :BILRM1

Industry sector                        :Mechanical engineering

Material type               :Raw material

Press select views button

Select basic data1, purchasing, general plant data/storage1/accounting1

Select organization levels button (bottom side)

Give the plant                                     :BILP

Storage location                      :HYD

Enter

Give the description                :Raw material 1

Basic unit of measurement      :KG

Material group                         :BILC (Chemicals)

Division                                   :BS (Steel)

Select purchasing tab

Purchasing group                    :BIL

Select accounting one tab

Valuation class                        :select BIL1 (RM local)

Price control                            :select V moving average price

Moving price                           :50

Select save button or Ctrl+S

To open material periods for November:

Up to material master the path is same –Other-Close period (Transaction code is MMPV)

From company code                           :BIL

Give the period                                   :8 (November)

Fiscal year                                           :2008

Select check and close period radio button

Execute

Purchase order creation

Path :Logistics – Material management –Purchasing –Purchase order-Create-Vendor/supplying plant known (The transaction code is ME 21N)

Give the purchasing organization       :BILR

Company code                                    :BIL

Enter

Give the purchasing group                  :BIL

Item                                                     :10

Material                                               :BILRM1

PO quantity                                         :100 Kg

net price                                              :75

Plant                                                    :BILP

Give the currency                                :INR

Vendor no.                                          :2001

Save

Note the purchase order no.4500017092

Goods receipt:

Path :Logistics –Material management –Inventory management –Goods movement –Goods receipt- for purchase order –PO number known (The transaction code is MIGO)

Select goods receipt

Give purchase order no.4500017092

Enter

Storage location select            :HYD

Select quantity tab

Quantity in delivery note        :100

Select item ok check box

Select save button or Ctrl+S

Select display button

Enter

Select document information tab

Select FI documents button

                                                                                                            BSX

200121 Inventory RM local 7500                   BILRM1                     BIL1

                                                                                                            WRX

100520 GR/IR  CLRG RM local -7500         BILRM1                     BIL1

            Qty .Received(GR) *Rate as per PO

            100*75

Note: change USTAX to GTAX

Invoice verification:

Path :Logistics –Materials management –Logistics-Invoice verification –Document entry-Enter invoice (Transaction code is MIRO)

Give the invoice date              :Today’s date

Reference                                :Party bill no.1234

Text                                         :Invoice verification

Purchase order                                    :4500017092

Select payment tab

Payment terms                                    :0001

Baseline date                           :today’s date

Select base data tab

Tax code                                 :select V0

Enter

            Business area                           :BILH

            Select beside data tab

            Amount                                   :7500

            Enter

            Select save button or Ctrl+s

            From the menu select invoice document –Display

            Select follow on document button

            2001 Nagarjuna Steels Limited 7500 –From party no is taken

            100520 GR/IR CLRG RM local 7500  BILRM1      BIL1

            Raw material consumption 

Path :Logistics –Materials management –Inventory management –goods movement –goods issue (Transaction code is MB1A)

           

            Movement type           :201

            Plant                            :BILP

            Storage location          :HYD

            Enter

            Give the cost center    :Dept A

            Material                       :BILRM1

Quantity                      :30

            Select save button or Ctrl+S

            From the menu select goods –Issue display

            Enter

            Select accounting documents button

            Select accounting document number

                                                                                                            BSX

            200121 Inventory RM local    2250-BILRM1                        BIL1

                                                                                                GBB VBR

            400000 RM consumption LCL 2250-BILRM1                     BIL1

            Qty consumed * moving average price

                        30*75

            To view stock ledger

Path :Logistics –Materials management –Inventory management –Environment –Stock for posting date (Transaction code is MB5B)

Material no.                             :BILRM1

Company code                        :BIL

Plant                                        :BILP

Selection date                                     :01.04.2008 to 31.03.2009

Select valuated stock radio button

Execute