Scribd
Upload
37 views28 pages

Foramt For Gaurav For FS

This document appears to be a sales register or invoice log for a company. It includes details of sales transactions over a specified period, categorized by tax rates and jurisdictions. It lists invoice numbers, dates, customers, quantities, rates, taxes, and totals. The log contains sections for within-state sales at different tax rates, inter-state sales, exempt sales, and transport details. There are also sections that describe logic for fetching data from other systems to populate the fields.

Uploaded by

Gaurav Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
37 views28 pages

Foramt For Gaurav For FS

This document appears to be a sales register or invoice log for a company. It includes details of sales transactions over a specified period, categorized by tax rates and jurisdictions. It lists invoice numbers, dates, customers, quantities, rates, taxes, and totals. The log contains sections for within-state sales at different tax rates, inter-state sales, exempt sales, and transport details. There are also sections that describe logic for fetching data from other systems to populate the fields.

Uploaded by

Gaurav Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 28

Sales Register for the period from ................ To ...................

Within State Sales @ 14.5%


Sl.No.

Invoice No.

Date

Name of the Customer

5000011455 13.04.2015 KNA1 KUNNR


B9

C9

D9

Input Fields

BILLING DATE

LOGIC

B9
C9
D9
E9
J9
K9
M9
N9
O9
P9
L9
Q9
R9
S9
T9
U9
V9
W9

