Clean up the TaxDocumentJSON table
Supported versions
- Version 10.0.13 and later support compressing old data from versions that are earlier than 10.0.9.
- Version 10.0.14 and later support removing data.
Purpose
As the system runs, more and more data is produced, and the database size continues to increase. To free up space in the database, you can clean up old data. During cleanup, if you observe that the TaxDocumentJSON table is using too much space, you can follow the steps in this article to clean it up.
Before you begin
Before you begin the cleanup, complete the following tasks:
- Contact the customer's technical consultant or administrator, and confirm that no customization depends on the tax document object of the posted transaction.
- Ask the customer to work with its business department to determine a date that all transactions have been closed before.
- Export and back up the data of the TaxDocumentJSON table.
Clean up the database
By default, the Cleanup options wouldn't be available because it's a one-time task to compress old data from versions that are earlier than 10.0.9. If you want to use the Remove option, contact Microsoft to enable, TaxRemoveDependenciesOnTaxDocumentJSONFlighting.
Go to Tax > Periodic tasks > Tax document JSON cleanup.
Select the Remove option.
Note
The Compress option is used to compress the tax document JavaScript Object Notation (JSON) from versions that are earlier than 10.0.9. This compression is a one-time optimization.
The following note appears. Be sure to verify that the customer understands the impact of the change.
NOTE: By choosing the remove option, the tax document JSON will be cleared out. Before continuing, please:
1. Confirm with technical consultant or administrator that no customization depends on tax document object.
2. Specify conditions in 'Records to include' tab. It's recommended to only remove the data prior to current fiscal year.On the Records to include FastTab, specify the conditions that you confirmed with the customer's business department. For example, you've agreed to remove the tax document JSON before March 31, 2018. In this case, in the Tax document extension information for India section, in the Transaction date field, specify .."31/3/2018". For more details about the query filter, see Advanced filtering and query syntax.
Select OK to start the cleanup.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기