Analyse Data Integrity: Difference between revisions

From eStream Software
Line 30: Line 30:
:: * Resequence Table Fields
:: * Resequence Table Fields
:: * Regenerate Views
:: * Regenerate Views
:: * Remove Temporary Table
:: * Remove Temporary Table<br />
<br />
: b. Reposting
: b. Reposting
:: * Repost AR Documents
:: * Repost AR Documents

Revision as of 01:51, 19 January 2016

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
* 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
* Repost AR Documents
* Repost AP Documents
* Repost GL Documents
* Repost PH Documents
* Repost SL Documents
Tools-Analyse Data Integrity-01.jpg