Use this function to mass post customer invoices that have already been entered in Customer Invoicing, provided they have not been posted individually when entered. Invoices sent via the Sales Management module have already been posted in this module.

French 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<>"",
[F:DAE]DES)+string$([F:DAE]DES="","NA")

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Use this screen to select the invoices to be posted.
The selection options include:

  • The company, the site
  • The user
  • The entry types
  • A date range
  • A number range

Indicate if you wish to generate a log file detailing the list of posted invoices.

Criteria

All companies (field ALLCPY)

No help linked to this field.

Company (field CPY)
Legislation (field LEG)
All sites (field ALLFCY)

No help linked to this field.

Site (field FCY)
All users (field ALLUSR)
User (field USR)
All types (field ALLTYP)
Invoice type (field SIVTYP)
Start date (field STRDAT)
End date (field ENDDAT)
From invoice (field VCRDEB)
To invoice (field VCRFIN)

Generation

Log file (field TRC)

No help linked to this field.

Batch task

This function can be run in batch mode. The standard task BPCINV is provided for that purpose.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

The posted documents will have the 'Final' status for the company

If the processing is launched for a given company and this company has selected the French compliance rules (the parameter FRADGI - French fiscal regulation - LOC chapter, CPT group - is set to Yes), then the documents generated by the processing will have the status Final.

The posted documents will have the 'Final' status for one or more companies

The processing is launched for all companies or group of companies and if at least one of the companies chose French compliance rules (i.e. parameter FRADGI - French fiscal regulation - LOC chapter, FRA group set to Yes), the documents generated by the processing will have the status Final.

Tables used

SEEREFERTTO Refer to documentation Implementation