|
Do You Want To Know:
- How much of a particular packed product do I have available or unavailable?
- How much bulk product, by commodity, variety or size do I have available to pack?
- What are my historical received quantities for a given product?
- What warehouse positions contain my oldest inventory?
Included Templates
A collection of pre-built views included with this view pack to answer common reporting
questions.
-
Aged Inventory by Warehouse Location
-
Summary view of on hand inventory in aging groups from 0-30, 31-60, 61-90 and 91+ aged days by warehouse. This view is filtered to on hand quantities greater than zero.
-
Weekly Received Totals by Warehouse Location
-
Summary view of all received product quantites by warehouse and week.
Technical Details
|
|
Name
|
Type
|
|
Access Group
|
Dimensions
|
|
Acres
|
Measures
|
|
Aged Days
|
Measures
|
|
Available
|
Dimensions
|
|
Block
|
Dimensions
|
|
Block Acres
|
Measures
|
|
Block ID
|
Dimensions
|
|
Bulk Flag
|
Dimensions
|
|
Carrier
|
Dimensions
|
|
Color
|
Dimensions
|
|
Combine Flag
|
Dimensions
|
|
Commodity
|
Dimensions
|
|
Condition
|
Dimensions
|
|
Current Time
|
Dates
|
|
Description
|
Dimensions
|
|
Field Name
|
Dimensions
|
|
Grade
|
Dimensions
|
|
Grower
|
Dimensions
|
|
Grower Address
|
Dimensions
|
|
Grower City
|
Dimensions
|
|
Grower Country
|
Dimensions
|
|
Grower County
|
Dimensions
|
|
Grower ID
|
Dimensions
|
|
Grower State
|
Dimensions
|
|
Grower Zip
|
Dimensions
|
|
Hold Flag
|
Dimensions
|
|
Inventory Type
|
Dimensions
|
|
Issue Cost
|
Measures
|
|
Issue Eq Qty
|
Measures
|
|
Issue Qty
|
Measures
|
|
Issue Type
|
Dimensions
|
|
Issue Type Eq Qty
|
Measures
|
|
Issue Type Qty
|
Measures
|
|
Label
|
Dimensions
|
|
Lot
|
Dimensions
|
|
Lot Id
|
Dimensions
|
|
Method
|
Dimensions
|
|
On Hand Eq Qty
|
Measures
|
|
On Hand Qty
|
Measures
|
|
Packer Id
|
Dimensions
|
|
Packer Name
|
Dimensions
|
|
Pool
|
Dimensions
|
|
Pool Id
|
Dimensions
|
|
Position
|
Dimensions
|
|
Product
|
Dimensions
|
|
Product Class
|
Dimensions
|
|
Product Group 1
|
Dimensions
|
|
Product Group 2
|
Dimensions
|
|
Product Group 3
|
Dimensions
|
|
Product Group 4
|
Dimensions
|
|
Quality
|
Dimensions
|
|
Quantity
|
Measures
|
|
Receipt #
|
Dimensions
|
|
Receive Cost
|
Measures
|
|
Receive Date
|
Dates
|
|
Receive Eq Qty
|
Measures
|
|
Receive Qty
|
Measures
|
|
Receive Type
|
Dimensions
|
|
Ref
|
Dimensions
|
|
Region
|
Dimensions
|
|
Room
|
Dimensions
|
|
Room/Row Id
|
Dimensions
|
|
Row #
|
Dimensions
|
|
Run Id
|
Dimensions
|
|
Sales Order #
|
Dimensions
|
|
Size
|
Dimensions
|
|
Size Equiv
|
Dimensions
|
|
Storage
|
Dimensions
|
|
Style
|
Dimensions
|
|
Tag #
|
Dimensions
|
|
Transaction Type
|
Dimensions
|
|
Transfer To Whse
|
Dimensions
|
|
Units Per Pallet
|
Measures
|
|
UOM
|
Dimensions
|
|
Variety
|
Dimensions
|
|
Variety Group
|
Dimensions
|
|
Vender PO #
|
Dimensions
|
|
Vendor
|
Dimensions
|
|
Warehouse
|
Dimensions
|
|
Warehouse Loc
|
Dimensions
|
|
Weight Factor
|
Measures
|
|
Weight UOM
|
Dimensions
|
Version 1.0.36
Updated:
09/08/2010
|
What's Changed:- Changed the Sales Order # field to reflect the order number the inventory was issued out of when the Receive Type field = 'Receive'
|
Version 1.0.35
Updated:
08/26/2010
|
New Fields:
|
Version 1.0.34
Updated:
05/07/2010
|
What's Changed:- Changed the Quantity field to reflect the actual quantity and not the IC quantity for Receive Type of 'Issue'
New Fields:- Product Class
- Product Group 1
- Product Group 2
- Product Group 3
- Product Group 4
|
Version 1.0.33
Updated:
03/30/2010
|
New Field:
|
Version 1.0.32
Updated:
02/16/2010
|
What's Changed:- Corrected a duplication problem that was occurring occasionally with consolidated tags
|
Version 1.0.31
Updated:
02/10/2010
|
New Fields:- Grower Address
- Grower City
- "Grower State
- Grower Country
- Grower County
- Grower Zip
- Lot Id
- Pool Id
- Run Id
|
Version 1.0.30
Updated:
02/09/2010
|
What's Changed:- Adjusted the Quantity field when the Receive Type = Issue to reflect the actual Issue Quantity for all transaction types.
|
Version 1.0.29
Updated:
12/10/2009
|
Removed Field:
|
Version 1.0.28
Updated:
12/09/2009
|
New Fields:
|
Version 1.0.27
Updated:
08/26/2009
|
New Fields:- Block Acres - The amount of acres for the block.
What's Fixed:- Fixed a duplication error when certain tags where both consolidated and transfered.
|
Version 1.0.26
Updated:
08/19/2009
|
What's Fixed:- Fixed the date format to include the time aspect so as to work correctly with the Fixed type format.
|
Version 1.0.25
Updated:
06/02/2009
|
New Fields:- Ship To City
- Ship To State
- Ship To Country
|
Version 1.0.24
Updated:
04/30/2009
|
New Fields:
|
Version 1.0.23
Updated:
03/24/2009
|
New Fields:- Packer Name
- Packer Id
- Size Equiv
|
Version 1.0.22
Updated:
10/30/2008
|
New Fields:
|
Version 1.0.21
Updated:
10/21/2008
|
New Fields:
|
Version 1.0.20
Updated:
08/08/2008
|
New Fields:
|
Version 1.0.19
Updated:
06/26/2008
|
New Fields:- Transaction Type - This is the Inventory Transaction Type with the following possible values: Receive, Pack, Repack, Transfer, Consolidate and Blank.
Line items with a Transaction Type of anything other than Blank will have their Issue Type Qty and other Issue Type related fields empty or zero. Line items with an Issue Type of anything other than Blank will have their Receive Qty and other Receive related fields empty or zero.
The above changes were made to ensure totals come out correctly regardless of grouping.
What's Fixed:- Corrected a bug where the Receive Qty was getting duplicated if a single pallet had more than one issue type associated with it.
|
Version 1.0.18
Updated:
04/23/2008
|
What's Changed:- Updated the Combine Flag field to now include three types "Normal," "Pre-Consolidated," and "Consolidated." This will allow you to see the consolidated inventory along with the items that where never a part of a consolidation.
|
|
|