Analyse Data Integrity: Difference between revisions

From eStream Software
 
(8 intermediate revisions by the same user not shown)
Line 13: 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 31: Line 31:
:: * Regenerate Views
:: * Regenerate Views
:: * Remove Temporary Table<br />
:: * Remove Temporary Table<br />
: b. Reposting
: b. Reposting (Optional)
:: * Repost AR Documents
:: * Repost AR Documents
:: * Repost AP Documents
:: * Repost AP Documents
Line 37: 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]]
Line 46: Line 50:
:2. Click on '''Start Analyse'''.
:2. Click on '''Start Analyse'''.
::[[File:Tools-Analyse Data Integrity-02.jpg]]
::[[File:Tools-Analyse Data Integrity-02.jpg]]
<br />
:3. Prompt the message to inform you the total tasks ticked has analyse completed.
:3. Prompt the message to inform you the total tasks ticked has analyse completed.
::[[File:Tools-Analyse Data Integrity-03.jpg]]
::[[File:Tools-Analyse Data Integrity-03.jpg]]
<br />
:4. You can copy the analyse log detail by click on '''Copy to Clipboard'''.  
:4. You can copy the analyse log detail by click on '''Copy to Clipboard'''.  
::[[File:Tools-Analyse Data Integrity-04.jpg]]
::[[File:Tools-Analyse Data Integrity-04.jpg]]
<br />
:5. Open notepad or Microsoft Words. Paste it.  
:5. Open notepad or Microsoft Words. Paste it.  
::[[File:Tools-Analyse Data Integrity-05.jpg]]
::[[File:Tools-Analyse Data Integrity-05.jpg | 640px]]
<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:
  1. malfunction/glitch from hardware such as network switch, computer, server, etc.
  2. Network stability, such as wireless lost connection.
  3. Power failure
  4. 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.
Tools-Analyse Data Integrity-01.jpg


To Start Analyse

1. Tick the Analyse Items required to analyse, otherwise skip this step 1.
2. Click on Start Analyse.
Tools-Analyse Data Integrity-02.jpg


3. Prompt the message to inform you the total tasks ticked has analyse completed.
Tools-Analyse Data Integrity-03.jpg


4. You can copy the analyse log detail by click on Copy to Clipboard.
Tools-Analyse Data Integrity-04.jpg


5. Open notepad or Microsoft Words. Paste it.
Tools-Analyse Data Integrity-05.jpg