G/L Account - Movement Type

[antonio_bruno]

Hi,

how can i extract a list of the G/L Account related to the movement type (309, 311, 561, 562, 551, 201, 333, 321, 322, 541, 542) used in the manual registration (MB1A, MB1B, MB1C)?

Thanks and best regards.

Antonio

[Muralinag14 · Accepted solution]

OMWB

Simulation

give plant and material

select movement type and click on account assignments

here you can find the GL accounts assignment.

[antonio_bruno · Accepted solution]

Hi Murali,

thanks for your answer.

But i can see only a specific situation. Is there a solution to extract (maybe in a query) the general setting of the movement type and the related G/L account?

Thanks.

Best regards.

Antonio

[iklovski · Accepted solution]

Hi Antonio,

I'm not aware of this. There is no report, and since the data is not stored simply in one table, you cannot access it just via database. Of course, you can develop following basically the same algorythm OMWB is working or reading the data from T030 and T156X tables.

Regards,

Eli

[antonio_bruno · Accepted solution]

Ok Eli.

Thanks.

Best regards.

Antonio

[former_member823860 · Accepted solution]

Very helpful Murali,

Thank you it solved my problem.

[Former Member]

Hi,

You can check through Tx - OMJJ. Go to accounting group find the account modifier for those rows for which  column "S" (Special stock) is empty and  than go to Tx- OBYC and find the corresponding GL a/c with the general Modifier in GBB.

[iklovski]

Hi,

G/L account is not directly assigned to movement type, but defined through transaction type. Assignment of the accounts to transaction type is done in OBYC. In order to check the link of movement type to transaction, you have to use OMJJ.

Regards,

Eli

[suma_mani]

Hi Antonio,

OMWB where you can simulate and check the GL accounts.

Rgds

Mani