Journals
From version 2025.10.1 Journals are loaded in a new format which collects detail lines and posts them under a header record which makes it impossible to post an unbalanced journal. This new method is also faster. Previously, they were uploaded on a line by line basis.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Data Type |
Notes |
|
|
ID |
N/A |
N/A |
int |
Used internally and not uploaded to Sage |
|
|
NomCode |
Nominal Code |
Nominal Ledger Record - Activity Screen |
nvarchar(8) |
Nominal Code this Journal is for. Please note that this must also be a valid Bank Account in Sage. |
|
|
Ref |
Ref |
Nominal Ledger Record - Activity Screen |
nvarchar(30) |
The key field for this tab. We will check that grouped records on the Ref field balance to zero before uploading. |
|
|
ExtRef |
Ex. Ref. |
Nominal Ledger Record - Activity Screen |
nvarchar(30) |
|
|
|
Date |
Date |
Nominal Ledger Record - Activity Screen |
datetime |
|
|
|
Details |
Details |
Nominal Ledger Record - Activity Screen |
nvarchar(60) |
|
|
|
Dept |
n/a Dept |
n/a |
nvarchar(2) |
Not visible on Journal Activity screen |
|
|
TaxCode |
n/a Tax Code |
n/a |
nvarchar(2) |
Not visible on Journal Activity screen |
|
|
Value |
Credit / Debit |
Nominal Ledger Record - Activity Screen |
decimal(18, 2) |
Any positive value will result in a Debit and negatives a Credit transaction |
|
|
Status |
N/A |
N/A |
nvarchar(8) |
|
NB: Sage will accept one side of a journal but reject another with an error such as invalid nominal code causing one-sided postings. In the event of this happening a balancing journal will be required to solve the imbalance.
Script to create the table...
CREATE TABLE [dbo].[Journals](
[ID] [int] IDENTITY(1,1) NOT NULL,
[NomCode] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ref] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExtRef] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[Details] [nvarchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Dept] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaxCode] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Value] [decimal](18, 2) NULL,
[Status] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Journals_Status] DEFAULT (N'New'),
CONSTRAINT [PK_Journals] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]