Skip to Content
0

'Calculate Tax' Check box mandatory tick

May 02 at 11:03 AM

62

avatar image

I want the 'calculate tax' check box ticked by default mandatorily.

I entered a parameter value with XTX = X;but stil, while we are posting the bank statement, it is not ticked in the bank charges item. If the user forgets to check this manually, the tax will not be calculated. Hence we want this tick automatically checked.

Please guide.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sanil Bhandari May 03 at 04:05 AM
0

Hi nikki saju


Some of the questions first:

1. Does your bank statement file contains a single line for bank charges and tax? Eg, $ 10 is the amount of Bank Charges and $ 1 is the tax amount, does it appear as a single item in the bank file. If not, is tax shown as a seperate line item in the bank file

Depending on the reply, there could potentially be two approaches:

(A) If your bank is giving a single line in the bank statement file for $11, I would suggest to allow posting through EBS for $11 into bank charges account and than post a journal entry to transfer the tax amount to tax credit account. Since you are processing your bank statement in background mode, the above parameter id would not work.

(B) If you have a seperate line item for tax amount of $1, I would suggest to see if there is an unique external transaction type. If yes, you may create a new posting rule and have it posted directly to tax credit account. If that is not the case, you may check your bank file to see if you can set up a search string in EBS Configuration to post the tax amount to tax credit account depending on notes to payee information in the bank file.

Thanks & Regards

Sanil Bhandari

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi

The bank sends us only single line item which is equal to (bank commission + VAT amount).

So the tax should be calculated on 'gross basis'. But all our other transactions are 'net basis'.

on 'net basis', tax will not be calculated and the entry will be posted from the statements as 'bank commission' Dr. & Main bank Cr. Amount 11 without any tax split.

Hence, what I did is as follows:

* I created a validation for 'calculate tax' mandatory for the user with error check for the bank commission GL account.

* Unticked the user FB00 screen the 'net tax base'

Now the tax is calculated with gross basis on the bank commission items.

The above is OK as long as the user does not post any other normal invoices where tax to be calculated on net basis !!

Thanks for the inputs.

0

Hi

Thanks for the update. One question, will this not have impact on the amount of VAT Input credit available for you, however, miniscule. You should still transfer the amount of VAT to input credit GL as I pointed out already in my reply, so that your tax reports are correct. I also assume that the user who is processing EBS would not post invoices most of the times, so your issue should be resolved.

Regards

Sanil Bhandari

0
Gustavo Vazquez May 02 at 04:02 PM
0

Hi nikki,

Does it work with FB60 or FB01 ? What trx does not get the value ?

Kind Regards

Show 3 Share
10 |10000 characters needed characters left characters exceeded

thanks.

I did not check with other screens. I have this issue in manual bank statement upload.

0

Check if works on these trx, the flag might not work on all of them

You can use exit FEB00001 and make that checkbox marked (Electronic bank Statement) or create an exit in trx OBBH

Kind Regards

1

Thanks Gustavo

Very good inputs.

0