Get all active Sales Taxes

Hi,

I am trying to get all active Tax Codes and iit's taxes using .NET SDK.

From tTaxAuth table, I can get all Taxes ,from tTaxCode I am able to get all taxcodes and from tTxCdDtl table I am able to get Tax rate for each Taxcode's tax.

I have removed on Tax from Taxcode listing but still I can see into tTxCdDtl table using SDK and I didn't found any specific status which say its deleted or inactive.

May I know, how I can identify particular tax has been deleted from Taxcode?

Thanks for your help.

Parents
  • I cannot respond directly to your query about identifying tax codes that have been deleted but I can suggest that this practice would not be recorded as the users do not delete tax codes. The only safe way to delete a tax code would be if all of the historical lookup data is also deleted. Once a code is deleted if it is used in an historical entry then the entry would show incorrectly and all historical reports would be incorrect as well. Deleting data and codes from the Sage 50 files is not a very wise move from the users point of view.

Reply
  • I cannot respond directly to your query about identifying tax codes that have been deleted but I can suggest that this practice would not be recorded as the users do not delete tax codes. The only safe way to delete a tax code would be if all of the historical lookup data is also deleted. Once a code is deleted if it is used in an historical entry then the entry would show incorrectly and all historical reports would be incorrect as well. Deleting data and codes from the Sage 50 files is not a very wise move from the users point of view.

Children
No Data