Defaulting a GL account in a PO line based on the Material Group selected

[former_member95896]

We often have situations where our PO lines are free form text for a custom art piece or store design item. These lines are assigned to a specific material group as opposed to being a discrete material. In our setup a material group will always be associated with 1 GL account. Is there a way to default or maintain that relationship between the Material Group and GL account to auto-populate the GL account field and cut down on the PO manual user entry?

Thanks!

Ryan

[junaidalam · Accepted solution]

Hi rpmuller , Not sure that you have configured the system for your requirement. Below are the steps and SSCUI's that you can use to implement your requirement in S4HC,

1- Configure the Valuation Classes through SSCUI 102424. You can use the existing valuation classes as well. It depends on your requirement, if required create new valuation classes.

2- Configure the Material Groups Through SSCUI 102665. You can use the existing Material groups.

3- Now assign the Valuation classes to the material groups through SSCUI 101602.

4- Now assign GL account to Valuation classes in SSCUI 100297. We normally use GBB as Transaction key.

After these settings your Valuation class is now assigned to GL Account. Material group is assigned to the valuation class. Now when you will create a purchasing document and enter the material group, system will determine the GL account automatically.

Revert back for any further clarification.

Regards,

Junaid

[former_member95896 · Accepted solution]

junaid.alam1976 Thanks so much for your reply. I'd done steps 1-3, I just needed to do ‎#4. Account Determination transaction keys are tough to discern sometimes. I'll give it a try and report back.

Appreciate the help!

Ryan

[Feras_Al-Basha]

Hi Ryan,

In follow-up to Luke's comments and your latest update, have you tried maintaining the OBYC settings found in the configuration path General Ledger---->Chart of Accounts---->Automatic Account Determination: SSCUI (100297)? Thereafter you may be able to maintain the desired GL account for a given valuation class.

For instance attached please find a screenshot of the available settings within SSCUI 100297, Area=Materials Management, Transaction Key: GBB.

Hope this addresses your need,

Thank you,

Feras

[former_member95896]

Hi ferasbasha3 ,

Thanks for your tip, I've poked around with account determination a bit, (intuitively that's where I thought the connection might be) but didn't find a transaction key that I thought fit what I wanted to do. I'll explore it more and keep poking at it.

Thanks‎!

Ryan

[Former Member]

Hi Ryan,

Yes there is. It requires two things. First the Material Group needs to be assigned to a Valuation Class. That can be done through SSCUI ‎# 101602. Once that is done, Finance needs to assign the proper G/L Account to each Valuation Class. As I'm not an FI guy, I'm not sure which SSCUI this is done through. I'll see if I can find out and you can look too. I'll update here if I find it.

Luke

[former_member95896]

Hi luke.brazell1 ,

Thanks for the response. The good news is that I had already done the first step in assigning the valuation class to the material group. I've found some additional great news in that area in that creating a new valuation class used to require expert config, but now it appears as an SSCUI 102424. I'm struggling with the same step you were the G/L assignment to the valuation class which I believed was possible I just can't find where.

I'll post here if I find anything.

Thanks,

Ryan

[PollyGan]

Hi，

You can check Feras's reply and refer to SSCUI ID 100297.

Kind regards,

Polly