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

[Former Member]

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

[fbio_bilicki]

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

[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

[Former Member]

Hi SAP B1 User,

You could get around this?

Thanks

Marcos

[Former Member]

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

[frank_wang6]

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

[Former Member]

Hi Irfan,

9.1 Patch Level 5

Thanks

[former_member183582]

Hi what version of B1 You used?

Irfan