When a goods movement is entered, the G/L accounts need not be entered manually since SAP automatically determines the correct accounts. The settings for this automatic account determination & material valuation are done by using the account information set up in advance in an area of Customizing known as “Valuation & Account Assignment”.

Price Control for Material Types:

For each material, a price control is mentioned in the accounting view (Standard price ‘S’ and Moving average price ‘V’) of material Master. And it is mandatory to maintain any one of these price type in the material master.

/wp-content/uploads/2014/08/1_519280.png

/wp-content/uploads/2014/08/2_519305.png

Each material is valuated according to the price set in the material master. And this price control can be set for the material type. There are two types of price control in the material master record (Accounting View)

V-Moving Average Price & S-Standard Price

You can the material price by using transaction code MR21. Once you change the price documents will get generated which reflects old price, new price and change in valuation.

Valuation Area;

Valuation area is nothing but the valuating the materials at organization level. In SAP you can set the set the valuation area at either Company code level or at Plant level. Once the valuation area is assigned it’s very difficult to reverse.

/wp-content/uploads/2014/08/3_519306.png

/wp-content/uploads/2014/08/4_519307.png

Here is the flow chart how automatic account determination works:

/wp-content/uploads/2014/08/aac_519308.jpg

/wp-content/uploads/2014/08/5_519309.png


Valuation Grouping Code: It is the group of valuation areas having same account determination process. Plants with different account determination process should be grouped separately. Valuation grouping code can be activated by navigation path, SPRO—->IMG—->Material Management—>Valuation and account determination—->Account Determination without wizard—-Define valuation control. The valuation grouping code must be active.

/wp-content/uploads/2014/08/6_519310.png

/wp-content/uploads/2014/08/7_519311.png

Account Category reference:

Account category links the Material Type and valuation class (“Grandfather of AAC”, as said by Biju Sir). The valuation classes are defined and assigned to the material master. And finally you have to assign the material type to the account category reference.

/wp-content/uploads/2014/08/8_519312.png


Define Valuation class: The combination of material type, account category reference, valuation class determines the G/L accounts updated for valuation relevant transactions. The Valuation class and account category references are defined in these steps. SAP has in built valuation classes and account category references. If you want different valuation class then you can create new one. And this valuation class must be entered in the material master accounting View.

/wp-content/uploads/2014/08/9_519313.png

/wp-content/uploads/2014/08/10_519314.png


Account Grouping for Movement Type: Example of account grouping

Movement Type

Account Grouping

G/L accounts

561-Initial entry of stock balance

BSA

399999

201-GI for cost centre

VBR

400000

The Account Grouping is used for following transactions:

GBB-Offsetting entry for inventory posting

PRD-Price difference

The Transactions such as MIGO are linked to the Movement type with the help of Value string. Movement types are linked to the Transaction/Event keys. These Transaction/Event Keys are linked to the Account grouping code. And Account groupings are linked to the G/L accounts. The Account Grouping is the finer and subdivision of Transaction/Event keys.

You can configure this by navigating menu, SPRO—->IMG—–>Material Management——>Valuation and Account determination—–>Account Determination without wizard——>Account grouping for Movement Type

/wp-content/uploads/2014/08/11_519315.png

Configure Automatic posting:

You can configure this by navigating menu, SPRO—->IMG—–>Material Management——>Valuation and Account determination—–>Account Determination without wizard——>Account grouping for Movement Type

/wp-content/uploads/2014/08/12_519316.png


Under this transaction, there are different subsequent steps for configuration as per different transactions. Let us look at BSX and WRX

When the transaction such as GR is done, transaction BSX will get hit. Based on the valuation class set in the material master, Valuation grouping code (Valuation modification), and the Value string WE01(for Movement Type 101), The G/L account will be determined.

For BSX, The Valuation class and valuation modifier will be set active in RULES tab. And relevant posting key will selected in the Posting key tab. Similarly we have to configure for WRX and relevant posting key has to be selected for Debit and credit entries for the GR/IR clearing account.

/wp-content/uploads/2014/08/14_519317.png

/wp-content/uploads/2014/08/15_519318.png

PRD will come into account when standard price is maintained in the material master and if it is valuated at same price. The delivered price will not be used for valuation. And whatever the price difference it is posted to the PRD account.

/wp-content/uploads/2014/08/19_519319.png

/wp-content/uploads/2014/08/20_519320.png

Posting transaction Offsetting entry for inventory GBB is used for different transactions such GI, scrapping, physical inventory. These are assigned to the different account like consumption account.

/wp-content/uploads/2014/08/17_519321.png

/wp-content/uploads/2014/08/18_519322.png

/wp-content/uploads/2014/08/21_519323.png

This is the brief overview of Automatic account determination process configuration and I hope it will be useful.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. B V Yadav

    Hi Manjunath BL,

    Have checked about this document previous in SCN, I think there might be document regarding AAD (Automatic Account Determination).

    any how nice document.

    Regards,

    BVYadav

    (0) 
        1. Manjunath B L Post author

          Dear Dev,

          I Have checked if you want me to remove then i will remove it. I worked whole night to prepare this document.

          Waiting for your valuable response.

          Regards,

          Manjunath B L

          (0) 
          1. Dibyendu Patra

            No. I am not saying to remove it. It can be seen that you worked really hard for this document.

            So I’ve not pressed the alert moderator. Lets give it to moderator’s hand.

            (0) 

Leave a Reply