Data integrity

You can check the integrity of various aspects of the system:

  • Financial statements
  • The integrity of financial statements depends on your reconciling sales and purchase ledgers with the nominal on a regular basis.

  • Balance on your accounts
  • The Balance Ledgers option checks the balance on each account agrees with the total transactions applied to each account, and also that the total values on all accounts agree with the total central value stored for each ledger. It also verifies transactional information to ensure that correct transaction types are held and that there are no invalid period numbers or VAT numbers.

    You should use Balance Ledgers immediately, following power or hardware failures.

    It is also good practice to run this routine on a regular basis to prevent any problems being left undetected for any length of time. If problems are not discovered, your daily processing and backups will be affected.

    Ledger Summaries provides you with the overall status of the system in terms of number of accounts per ledger, ledger balance and the period you are currently working in.

  • Setup of stock items and associated units of measure
  • You can also run the Validate Units of Measure report to check that there are no problems with the setup of stock items and their associated units of measure, and identify live SOP and POP lines that contain stock items that may not be set up in the recommended way.

If you are using online payments and your system crashes whilst a receipt is returning from your online payment service provider, you can be left with orphaned card transactions. In this case, use the Complete orphaned card transactions option to resolve this.

Note:

You can also use the following as a last resort to solve balance problems on accounts, if there is no backup available. However, the usual use for these is to delete test data from the system, before going live.

  • Delete sales and purchase transactions.
  • Delete nominal transactions and waiting postings.