WILLIAMS CO 001 WAREHOUSE BALANCE FILE INQUIRY BEF 2/17/92
DSP01 WHS BEL STATISTICS
Part Number BOLT-200 BOLT-200 Type MFG SKU EA
Product Class PRODUCT CLASS 02 Subclass
Date Lst Shp 2/12/92
Current Period Year To Date Prior Year
Sales 126670.00 126670.00 .00
Cost Of Sales .00 .00 .00
Gross Margin 126670.00 126670.00 .00
Gross Margin Pct .000 .000 .000
Units Shipped 1000.000 1000.000 .000
Backorder Units Shipped .000 .000 .000
Lines Shipped 1 1 0
Units Per Line 1000.000 1000.000 .000
Margin Per Unit 126.67 126.67 .00
Margin Per Line 126670.00 126670.00 .00
F2=Command F3=Exit F5=Cycle Count F6=Description
F7=Sales F9=Maintenance
This screen is used to display sales statistics for the specified part/company/warehouse. Current Period, Year To Date, and Prior Year statistics are displayed.
In a multi-currency environment, the base currency is displayed in the upper right-hand corner of the screen, immediately to the left of the date.
COMPANY/WAREHOUSE
Display only. The company/warehouse in which the inquiry is being performed.
BASE CURRENCY
Display only. Base currency associated with company/location which is assigned to the company/warehouse. The field appears in the upper right corner of the screen to the left of the date field. ''
PART NUMBER/PART DESCRIPTION
Display only. The number and description of the part entered on the Function Select screen for which the inquiry is being performed.
TYPE
Display only. The type of the part as defined on the Part Master File. The standard part types are:
PUR - Purchased Part
MFG - Manufactured Part
RAW - Raw Material
PLN - Planning Part
REF - Reference Part
B/T - Build-Thru Part
N/S - Non-Standard Part
TRN - Transfer Part
NSK - Non-Stock Part
STOCKKEEPING UNIT OF MEASURE
Display only. The unit of measure in which the part is stocked in the warehouse (such as EA for Each).
PRODUCT CLASS
Display only. The product class associates the part with a cost of sales general ledger account and to define common parameters for similar parts. Valid product class codes are defined on Reference File category 426.
SUBCLASS
Display only. The product subclass can be used to provide a secondary grouping within product class.
DATE OF LAST SHIPMENT
Display only. Displays the last date on which the part was shipped.
SALES
Display only. This represents the sales for this part in this company/warehouse for the given currency.
COST OF SALES
Display only. This represents the cost of goods sold for this part in the given currency.
GROSS MARGIN
Display only. This represents the difference between the extended selling price and the extended inventory cost of all sales order lines shipped and billed.
GROSS MARGIN PERCENT
Display only. This is calculated as the Extended Price minus the Extended Cost, divided by the Extended Price times one hundred (100). This is calculated for all units shipped within the given period.
UNITS SHIPPED
Display only. This represents the units shipped from sales order lines for the part, sourced out of this company/ warehouse.
BACKORDER UNITS SHIPPED
Display only. This represents all the units which were back-ordered, filled, and shipped out of this company/warehouse.
LINES SHIPPED
Display only. This represents the number of sales order lines for this part which have been shipped out of this company/warehouse.
UNITS PER LINE
Display only. This represents the average number of units per line shipped.
MARGIN PER UNIT
Display only. This represents the average gross margin per unit shipped.
MARGIN PER LINE
Display only. This represents the average gross margin per line item shipped for this part.
COMMAND KEYS
Enter - Return to Function Select screen.
F2 - Display a window where a fast path option, mnemonic or an OS/400 command (if the user is authorized) can be entered. Fast path allows the next menu selection to be made directly from this screen. When the window is displayed, pressing F3 will remove it.
F3 - Exit program and return to menu.
F5 - Display Cycle Count information.
F6 - Display Description values for this part.
F7 - Display Sales information.
|