Intercompany journal creation
Use this function to generate journals in each company used in he Intercompany journal entry. You can automatically generate one or several journal transactions according to the selection criteria.
In this function, you should:
- Run the generation in provisional mode so as to identify the intercompany journals that can be generated.
- Generate a log file indicating the intercompany journals that were created and the intercompany journal recording used.
- Create or recall a memo.
- Check if the accounting period date is open for the source company and all target companies.
This function is available only if the INTCO - Intercompany transactions activity code is active.
Although the Partner and Flow fields are not part of the Intercompany journal entry function (GESGIC), the partner and flow are initialized when posting to the Intercompany journal.
Refer to the documentation on Partner initialization and Flow initialization.
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
Criteria
| All companies (field ALLCPY) |