Use this function to create and manage accounting journals according to the selected entry transaction.

  • Create accounting journals such as miscellaneous operations.
  • Partially modify accounting journals generated in other modules.
  • View all the accounting journals.

When an entry is entered directly, its counterpart is mandatory. For journals generated in other modules, the counterpart is automatic.

When the status is Temporary, journals can be deleted or modified, but journals generated in other modules are subject to consistency checks. When the status is Final, some accounting elements included in a journal can no longer be modified.

Depending on the setup of the transaction and journal type used, the following elements can be specified in journal entry:

  • Purely analytical journals
  • General and analytical journals
  • IAS documents, etc.

The types of ledgers entered and actually propagated depend on two setup elements.

You can browse between the source journal and the target journals.

When fixed assets are managed, the journal entry can trigger the automatic generation of the expenses. The list of expenses generated is displayed in the selection panel under Associated expenses.

SEEREFERTTO See the documentation for entry transactions setup.

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

The transaction you select determines how you enter information, and how information is displayed and printed.

If only one transaction has been set up you are not offered a choice, the default entry screen displays.

  • If the entry mode for the selected transaction is Column or Row you can view, enter, and edit a journal for a manual ledger.
  • If the entry mode for the selected transaction is Tab, you can only view existing journals. You cannot enter or edit a journal. All ledger types, manual and automatic, are displayed.
  • Transferring the journal to other ledgers is determined by the entry transaction.

Automatic generation of expenses

Entering miscellaneous operation documents, or the reversal entry, can automatically generate fixed assets Expenses. The list generated expenses displays in the Selection panel under Associated expenses.

The journal must be Actual and the status must be Final. The following steps must be implemented:

  • The FAS - Fixed assets activity code must be active.
  • Entry type: The expense creation must be authorized for the entry type to which the journal is attached.
  • Account setup: Fixed asset tracking must be activate to authorize the use of the account on assets and expenses that are managed in fixed assets module. Creating expenses from validating the journal to allocating to the accounts must be authorized. The accounting nature must be entered.

SEEINFO

  • When the journal status is temporary, the Final validation process, or the Reversal process, after validation of the document, automatically generates the expense.
  • When a journal line is subject to a manual analytical distribution (the $ symbol is displayed in the field Distribution), then there are as many expenses created as there are manual distribution lines for this journal line.
  • When the company is subject to the French legislation, the recovery VAT rate is not 100 percent and the VATAUTVAL - VAT Automatic validation parameter is set to No, then the VAT coefficients on the expense must be validated so the expense is capitalized. The validation is done by selecting the Validated checkbox, available and displayed only on the expense as long as the validation has not been performed.

Screen management

Header

Tab Header

Tab Lines

These lines are used for the accounting entry. Each entry transaction is different.

For manual journal entry

If the Control type field is set to Inactive for the account, you can enter any value on the line.

If the Control type field is set to Authorization for the account, you can only enter a code listed in the Tax control grid in the Management section for the account. Otherwise you receive a blocking message.

I the Control type field is set to Restriction for the Account, you can only enter a code that is not listed in Tax control grid. Otherwise, you receive a blocking message.

For automatic journal entry

The same rules apply but the blocking message displays when you click Save.

Select this option to view the Open items of the current journal. The automatic open items are calculated according to the selected payment method when you create the accounting journal.

Analytical account inquiry

Select this option to view the current journal distributions. The window displays the distribution percentage, the distributed amounts, and the dimensions where the amounts are distributed.

Reports

By default, the following reports are associated with this function :

  PIECE : Entry print

This can be changed using a different setup.

Special functions

Copy

1. In the Number field, delete the entry number.
2. Update the data in the other fields if necessary.
3. Click Create to create the new entry.

Fields that cannot be modified

To guarantee the integrity of the journal data from other modules, certain fields cannot be modified. For example, a payment sent to a given bank prevents the modification of the associated account. To cancel such a transaction, you first need to cancel the payment (this reverses the journal), then re-enter the payment for a new bank account. The ability to modify some fields can also be subject to whether or not the journal entry has been validated or not. The table shown below lists the fields that cannot be modified for journals from modules other than accounting:

Source module

Field

Account type

Journal status

Modification

All

Currency

-

Temporary

Impossible

All

Currency rate

-

Final

Impossible

All

Exchange rate type

-

Final

Impossible

All

Site

-

Temporary

Impossible

All

Account

Collective

Temporary

Impossible

All

Business partners

-

Temporary

Impossible

All

Amount

Collective

Temporary

Impossible

BP

Account

Bank

Temporary

Impossible

BP

Amount

Bank

Temporary

Impossible

Specific buttons

Currency

For a specific journal entry, click Currency to view amounts in the currency of the first ledger entered on the line and the transaction currency. If there are automatic ledgers linked to the first ledger, you can cycle through those currencies by clicking Currency multiple times.

