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

"Invalid Data [Tax Code Determination - Tax Code][line: 66] [Message 80401-9]"

Hi Experts,

we have added 1000+ successfully but when ever adding new item group in tax code Key Field Values are updated successfully but when ever

we are updating "TAX Code Determination -Set up" attach screen short error is occurred.

Please do the need full

Thanks in advance

Error001.png (83.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Dec 20, 2015 at 11:26 AM

    Hi what version of B1 You used?

    Irfan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2015 at 11:47 AM

    Hi Irfan,

    9.1 Patch Level 5

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2015 at 05:06 PM

    When you add tax code, i think u forget to specify the valid date range, open tax code, and check if the valid data range covers all the time.

    Frank

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2015 at 05:40 PM

    Hi Frank,

    All the data is correct 1000 + tax codes added its working fine in all the marketing documents .now we are getting problem.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2016 at 12:04 PM

    Hi SAP B1 User,

    You could get around this?

    Thanks

    Marcos

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2016 at 04:09 PM

    Hi,

    I have the same problem after update SAP 9.0 PL15 to SAP 9.1 PL11, but in my case is because the tax code 5933-001 is inactive , need to enable code to be able to update.

    See the image in my post .


    But do not want to enable the tax code , I want to make inactive.

    Rgs

    Fabio

    SAP 9.1 PL11

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Fabio,

      To solve, it was necessary to check all the links between TCD1 tables, TCD2, TCD3, CD4, and TCD5 OUSG.

      In a PL, excluding an Usage was possible and was corrected at some later PL.

      In the DB Teste I discovered this "unlink" and delete directly into the DB and solved. However, on the DB Productive I did not, as this command is not allowed. Then I opened a ticket to SAP Support and they made the necessary checks and sent to Query (much like mine) to be performed on the DB Test before and then the DB production.

      Just to remember is not allowed DELETE, INSERT or UPDATE directly on the DB, only with guidance from the SAP Support.

      I hope you help.

      ------------------------------------------------------------------------------------------------------------------------------------------------


      Oi Fabio,

      Para resolver, foi necessário verificar todos os vínculos entre as tabelas TCD1, TCD2, TCD3, TCD4, TCD5 e OUSG.

      Em uma PL, a exclusão de uma Utilização era possível e foi corrigida em alguma PL posterior.

      Na base de teste eu descobri esse "desvínculo" e excluí diretamente na base e resolveu. Porém, na base de produção eu não fiz, visto que tal comando não é permitido. Então eu abri um chamado na SAP e eles fizeram as devidas verificações e enviaram a Query (bem semelhante a minha) a ser executada na base de Testes antes e então na base de Produção.

      Só para lembrar não é permitido DELETE, UPDATE ou INSERT direto na base, apenas com orientação por parte do SAP Support.

      Espero poder ter ajudado.

      Best Regards

      Marcos Taira

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.