Detailed Tax Entry already exists

Sumathi2107

Hi all,

I have got an error while posting Sales Invoice with tax in Nav 2009. The error message is "Detailed Tax entry already exists".

Could you please help to solve this error?

Thanks & Regards,
Sumathi

ara3n

If you haven't done any modifications, I suggest to contact your solution center who will need to open a support request with MS.
This looks like a :bug:

ashbhardwaj

Hi
Please try to do posting after activating Tools->Debugger->Active.
so u will have some idea from where u r getting error.....is there any customization in this functionality. :oops:

Thanks
Ashish

lally

Hi,

i am also getting the same error , please throw some valuable information to solve this.


Thanks and regards

Umakaranam

Hi,
I am also getting the same error.
i have posted the purchase invoice with out giving the structure.so i posted the JV for Tax against the same purchase invoice.
then onwards i have got an error while posting purchase Invoice with tax(vat) in Nav 2009 SQL Database . The error message is "Detailed Tax entry already exists".
i deleted the JV entry from deatiled Tax entry .after that we found that there is no check mark given at creditable goods in Tax detail Setup for Taxtype VAT .corrected the Setup for tax detail

for tax type VAT --Creditable goods=yes & for CST Creditable goods=No.

then i haven't got the error while posting the Purchase invoice with Vat. But got the same error while posting the Purchase Invoice with CST.


system is allowing to post the Purchase invoice with CST with the same posting date.if i change the posting date again same error.
Detailed tax entry table already having two entries for CST purchase with posting date 26/04/09 .system is allowing to post the invoice with the same date.

please throw some valuable information to solve this.

Regards,
Uma.

vsalot

Do the Below Activity - Only using Client Licence.
There is no bug in NAV 2009 related to Code.

Export all the data using Dataport.

Delete all the data from Detailed Tax Entry Table.

Import all the data again using the same dataport.

While importing you will get the Error of Entry no. does not exists. Delete that line & Import the rest of the data. You will not be able to enter those data again. This is because somebody has modified the data using Developer LIcence.

Enjoy.

Umakaranam

Hi,
thanks for your suggestion.
we followed the same steps.
By using the client license we exported the Detailed tax entry Table Data and then deleted the data from same table using report.
then we try to import the data we got error saying that Entry No 20 does not exist.so we deleted that line from csv file (detailed tax entry data) and again we imported the data.
all the data copied to detailed tax entry.
But still we are getting same error "Detailed tax entry already exist while posting the purchase invoice with Tax.

](*,) .

Regards,
Uma.

ssingla

I started looking at the issue only yesterday and have found that while the posting happens accurately in Native Db, error pops up in SQL database. Further the transaction gets posted if there is no entry in detailed tax entry table.

Seems like a :bug:

Umakaranam

Hi all,
thanks for your response.
someone suggetsed that
This is because in Table "Detailed Tax Entry" there is a key defined which has 19 fileds into it and SQL server supports maximum 16 fileld in one key.

Current Key is :

(Transaction Type,Tax %,Positive,Location Code,Works Contract,Exempted Sale,Product Type,Form Code,Tax Type,Export or Deemed Export,State Code,Entry Type,Adjustment Type,Type,Input Credit/Output Tax Amount,Adjusted by Entry No.,Posting Date,Document Type,Deferment No.)

There is a patch for it from Microsoft ...have a look at partner source.

i tried for that patch but i could not get that. Can any one tell whr i can get that in partner source. we are using Navision 2009. SQL Database.


Regards,

Uma.

manjusree

Hi,

Please let me know if anyone knows the reason and solution for this error..

Thanks,
Manju

mohana_cse06

You can check this link
http://mibuso.com/forum/viewtopic.php?f=23&t=33224

manjusree

Thank you so much

Regards,
Manju