Financials > Journals > Intercompany journal entry 

Use this function to enter intercompany journal transactions. Source and target journal lines will be used to generate separate journals in the associated companies (source and target). 

  • A sequence definition/type is attached to the intercompany entry.
  • Only target companies that were defined in Intercompany account mapping can be selected.
  • It verifies that the intercompany journal entry is balanced.
  • The following occurs if the target company entered on the line is not the same as the source company:
    • The COA column headers are based on the source company ledgers.
    • The first account column is based on the COA of the target company’s main general ledger.
    • For the subsequent account columns, an entry is to be made only if the target company has the same ledger defined in the accounting core model. Otherwise, the column will be skipped.
    • Only the dimension types associated with the displayed/entered ledgers can be entered.

SEEWARNINGAn error may occur if the dimension types are set to be required for the analytical ledger and the source company does not include that analytical ledger, but the target company does. 

When the transaction is posted, separate journals are generated in the source and target companies using the designated debit and credit accounts from Intercompany account mapping.

This function is available only if the INTCO activity code is active.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Journal Entry Example:

Company A has a $100 transaction reducing cash which is $40 of rent to company A with dimension department 1 and $60 of rent to company B with dimension department 5. 
When the Intercompany journal entry is entered, the entry would be as follows in source CO A:

Site

Company

Legal

Debit

Credit

Accounts used

B1 

B

RENT

60.00

 

Account in CO B, DIM DEPT 5

A1

A

RENT

40.00

 

Account in CO A, DIM DEPT 1

A1

CASH

 

100.00

Account in CO A

When the journal entry is created in Intercompany journal creation, the resulting journal entries would be separate journal entries in each company as follows:

Company A

Site 

Legal

Debit

Credit

Accounts used

A1

RENT

40.00

 

DIM DEPT 1

A1

 DUE FROM CO B

60.00

 

 Account defined in Intercompany account mapping

A1

 CASH

 

 100.00

 

Company B

Site 

Legal

Debit

Credit

Accounts used

 B1

RENT

60.00

 

DIM DEPT 5 

 B1

DUE TO CO A

 

60.00 

Account defined in Intercompany account mapping

Entry screen

Presentation

 

Close

 

Fields

The following fields are present on this tab :

Block number 1

Entry must be a valid site and the user must have security rights to the site.

This field can be used to display the company linked to the selected processing code.

Enter the document type for the journal entry that will be generated during Intercompany journal creation.

Each accounting journal entered is linked to a document type.

  • Number (field NUM)

This field displays the automated sequence number from Assignment.

  • Description (field DESNUM)

Enter text to provide the purpose of the intercompany transaction.

  • Status (field FLGPST)

The status displayed in this field is updated upon validating a journal entry from Intercompany journal creation and Intercompany journal entry.

SEEINFO The simulation status Validated can only be updated from Intercompany journal creation.

Block number 2

  • Date (field ACCDAT)

Enter the date for the intercompany journal. This date is used as the accounting date during the journal creation.

The date must belong to a fiscal year or period that is open for all general ledger types assigned to the source company. If the date is modified after the documents are created, verify the accounting date period is open for all of the target companies that exist on the lines.

Enter the journal code for the journal transaction that will be generated in Intercompany journal creation.

 Journal codes can apply to a specific company, a specific site, or a specific group. This information is defined when the journal code is created but the selection window for this field (using the selection tool) does not take this into account. These controls are applied when you select or confirm the journal code. You can amend the journal code if an error message warns that it is invalid.

  • Rate type (field TYPRAT)

Enter the exchange rate type that must be used to convert the amounts in currencies.

  • Rate date (field RATDAT)

Enter the rate date that must be used to convert the amounts in currencies. The accounting date is the default value.

Enter the currency to be used when the journals are created. The main general ledger currency of the header company is the default value. If the currency is different from the original currency, the conversion will be based on the exchange rates for the selected rate type and rate date.

Grid Lines

  • No. (field NUMLIG)

It is the line number.

When entering intercompany journals, this field will display only the site of the companies that were defined in Intercompany account mapping.

  • A financial site belonging to another company can be selected.
  • A target company must be mapped to the source company.

This field displays the company associated to the target site/site of the line.

Enter the journal type for the journal entry that will be generated during Intercompany journal creation. Each accounting journal is linked to a journal type.

SEEINFOOnly one journal type can be assigned for each company. If the line company is also used on subsequent lines in the document, this value is displayed.

Enter the code for the journal entry that will be generated during intercompany creation. A default journal is assigned based on the entry/document type selected in the Type field.

Only one journal code can be assigned for each company. If the line company is also used on subsequent lines in the document, then this value will be used for all subsequent lines with a repeat company. 

