(11 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
==Introduction== | ==Introduction== | ||
: To analyse the data integrity check. | : To analyse the data integrity check. It is recommended to perform this action weekly or monthly (before month end closing). | ||
: Reason to run this may due to the following unpredictable matters: | |||
:# malfunction/glitch from hardware such as network switch, computer, server, etc. | |||
:# Network stability, such as wireless lost connection. | |||
:# Power failure | |||
:# Operating System failure | |||
<br /> | <br /> | ||
Line 8: | Line 13: | ||
==Analyse Data Integrity== | ==Analyse Data Integrity== | ||
:There are 3 parts of analyse data integrity. | :There are 3 parts of analyse data integrity. | ||
: a. Regular Data Integrity | : a. Regular Data Integrity (Default) | ||
:: * Check AP Knock Off Integrity | :: * Check AP Knock Off Integrity | ||
:: * Check AR Knock Off Integrity | :: * Check AR Knock Off Integrity | ||
Line 25: | Line 30: | ||
:: * Resequence Table Fields | :: * Resequence Table Fields | ||
:: * Regenerate Views | :: * Regenerate Views | ||
:: * Remove Temporary Table | :: * Remove Temporary Table<br /> | ||
<br /> | : b. Reposting (Optional) | ||
: b. Reposting | |||
:: * Repost AR Documents | :: * Repost AR Documents | ||
:: * Repost AP Documents | :: * Repost AP Documents | ||
Line 33: | Line 37: | ||
:: * Repost PH Documents | :: * Repost PH Documents | ||
:: * Repost SL Documents | :: * Repost SL Documents | ||
NOTE: | |||
1. Reposting might took longer time to perform repost for the documents selected. | |||
2. Recommended to run at the server side. | |||
::[[File:Tools-Analyse Data Integrity-01.jpg]] | ::[[File:Tools-Analyse Data Integrity-01.jpg]] | ||
<br /> | |||
==To Start Analyse== | |||
:1. Tick the '''Analyse Items''' required to analyse, otherwise skip this step 1. | |||
:2. Click on '''Start Analyse'''. | |||
::[[File:Tools-Analyse Data Integrity-02.jpg]] | |||
<br /> | |||
:3. Prompt the message to inform you the total tasks ticked has analyse completed. | |||
::[[File:Tools-Analyse Data Integrity-03.jpg]] | |||
<br /> | |||
:4. You can copy the analyse log detail by click on '''Copy to Clipboard'''. | |||
::[[File:Tools-Analyse Data Integrity-04.jpg]] | |||
<br /> | |||
:5. Open notepad or Microsoft Words. Paste it. | |||
::[[File:Tools-Analyse Data Integrity-05.jpg | 640px]] | |||
<br /> | <br /> |
Latest revision as of 07:24, 14 October 2019
Menu: Tools | Analyse Data Integrity...
Introduction
- To analyse the data integrity check. It is recommended to perform this action weekly or monthly (before month end closing).
- Reason to run this may due to the following unpredictable matters:
- malfunction/glitch from hardware such as network switch, computer, server, etc.
- Network stability, such as wireless lost connection.
- Power failure
- Operating System failure
Analyse Data Integrity
- There are 3 parts of analyse data integrity.
- a. Regular Data Integrity (Default)
- * Check AP Knock Off Integrity
- * Check AR Knock Off Integrity
- * Update Customer Outstanding
- * Check Document Integrity
- * Check Document Transfer Integrity
- * Check Delivery Order/Invoice/Cash Sales to Credit Note Posting Date
- * Check Production Document Transfer Integrity
- * Check GL Opening Balance
- * Check GST DO -> IV Posting Integrity
- * Repost Stock Transactions
- * Calculate Stock Costing
- * Compress Stock Item Pictures
- * Update Stock Balance Quantity
- * Update Supplier Outstanding
- * Resequence Table Fields
- * Regenerate Views
- * Remove Temporary Table
- b. Reposting (Optional)
- * Repost AR Documents
- * Repost AP Documents
- * Repost GL Documents
- * Repost PH Documents
- * Repost SL Documents
NOTE: 1. Reposting might took longer time to perform repost for the documents selected. 2. Recommended to run at the server side.
To Start Analyse
- 1. Tick the Analyse Items required to analyse, otherwise skip this step 1.
- 2. Click on Start Analyse.