Import adjustments file structure
The required items in the import file are the items shown during online input of Local or Group Journal entries.
The required structure of the import file is predefined as follows:
-
Column 1/A: CompanyID
-
Column 2/B: JournalType
-
Column 3/C: JournalCategory
-
Column 4/D: JournalEntry
-
Column 5/E: JournalSequence
-
Column 6/F: AccountNbr
-
Column 7/G: PartnerId
-
Column 8/H: Currency
-
Column 9/I: Amount
-
Column 10/J: TransactionCurrency
-
Column 11/K: TransactionAmount
-
Column 12/L: DimensionGroup
-
Column 13/M: Dimension1
-
Column 14/N: Dimension2
-
Column 15/O: Dimension3
-
Column 16/P: FlowNbr (only for Group Journals)
-
Column 17/Q: FlowTransRate (only for Group Journals)
-
Column 18/R: FlowTransactionAmount (only for Group Journals)
-
Column 19/S: TransRate (only for Group Journals)
-
Column 20/T: JournalDesc
-
Column 21/U: Behaviour
-
Column 22/V: BeforeAfter
-
Column 23/W: AdjCurrency
-
Column 24/X: AssociatedJournalType (only for Group Journals)
-
Column 25/Y: AssociatedJournalCategory (only for Group Journals)
-
Column 26/Z: DateCreation
-
Column 27/AA: DateLastModification
Example of an import of group journal entry with flow and dimension data:
| Column A | Column B | Column C | Column D | Column E | Column F | |
| Row 1 | CompanyId | JournalType | JournalCategory | JournalEntry | JournalSequence | AccountNbr |
| Row 2 | ABC | M | 001 | 1 | 1 | TradeReceivables |
| Row 3 | ABC | M | 001 | 1 | 2 | Sales |
| Row 4 | ABC | M | 001 | 1 | 2 | Sales |
| Row 5 | ABC | M | 001 | 1 | 3 | CurrentEarningsPL |
| Row 6 | ABC | M | 001 | 1 | 4 | CurrentEarningsBS |
| Column G | Column H | Column I | Column J | Column K | Column L | |
| Row 1 | PartnerId | Currency | Amount | TransactionCurrency | TransactionAmount | DimensionGroup |
| Row 2 | DEF | USD | 200 | |||
| Row 3 | DEF | USD | -200 | |||
| Row 4 | DEF | USD | -200 | DimGr | ||
| Row 5 | USD | 200 | ||||
| Row 6 | USD | -200 |
| Column M | Column N | Column O | Column P | Column Q | Column R | |
| Row 1 | Dimension1 | Dimension2 | Dimension3 | FlowNbr | FowTransRate | FlowTransactionAmount |
| Row 2 | NetVariance | |||||
| Row 3 | ||||||
| Row 4 | Dim1 | Dim2 | ||||
| Row 5 | ||||||
| Row 6 | CurrentEarnings |
| Column S | Column T | Column U | Column V | Column W | |
| Row 1 | TransRate | JournalDesc | Behaviour | BeforeAfter | AdjCurrency |
| Row 2 | Additional intercompany invoice | 2 | 0 | L | |
| Row 3 | Additional intercompany invoice | 2 | 0 | L | |
| Row 4 | Additional intercompany invoice | 2 | 0 | L | |
| Row 5 | Additional intercompany invoice | 2 | 0 | L | |
| Row 6 | Additional intercompany invoice | 2 | 0 | L |
| Column X | Column Y | |
| Row 1 | AssociatedJournalType | AssociatedJournalCategory |
| Row 2 | M | 001 |
| Row 3 | M | 001 |
| Row 4 | M | 001 |
| Row 5 | M | 001 |
| Row 6 | M | 001 |