EBS Search string issue with involving tax code and posting

[Former Member]

Hello Everyone,

I need some help with respect to below issue being faced.

I have setup a search string in EBS to automatically post bank transaction item with tax code uploaded and automatic tax calculated and posted.

While trying to do so the tax code gets updated in both debit/credit item although it is required only for the debit item.

I have although made settings as shown below so that tax code should only be updated for first line item only but not getting desired output.

Any assistance would be appreciated.

[Former Member]

Hi,

Found the solution.

I had to control transfer of tax code from first line item to second line item by selecting option "Do not copy tax code" in "Account Editing Options" (Tcode:FB00)

Thankyou to those who spent time to assist.

[jayj07]

Hi Ankit,

You may want to check this document.

Define Search String for Electronic Bank Statement - Bank Accounting - SAP Library

"If you want to transfer the content of only one particular line, you can use the "BDC Account Type" field to control the process. If you enter the constants 0, 1, 2, or 3 in this field, the transfer only takes place as specified."

Hope this helps.

Jayj

[Former Member]

Hi Jayj,

I had already maintained the configuration based on the link provided but it is somehow not working for me.

@Mukthar : I cannot default the tax code as the account may use other tax codes as well.

--

Regards,

Ankit

[former_member198650]

Hi Ankit,

Instead of defining in search string, you can default the tax code in the GL. When you post the transaction, it will automatically calculate tax and post it.

Regards,

Mukthar

[former_member695108]

Good Day, I am sitting with the same situation and I have updated the GL account and the tax is not calculated