Skip to Content
Author's profile photo Dibyendu Patra

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

Capture.JPG

(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

Capture.JPG

and for Tran. Key PRD

Capture.JPG

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.

Capture.JPG

Tick the movement type buttons and press enter.

Capture.JPG

Leave the movement type blank for both “From” and “To”, then press enter.

Capture.JPG

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)

Capture.JPG

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.

Capture.JPG

After pressing enter, you can see a dialog box as above Just click on “copy all”

Capture.JPG

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.

Capture.JPG

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:

Capture.JPG

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:

Capture.JPG

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:

Capture.JPG

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.

Capture.JPG

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

Dev Patra

Assigned Tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Dibyendu Patra
      Dibyendu Patra
      Blog Post Author

      Thanks all. 🙂

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      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

      Author's profile photo Dibyendu Patra
      Dibyendu Patra
      Blog Post Author

      Not at all Mehmat.

      About subject - good suggestion, point noted.

      Author's profile photo Former Member
      Former Member

      The current subject line needs to be changed.

      Author's profile photo Dibyendu Patra
      Dibyendu Patra
      Blog Post Author

      What's your suggestion ?

      Author's profile photo Former Member
      Former Member

      Creation of Movement types for specific Account determination requirements or I would even support Mehmet's suggestion.

      Author's profile photo Former Member
      Former Member

      gud document

      pls reply to stock determination problem i have posted

      Author's profile photo Former Member
      Former Member

      Useful one...Thanks.

      BR,

      Naresh K.

      Author's profile photo Dibyendu Patra
      Dibyendu Patra
      Blog Post Author

      Thank you Naresh.... Keep in touch.

      Author's profile photo Former Member
      Former Member

      HI,

      Super document lots of new things we can learn from your expertise.

      thanks

      Author's profile photo Former Member
      Former Member

      useful document thanks.......

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Hossam Gomaa
      Hossam Gomaa

      Thanks for sharing just a valuable info

      Author's profile photo Former Member
      Former Member

      Hi, Dev this Doc has helped me to understand account assignment explicitly.  Thank you 🙂

      Author's profile photo Nassar fathy
      Nassar fathy

      Very useful document, keep up the good work. 🙂 🙂

      Author's profile photo Nidhi Jain
      Nidhi Jain

       

      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

       

      Author's profile photo Ashish Shah
      Ashish Shah

      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

      Author's profile photo Powdan Jain
      Powdan Jain

      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.