Skip to Content
Author's profile photo Dibyendu Patra

Automatic Account Determination for without material master.

Recently I have configured how the default G/L is fetching on PO, when we are not using any material master for PO line item.

As we know when we use material master, It brings the G/Ls from valuation class (in material master) from OBYC (from table T030).

As per accounting entry for standard PO, we need to maintain G/Ls for two transaction keys against valuation class, these are BSX and WRX.

But If we use account assignment category K – Cost center(or even any), then we need to maintain G/L account for transaction key WRX and maintain manualy a G/L account to the PO line item.

Here I am introducing, G/L can be fetched from material group, so that we don’t have to maintain G/L account in PO line item.

Configurations

Step 1: Create Material Group

Create the material group from OMSF (If material group is not maintained in system). Else continue with existing.

Capture.JPG

I have created a material group as TEST, which will be used in PO. Save your entry.

Step 2: Create Valuation Class

Go to t-code OMSK, and click on Valuation Class. Else continue with existing.

Capture.JPG

Click on “New Entries”, fill the value of valuation class and description. No need to maintain Account Category Reference. Save your entry.

I have maintain valuation class 8004 and description Testing Purpose.

Step 3: Assign valuation Class to Material Group

Please go through the path SPRO-IMG-Materials Management-Purchasing-Material Master-Entry Aids for Items Without a Material Master.

Capture.JPG

Here, maintain the new valuation class against the material group.

As I’ve maintained 8004 for material group TEST.

Step 4:Assign General Modification to Account Assignment

You have to maintain the general modification (account modification) to account assignment category, which you will use at the time of PO creation.

Go to SPRO-IMG-Materials Management-Purchasing-Account Assignment-Maintain Account Assignment Categories/OME9

Capture.JPG

Here, maintain the general modification for account assignment K (const center)

Step 5: Maintain G/L against Valuation Class

Now we have to maintain G/L account for this valuation class on transaction key GBB along with General Modification VBR

And maintain WRX for GR/IR clearing account. For WRX we don’t have to use Valuation Class, Just assign the G/L for blank valuation class.

Use T-code OBYC

Capture.JPG

Here maintain the G/L which will be expenses account for PO (as instead of Inventory Stock Account)

Maintain As per screen shot above.

I have maintain G/L account 270001 against valuation class 8004.

Capture.JPG

Maintain the G/L like above figure. As I maintain 150050.

Result:


Now Lets Create PO without material master.

T-code ME21N,

Capture.JPG

Give the all details on Header level.

In item level give the account assignment key “K” Short text (as per your requirement), Just give the Material group.

Whenever you put the material group and press enter you can see the G/L account which you have maintained in OBYC for this.

Save your PO.

Then do Goods Receive.

The accounting entry will be as below figure.

Capture.JPG

You can see the account 270001 has been debited and account 150050 has been credited.

270001 = Expenses Account ( As Stock Inventory Account)

150050 = GR/IR Clearing Account.

Here, system will bring that G/L account for transaction event key WRX, which has maintained with blank valuation class. It will take the only one G/L account with irrespectively valuation classes. You can only change the Expenses (270001) account with regards to the valuation class. There are no standard option to bring the G/L account for WRX transaction key from T030 table with regards to the valuation class. If you want to do that, then you can do that with the help of some enhancement. You can have a look into the blog post Determination of different GR/IR accounts for non-inventory procurement.

Its a supply chain as automatic account determination, whenever we create PO without material master

Material Group assign with valuation class. Valuation class assign with G/L account.

