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

Page History: Inventory On Hand Report

Compare Page Revisions

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

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

Page Revision: Thu, 30 Apr 2009 16:47

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

Default Menu Location¶

Reports >> Item Control >> Inventory On Hand Report

Click here for a screenshot

General Description¶

Detailed Inventory On Hand Report allows users to see where the inventory is stored, the pricing information, and the quantity.

Fields/Filters¶

Warehouse: Warehouse location or code

Class: Merchandise class

Beginning Item: Beginning item for the report

Ending Item: Ending item for the report

Commodity Code: The commodity code

Held for: Customer merchandise is holding for

Owner: Merchandise owner

Sort By: Preference to choose for the report

Group by: Preference to choose for the report

Include Only: Preference to choose for the report

As Of Date: Cut off date for the report

Standard Report Fields (Header)¶

Company

• company
  

Group Header 1¶

Group, Class, Commodity Code

• iif(empty(lc_group),'',iif(lc_group='Class','Class:' + iclass,'Commodity Code: ' + comcode))
  

Group Header 2¶

Held for

"Heldfor: " + heldfor

Group Header 3¶

Item

"Item: " + alltrim(item) + " / " + alltrim(descrip)

Standard Report Fields (Line Items)¶

Warehouse

• alltrim(warehouse) + ' / ' + location
  

Unit/Measure

• unit_stk
  

Unit Cost

• round(avgcost,4)
  

Qty On Hand

• qty
• lonord
• lalloc
  

On Hand Value

• round(avgcost * qty,2)
  

Group Footer: Item¶

Subtotal for item

• "Subtotal for item " + item
  

On Hand Quantity

• qty
  

On Hand Value

• round(avgcost * qty,2)
  

Standard Report Fields (Page Footer)¶

Group, Class, Commodity Code

• iif(empty(lc_group),"","Subtotal for " + iif(lc_group = 'Class',"Class " + iclass,"Commodity Code " + comcode))
  

On Hand Quantity

• qty
  

On Hand Value

• avgcost * qty
  

Additional Report Fields for Customization¶