WILLIAMS CO 001 WAREHOUSE BALANCE FILE INQUIRY BEF 6/10/94
DSP01 WHS BEL SALES
Part Number BOLT-200 BOLT-200 NON-LOT CONTROL Type PUR SKU EA
Base Price 1.34 Qty Brk 1 100 Price/Dsc 1 1.3
Unit Cost 12.0000000 Qty Brk 2 200 Price/Dsc 2 1.2
Repl Cost .0000000 Qty Brk 3 300 Price/Dsc 3 1.1
Tran Price .0000000 Qty Brk 4 400 Price/Dsc 4 1.
LIFO Cost .0000000 Qty Brk 5 500 Price/Dsc 5 .98
LIFO Pool Price Code 1 Min G/M Pct .01000
Max G/M Pct .99000
Comm Pct .00000 Cash Disc Flag Y
Allow Remote Src Y Price/SKU Numer. 1
VAT Code V2 Price UM EA Price/SKU Denom. 1
F2=Command F3=Exit F5=Cycle Count F6=Description
F8=Statistics F9=Maintenance
This screen is used to display pricing, cost and other sales information for the specified combination of part/company/warehouse.
COMPANY/WAREHOUSE
Display only. The company/warehouse combination 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.
PART 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).
BASE PRICE
Display only. The standard unit price for the part without discounts or price breaks.
QUANTITY BREAKS 1 - 5
Display only. One of the optional pricing methods is to select the unit price or apply a price discount based on the quantity ordered, allowing a better price for larger orders. These are the quantities that must be ordered to be eligible for the corresponding price or discount, with the lowest quantity as Quantity Break 1. The quantity breaks may be used only if the price code is 3 or 4.
PRICE/DISCOUNT 1-5
Display only. This is the price or discount allowed for the corresponding quantity break. If the price code is 3, this is a unit price. If the price code is 4, this is a discount percentage. As an example, a 2% discount appears as 0.0200.
UNIT COST
Display only. Defines the standard cost per stockkeeping unit of measure for the part/warehouse.
REPLACEMENT COST
Display only. This cost is defaulted onto the maintenance screen as the Purchasing Unit Cost when purchase orders are recorded. The value is updated automatically each time a new purchase order is recorded with the most recently-used purchase cost.
TRANSFER PRICE
Display only. Defines the cost that is charged when this part is transferred from this warehouse to another warehouse. If left blank, the standard cost will be charged for the inventory.
LIFO COST
Display only. Defines the unit cost at the beginning of the period used for LIFO cost analysis.
LIFO POOL
Display only. May be used to group parts for LIFO cost analysis.
PRICE CODE
Display only. The price code defines the pricing method to be used when the part is sold to a customer. The price code for the part is used in conjunction with the price code for the bill-to customer to establish an order price. Possible values are:
0 - Non-saleable. The part cannot be sold.
1 - Manual. The price must be entered by the operator.
2 - Standard. The base price will be used.
3 - Quantity Price Break. The price will be determined based on the order quantity, the Quantity Breaks 1-5 and the Price/Dsc 1-5.
4 - Quantity Discount. A discount percentage will be applied based on the order quantity, the Quantity Breaks 1-5 and the Price/Dsc 1-5.
MINIMUM GROSS MARGIN PERCENT
Display only. A warning message will be generated in the Order Processing module when the gross margin for a sales order falls below the entered percentage.
MAXIMUM GROSS MARGIN PERCENT
Display only. A warning message will be generated in the Order Processing module when the gross margin for a sales order exceeds the entered percentage.
COMMISSION PERCENT
Display only. Used to associate a commission percent with the part for this company/warehouse.
CASH DISCOUNT FLAG
Display only. Specifies whether cash discounts (based on payment terms) are available for this part. Valid values are:
Y - Apply cash discount
N - Do not apply cash discount
The value in this field is used as a default in the Sales Order Maintenance and Quote Order Maintenance conversations.
ALLOW REMOTE SOURCING FLAG
Display only. This flag indicates whether this item can be supplied from a remote source. Valid values are:
Y - Yes, allow remote sourcing for this part.
N - No, this part cannot be outsourced.
TAXABLE FLAG
Display only. (Field is displayed only in a US tax environment.) Used to define whether taxes should be calculated for this part when it is sold.
VALUE ADDED TAX CODE/GOODS AND SERVICES TAX CODE
Display only. (Field is VAT Code or GST Code depending on environment) Using this field, the system associates a VAT or GST rate with the part. Each VAT or GST code has a related VAT or GST rate. Using the VAT or GST rate during Order Processing, the system calculates the tax for this part based on the order quantity.
PRICING UNIT OF MEASURE
Display only. Defines the unit in which pricing will be performed.
PRICE/STOCKKEEPING UNIT OF MEASURE CONVERSION
Display only. The factor required to convert pricing to stockkeeping unit of measure.
COMMAND KEYS
Enter - Return to the Function Select screen.
F2 - Display a window where a fast path option or mnemonic 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.
F8 - Display Statistics.
F9 - Enter Warehouse Balance Maintenance.
|