Different accounting for different purpose against movement type
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.