Post

This process converts simulated documents to actual journals.

You can run this simulation to evaluate the impact of accounting or analytical entries on the respective accounts without posting to the journal.

The journal being simulated can be active or inactive. When active, it is added to inquiry screens and reports. It can be converted to an actual journal or deactivated to become an inactive simulation journal that is not visible in inquiries and reports. For example, simulating stock count entries such as provisions for risk.

Because the journal entry is recreated each time you run the operation, open items for the new actual journal entry are not necessarily the same as the ones of the journal entry when active. The standard internalization rules are then applied to create the new open items according to the PAYTERMVAL - Init payment conditions parameter (TC chapter, RSK group) setting.

There are several operations that directly affect the simulated journals:

Activiation changes the journal category from inactive to active simulation
Deactivation changes the journal category from active to inactive simulation
Cancellation cancels all simulated entries, whether active or inactive

You cannot close a period if simulated entries are not converted to actual entries or if they are not canceled.

When a simulated entry is processed, all the ledgers containing this entry are affected.

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 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")

Prerequisite

Refer to the documentation on Implementation.

Screen management

The entry status for entries needs to be Final when the requested generation type is Actual and the company meets one of the following criteria:

A French legislation company that has the FRADGI - French fiscal legislation parameter (TC chapter, CPT group) set to Yes and cannot be modified.
A foreign company applying the French DGI no. 13L-1-06 compliance rules and the FRADGI - French fiscal legislation parameter (TC chapter, CPT group) set to Yes and can be modified.

Entry screen

Select criteria make to restrict the selection of the simulated documents to be processed. Not all fields are required. By default, all documents are selected.

Date ranges are used to refine the selection. The creation date, specified on document entry, is considered.

Select Inactive simulations documents for validation only. If not selected, only the active simulation documents are validated and as a result become actual documents.

Field descriptions

Criteria

All companies (ALLCPY)

Select this checkbox to run the process for all companies. Otherwise, you need to select a company.

If you have companies in mulitple legislations, you can only run the process for one legislation at a time.

Company (CPY)

Enter or select the company code for a single company.

Legislation (LEG)

If you select All companies, you need to enter a legislation.

If you entered a single company, this field defaults to the legislation for that company.

All sites (ALLFCY)

Select this checkbox to include all sites for a selected company.

If you select All companies, this checkbox is selected by default.

Site (FCY)

Enter or select a site code.

All document types (ALLTYP)

Select this checkbox to include all types.

Entry type (TYP)

Enter a journal type to limit the simulation to this entry type.

Only document types whose Entry category is Simulation can be selected.

From entry (VCRDEB)

If you select a single journal type, you can enter a range of journal numbers to limit the process to documents within the range.

To entry (VCRFIN)

End journal number used to select the records to be processed.

All journal types (ALLTYPJOU)

Select this option to include all journal types.

Journal type (TYPJOU)

Enter the journal type. It must be the same type as the journal linked to the selected journal type.

The journal type is used to group journals based on common characteristics mainly linked to the nature of the operations where it will be recorded:

Sales
Purchasing
Cash
Miscellaneous operations
Analytical miscellaneous operations
Carry-forward entries

Some processes and controls depend on the journal type:

Carry-forward entries journal types can only record journals associated with the carry forward entries period.
Analytical miscellaneous operation journal types can only record journals assigned to the analytical category.
A cash account needs to be linked to each cash journal type so that the entries posted in this journal have an automatic counterpart. These journal types are used in the A/P-A/R accounting module for payment posting and in automatic journals.

Cash journals are defined in the Definition of the journals, journal types and accounts on payments.

Six journal types were allocated to the miscellaneous operations:

Values 4 and 5 for general accounting
Values 8, 9, and 10 for analytical accounting

All journals (ALLJOU)

Select this option to include all journal types.

Journal (JOU)

Enter the journal code.

The journal selected needs to be the same type as the journal linked to the journal type entered in the previous selection criteria.

All users (ALLUSR)

Select this checkbox to include all users. To run this process for a single user group, leave clear.

The current user is used if the user/group code is blank.

User (USR)

If you enter a user code, the process only includes accounting documents entered by that user. By default, the current user is applied.

Inactive simulations (SIM)

Select this option to include inactive simulated entries and to generate the journals in temporary or final mode.

The inactive simulation and the status of the generated entries are only requested to validate journals as miscellaneous operations.

Automatic simulated entries (AUTACC)

Select this option to include the automatic simulated entries in the activation, deactivation, or cancellation processes. These automatic simulation entries are identified by the Simulation reference field values that are loaded.

The automatic simulated entries are excluded from the post process.

Start date (STRDAT)

The date range applies to the date the journal was created.

End date (ENDDAT)

Generation

Generation type (SIMSTA)

For an actual generation, the journal status can be:

Temporary
Final

The entry status for entries must be Final when the requested generation type is Actual and the company meets one of the following criteria:

French legislation company with the FRADGI - French fiscal regulation parameter (TC chapter, CPT group) set to Yes and not editable;
Foreign company applying the French 'DGI no. 13L-1-06' compliance rules with the FRADGI - French fiscal regulation parameter (TC chapter, CPT group) set to Yes and editable.

The status defines your ability to modify the document. When final, the modifications of the journal are only for information purposes or concern the analytical postings. The date, amounts, accounts, VAT code, and other purely accounting information can no longer be modified.

In temporary mode, most of the information displayed on the journal can be modified. The modification options can vary based on:

The nature and the origin of the accounting document:

Temporary payment document: bank lines that cannot be deleted
Purchase invoice document: BP line that cannot be deleted, purchase account and VAT that cannot be modified

The management events that have an impact on the account document are:

Charge account with a declared VAT amount
Matched VAT account or not

Entry type (TYPDES)

Journal type to be used to generate the journals from the process.

Pay attention to the selected journal types. They can prohibit or authorize propagation between ledger types.

Journal (JOUDES)

Journal used to generate journals coming from the process. It needs to be the same type as the journal linked to the journal type previously selected.

Log file (TRC)

Select this option for the list of the journals validated by this process.

Batch task

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

Specific Buttons

Memo	Select this action to save the current settings to reuse later using a unique memo code. The memo code is linked to your user profile, not to the function or the screen.
Recall	Enter or select the unique memo code you created to apply the settings saved with that code.
Delete memo	This action deletes a saved memo code and cannot be undone.

Error messages

Generic messages

In addition to the generic error messages, the following messages can display:

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 Conformity DGI no. 13L-1-06 (i.e. the value of parameter FRADGI/chapter TC/group CPT is 'yes'), 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 a group of companies, and if at least one of the companies chose Conformity DGI no. 13L-1-06 (i.e. the value of parameter FRADGI/chapter TC/group CPT is 'yes'), the documents generated by the processing will have the status 'Final'.

Tables used