Electronic signature control
Use this function to review electronic signatures for sales invoices and journal entries. This applies to French and Portuguese legislation. This signature is generated when the journal entry status is final. One signature is generated for each line.
When you run this function, the process analyzes and compares the data between the Electronic signatures table (DKSDATAFRA) and the Sales invoice table (SINVOICE) and the Account entries table (GACCENTRY).
The process also compares data in the DKSDATAFRA table and the current electronic signature to identify inconsistencies.
For example, this analysis can provide details such as which data records in the DKSDATAFRA were changed.
Electronic signatures for sales invoices and journal entries
In compliance with French and Portuguese 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” or the "SVAT certification for Portuguese legislation guide" on the 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 DKSDATAFRA table and therefore no electronic signature is created.
Legislations other than French or Portuguese do not need to generate electronic signatures.
The electronic signature is a record in the Electronic signatures table (DKSDATAFRA) 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<>"", |
Screen management
Entry screen
| Company (field CPY) |
|
Enter the company for the analysis. The company must be linked to French or Portuguese 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. |
| BP (field BPRNUM) |
|
Enter a BP to limit the analysis to a single BP. This field is only available if the All BPs check box not selected. |