MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Inventory Control > Screens > Warehouse Balance > IC930S05 - Statistics

IC930S05 - Statistics

 

 

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.