Assigned Tags

      28 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo PRASOON AK
      PRASOON AK

      Hi,

         You didnt mention how the VBR modifier came against GBB. Actually it is depending on the account assignment category. Here, you used acc assignment K. Go to OME9 transaction and go to details of the account assignment category K and check the account modifier assigned. It will be VBR. It will be good if you mention the same in your document.

          Nice document. Keep it up.

      Regards,

      AKPT

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

      Thank You Sir,

      I have mentioned that.

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      super really 🙂 lots of think to learn

      Author's profile photo manu m
      manu m

      Good Document Dev.

      Normally we have this scenario for service PO - just fyi .Thanks for sharing

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

      Yeah, We can use it for service PO.

      Whenever we use account assignment K and material group, then we can default the G/L.

      Author's profile photo Preeti Kashyap
      Preeti Kashyap

      Thanks for the document sharing.

      Saved in my inventory.

      Regards

      Author's profile photo saurabh awasthi
      saurabh awasthi

      Great document......................................... 🙂

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Lovely blog and I like the way you have presented.

      Keep up the good work!

      Regards,

      Hari Suseelan

      Author's profile photo Former Member
      Former Member

      Really a good document posted by you Dev.

      Many thanks

      Author's profile photo Preeti Kashyap
      Preeti Kashyap

      We can add PVK also here for the scenario of over/under delivery tolerance when we are not using Material Master and having tolerance limit while doing MIGO.

      Regards

      Preeti

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

      You can do it via Info record.

      Create an info record. with vendor and material group.

      Maintain the PVK details in info record.

      Then while creating PO you have to call up the info record manually.
      Then all PVK details will come to PO.

      Author's profile photo Sheetal Premnath
      Sheetal Premnath

      Hi Dev,

      Thanks a lot for sharing the document.

      Regards,

      Sheetal

      Author's profile photo Junaid ALAM
      Junaid ALAM

      Good work...

      Author's profile photo Former Member
      Former Member

      Thanks Dev,

      Its really helpful!!

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi

      Dear Dev,

      Informational Document really........:D

      Best Regards

      Mohsin Abbasi

      Author's profile photo Swapnil nevrekar
      Swapnil nevrekar

      Its an addition to the knowledge.

      Thanks Dev

      Best Regards,

      Swapnil

      Author's profile photo Sheetal Premnath
      Sheetal Premnath

      Thanks a lot for sharing this document.

      Author's profile photo Former Member
      Former Member

      Thanks for the sharing this is very beneficial documents.

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      You are always very helpful.

      Thank you.

      Author's profile photo Former Member
      Former Member

      thanks!

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Document is mind-blowing and Thanks for your Doc

      Regards,

      Sathish .

      Author's profile photo Former Member
      Former Member

      Dear Dev,

      Thanks for this document, I would like to raise one questions:

      - In the case I use the valuation class assigned to my Material Group for WRX to determine an G/L account in MIGO, system will use the "blank" line in WRX instead, why?

      - Imagine a case where a customer wants two different GR/IR G/L accounts for two different Non inventory Material Group ? How should we proceed ?

      Best regards,

      Vincent.

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

      It is certainly not possible in standard.. You may can follow the blog written by Alexandre N. Determination of different GR/IR accounts for non-inventory procurement

      Author's profile photo Osvaldo Lopez
      Osvaldo Lopez

      Excellent documment, thanks for share!

      Author's profile photo Mahesh Madhavan
      Mahesh Madhavan

      Thanks for this wonderful document!

      Cheers,

      Mahesh

      Author's profile photo Vikash Sharma
      Vikash Sharma

      Hi Dibyendu Patra,

      While trying to map this account determination in sandbox.. i found out that none of the above setting exist for material group but at GRN account is determined ?? How??

      Correct me if I am wrong...

      I believe irrespective of valuation class whatever G/L account you pass in PO that will get determine at GRN but in OBYC an entry with that G/L A/c and VBR modifier must be exist. Ex can be like below

      0001 VBR 3000 400000

      So if 400000 G/L passed in PO the above entry will get determine irrespective of valuation class.

      In case of using an specific G/L account above setting will do best.

      Author's profile photo Former Member
      Former Member

      Hi I did same settings in my system, still it is not picking...plz help me on this issue...

      Author's profile photo Ali Mozahid
      Ali Mozahid

      Hello Dibyendu Patra,

       

      Thanks for your well organized documentation. I have two question if anyone can help.

      1. How can I  find which material group should go under which valuation class. Currently business provided me 110 new Material Group. Once user key in Material group system should default designated GL Account
      2. Deriving  the GL from Material group does it work for PO and PR both. if yes, is there anyway to control it document level.