FBCJ Validation for Rs20,000/- payment

[Former Member]

Dear All,

I have created accounting validation to restricts payment transactions in FBCJ to limit Rs.20,000/-

I have created like below, but it is not working.

Prerequisite :-

BSEG-BUKRS = '1020' AND SYST-TCODE = 'FBCJ' AND

BKPF-BLART = 'BR' AND

BSEG-HKONT = '606901'

Check :-

BSEG-WRBTR <= '20000.00'

Message:- Error

Can anybody advise how it can be done.

Regards,

Alok Parida

[Former Member · Accepted solution]

Hi Alok,

Try this,

Pre-requisites:

SYST-TCODE = 'FBCJ' AND ( BKPF-BUKRS = '1020' AND BSEG-HKONT = '606901' )

Check:

BSEG-WRBTR <= '20000.00'

Message:

Error: Amounts exceeds 20000

Regards,

Balaji

[Former Member · Accepted solution]

Dear Mr Balaji,

Thanx It is working fine for blocking payment of rs20000 and more.

But it is also blocking cash withdrawn from bank for 20000 or more. We want for receipts there should not be any blocking

Regards,

Alok

[Former Member · Accepted solution]

Dear Alok,

Can you please tell me the GLs and Business transactions which are used for both payments and receipts?

Regards,

Balaji

[Former Member · Accepted solution]

Hi Alok,

You are correct.. This Validation need to be written only for Cash Payments and not for cash receipts..

So, as of now, you already have a validation in place which is working for both payments and receipts.. just add this condition to your validation and it will check only for payments and not receipts..

BSEG-SHKZG = 'H'

Try and let us know if it works..

BR,

kavita

[Former Member · Accepted solution]

Hii Kavita,

I have written the validation like below an it is working fine:-

Prerequisite :-

( G/L = '300001' ) AND ( Debit/Credit = 'H' )

Check:-

Amount <= '19999.00'

Message:-

Cash Payment Should not be more than Rs.19,999/-

The above is working fine:-

I want to add Vendor payment block for Vendor range 0001 to 9999 for Rs,19999/- for a particualr posting date.

The above is control if any body making split cash payment above Rs19999/- for a day.

please advise.

Regards,

Alok

[Former Member · Accepted solution]

Hi

pleas follow the steps given below in the validation

PREREQUISITE

( BSEG-HKONT = '242172' ) AND BKPF-BUKRS = '1000' AND

BSEG-BSCHL = '50'

CHECK :

BSEG-WRBTR <= '20000'

Give error message which you want to give.

e.g Check whether you have entered more than Rs 20000 in Cash

In HKONT give cash account GL account.

Please try above. Hope it will resolve your query.

Thanks & Regards

Mahesh

[venkateswaran_k]

Dear Alok,

Based on your latest update on validation,  it is better you approach the ABAP team to put the validation on Exits..

As you asked for

1. If any split payements on a day  that cross 20000.

Apart from the validation you already spcified.

Regards,

Venkat

[venkateswaran_k]

Hi Alok,

1. Can you please show me the screen shot of ob28 where yu defined your validaltions..

2. Is your request is transported.

Regards,

Venkat

[Former Member]

Dear Venkat,

prequisite:-

SYST-TCODE = 'FBCJ' AND BKPF-BUKRS = '1020'

check:-

BSEG-WRBTR <='20000.00'

Message:-

Error

[venkateswaran_k]

Okay, if you want to restrict only for Vendor paymet, you have to include another conditon BKPF-BLART = 'KZ'  along with SYST-TCODE = 'FBCJ' AND BKPF-BUKRS = '1020'

[Former Member]

Dear Venkat,

the document type is same both for payment and receipt transaction.

Regards,

Alok

[venkateswaran_k]

Same document type?.....

Hmm.. ok .. try adding this condition as well..  BSEG-BSCHL = '25' 

that is... 25 means Outgong payment

[Former Member]

Dear Venkat,

in FBCJ only 40 and 50 posting keys are used.

Regards,

[venkateswaran_k]

Okay.. use conditon BSEG-BSCHL = '50'  in additon to the existing conditons..

[Former Member]

Dear Venkat,

I have already tried with that,

not working.

Regards.

[suma_mani]

Hi Alok,

Validation Pre Requisites :-

( SYST-TCODE = 'FBCJ' )

Check

( BSEG-SHKZG = 'S' OR BSEG-SHKZG = 'H' ) AND (

BSEG-DMBTR <= '20000.00' )

Message :- Error

Try this and let me know ,if any issues.

[Former Member]

tHIS IS NOT WORKING

[suma_mani]

Hi Alok,

It is working fine in my system. Check again

Regards

Mani Kumar

[Former Member]

Dear Manikumar.

I have written the validation like below:-

Prerequisite :-

( G/L = '300001' ) AND ( Debit/Credit = 'H' )

Check:-

Amount <= '19999.00'

Message:-

Cash Payment Should not be more than Rs.19,999/-

The above is working fine:-

I want to add Vendor payment block for Vendor range 0001 to 9999 for Rs,19999/- for a particualr posting date.

The above is control if any body making split cash payment above Rs19999/- for a day.

please advise.

Regards,

Alok

[venkateswaran_k]

Hi

Your amount check should be

Check :-

BSEG-WRBTR > '20000.00'      (should be greater than symbol )... 

and NOT 

Check :-

BSEG-WRBTR <= '20000.00'

[Former Member]

nOT YET WORKING

[yogesh_kshatriya2]

Hi Alok,

remove the BKPF-BLART condition and check.

Regards,

-Yogesh

[Former Member]

Hi Alok,

Please extend the Validation as below:

Pre-requisite:

SYST-TCODE = 'FBCJ' AND ( BKPF-BKTXT = 'OFFICE EXPENSES')

Check:

BSEG-DMBTR <= '20000.00'

Message:

E - Amount exceeds Rs 20000.

Regards,

Jaymin R. Bhatt