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

Page History: Physical Inventory Worksheet

Compare Page Revisions

4 3 2 1 0 Current 4 3 2 1 0

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

Page Revision: Thu, 30 Apr 2009 17:02

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

Default Menu Location¶

Reports >> Item Control >> Physical Inventory Sheet Report

Click here for a screenshot

General Description¶

Physical Inventory Worksheet screen allows users to update the inventory on the worksheet if there is any discrepancies arise; the discrepancies quantity, the date, the item, and etc will be recorded.

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

Price Group: Price group

VendNo: Vendor number or code

Owner: Merchandise owner

Held for: Customer merchandise is holding for

Sort By: Preference to choose for the report

Standard Report Fields (Page Header)¶

Page

• "Page " + alltrim(str(_pageno))
  

Date

• "Date: " + dtoc(date()) + " at " + time()
  

Company

• company
  

Group Header 1¶

Warehouse

• "Warehouse: " + warehouse
  

Group Header 2¶

Held For

• "Heldfor: " + heldfor
  

Group Header 3¶

Company

• "Location:" + location
  

Group Header 4¶

Location

• "Location:" + location
  

Standard Report Fields (Line Items)¶

Item

• item
  

U/M: Units measure

• unit_stk
  

Unit Weight

• unitw
  

Description

• descrip
  

Serial/Heat#: Serial Number or Heat Number

• "Serial/Heat#:" + alltrim(ident)
  

Additional Report Fields for Customization¶