This field displays the default document/header currency.

If the document currency is not equal to the main general ledger currency of the target/line company, then a currency rate must be specified on the first line of each target company.

  • Ctrl. (field SAC1)

Enter the main control/collective account to be posted. The target account will automatically appear when a control/collective is entered.

If a control account is selected, the default account field will automatically display.

Enter the main ledger account that is associated with the target/line company to be posted for this transaction line.
This field is disabled if the main general ledger is equal to the main analytical ledger. Accounts linked to exceptional account classes cannot be selected. 

  • Ctrl. (field SAC2)

Enter the analytical control/collective account to be posted. The target account will automatically appear when a control/collective is entered.

If a control account is selected, the default account field will automatically display.

Enter the analytical ledger account that is associated with the target/line company to be posted for this transaction line.
This field is disabled if the main general ledger is equal to the main analytical ledger. Accounts linked to exceptional account classes cannot be selected. 

Enter the BP associated with the control account.

  • Document no. (field DOCNUMLIN)

This field displays the automated sequence number from Assignment.

  • Debit (field DEB)

Enter the amount to be debited for this account.

  • Credit (field CDT)

Enter the amount to be credit for this account.

  • Description (field DES)

Enter text to provide the purpose of the intercompany transaction.

Enter the sales tax if the account on the line is subject to sales tax. The default tax code associated with the account automatically appears, but it can be changed.

On analytical inquiry, this field determines the non-financial unit linked to the displayed account.
The non-financial unit is determined when setting up an account associated with a given value.
This unit is called upon entry.

  • Quantity (field QTY)

Because of the analytical nature of a line, you have to enter a quantity expressed in the indicated non-financial unit.
The default value of this field is calculated based on the amount of the entry line and the "Unit value" line of the analytical account, by dividing the ex-tax amount (converted into devise commune) by the value of the non-financial unit. The quantity can be modified.

SEEINFO This information can be processed on the analytical and budgetary reports and be useful for the automatic calculation of the analytical allocations.

  • Distribution (field DSP)

Defined here are the allocation methods for the line amount on the different dimensions of each dimension type.

These methods are defined as follows:

  • the entry of an analytical allocation key previously configured,
    SEEREFERTTO See the documentation on Allocation keys for further information.
  • in amount. It is then possible to allocate the amount to as many sub-amounts as required,
  • in percentage. A calculation is performed based on the sum of the coefficients used for the allocation.

Example: on a basis of 100, a coefficient of 10 will be read as 10 %. But, on a basis of 50, a coefficient of 10 will be equivalent to 20 %.
For these two later cases, it is possible to pre-initialize the allocation with an already existing key. The final display will be "$".

Indicate in this field the dimensions that should be assigned to the posting line.
The entry of this field:

  • can be mandatory for a dimension type. (see the company record setup)
  • is controlled according to the setup of the prohibited account-dimension and dimension-dimension codes.

If the accounting amount is not distributed over several analytical dimensions, the "allocation" field cannot be assigned. The entry is achieved directly in the following columns, in the dimension concerned, for each of the dimension types.

Default dimensions can be specified in the analytical account and taken into account or not, according to the default dimension setup.

For the journals automatically generated from other modules, the default dimensions are defined by a process (see the Default dimensions documentation).

Totals

  • Total debit (field TOTDEB)

Total of the debit lines which compose the posting lines.

  • Total credit (field TOTCDT)

Total of the credit lines which compose the posting lines.

Account

  • Description (field AFFICHE)

This field displays the main or the analytical account as well as its description.

  • Balance (field SOLDE)

This field displays the total sum of debits and credits.

Close

 

Action icon

Intercompany dimensions

This window is used to enter the target company’s dimension type values when the dimension types are different between the source and target company. If the source and target companies use the same ledger and exactly the same dimension type and number, the Intercompany dimensions window is not used.

Dimension types that are different between the source and target company ledger must be entered using the Intercompany dimensions window.

  • The Intercompany dimensions window will automatically appear if different dimensions are found between the source and target company, or by selecting Dimensions from the right-click menu on the line.
  • Only the dimension types associated with the displayed/entered ledgers can be entered. If the ledger is not displayed, then the dimensions for the target company cannot be entered.

SEEWARNINGAn error may occur if the dimension types are set to be required for the analytical ledger and the source company does not include that analytical ledger, but the target company does.

SEEINFOUp to 20 dimension types can be displayed in the Intercompany dimensions window.

 

Close

 

Specific Buttons

Menu Bar

Zooms / Accounting entries

This function is used to access the accounting journal generated after posting the current journal entry.
If using the intercompany feature, all general ledger entries generated after posting are also displayed and the document can be viewed.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation