Validation in GL Account

[Former Member]

Hi Everybody,

My client wishes to create a validation on the Balance of a GL Account. It should be such that in some account groups Debit Balance will not be allowed and in some account groups Credit Balance will not be allowed. Can anybody let me know how to do this please?

Thanks and Regards,

Sachin.

[Former Member]

HI,

With Validation you can give error message that to perticular account will not be credited or debited.

However if he dont want to see the credit/debit balance in the financial statements then you can mark debit or credit check mark(any one depending on your requirement) in the financial statement version.

For ex.If client want to show credit balance to one account then tick mark credit check box in the financial statement version.

[Former Member]

Hi

I agree with Saurabh, following are the points -

1) you need to create sets for account groups in GS01, including all the GL accounts

2) Create the messages in the existing or new message class (SE91)

3) Go to GGB0/OB28 for validation, you need to create 2 validations, one for debit balance account group other for credit balance.

4) These validations should be on the field BSEG-HKONT

(You need to properly put the logic for pre-requisites, check and message)

Regards,

Lalit

[Former Member]

Hi Sachin,

The validation rules are designed for one accounting document and typically do not support account balances, which comprise of several documents posted. So generally you can tell the client that it is not possible. But you should try your best before you say that.

Here you can stretch your imagination, take the help of an ABAPer and see if you can implement the following.

You need 2 validations, one for all GL Accounts which need debit check and another for credit balance check.

Create 2 sets of GL Accounts in GS01 and enter all GL Accounts which need debit check in one set and similarly the other set.

Define a line item validation rule inside GGB0 for a combination of company code and GL Account and then insert a user exit.

Inside the user exit, ask the program to check the following 2 conditions. Let us take the debit check:

1. If the sign of the amount entered is debit it is ok no further checks

2. If the sign is credit then compare the amount entered in the line item with the GL Account balance. If the amount is greater then issue an error message.

Hope the above helps.

Sharabh