Absolute Value of data

OK this is to create the table:

/****** Object:  Table [dbo].[Company Live$G_L Entry]    Script Date: 17/08/2018 10:49:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Company Live$G_L Entry](
 [timestamp] [timestamp] NOT NULL,
 [Entry No_] [int] NOT NULL,
 [G_L Account No_] [varchar](20) NOT NULL,
 [Posting Date] [datetime] NOT NULL,
 [Document Type] [int] NOT NULL,
 [Document No_] [varchar](20) NOT NULL,
 [Description] [varchar](50) NOT NULL,
 [Bal_ Account No_] [varchar](20) NOT NULL,
 [Amount] [decimal](38, 20) NOT NULL,
 [Global Dimension 1 Code] [varchar](20) NOT NULL,
 [Global Dimension 2 Code] [varchar](20) NOT NULL,
 [User ID] [varchar](20) NOT NULL,
 [Source Code] [varchar](10) NOT NULL,
 [System-Created Entry] [tinyint] NOT NULL,
 [Prior-Year Entry] [tinyint] NOT NULL,
 [Job No_] [varchar](20) NOT NULL,
 [Quantity] [decimal](38, 20) NOT NULL,
 [VAT Amount] [decimal](38, 20) NOT NULL,
 [Business Unit Code] [varchar](10) NOT NULL,
 [Journal Batch Name] [varchar](10) NOT NULL,
 [Reason Code] [varchar](10) NOT NULL,
 [Gen_ Posting Type] [int] NOT NULL,
 [Gen_ Bus_ Posting Group] [varchar](10) NOT NULL,
 [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL,
 [Bal_ Account Type] [int] NOT NULL,
 [Transaction No_] [int] NOT NULL,
 [Debit Amount] [decimal](38, 20) NOT NULL,
 [Credit Amount] [decimal](38, 20) NOT NULL,
 [Document Date] [datetime] NOT NULL,
 [External Document No_] [varchar](20) NOT NULL,
 [Source Type] [int] NOT NULL,
 [Source No_] [varchar](20) NOT NULL,
 [No_ Series] [varchar](10) NOT NULL,
 [Tax Area Code] [varchar](20) NOT NULL,
 [Tax Liable] [tinyint] NOT NULL,
 [Tax Group Code] [varchar](10) NOT NULL,
 [Use Tax] [tinyint] NOT NULL,
 [VAT Bus_ Posting Group] [varchar](10) NOT NULL,
 [VAT Prod_ Posting Group] [varchar](10) NOT NULL,
 [Additional-Currency Amount] [decimal](38, 20) NOT NULL,
 [Add_-Currency Debit Amount] [decimal](38, 20) NOT NULL,
 [Add_-Currency Credit Amount] [decimal](38, 20) NOT NULL,
 [Close Income Statement Dim_ ID] [int] NOT NULL,
 [IC Partner Code] [varchar](20) NOT NULL,
 [Reversed] [tinyint] NOT NULL,
 [Reversed by Entry No_] [int] NOT NULL,
 [Reversed Entry No_] [int] NOT NULL,
 [Prod_ Order No_] [varchar](20) NOT NULL,
 [FA Entry Type] [int] NOT NULL,
 [FA Entry No_] [int] NOT NULL,
 [Audited By] [varchar](20) NOT NULL,
 [C_A_R_ Line Type] [int] NOT NULL,
 [C_A_R_ Line No_] [varchar](20) NOT NULL,
 [C_A_R_ Line Variant] [varchar](10) NOT NULL,
 [C_A_R_ Line Quantity] [decimal](38, 20) NOT NULL,
 [C_A_R_ Line Inv_ Posting Group] [varchar](20) NOT NULL,
 CONSTRAINT [Company Live$G_L Entry$0] PRIMARY KEY CLUSTERED
(
 [Entry No_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Data Filegroup 1]
) ON [Data Filegroup 1]

GO

SET ANSI_PADDING OFF
GO

What's the best way to send you the Excel sample?

xenon325i,

You can upload Excel to OneDrive or Dropbox and then post shared link of the file here.

Regards,
Lydia

Here is a sample:

https://sunhydraulics-my.sharepoint.com/:x:/p/ian_callow/ERpCHAEzpNxBnYhcZtPbvDYBzeVVliY6gKipiqL7Oag2ew?e=ZIDhID

xenon325i,

I am unable to access the above link as it requires permission.


Regards,
Lydia

Sorry, try this:

https://sunhydraulics-my.sharepoint.com/:x:/p/ian_callow/ERpCHAEzpNxBnYhcZtPbvDYBzeVVliY6gKipiqL7Oag2ew?e=yPHkWy

xenon325i,

I can't find any Amount column in your Excel file, and I am unable to reproduce this issue when creating a table using your SQL script.

I would recommend you add a column in the SQL data source. 

Regards,
Lydia