cancel
Showing results for 
Search instead for 
Did you mean: 

VAT REPORT

former_member218051
Active Contributor
0 Kudos
42

Hi All,

How do i get VAT Report ?

Is there something in SAP which will give me statutory reports like

Sales register

Purchase register

VAT report etc.

Thanking you

Malhaar

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

DECLARE

@StartDate DATETIME,

@EndDate DATETIME,

@Dummy INTEGER

SELECT TOP 1 @Dummy = DocNum

FROM OINV T0

WHERE T0.DocDate >=[%1]

AND T0.DocDate <= [%2]

SELECT

@StartDate='[%1]' ,

@EndDate = '[%2]'

SELECT DISTINCT

T0.DocEntry,

T0.DocNum,

T0.DocDate AS 'Bill Date',

T0.CardName AS 'Customer Name' ,

(SELECT DISTINCT ISNULL (SUM(INV4.TaxSum),0)

FROM INV4

WHERE INV4.StaType = -90

AND INV4.DocEntry = T0.DocEntry) AS 'BED',

(SELECT DISTINCT ISNULL (SUM(INV4.TaxSum),0)

FROM INV4

WHERE INV4.StaType = -60

AND INV4.DocEntry = T0.DocEntry) AS 'Cess',

(SELECT DISTINCT ISNULL (SUM(INV4.TaxSum),0)

FROM INV4

WHERE INV4.StaType = 9

AND INV4.DocEntry = T0.DocEntry) AS 'HeCess',

(SELECT DISTINCT ISNULL (SUM(INV4.TaxSum),0)

FROM INV4

WHERE INV4.StaType = 1

AND INV4.DocEntry = T0.DocEntry) AS 'VAT',

(SELECT DISTINCT ISNULL (SUM(INV4.TaxSum),0)

FROM INV4

WHERE INV4.StaType = 8

AND INV4.DocEntry = T0.DocEntry) AS 'CST',

T0.Comments

FROM OINV T0

INNER JOIN INV1 T1

ON T0.DocEntry = T1.DocEntry

AND T1.Targettype < > 14

WHERE

T0.DocDate >= @StartDate

AND T0.DocDate <= @EndDate

FOR BROWSE

This is for Sales... like the way edit for purchase..

Regards,

Sudhir B.

Former Member
0 Kudos

Hi Malhaar

You have to develop those reports using queries.

SAP doesnt have pre designed reports