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

Page History: Inventory Journal Report

Compare Page Revisions

9 8 7 6 5 4 3 2 1 0 Current 9 8 7 6 5 4 3 2 1 0

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

Page Revision: Mon, 08 Jun 2009 12:10

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Page Header)    Group Header 1: Whsen    Group Header 2: Heldfor21 Standard Report Fields(Detail)

Default Menu Location¶

Reports >> Item Control >> Inventory Journal Report

Click here for a screenshot

General Description¶

Inventory Journal Report screen allows user to generate a detail report journal from a specific time frame.

Fields/Filters¶

Start Date: Starting date for the report

End Date: Ending date for the report

Item: Item code

Held For: Inventory is being held for

Whse: Warehouse code

Rack#: Rack number

Owner: Inventory owner

CommCode: Commodity code

Serial/Lot: Serial or Lot number

Sort By: Report can either be sorted by Date or Commodity Code

Standard Report Fields(Page Header)¶

Company

• lc_company
  

Date Range

• iif(empty(alltrim(lc_para)), '( All )' , '( ' + alltrim(lc_para) + ' )')
  

Group Header 1: Whsen¶

Whse

• whsen
  

Group Header 2: Heldfor21¶

HeldFor

• heldfor21
  

Standard Report Fields(Detail)¶

Track #

• trackno
  

Trans Date

• iif(isnull(adddate),, adddate)
  

AcctDate

• iif(isnull(acctdate),, ttod(acctdate))
  

Item

• item9
• getudfanslotno("LOTCOLOR","zitemquest",1,tmplookup.ikey,"",tmplookup.seriallot)
  

Type

• note
  

Reference

• source
  

Serial/Lot

• seriallot
  

Quantity

• qty
  

Ext. Value(AvgCost)

• avgcost*qty