account_determination
Movement Type and GL Account Determination
Movement Type and GL Account Determination
Any report to show which account with what movement type? As we have too many movement
type with different account, we want to download it from system and check.
By: Roger
In transaction OMWB (it require to input material no.), go to the simulation mode, then in menu
Simulation --> Go to Report. There, you can give the plants, valuation classes and movement types and
execute the report. Then you can download it to excel and analyze.
or
In the initial screen input the plant, material number and movement type and then go to simulation -->
report. It will take you to simulation of automatic account assignments : Inventory Management which
is independent of materials and there you can get the desired report.
Account no. with movement type
Different materials will use different accounts during movement. This is defined by the Valuation Class
the material is assigned to. Also, movement definition also differs with the type of movement, i.e., a
consumption on a production order has a different movement than a consumption on a sales order.
These movements are therefore linked to Transaction/Event Keys, which are the accounting reflection
of the movement.
Call transaction OMWN, Account Grouping for Movement Types. This table will provide you with the
Transaction/Event Keys for the movement. Withine a movement
type, these will differ based on the movement, consumption type, etc. The tables behind this are T156X
and T156W.
With this Transaction Key information, read the table T030 (OBYC) using the Val Class and the Chart
of Accounts to get the GL Accounts.
How to find out how G/L account is determined with respect to movement type for various
material types?
G/L a/c is decided not only by Movement type, but also material master/plant/type of transaction
(transaction key). Movement type in OMJJ is contains transaction key / Account modifier which is the
link for GL a/c.
f
Movement Type and GL Account Determination
In material master we maintain valuation class. Hence when we do let us say GR for Purchase order
(101), the G/L account is decided as below
Let us say movement type 101
Account modifier = space
Check in OBYC
As you are aware for any transaction there will be +ve and -V entry in GL a/c
Which a/c has to be -ve and which has to be + is decided by posting key depending on transaction.
Hence When we do GR...Stock a/c will be +, GR/IR will be -Ve and any price difference(if price
control is -S) will be posted to price difference account.
Inventory posting is done through BSX
Price difference will goto PRD
GR/IR will goto WRX
In OBYC, check the transaction BSX, for a given Chart of A/c, for a given valuation modifier(it is
nothing but plant grouping) and valuation class, you can see the G/L account. This data is available in
table T030
You can see the posting key for debit and cr. That means when we do 101, then Stock will be credited
and that posting key is used, if you do reverse GR-102, then same stock a/c will get debited with that
posting key
For the transaction PRD, you will get addition to the above, one more column General modifier, this is
nothing but the account modifier in OMJJ for that movement type, i.e. Same transaction i.e. GR, if i
define a different account modifier, I can change the G/L account so that new movement type PRD
(variance) can be collected at different G/L account.
Like that WRX, in which it is maintained at client level no a/c modifier, no valuation class etc...that
means GR/IR account determination will not depend on movement type/material/plant etc.
l
l
MM-FI Integration
IMPORTANT SAP NOTES ON CONFIGURATION OF MM-FI ACCOUNT DETERMINATION &
AUTOMATIC POSTINGS
What are automatic postings?
Postings are made to G/L accounts automatically in the case of Invoice Verification and Inventory
Management transactions relevant to Financial and Cost Accounting.
Example
Posting lines are created in the following accounts in the case of a goods issue for a cost center:
Stock account, Consumption account
How does the system find the relevant accounts?
When entering the goods movement, the user does not have to enter a G/L account, since the R/3
System automatically finds the accounts to which postings are to be made using the following data:
Chart of accounts of the company code
If the user enters a company code or a plant when entering a transaction, the R/3 System determines
the chart of accounts which is valid for the company code.
You must define the automatic account determination individually for each chart of accounts.
Valuation grouping code for the valuation area
If the automatic account determination within a chart of accounts is to run differently for certain
company codes or plants (valuation areas), assign different valuation grouping codes to these valuation
areas.
You must define the automatic account determination individually for every valuation grouping code
within a chart of accounts. It applies to all valuation areas which are assigned to this valuation grouping
code.
If the user enters a company code or a plant when entering a transaction, the system determines the
valuation area and the valuation grouping code.
Transaction/event key (internal processing key)
Posting transactions are predefined for those inventory management and invoice verification
transactions relevant to accounting. Posting records, which are generalized in the value string, are
assigned to each relevant movement type in inventory management and each transaction in invoice
verification. These contain keys for the relevant posting transaction (for example, inventory posting and
consumption posting) instead of actual G/L account numbers. You do not have to define these
transaction keys, they are determined automatically from the transaction (invoice verification) or the
movement type (inventory management). All you have to do is assign the relevant G/L account to each
posting transaction.
Account grouping (only for offsetting entries, consignment liabilities, and price differences)
Since the posting transaction "Offsetting entry for inventory posting" is used for different transactions
(for example, goods issue, scrapping, physical inventory), which are assigned to different accounts (for
example, consumption account, scrapping,
MM-FI Integration
expense/income from inventory differences), it is necessary to divide the posting transaction according
to a further key: account grouping code.
An account grouping is assigned to each movement type in inventory management which uses the
posting transaction "Offsetting entry for inventory posting".
Under the posting transaction "Offsetting entry for inventory posting", you must assign G/L accounts for
every account grouping, that is, assign G/L accounts.
If you wish to post price differences to different price difference accounts in the case of goods receipts
for purchase orders, goods receipts for orders, or other movements, you can define different account
grouping codes for the transaction key.
Using the account grouping, you can also have different accounts for consignment liabilities and
pipeline liabilities.
Valuation class of material or (in case of split valuation) the valuation type
The valuation class allows you to define automatic account determination that is dependent on the
material. for example: you post a goods receipt of a raw material to a different stock account than if the
goods receipt were for trading goods, even though the user enters the same transaction for both
materials. You can achieve this by assigning different valuation classes to the materials and by
assigning different G/L accounts to the posting transaction for every valuation class.
If you do not want to differentiate according to valuation classes you do not have to maintain a
valuation class for a transaction.
Requirements
Before you maintain automatic postings, you must obtain the following information:
1. Valuation level (plant or company code)
Establish whether the materials are valuated at plant or at company code level
When valuation is at plant level, the valuation area corresponds to a plant. When
valuation is at company code level, the valuation area corresponds to a company
code.
2. Chart of accounts and valuation grouping code per valuation area
Find out whether the valuation grouping code is active.
Activate split valuation
If it is not active, determine the chart of accounts assigned to each valuation area
(via the company code). If it is active, determine the chart of accounts and the
valuation grouping code assigned to each valuation area. Group valuation areas
You must define a separate account determination process for chart of accounts
and each valuation grouping code.
3 Valuation class per material type
If you wish to differentiate the account determination process for specific
transactions according to valuation classes, find out which valuation classes are
possible for each material type Define valuation class
4. Account grouping for offsetting entries to stock accounts
Under Define account grouping for movement types, determine for which
movement types an account grouping is defined for the transaction/event keys
GGB (offsetting entry to stock posting), KON (consignment liabilities) and PRD
(price differences).
...