PASS SELECTION SCREEN BILLING DATE TO ( VBRK) AND FETCH (VBRK-VBE


PASS SELECTION SCREEN BILLING DATE TO

PASS SELECTION SCREEN (VBRK-VBELN) TO (KNA1 ) AND FETCH (KNA1-KUN

PASS SELECTION SCREEN (VBRK-VBELN) TO (KNVI ) AND FETCH (KNVI-TAXK

PASS SELECTION SCREEN BILLING DATE TO ( VBRP) AND FETCH (VBRP-ARK

PASS SELECTION SCREEN BILLING DATE TO ( VBRK) AND FETCH (VBRK-XBL

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRP ) AND FETCH (VBRP-MEI

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRP ) AND FETCH (VBRP-KW

PASS SELECTION SCREEN (VBRP-MATNR) TO ( MBEW) AND FETCH (MBEW -

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

PASS SELECTION SCREEN BILLING DATE TO ( VBRK) AND FETCH (VBRK-XBL

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

PASS SELECTION SCREEN (VBRK-VBELN) TO (VBRK ) AND FETCH (VBRK-KOM

Within State Sales @ 5%


Sl.No.

Invoice No.

Date

Name of the Customer

Invoice No.

Date

Name of the Customer

1
2
3
4
5
6
7

WCT Sales @ 5%
Sl.No.
1
2
3
4
5
6
7

Inter State Sales @ 14.5%


Sl.No.

Invoice No.

Date

Name of the Customer

Invoice No.

Date

Name of the Customer

Invoice No.

Date

Name of the Customer

1
2
3
4
5
6
7

Inter State Sales @ 2%


Sl.No.
1
2
3
4
5
6
7

Exempt Sales
Sl.No.
1
2
3
4
5
6
7

TIN NO.

DC.No.

Name of the Transporter

LR No.

Vehicle No.

KNVI
E9

TOTAL

D FETCH (VBRK-VBELN)

D FETCH (KNA1-KUNNR)

D FETCH (KNVI-TAXKD)

D FETCH (VBRP-ARKTX)

D FETCH (VBRK-XBLNR)

PASS (XBLNR) TO (VBAK) AND FETCH ( VBAK-BSTNK)

D FETCH (VBRP-MEINS)

D FETCH (VBRP-KWMENG)

ND FETCH (MBEW - VERRR)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

D FETCH (VBRK-XBLNR)

PASS (XBLNR) TO (VBAK) AND FETCH ( VBAK-BSTDK)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

D FETCH (VBRK-KOMV) AND PASS (KOMV) TO (VBRP-KONV) AND FETCH (VBRP-KOMV)

TIN NO.

DC.No.

Name of the Transporter

LR No.

Vehicle No.

LR No.

Vehicle No.

TOTAL

TIN NO.

DC.No.

Name of the Transporter

TOTAL

TIN NO.

DC.No.

Name of the Transporter

LR No.

Vehicle No.

LR No.

Vehicle No.

LR No.

Vehicle No.

TOTAL

TIN NO.

DC.No.

Name of the Transporter

TOTAL

TIN NO.

DC.No.

Name of the Transporter

TOTAL
TOTAL SALES FOR THE PERIOD

Description of Material

PO.No.

Date

UOM

(VBRP-ARKTX)

VBKD-BSTKD

VBRK-FKDAT

VBRP-MEINS

J9

K9

L9

M9

Description of Material

PO.No.

Date

UOM

Description of Material

PO.No.

Date

UOM

Description of Material

PO.No.

Date

UOM

Description of Material

PO.No.

Date

UOM

Description of Material

PO.No.

Date

UOM

QTY

Rate

Basic

ED

Cess

VBRP-KWMENG

MBEW-MEINS

KONV/

KONV/

KONV/

N9

O9

P9

Q9

R9

QTY

Rate

Basic

ED

QTY

Rate

Basic

Cess

ED

Cess

QTY

Rate

Basic

ED

QTY

Rate

Basic

ED

QTY

Rate

Basic

Cess

Cess

ED

Cess

SHEC

Insurance

Freight

Otherrs

TSVAT-@ 5%

KONV/

KONV/

KONV/

KONV/

KONV/

S9

T9

U9

V9

W9

SHEC

Insurance

SHEC

Freight

Insurance

Otherrs

Freight

TSVAT-@ 14.5%

Otherrs

WCT @ -5%

SHEC

Insurance

SHEC

Insurance

SHEC

Freight

Freight

Insurance

Otherrs

Otherrs

Freight

CST-@ 14.5%

CST @ 2%

Otherrs

CST @ 2%

Total
0
0
0
0
0
0
0

Total
0
0
0
0
0
0
0

Total
0
0
0
0
0
0
0

Total
0
0
0
0
0
0
0

Total
0
0
0
0
0
0
0

Total
0
0
0
0
0
0
0

0
0

Plant

Excise Challan Tax Inv


No
No
2

VBRP/WER J_1IEXCHDR

Inv Date

Custome Custome
r Code
r Name
5

J_1IEXCHDJ_1IEXCHDKUNNR

Custome
r
Address

KNA1

KNA1

Ref no1

A7
LOGIC
A7

PASS SELECTION SCREEN (VBRK-VBELN) TO ( VBRP) AND FETCH (VBRP-ERKS)


PASS SELECTION SCREEN (VBRK-VBELN) TO (J_1IEXCHDR ) AND FETCH (J_1IEXCHDR - )

Product
Custome Product
Descripti Quantity UOM
r City
Name
on
8

KNA1

VBRP

10

VBRP

Pass Ref no

CH (VBRP-ERKS)
D FETCH (J_1IEXCHDR - )

11

VBRP

12

VBRP

Type Of
sale

Basic
Value

Discount

13

14

15

find by do VBRP/VBRK(
VBRP/condi

Assessab
Packing
le value
Basic
&
for
Excise
Forwardi
Excise
Duty %
ng
Duty
16

17

18

Basic
Excise
Duty

Educatio
n Cess

S&H
Cess

19

20

21

Assessab
Addition
le value
al Excise
for Sales
Duty
Tax
22

23

(Sum =
(Sum =
Column
Column
VBRP/Condi
VBRP/CondiVBRP/CondiVBRP/CondiVBRP/CondiVBRP/CondiNo.17+1
No.149+20+21
15+16)
+22)

VAT %

VAT
Amount

CST %

CST
Amount

Freight
%

Freight
Amount

Total
Invoice
Value

24

25

26

27

28

29

30

(Sum =
Column
VBRP/CondiVBRP/CondiVBRP/CondiVBRP/CondiVBRP/CondiVBRP/CondiNo.23+2
5+27+29
)

You might also like