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

Page History: Inventory Serial Lot Report

Compare Page Revisions

3 2 1 0 Current 3 2 1 0

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

Page Revision: Mon, 08 Jun 2009 14:06

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Page Header)    Group Header 1: HeldFor    Group Header 2: Name    Group Header 3: Item Standard Report Fields(Details)    Group Footer Additional Report Fields

Default Menu Location¶

Reports >> Item Control >> Inventory Serial Lot Report

Click here for screenshot

General Description¶

Inventory Serial Lot Report screen allows users to generate an itemized inventory with serial numbers.

Fields/Filters¶

Item: Item Code

Warehouse: Warehouse location or location code

HeldFor: Inventory being held for

Rack#: Tracking number

Owner: Inventory owner

Serial/Lot: Serial or Lot number of the inventory

Standard Report Fields(Page Header)¶

Company

• company
  

Item

• lc_filter
  

Group Header 1: HeldFor¶

HeldFor

• heldfor
  

Group Header 2: Name¶

Whse

• name
  

Group Header 3: Item¶

Item

• item
  

Description

• descrip
  

Standard Report Fields(Details)¶

Track#

• "P" + ALLTRIM(STR(trackno))
  

Quantity

• qty
  

Serial/Lot

• serial
• lot
  

Group Footer¶

• "Total for " + alltrim(item)
• qty
  

Additional Report Fields¶