Validation

[Former Member]

Hi All

I want to create a validation for t code fb50 and fb60.

for these transactions should not allow the the document type Z2 and Z3.

so i have created the validation step in the following way.

Prerequisite: tcode =fb50 and Tcode = fb60

Check: document type <>Z2 and Document type <> Z3

message: error.

but when i am doing testing, system is allowing the document type Z2 and Z3

Please let me know how to proceed this issue.

Best Regards

Madhavi

[Former Member · Accepted solution]

Hi Madhavi,

Go to GGB0---- maintain validations.

Please copy the below validation code to meet your requirement.

Prerequisite : BKPF-BLART = 'Z2' OR BKPF-BLART = 'Z3'

Check : SYST-TCODE <>(NOT EQUAL TO) 'FB50' AND SYST-TCODE <>(NOT EQUAL TO) 'FB60'

For NOT EQUAL TO, use the symbol in validation as it is not displayed here while iam typing.

Go to GGB4 and activate it to your company code.

In writing validation code AND , OR , = , <>(NOT EQUAL TO) will greatly impact on logic.You must be careful while writing the logic, other wise the whole validation code will be useless.

Let me know if you need further help.

Regards

venkat

Edited by: Venkat Dara on Nov 29, 2008 12:43 PM

[Former Member · Accepted solution]

Hi Venkat

thank you for response

still it is not working...

i have tried all possbile ways for validation

still it is not working..

[Former Member · Accepted solution]

Hi

I just edited the post as the not equal to was not appearing in the post.In check use the less than ,greater than symbols against each other as NOT EQUAL TO .This will work.

You might have viewed my post before i edited.

Thank you.

venkat

[Former Member · Accepted solution]

Hi Venkat

I think i am doing mistake in writing the logic and symbols.

how to mention not equal to symbol..

please let me know.

thank you

best regards

Madhavi

[Former Member · Accepted solution]

Hi

for "NOT EQUAL TO" use the symbol just next to "="

which will look like as "less than and greater than" symbols against each other.

thanks

venkat

[Former Member · Accepted solution]

Hi venkat..

Thanks alot for your promt and qucik responses..

May i know ur mail ID.,

Best Regards

Madhavi

[Former Member · Accepted solution]

you check my user profile.

[Former Member]

Hi,

I need to find a way to prevent users from entering duplicate invoice numbers on transaction FB65.

Is this possible via validation rules?

Annelize

[Former Member]

Hi

you can activate "Chk double inv" in the vendor master->payment trn tab page.

When the reference number and amount is same, the system will give you a warning message to check the duplicate which can be overrided by the user. You can change the message control from warning to error so that the user can not override.

If you find this suitable, then pls use mass changes to activate the double inv check for all vendors.

[Former Member]

Follow Ravi Logic,

Active this Validation to your company code in T.Code: OB28.

Regards,

Viswa

[ravichandran_iyer]

Hi Madhavi,

You need to change your condition as follows :

Prerequisite: tcode = FB50 OR Tcode = FB60

Check: document type = Z2 OR Document type = Z3

message: error.

If you use AND in your condition, then the document has to satisfy both parameters i.e. the TCode should be both FB50 & FB60 and same is the case with Doc. Type also.

Ravi.

[Former Member]

Hi

Thanks for your quick response.

I have tried the validation which was explained by you.

Still it was not working.

Best Regards

Madhavi