When a goods movement in the system, we must enter a movement type to differentiate between the various goods movements. A movement type is a three-digit identification key for a goods movement.
In this step, we can change the setting of existing movement types
When you enter a goods movement, you must always enter the movement type. The movement type has important control functions in Inventory Management. It is essential for updating the quantity fields updating the stock and consumption accounts selection of the fields used for entering documents printing goods receipt/issue slips
How to create movement types? What are the steps involved? When will you recommend a new movement type?
Companies may request a new movement type to differentiate between the inventory posting transaction. For example, 551 scrap movement type. Some company may request to have it as 551 for Internal Scrap and Z51 for External Scrap.
Copy, Change Movement Types
Assuming I want to create another movement type Z01.
Transaction OMJJ
Select the standard movement type 201
Click copy, then overwrite the 201 with Z01
Click the Enter button, then click Copy all
Select the new movement type Z01
On the left hand column screen, click Reversal/follow-on movement
Fill in the reversal movement type
For the rest of the options, you can leave it alone or change it depending on your requirement
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.
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.
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.
In this step, we can change the setting of existing movement types
When you enter a goods movement, you must always enter the movement type. The movement type has important control functions in Inventory Management. It is essential for updating the quantity fields updating the stock and consumption accounts selection of the fields used for entering documents printing goods receipt/issue slips
How to create movement types? What are the steps involved? When will you recommend a new movement type?
Companies may request a new movement type to differentiate between the inventory posting transaction. For example, 551 scrap movement type. Some company may request to have it as 551 for Internal Scrap and Z51 for External Scrap.
Copy, Change Movement Types
Assuming I want to create another movement type Z01.
Transaction OMJJ
Select the standard movement type 201
Click copy, then overwrite the 201 with Z01
Click the Enter button, then click Copy all
Select the new movement type Z01
On the left hand column screen, click Reversal/follow-on movement
Fill in the reversal movement type
For the rest of the options, you can leave it alone or change it depending on your requirement
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.
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.
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.
