Dynamics Community Forum Thread Details

HITB Report

Hello,

I trying to understand what the variance quantity column on the HITB report represents. I would appreciate if you can provide me with any information that I can use.

When I run the HITB report I notice that sometimes there is a negative stock quantity shown in the variance quantity column, however both unit cost and extended value are seen as positive figures.

When I check the quantity column on the same report a negative quantity is also seen, however both the unit cost and extended value are seen as zero ($0.00)

I ran the HITB report for Jan’16 and compared it against transaction in the Wines & Sprits-Inventory - Finished Goods account for the same period and the following was noticed. See below

Account Number

900-1510-00-135

HITB Report

Date

Source

Document Number

Sum of Quantity

Sum of Value

Journal Entry

TRX Date

Originating Document Number

TRX Source

Sum of Debit Amount

Sum of Credit Amount

Sum of Total Amount

1/1/2016

VAR004028

(869)

($52,982.85)

851181

1/1/2016

VAR004028

GLTRX00389235

$2,633.20

$59,730.45

($57,097.25)

1/25/2016

TRF200131

(406)

($33,216.47)

854539

1/25/2016

TRF200131

GLTRX00390014

$0.00

$33,216.47

($33,216.47)

3/22/2016

TRF210102

(60)

($10,581.60)

902489

3/22/2016

TRF210102

GLTRX00405394

$0.00

$10,581.60

($10,581.60)

(1,335)

($96,780.92)

Grand Total

$2,633.20

$103,528.52

($100,895.32)

I have added another screen shot which may be helpful. This a detail Historical Inventory Trial Balance (HITB) report on the left side of the screen and i compared the transaction to transactions in the GL on the right side of the screen. The ones highlighted in RED do not match

Journal Entry	Date	Document Number	Source	Variance Qty	Quantity	Unit Cost	Value	TRX Date	Journal Entry	TRX Source	Originating Document Number	Account Number	Debit Amount	Total Amount	Credit Amount
851181	1/1/2016	VAR004028	IV		(56)	$33.87	($1,896.72)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($65.48)	$65.48
851181	1/1/2016	VAR004028	IV		(4)	$31.08	($124.32)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($158.64)	$158.64
851181	1/1/2016	VAR004028	IV		(1)	$32.57	($32.57)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($406.01)	$406.01
851181	1/1/2016	VAR004028	IV		(22)	$34.84	($766.48)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($729.85)	$729.85
851181	1/1/2016	VAR004028	IV		(12)	$61.55	($738.60)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($738.60)	$738.60
851181	1/1/2016	VAR004028	IV		(37)	$0.00	$0.00	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($815.98)	$815.98
851181	1/1/2016	VAR004028	IV	-37	0	$2,057.20	$2,057.20	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($923.37)	$923.37
851181	1/1/2016	VAR004028	IV		24	$77.95	$1,870.80	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($1,198.38)	$1,198.38
851181	1/1/2016	VAR004028	IV		(2)	$32.74	($65.48)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($1,896.72)	$1,896.72
851181	1/1/2016	VAR004028	IV		(1)	$729.85	($729.85)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($2,057.20)	$2,057.20
851181	1/1/2016	VAR004028	IV		8	$95.30	$762.40	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($2,684.22)	$2,684.22
851181	1/1/2016	VAR004028	IV		(1)	$406.01	($406.01)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($10,050.26)	$10,050.26
851181	1/1/2016	VAR004028	IV		(11)	$74.18	($815.98)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($17,988.72)	$17,988.72
851181	1/1/2016	VAR004028	IV		(309)	$64.78	($20,017.02)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$0.00	($20,017.02)	$20,017.02
851181	1/1/2016	VAR004028	IV		(83)	$32.34	($2,684.22)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$762.40	$762.40	$0.00
851181	1/1/2016	VAR004028	IV		(12)	$13.22	($158.64)	1/1/2016	851181	GLTRX00389235	VAR004028	900-1510-00-135	$1,870.80	$1,870.80	$0.00
851181	1/1/2016	VAR004028	IV		(6)	$199.73	($1,198.38)							($57,097.25)
851181	1/1/2016	VAR004028	IV		(102)	$176.36	($17,988.72)
851181	1/1/2016	VAR004028	IV		(242)	$41.53	($10,050.26)
							($52,982.85)

Quick Links

Leaderboard