Sales Tax Error

Hi Every body,

This my report design. In this i am getting sales tax for order quantity how can i get sales tax for received quantity.

Here my order quantity is 50, item price is 1000, total amount is 50000, sales tax(vat@4%) is 2000

my received quantity is 10, total amount is 10000 Sales tax(Vat@4%) is 400

but in my report for received quantity also Tax is getting for total amount of order quantity how can i get tax for total amount of received quantity…?Please help me

Goods Receipt Note(GRN)

Suppliers Name

G.R.N. NO.

45646

GRN DATE

22 Apr 2014

AAAA

INWARD NO

INWARD DATE

PPPPPP

CH. No

768

CH. Date

22-04-2014

HHHH

LR. No.

8769679769

LR Date

22-04-2014

INVOICE NO

INVOICE DATE

626 125

VEHICLE NO

7877

TINNumber:123450

PO No.

000554

PO Date

22-04-2014

Sl.No

Description

UNIT

INV. Qty

Acpt. Qty

Rate

Amount

Valuation

1

SAN

g

10.00

₹1000.00

₹10,000.00

Total

₹10,000.00

Exice Duty

₹0.00

Vat@4%

₹2000.00

Freight Charges

Grand Total

₹12,000.00

Amount In Words Rs: