Skip to Content
Author's profile photo Mohsin Abbasi

Different GL Requirement on Plant to Plant Stock Transfer and rest of the Movt. of Stock Transfer on AUM Key

Hi Friends,

    My name is Mohsin Abbasi, I am an SAP Consultant of Materials Management.This is my first blog and I would like to share a requirement from one of our clients and how it is achieved in standard!

    One of our client mainly in textile was using Stock Transport Order, as there are two plants, one Plant (B) is manufacturing semi-finished which in turn used to make finished product in other plant (A). We maintain the semi finished i.e. on price control (S)standard, as we have PP module implemented as well. When they transferred material from manufacturing plant (B) to manufacturing plant (A), due to standard price there will be always chances of incurring price difference, as plant (A) sometime procure directly or do subcontracting and either start production itself in plant (A). Due to this there is cost price difference in both plant.

Requirement

There Finance department agreed to have separate GL for inter-plant Stock transfer (Price Difference inter Plant Transfer) Movt type 351 and for the rest of the material stock transfer GL would be for Movt type 411 E, 412 E, 413 E & 414 E (price difference Material Transfer). So that at the month end they could calculate the total price difference while transferring of material Plant to plant. In standard, there would be only one key which is triggering i.e. AUM while transferring of material. As company is following both MTO and MTS process. At that time, whatever difference incur either from plant to plant transfer or sale order to sale order, Sale order to own and own to sale order, GL is common and we need to separate it.

And the GL (Price Difference inter Plant Transfer) is hitting i.e. on movt type 413 E, 414 E, 411 E and 412 E, which is not required at all.

So, there is no Account modifier now in Standard SAP and the problem is how we can differentiate the GL stock transfer between plant and Stock transfer between sale order to sale order, Sale Order to own Stock and own stock to Sale Order.

And the GL is hitting i.e. on movt type 413 E, 414 E, 411 E and 412 E, which is not required at all while transferring Sale order to own and sale order to sale order and so.

And client wanted the separate GL incase of 411 E, 412 E, 413 E and 414 E i.e. 53500201 (Price difference from Material Transfer)

 

In Standard there is blank field in acct modifier w.r.t to every movt type. you can see in mentioned below screenshot as well.

OBYC Rule (Automatic Account Determination)

OBYC rule based on Five factor upon which system recognize that which GL should be posted in case of inventory management and invoice posting relevant to financial and cost accounting. These factors are:

  • Chart of Account
  • Valuation grouping Code
  • Transaction Event Key
  • Account Grouping
  • Valuation Class

We can differentiate GL based on these Five factors.

  1. 1. Chart of Account

2.Valuation Grouping Code

3.Transaction Event Keys

4. Account Grouping (General modifier)

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

5. Valuation Class

You can assign GL to valuation class and then that valuation will be assigned to material master data.

Now this is sure if you have any of above factor different, you can assign different GL but here All factors are same i.e. Chart of account 1000, Valuation Grouping Code 0001, Transaction event Key AUM, Account Grouping (Blank), Valuation Class (3001) and we can’t get separate GL with standard configuration.

Note: An account grouping is defined for the transaction/event keys GGB (offsetting entry to stock posting), KON (consignment liabilities) and PRD (price differences). And we don’t have account grouping for AUM in standard.

Solution:

After deep analysis, I came up with the solution of activating account grouping for Transaction event key AUM. As we are dam sure that plant to plant transfer is always done by STO which trigger the movt Type 351 which is different from other movt type of stock transfers like Sale order to Sale order 413 E and 414 E and Sale Order to own and so 411 E and 412 E. So we could make new account modifier to assign separate GL. To do this configuration is in shown in screen shots.

Now After this configuration, when i transfer Plant to plant, it will hit movt type 351 where General modifier is blank which fetch the GL 53500202  Price Dif Plant Tran which is client requirement. You can see the screenshot as well.

Now other client requirement is to hit the GL  53500201 Price Differnce Mat.Trnsfer  

on rest of the stock transfers i.e. 413 E, 414 E, 411 E and 412 E

Accounting Entry

I hope this will suffice your requirement, if you ever come across this type of scenario.

Best Regards

Mohsin Abbasi

Assigned Tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi Mohsin

       

      I am glad to see that you finally posted something here and you started giving back to SCN in return of the favor that we have had from last couple of years.

      Keep sharing your knowledge and experience for community members.

       

      Thank$

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Dear Moazzam,

      You are right, you were the only person who kept insisting me to do this, and finally i did this. Now onward i will share as accordingly.

      Kind Regards

      Mohsin Abbasi

       

      Author's profile photo Muhammad Usman Raza
      Muhammad Usman Raza

      Nice blog.. Keep sharing.., Usman

       

       

       

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Thank you very much Muhammad Usman Raza

      Author's profile photo Former Member
      Former Member

      This is superb, I had no idea a document could look this good. This is very informative and a much-needed document, you have solved a big problem. I really appreciate your effort.

      keep up the good work.

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Dear Imran Mazhar ,

      For me your comments are of immense importance, Thanks Sir.

      Author's profile photo Faisal Iqbal
      Faisal Iqbal

      It's a good step and hope many will benefit from your experience. And as Moazzam said it's a way to return favors to the community. Happy to see your contribution. Well done! : )

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Dear Faisal Iqbal ,

      Thanks for your valuable comments, Yes you are right, it's the only way pay back the Community from whom we get benefited since from the birth in SAP.

      Author's profile photo Adnan Maqbool
      Adnan Maqbool

      Nice , next episode can be Output Management within S/4 HANA

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Dear Adnan Maqbool Bahi,

      Yes definitely, I will now take into consideration surely, my next target would Output Management in S/4 HANA but One thing i must say, Output management In IESCO would never become possible without your help.

      By the way thanks for your valuable Comments. Jazak Allah Sir.

      Best Regards

      Mohsin Abbasi

      Author's profile photo Former Member
      Former Member

      Dear Mohsin bhai,

      Very useful document and nicely explained. It is very helpful for the newcomers in MM. Thanks for sharing. Keep up the Good work (Y)

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Dear Muhammad Arsalan ,

      Yes you are right, it is very helpful for the newbies as well.

      Author's profile photo Former Member
      Former Member

      Great work for new borns in Sap

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Thanks brother.

      Author's profile photo Aqib Dar
      Aqib Dar

      Excellent !! Well Explained.


      With the help of this document.I
       managed to configure 1-year-Old scenario for the client.


      You are the best.

      Aqib Zaka Dar

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Dear Aqib Dar ,

      Feel a sense of proud now, at least someone get benefited practically.

       

      Best Regards

      Mohsin Abbasi

      Author's profile photo Syed Muhammad Fahad Raza Shah
      Syed Muhammad Fahad Raza Shah

      Dear Mohsin,

      Very comprehensive Document... nicely presented. Well Done.

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi
      Blog Post Author

      Dear Syed Muhammad Fahad Raza Shah,

      Thanks for endorsing

       

      Best Regards

      Mohsin Abbasi

      Author's profile photo Rameesa Shabbir
      Rameesa Shabbir

      Mohsin bhai,

      That was really informative, keep sharing .