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.
An 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
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 |
A |
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
Block number 1
Site (field FCY) |
Entry must be a valid site and the user must have security rights to the site. |
Company (field CPY) |
This field can be used to display the company linked to the selected processing code. |
Entry type (field TYP) |
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. 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. |
Journal (field JOU) |
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. |
Currency (field CUR) |
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. |
Site (field FCYLIN) |
When entering intercompany journals, this field will display only the site of the companies that were defined in Intercompany account mapping.
|
Company (field CPYLIN) |
This field displays the company associated to the target site/site of the line. |
Type (field TYPLIN) |
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.
Only 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. |
Journal (field JOULIN) |
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. |
Currency (field CURLIN) |
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. |
Main general (field ACC1) |
Enter the main ledger account that is associated with the target/line company to be posted for this transaction line. |
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. |
Main analytical (field ACC2) |
Enter the analytical ledger account that is associated with the target/line company to be posted for this transaction line. |
BP (field BPR) |
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. |
Tax (field TAX) |
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. |
Unit (field UOM) |
On analytical inquiry, this field determines the non-financial unit linked to the displayed account. |
Quantity (field QTY) |
Because of the analytical nature of a line, you have to enter a quantity expressed in the indicated non-financial unit.
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:
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 %. |
field CCE1 |
Indicate in this field the dimensions that should be assigned to the posting line.
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. |
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.
An 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.
Up to 20 dimension types can be displayed in the Intercompany dimensions window. |
Menu Bar
This function is used to access the accounting journal generated after posting the current journal entry. |