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.
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.
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.
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
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
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.
Maintain the G/L like above figure. As I maintain 150050.
Result:
Now Lets Create PO without material master.
T-code ME21N,
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.
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.
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
Thank You Sir,
I have mentioned that.
Hi Dev,
super really š lots of think to learn
Good Document Dev.
Normally we have this scenario for service PO - just fyi .Thanks for sharing
Yeah, We can use it for service PO.
Whenever we use account assignment K and material group, then we can default the G/L.
Thanks for the document sharing.
Saved in my inventory.
Regards
Great document......................................... š
Hi Dev,
Lovely blog and I like the way you have presented.
Keep up the good work!
Regards,
Hari Suseelan
Really a good document posted by you Dev.
Many thanks
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
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.
Hi Dev,
Thanks a lot for sharing the document.
Regards,
Sheetal
Good work...
Thanks Dev,
Its really helpful!!
Dear Dev,
Informational Document really........:D
Best Regards
Mohsin Abbasi
Its an addition to the knowledge.
Thanks Dev
Best Regards,
Swapnil
Thanks a lot for sharing this document.
Thanks for the sharing this is very beneficial documents.
Hi Dev,
You are always very helpful.
Thank you.
thanks!
Hi Dev,
Document is mind-blowing and Thanks for your Doc
Regards,
Sathish .
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.
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
Excellent documment, thanks for share!
Thanks for this wonderful document!
Cheers,
Mahesh
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.
Hi I did same settings in my system, still it is not picking...plz help me on this issue...
Hello Dibyendu Patra,
Thanks for your well organized documentation. I have two question if anyone can help.