Skip to Content
Author's profile photo Ravindra Devarapalli

Automatic Account Determination

Before Explaining the Account determination, will look into Inventory Management Introduction.

Inventory Management :

Simply explanation :  Managing the stock of material on qty and value basis is known as Inventory Management..

Whether Inventory is required or not for the material is controlled at material type and valuation area (plant) level.

In OMS2, Configuration required  for each material type qty and value updating at valuation area level.

Case 1: If both Qty and Value update indicators are selected then PO can be raise for stock purpose and at GR material can be placed in store on qty basis and this Qty means stock value will be updated in inventory or stock G/L account.

Case 2 : If qty update selected and value update not selected for material type at valuation area level, These material type related materials must procure for consumption Purpose. Means you should select account assignment category in PR and PO. At GR, received material is placed in store on qty basis but material value will be booked in relevant consumption G/L account but not in stock or inventory g/l account.

Inventory Management scenario’s can be defined as  1) Goods Receipt 2) Goods Issue 3) Stock Transfer 4)Transfer Posting

Characteristics of Goods Movements :

1) At least one material document will be generated and if goods movement is relevant to FI then accounting document to be generate.

2) Stock and Stock Value and Consumption Value may increase or decrease based on the goods movement.

3) If GR is entered against PO then PO history to be updated in Display PO.

4) Total value and Total stock, Moving average price to be updated (may be increase or decrease) in Material Master.

5) If Quality Management views are maintained with required fields, then when you completed the GR or GI, inspection lot to be generated when you run in QA32 , Based on Usage decision stock to be accepted or Rejected.

Sample process for Goods Receipt, Goods Issue, Stock Transfer, Transfer Posting.

Goods Receipts : 1) GR w.r.t Po for raw material

                            2) GR w.r.t Production order for finished Product.

                            3) GR With out for Production order

                            4) GR with out Purchase Order.

Goods Issue :       1) GI w.r.t Production order for raw material.

                            2) GI w.r.t sales order for finished product

                            3) GI to cost center or to plant maintenance.

                            4) GI to Scrap.

Stock Transfer :   1) Plant to plant stock transfer with in the company code.

                            2)From plant to plant across company code.

                             3)Store to Store stock transfer

Transfer Posting :1) Unrestricted <———> QI <————–> Blocked

Account Determination : (MM & FI Integration)

                           With this account determination Configuration settings,system will determine a suitable G/L account while posting GR (or) GI etc.

1)Account Determination with out wizard

    I explained simply in one diagram, it is use full to remember the Process. Below I explained step by step.

/wp-content/uploads/2013/11/b1_329145.png

1st Part :

Chart of account includes G/L accounts. This chart of account to be assigned to one company code or multiple company codes.

/wp-content/uploads/2013/11/b3_329153.png

Note : Similar account determination required plants are grouped together and assigned to a valuation grouping code and then account determination will be configured at valuation grouping code level.

Step 1 : Define Valuation Control (OMWM)

/wp-content/uploads/2013/11/1_330208.png

  Here need to activate valuation grouping code.

For account determination, you can group together valuation area by activating the valuation grouping code.

Step 2 : Group together valuation area.(OMWD)

/wp-content/uploads/2013/11/2_330333.png

here you assigned the valuation grouping code with combination of company code and chart of account and valuation area (plant)  combination. If suppose similar account determination required plants are grouped together , here you can assign same valuation grouping code to multiple plants (or) multiple valuation areas.

2nd Part :

Material type and Account category reference and Valuation class.

Step 3 : Define Valuation Classes.(OMSK)

In this step, you define which valuation classes are allowed for a material type.

/wp-content/uploads/2013/11/b2_329150.png

Bijay already explained  about Account category reference (ACR) in below link

http://scn.sap.com/community/erp/logistics-mm/blog/2013/10/31/account-category-reference-acr–grandfather-of-automatic-account-determination-process

So I am not going to this detailed..  As account category reference is main controller and Mediator for material type and valuation class.

/wp-content/uploads/2013/11/3_330338.png

/wp-content/uploads/2013/11/4_330340.png

/wp-content/uploads/2013/11/5_330341.png

/wp-content/uploads/2013/11/6_330343.png

There is no direct configuration between material type and valuation class. Account category elaborates which material types related materials can be choose the which valuation classes.

You should enter this valuation class in material master.

3rd Part :

/wp-content/uploads/2013/11/7_330345.png

Step 4 :Define Account Grouping for Movement types (OMWN)


     Note : It is not possible to define new valuation string and new transaction event keys but account modifiers are editable with any movement type, for GBB or PRD or KON transaction keys are triggering then only account modifier also triggers.

Based on movement type system is triggering a valuation string and this valuation string is again triggers several transaction keys.. but few transaction keys again triggers account modifiers or account grouping code also.

