Welcome Guest, you are in: <root>AFIweb • Login

Page History: Min-Max Report

Compare Page Revisions

6 5 4 3 2 1 0 Current 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Wed, 29 Apr 2009 14:38

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields (Header) Standard Report Fields (Line Items) Additional Report Fields for Customization

Default Menu Location¶

Reports >> Item Control >> Min-Max Report

Click here for a screenshot

General Description¶

Min-Max report screens allows users to see on-hand quantity, the location of merchandise stored.

Fields/Filters¶

Warehouse: Warehouse location or Warehouse codes

Class: Merchandise class

Beginning Item: Beginning item for the report

Ending Item: Ending item for the report

Commodity Code: The Commodity code

Vendor: Vendor name or code

Sort By: Preference to choose for the report

Include Only: Preference to choose for the report

Qty to Use: Preference to choose for the report

Standard Report Fields (Header)¶

Company

• company
  

Standard Report Fields (Line Items)¶

Item

• item
  

U/M Unit or Stock Measures

• unit_stk
  

Unit Cost

• avgcost
  

Whse

• alltrim(warehouse)
  

HeldFor

• heldfor
  

Owner

• company
  

On-Hand Qty

• lc_ref
• qty
  

Min Qty On Hand

• minqty
  

Max Qty On Hand

• Maxqty
  

Additional Report Fields for Customization¶