Delete

Click Delete to delete this journal.

The following conditions must be met to successfully delete a journal:

  • The source module must be the Financials module.
  • The status cannot be Final.
  • The GASSUP - Delete accounting entries parameter (chapter TC, group INV) cannot be set to Yes.
  • The lines cannot declare a VAT amount.
  • A reconciliation cannot be present on the entry lines.
  • A matching cannot be performed on the entry lines.
  • The user is authorized to delete journal entries.
  • The document must have been entered and not generated automatically. This excludes, for example, recurring task entries and invoices to receive.

Limitations

  • Access code controls are not applied to the entry type, the account or the dimension in journal inquiry. Access code controls are only performed based on the journal (in compliance with the inquiry screens when using the Jump to action).

  • If a journal is not available in the inquiry, related journals are displayed in the selection panel. If, however, after clicking on a journal number you cannot view the journal, the message 'XXXX non authorized journal' is displayed.

  • The selection window for the header information field Journal(field JOU) displays all journal codes. It does not filter the codes by company, site or group if a specific company, site or group was defined when the journal code was created.

Error messages

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

Unbalanced journal entry

In entry creation, the journal must balance to zero (Balance=0).

At least one dimension type must be entered

The analytical allocation is mandatory.

Fiscal year change prohibited

It is not possible to change the journal date beyond the fiscal year, if journal lines have been entered.

X Journal not authorized for this journal type

The journal is prohibited for this journal type. For instance, documents with the type Sales invoice cannot be entered in a Purchasing journal.

Entry transaction: XXX Setup to review

Mandatory ledger not present for the selected Journal entry transaction code.

XXX Closed Period YYY: Incompatible transaction code

This message is displayed when a journal entry is displayed for the following reasons:

  • The Ledger type (for example, Legal (Social), Analytical, IAS, Group) has not been specified for the selected Journal entry transaction code.
  • The journal entry date falls within an accounting period that has been closed for this Ledger type.

To amend this journal you must use a journal entry transaction code that displays all Ledger types. This journal entry transaction code is defined in either the parameter SCHSTDC - Column entry transaction (chapter CPT, group DEF) or the parameter SCHSTDL - Line entry transaction (chapter CPT, group DEF).

Amount line null: update the quantity sign

This message is displayed if the modified document does not come from the accounting module and if this document contains at least one line with an amount equal to zero and quantities.
The quantity must be an absolute value. The direction has an impact on the debit or credit of the analytical balance.

Setup to be reviewedJournal not authorizedWarning, the setup of the transaction ledger types should be reviewedDue date being paidAmount line null: update the quantity signJournal present on temporary fileThere is no line enteredZero lines not allowedSite not used on linesThis journal includes the declared VATThe amount(s) entered on the VAT account(s) is(are) wrong

Error on counter [Counter Code]

Entry matched, cancellation not possibleEntry checked, cancellation not possibleThis journal will not be regenerated

Document generated via the calculated entry [Calculated entry code]

This journal will not be regenerated
Confirm?

Line i: this line has been subject to marking

The company is not converted to EuroOpen item on statementOpen item settledOversettled open itemEntry date inconsistent with entry dateReserved for the legislationMaximum matching dateMini matching dateCarry-forward period not openClosing period not openSwitching to actual amount not allowedDate prior to the accounting date

Authorized Payment approval level

This site is in the companyAt least one account must be enteredControl accountUnbalanced distributionToo many different sitesUnbalanced journalUnbalanced journal in ledger currencyAutomatic counterpart impossibleAutomatic generation of connection entries not possibleActual documents prohibited

Prohibited exceptional documents

Simulation journals prohibitedModel journals prohibitedBalance controlBalance controlQuantity controlAccount prohibited on journalMandatory accountNo spreading to chartAllocation mandatory on chartInconsistent nonfinancial unitProhibited code incompatibleChart of accounts incompatible

Full line entry grid

Unauthorized journal on this document typeAccount prohibited on journalChange of fiscal year prohibitedNot possible to determine the control accountBusiness partner incompatible with the control accountMandatory ledger: no default accountMandatory ledger not presentNo possible ledgerSingle-ledger journal typeChart $1$, account $2$ - Flow management is mandatoryProfit and loss accounts not defined

The results account (line 11) is not entered at the level of the accounts plan setup ( Various accounts tab) and the FRWANA - Analytical carry-forward (chapter CPT, group FIY) and/or FRWGAC - General carry-forward (chapter CPT, group FIY) parameters are set to 'Yes' for the current company.

The $1$ tax code is not authorized at setup level for the $2$ account / chart $3$

If the Control type field is set to Authorization for the Account, you can only enter a code listed in the Tax control grid on the Management tab in the Account.

If the Control type field is set to Restriction for the Account, you can only enter a code that is not listed in the Tax control grid.

Tables used

SEEREFERTTO Refer to documentation Implementation