Forum Discussion

xenon325i's avatar
xenon325i
Regular Visitor
8 years ago
Solved

Absolute Value of data

Hi all, first post here :smileyhappy:   I'm trying to show some sales data but because my data comes from an invoice table the values are all negative which doesn't look nice in my report. I'm usin...
  • xenon325i's avatar
    xenon325i
    8 years ago

    Sorry I sent the wrong sample :smileyembarrassed:

     

    I will use your work-around by adding a column at source.

     

    Thank you for your help.

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

xenon325i,

Right-click  your table in SSMS, then get create statement using option below. Also please share sample data of you table in Excel and share Excel to me.



Regards,
Lydia

xenon325i's avatar
xenon325i
Regular Visitor
8 years ago

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?