Skip to Content
author's profile photo Former Member
Former Member

Condition expression in validation

Hi Friends!

I want to create a validation rule in line item level for bank GL accounts.

I have 3 bank accounts

190000- Main Bank Account

190001-Check Deposti account

190002-Check Issue account

1) Want to restrict postings to main account, other than with doc type ZR

2) Want to restrict credit postings with PK50 to +++++1 account, other than with doc type ZR

3) Want to restrict Debit postings with PK40 to +++++2 account, other than with doc type ZR

ZR is my reconcilation doc type, used by FF67.

For one accounts, if we want to restrict i can directly write a condition like

Prerequesite: BSEG-HKONT = '190000'

Check: BKPF-BLART = 'ZR'

Message: Error Message

But if i want to restrict several main bank accounts from diff company codes, what will be the right procedure to do it.

If i choose Post automatically only in GL master, i cannot post entries even through FF67 also.

Can i use set IDs for this? i have created a set ID with table BSEG and field HKONT through GS01.

But how to express the set ID in the prerequesite section.

single values will be like BSEG-HKONT = '190000', but for set ID usage to what will be condition expression?

Kindly guide me.

Thanks,

Srinu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2010 at 05:49 AM

    Dear,

    You have done the right thing of creating Set in GS01. If you have created set like ZGLVAL so you can express in validation like...

    BSEG-HKONT IN ZGLVAL instead of BSEG-HKONT = '410000' for standalone GL.

    Regards,

    Chintan Joshi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear,

      In OBMSG, i have added msg no 094 of app area FV.

      There another 3 field available like Allowed, Standard, and Switch Off.

      What needs to enter in those fileds?

      In Allowed, enter WE (this means you can set this message as warning or Error in OBA5)

      Standard:Enter W (stadard attribute of the system is warning not error)

      Switch off: do not use this.

      Once you have done this then go to OBA5 and make FV 094 as an error.

      Regards,

      Chintan Joshi

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.