Finalize journal entries
This function is used to perform a mass validation of a group of journals with a Temporary status. With a single operation, a group of journals can move from Temporary to Final status, and they can no longer be modified.
When an accounting journal is validated, all the ledgers containing this journal are impacted.
When Fixed assets are managed, the journal posting results in the Expenses automatic generation, provided that the required setup is implemented (see the Journal entry documentation for further information). The list of expenses then created is included in the log file generated at the end of the posting process.
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<>"", |
Screen management
Entry screen
This processing performs a "mass" validation of the accounting entries. Once they have been validated, it will no longer be possible to modify these journals.
The only data that can still be modified are the title fields (in the header or on the lines), the 1099 processing and payment approval management, the original journal, the reference, the reversal management and the analytical allocation.
This processing cannot be undone.
The journals are selected according to several criteria specific to the journal, and based on date ranges:
- Company,
- Site,
- Document type,
- Journal type,
- Journal,
- User.
The "Log file" flag can be selected to display a summary of all the generated journals at the end of the processing.
Criteria
All companies (field ALLCPY) |