Usage  >  Audit >  Electronic signature control  

Display all Hide all

Use this function to review the French electronic signatures for sales invoices and journal entries.

When you run this function, the process analyzes and compares the data between the Electronic signatures table (DKSDATFRA) and the Sales invoice table (SINVOICE) and the Account entries table (GACCENTRY).

The process also compares data in the DKSDATFRA table and the current electronic signature to identify inconsistencies.

For example, this analysis can provide details such as which data records in the DKSDATFRA were changed.

French electronic signatures for sales invoices and journal entries

In compliance with French antifraud legal requirements and to ensure data security, electronic signatures are automatically generated when a customer invoice or journal entry is posted or set to Final, respectively. After the electronic signature is generated, further modifications to any of the fields identified below can be easily detected.

You can use the Electronic signature control function (FRADSICTL) to review the current electronic signature and highlight any inconsistencies.

See the “French electronic signature how to guide” on the How-to tab for details on implementing this feature. This document is intended for administrators and consultants who maintain and update Sage X3.

Exceptions

Data from invoices or journal entries posted before activating the electronic signature feature is not added to the DKSDATFRA table and therefore no electronic signature is created.

Legislations other than French do not generate electronic signatures.

The electronic signature is a record in the Electronic signatures table (DKSDATFRA) that includes data from the following fields in the Sales invoice (SINVOICE) and Account entries (GACCENTRY) tables:

Field code

Description

Data source: SINVOICE

Data source: GACCENTRY

ORIDOC

Origin of the document

1

2

DOCTYP

Journal

SINVOICE.SIVTYP

GACCENTRY.TYP

DOCNUM

Journal description

SINVOICE.NUM

GACCENTRY.NUM

TOTTAX(9)

Total by tax rate

SIH.AMTTAX(i) + SIH.BASTAX(i)

 

AMTATI

Invoice amount with VAT

SIH.AMTATI

 

DATTIM

Date and time of the signature

Datetime$

 

INVSNS

Document type

Evaluate SIH.SNS

 

CPYNAM

Company name

CPY.CPYNAM

 

POSCOD

Company postal code

BPA.POSCOD

 

CPYEECNUM

Company VAT number

CPY.EECNUM

 

BPRNAM

Customer name

SIH.BPRNAM(0)

BPARTNER.BPRNAM

BPREECNUM

Customer postal code

SIH.POSCOD

 

JOU

Journal code

 

GACCENTRY.JOU

DESTRA

Journal description

 

GACCENTRY.DESTRA

FNLPSTNUM

Final number

 

GACCENTRY.FNLPSTNUM

ACCDAT

accounting date

SINVOICE.ACCDAT

GACCENTRY.ACCDAT

ACC

Account code

 

GACCENTRYD.ACC

BPR

BP

SINVOICE.BPR

GACCENTRYD.BPR

LIN

Journal entry line

 

GACCENTRYD.LIN

LINDES

Line description

 

string$([F:DAE]DES<>"",
[F:DAE]DES)+string$([F:DAE]DES="","NA")

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Fields

The following fields are present on this tab :

Enter the company for the analysis. The company must be linked to French legislation.
  • Start date (field STRDAT)

Enter start and end dates to limit the analysis to posted sales invoices and posted journal entries within that time range.
  • End date (field ENDDAT)

Enter start and end dates to limit the analysis to posted sales invoices and posted journal entries within that time range.
  • All types (field ALLTYP)

Select this check box to include all document types in the analysis.
  • Document type (field DOCTYP)

Enter a document type to limit the analysis to this document type only.

This field is only available if the All types check box is not selected.
  • All BPs (field ALLBP)

Select this check box to include all BPs in the analysis.

Enter a BP to limit the analysis to a single BP.

This field is only available if the All BPs check box not selected.

Close

 

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation