Data audit

A1 proofreading not yet effective for this page. In the meantime, you can ask any questions on the forum.

This screen allows a certain number of control operations on Gestan data.

Access: Tools → Administration → Maintenance → Data audit (all options),
or Accounting → Controls → Data audit (accounting options only).

For all coins, the program checks that, if the coin has a non-zero total, there is at least one coin line.

The program, for the entire list of documents marked as “settled”, verifies that the sum of the entries attached to the document is indeed equal to the amount of the document.

For credit notes whose amounts have been deducted from an invoice, in this case, the entry being linked to the invoice and not to the credit note, it is not possible to control (easily) that the credit has been refunded in full. This is a case of a “normal” anomaly.

The program controls:

• the consistency of entries between amounts excluding tax/tax and VAT,
• the presence or absence of a check number depending on the payment method,
• the coherence of possibly linked parts
• correct ventilation of rooms

When this option is chosen, the context menu of the table allows you to choose the Delete incorrect breakdowns option. If this option is checked, during the check, all sub-entry posting breakdowns are deleted if they are incorrect (if the total excluding tax of the breakdowns is different from the excluding tax of the entry, or if the total including tax of the breakdowns is different from the tax included in the writing).

The program checks that for each part line, the master part is present.

The program flags products with negative current stock

The program checks each invoice number is N+1 compared to the previous number, and reports any “holes”.

The program checks the presence of all physical files possibly linked to a Document record.

The program displays all different products that have an identical EAN13 code (this can be problematic if you capture your products with a laser scanner).

The program checks the existence of product codes in all parts, as well as the correct connection to the family of the product sheet.

The program checks that the product family code is identical in the product catalog and in all the parts that reference these products.

The BB files are those which record any modification to certain sensitive Gestan files, here the accounting entries file, since 01/01/2018 (NF552 standard).

The program checks that the entry creation record is present, and that the timestamp of the creation and modification records are consistent with that of the entries.

The BB files are those which record any modification to certain sensitive Gestan files, here the files of quotes, orders, invoices, credit notes, delivery notes, since 01/01/2018 (NF552 standard).

The program checks that the creation record is present, and that the timestamp of the creation and modification records are consistent with that of the corresponding part.

The program checks that there is at least one component for each composite product (and none for each simple product), and that each component product is referenced in the catalog.

The program monitors the gap between the creation date and the possible modification date of all parts.

This program allows you to identify any part generated on one exercise and modified on another exercise.

This program verifies, in the case where stocks are managed, that the outgoing stock movements are consistent with what they should be, that is to say that there is no movement for products not managed in stock, and that for each product managed in stock, the sum of incoming or outgoing movements corresponds to the quantities indicated in the reference document.

Other “Admin” articles