This report is generated in Physical Inventory Comparison Report. It displays the physical count versus the computer's on hand quantity.
This following is a sample of the report:
|
Date: 01/04/2020 |
Time: 08:19:27 |
|
|
|
|
|
|
|
|
|
Page: 1 |
|
Physical Inventory Comparison Report for Consumer Goods Inc. |
|||||||||||
|
502 |
|||||||||||
|
Location Prefix: NJ Name: New Jersey |
|||||||||||
|
Report Options --- Listing for: 502 |
|
|
|
|
|
|
|
|
|
|
|
|
Product Code |
Trans ID |
Zone |
Bin |
Lot |
Serial# |
U/M |
Computer Inv |
Physical Inv |
Variance |
Variance % |
Cost Adj |
|
------------- |
------------- |
---------------- |
---------------- |
---------------- |
---------------- |
----------- |
--------------- |
---------------- |
---------------- |
---------------- |
---------------- |
|
AA |
00000001 |
%NONE% |
B03 |
%NONE% |
%NONE% |
Cs12 |
0 |
2 |
2.00 |
100.00 |
137.50 |
|
NOTES: |
|
|
|
|
|
|
|
|
|
|
|
|
AB |
00000002 |
%NONE% |
%NONE% |
%NONE% |
123456 |
Each |
85 |
85 |
0.00 |
0.00 |
0.00 |
|
NOTES: |
|
|
|
|
|
|
|
|
|
|
|
|
AC |
00000003 |
%NONE% |
B03 |
%NONE% |
%NONE% |
Each |
41 |
39 |
-2.00 |
-4.80 |
-27.25 |
|
NOTES: |
|
|
|
|
|
|
|
|
|
|
|
|
AD |
00000004 |
Zone 3 |
A100 |
%NONE% |
%NONE% |
Each |
1200 |
1200 |
0.00 |
0.00 |
0.00 |
|
NOTES: |
|
|
|
|
|
|
|
|
|
|
|
|
AE |
00000005 |
Zone 4 |
A150 |
%NONE% |
%NONE% |
Lbs |
6 |
9 |
3.00 |
0.500 |
87.75 |
|
NOTES: |
|
|
|
|
|
|
|
|
|
|
|
|
AF |
00000006 |
%NONE% |
%NONE% |
%NONE% |
141251 |
Each |
-3 |
0 |
3.00 |
100.00 |
0.00 |
|
NOTES: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
---------------- |
-------------- |
|
---------------- |
-------------- |
|
|
|
|
|
|
|
|
1329 |
1335 |
|
00.01 |
198.00 |
|
TOTALS: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
Overall inventory count accuracy (percent) |
99.55 |
|
|
|
|
|
|
|
|
||
|
Item accuracy (percent) |
33.33 |
|
|
|
|
|
|
|
|
||
|
Total shortage count |
2 |
|
|
|
|
|
|
|
|
||
|
Total shortage amount |
27.25 |
|
|
|
|
|
|
|
|
||
|
Total overage count |
8 |
|
|
|
|
|
|
|
|
||
|
Total overage amount |
225.25 |
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*** End of Report *** |
|
|
|
|
|
|
|
|
|
|
|