Different accounting for different purpose against movement type
Hello all,
Recently I configured a new thing in our organization.
I want to share with you via this document.
This can help you to all such as these types of business process.
Let’s discuss Scrapping for material.
In an organization, there are many reasons to scrap material stock.
Such as for loss material quantity if it damaged or burned or for any kind losses of these types of reasons.
For that reason we have to do scrap the material quantity.
Now if we do standard movement type 551 for all these reason, we can’t rectify the actual amount for different different reasons.
Such as how many amount loss against damaged?
How’s amount for burned.
For that we can create a new movement type (Z51) copied by 551 movement type.
Just accounting entry will be different for new movement type (Z51) and standard movement type (551).
At first let’s see the account entry for movement type 551.
Its Inventory a/c Credit and Scrap a/c Debit.
As per rule of 551, Z51 also will be same.
But we can set the G/L different via account modifier.
Let’s see the default setting for account modifier. Default settings are
(Note: There are many entries can found for movement types 551 as per procurement type like K,E,O,Q,V,W and Quantity Update/ Value Update. We can do in every type of procurement types, I am just doing Stock type blank and Quantity and value update stock type.)
And my accounts entry on OBYC are for Tran. Key GBB
and for Tran. Key PRD
Whenever I do scrap for material with having 5000 valuation class these above G/L accounts are hit.
Okay let’s assign the standard movement type 551 for damaged scrapping purpose.
Means Whenever Material stock got damaged, we do 551 movement type and it hits on these above G/L accounts.
Now Comes with These materials scrapped which is got damaged against burned.
If we do normal 551 movement type then it hit the same G/Ls. but we want this to a different G/Ls.
For that we can use new movement type Z51 (as copied 551)
Let’s create the movement type.
Use t-code OMJJ.
Tick the movement type buttons and press enter.
Leave the movement type blank for both “From” and “To”, then press enter.
As above, you can see the initial screen of movement type creation has come. Just select the movement type 551 and press the “Copy as..” (as highlighted in above figure)
You feel that you are in the same screen, but you are in new movement type creation mode now. Just change the 551 to Z51 and give the description as per your requirement. (As I maintain same as 551). Then just press enter.
After pressing enter, you can see a dialog box as above Just click on “copy all”
You can see the new movement type has been created.
Just select the movement type and change as per your other requirement as left side fields.
For accounting entry you have to maintain “Account Grouping”
Select the movement type and press “Account Grouping”
You can see the default all for movement type 551.
We have to change the account modifier for Z51 movement type.
Suppose I maintained ZZZ in GBB and ZZ1 in PRD account.
(Note: There are many entries can found for movement types Z51 as per procurement type like K,E,O,Q,V,W and Quantity Update/ Value Update. We can do in every types of procurement types, I am just doing Stock type blank and Quantity and value update stock type.)
Leave the rest all setting as it is. And save your movement type.
Now we have to maintain G/L accounts for this Tran. key with account grouping in OBYC.
Go to OBYC. Go to Tran. Key GBB and do the entry as below:
For movement type 551, we have maintained 190019 G/L. But there I maintain 190020 G/L for movement type Z51.
And go to Tran. Key PRD and do the entry as below:
For movement type 551, we have maintained 250011 G/L. But there I maintain 250012 G/L for movement type Z51.
Now all settings are done.
Let’s check the accounting entry for moth movement type.
I have done a movement for material which having 5000 valuation class using movement type 551.
See the accounting entry:
80010 is our Inventory stock account and you can see the G/L 190019 is debited for movement type 551.
Now let’s check the accounting entry for movement type Z51.
80010 is our stock account, and see for movement type Z51 it’s debited to 190020 G/L accounts.
Against that, you can track your debit details for different purpose for scrapping or any kind of off-setting entry.
Like If you want to do different accounting entry for initial stock upload you can make a new movement type as per 561 movement type and assign different account modifier as per above configuration.
Thanks
Thanks all. 🙂
Hi Patra,
You work on presentation i quess. ( Bad joke)
Thanks for sharing , subject might be 'Creation of Movement Type for Different Account Assignmnt.'
Regards.
M.Ozgur Unal
Not at all Mehmat.
About subject - good suggestion, point noted.
The current subject line needs to be changed.
What's your suggestion ?
Creation of Movement types for specific Account determination requirements or I would even support Mehmet's suggestion.
gud document
pls reply to stock determination problem i have posted
Useful one...Thanks.
BR,
Naresh K.
Thank you Naresh.... Keep in touch.
HI,
Super document lots of new things we can learn from your expertise.
thanks
useful document thanks.......
Hi Dev,
I can see all your efforts in this blog. Keep posting wonderful blog like this.
Whoever involved in the particular module it is very useful.
Regards,
Hari Suseelan
Thanks for sharing just a valuable info
Hi, Dev this Doc has helped me to understand account assignment explicitly. Thank you 🙂
Very useful document, keep up the good work. 🙂 🙂
Hi Dev
Thanks for this useful information. Can you please advise if we have requirement to assign specific G/L account as per reason for movement of a movement type, then how we can achieve this requirement. Thanks!
Regards
Nidhi
Hi Dibyendu,
Could you share your suggestion for this requirement:
In case of Fuel procurement , there could be loss of fuel during transport due to evaporation or oil spill. The vendor still needs to be paid for full amount.
I am planning of creating a new movement type as per your suggestion in this blog.
In MIGO if i chose goods issue and others with mvt type Z51 the loss doesn't reflect in purchase order.
In MIGO if i chose goods issue and purchase order with mvt type Z51 the i get an error Update control of movement type is incorrect "(entry Z51 X X _ B)"
Using which transaction should i post these losses using movement type Z51 so that i can find out how much losses are against each purchase orders?
Regards,
Ashish Shah
Hi i need your help,
I copied 551 & 552 mvt with Z51 & Z52. now if i post document with Z51 it is working fine but if i reverse the document the mvt 552 is picking automatically instead of Z52. What could be the reason.
Thanks in advance.