Below are the transaction event keys relevant account modifiers

GBB ——-> BSA,INV,VBO,VBR,VNG,ZOB

PRD——–.>PRA,PRE,PRU

KON———>PIP

Step 5 : Configure Automatic Postings (OBYC)

/wp-content/uploads/2013/11/8_330346.png

/wp-content/uploads/2013/11/9_330347.png

/wp-content/uploads/2013/11/10_330348.png

In this step, you enter the system settings for inventory management and invoice verification transactions for automatic postings to G/L account.

For transaction key w.r.t to chart of account need to assign g/l account based on transactions with combination valuation class, account modifier or valuation modifier

Assigned Tags

      28 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Hi Guys,

      Just look into this Document. I hope it is help full to all. Now i am little busy to other work that is reason i am posted simply, will modify as per required level. Will add screen shots and other modifications as soon.  Please send any suggestions or any comments on this.

      Author's profile photo Former Member
      Former Member

      Hi RD,

      Nice documentation...

      Author's profile photo Former Member
      Former Member

      Hi Ravindra,

                           U have explained in a detailed way. Very awesome job. Really appreciable.

      Author's profile photo Bharath Reddy
      Bharath Reddy

      Hi Sir...

      Thank you very much...! Nice explanation

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi

      Such a nice work Dear............:D

      Best Regards

      Mohsin Abbasi

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      Hi all ;

      Thanks Ravindra , we have to create a document for details of T030 table.

      A guide will be perfect which contains of BSA,BSX,GBB,VAX etc.

      Regards.

      M.Ozgur Unal

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Thank u Ozgur, As soon you can see document related to complete business process with account entries related to MM in SDN.

      Author's profile photo Swapnil nevrekar
      Swapnil nevrekar

      The step wise explanation given make its simpler to understand the concept.

      Thanks a lot Ravindra.

      Best Regards,

      Swapnil

      Author's profile photo Former Member
      Former Member

      A good continuation if we link this to ACR - Grandfather... 🙂

      Author's profile photo Former Member
      Former Member

      Good Job.. Thanks you.

      Author's profile photo Former Member
      Former Member

      Useful one...Thanks.

      BR,

      Naresh K.

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli
      Blog Post Author

      Thanks to all for supporting my document.

      Regards,

      Ravindra

      Author's profile photo Former Member
      Former Member

      good work, easy to understand... 🙂

      Author's profile photo PRASOON AK
      PRASOON AK

      Good Work! Thanks for sharing and keep sharing!.

      Regards,

      AKPT

      Author's profile photo Sudeep A
      Sudeep A

      Good document. Core of MM module, presented nicely. Could have included more about OBYC like Rules, posting keys etc. Anyway good job.

      Regards,

      Sudeep.

      Author's profile photo Former Member
      Former Member

      Good  document .

      If  you  add  the  accounting  entries for  each  movement type  , then  it  will  be helpful  for  MM  and  FI  people .

      Then  FI -MM  integration and  useful  to  all  the  MM  &  FI  consultants

      Author's profile photo Former Member
      Former Member

      Thanks ,

      It is good document and useful for MMFI integration work.

      Author's profile photo Nishant Kumar
      Nishant Kumar

      Hi Ravindra,

      Very well structured and explained as a business process case study.

      Good work 

      Regards,

      Nishant

      Author's profile photo Former Member
      Former Member

      Nice Document,if possible please explain the link between account assignment category --> and account modifier ,for Eg -->in configuration we can see for K-Cost Center account modifier VBR.

      Nice Documentation,appreciate it.

      Zubair

      Author's profile photo Former Member
      Former Member

      Hi Ravindra,

      Could you Please let me know logic behind the  automatic account determination for MIRO. on what basis the system will pick the GL accounts in MIRO?

      Thanks

      Kiran

      Author's profile photo satheesh kumar Varma
      satheesh kumar Varma

      great article. very helpful.  thanks for sharing

      Author's profile photo Former Member
      Former Member

      Good job Ravindra. Keep it up.

      Author's profile photo Raghavendra M
      Raghavendra M

      Hi Ravindra

      Nice Explanation..  Thanks For sharing. Share some more Document.

      Author's profile photo Former Member
      Former Member

      Hi Ravindra,

      Good Explanation, thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Hi Ravindra,

      Good Explanation..Share some more documents.....

      Author's profile photo Mudasir Makki
      Mudasir Makki

      very helpfull .. Thanks ..

      Author's profile photo Former Member
      Former Member

      hello ravindra sir,

      can u send me documentation of automatic account determination sir?

       

       

       

      Author's profile photo Prathyusha Alavala
      Prathyusha Alavala

      Very useful document...Thanks