WILLIAMS CO 001 INVENTORY CONTROL BEF 6/10/94
DSP01 WHS BEL WAREHOUSE BALANCE FILE MAINTENANCE CHANGE (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
Remote Src Y Price/SKU Numer. 1
VAT Code V2 Price UM EA Price/SKU Denom. 1
F2=Command F3=Exit F4=Prompt F9=Inquiry
F10=Function Select F15=Rekey Data
This screen is used to define pricing and cost information for a part in the selected warehouse.
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 maintenance is being performed.
PART NUMBER/PART DESCRIPTION
Display only. The number of the part and its corresponding description for which the maintenance is being performed.
PART TYPE
Display only. Standard part types are defined on the Part Master file. Valid values 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.
BASE PRICE
Optional. The standard price per pricing unit for the part without discounts or price breaks.
QUANTITY BREAKS 1 - 5
Optional. 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. Enter the quantity that must be ordered to be eligible for the corresponding price or discount, with the lowest quantity as Quantity Break 1. Not all of the five quantities need be entered. The quantity breaks may be used only if the customer price code is Force Price 1 - 5 and the Item Price Code is 2 or 3.
PRICE/DISCOUNT 1-5
Optional. Enter the price or discount allowed for the corresponding quantity break. If the Price Code is 3, enter a unit price. If the Price Code is 4, enter a discount percent. As an example, a 2% discount should be entered as 0.0200.
UNIT COST
Required. Defines the standard cost per stockkeeping unit for the part/warehouse. Because the Manufacturing Warehouse Balance record is created when a part is added, the initial unit cost is set to zero. Validation rules are as follows:
o If the warehouse is the manufacturing warehouse, the unit cost may not be defined on the Warehouse Balance file, but must be defined using Part Costs Maintenance and the Product Costing facilities. The unit cost will equal the total material, labor, and burden costs calculated by a Product Costing current cost generation in conjunction with standard cost rollover, since this represents a standard unit cost.
o If the warehouse is a distribution warehouse that has a costing option of Standard (S), the unit cost may not be defined on the Warehouse Balance file and must be defined in Warehouse Costs Maintenance. The standard cost displayed here will be the sum of all cost elements defined for the part.
o If the warehouse has a costing option of Moving Average (M), the initial unit cost may be established on the Warehouse Balance file, but may not be modified. The unit cost of Moving Average parts is recalculated automatically with each relevant inventory transaction.
o If the part is a Reference Part, regardless of warehouse, the unit cost may be modified on the Warehouse Balance file.
o If the part is a Non-Standard part, the initial unit cost may be defined on the Warehouse Balance file, but may not be modified afterward. This is because a Non-Standard part is always treated as a moving-average costed part with respect to the warehouse in which it is carried.
REPLACEMENT COST
Optional. This cost is defaulted onto the maintenance screen as the Purchasing Unit Cost when purchase orders are recorded. The field is updated automatically each time a new purchase order is recorded with the most recently used purchase cost.
TRANSFER PRICE
Optional. Defines the cost that is charged when inventory is transferred from this warehouse to another warehouse. If left blank, the standard cost will be charged for transferred inventory.
LIFO COST
Optional. Defines the unit cost at the beginning of the period used for LIFO cost analysis.
LIFO POOL
Optional. May be used to group parts for LIFO cost analysis.
PRICE CODE
Required. 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 if the customer price code is automatic. If the customer price code is Forced Price 1 - 5, then the quantity price breaks that keyed in 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.
Price codes must exist on Reference File category 414.
MINIMUM GROSS MARGIN PERCENT
Optional. 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
Optional. 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
Optional. Used to associate a commission percent with the part for this company-warehouse.
DISCOUNT FLAG
Required. This field specifies whether cash discounts (payment terms discounts) are available for this part. Valid values are:
Y - Apply cash discount
N - Do not apply cash discount
The value in this field will be used as a default in the Sales Order Maintenance and Quote Order Maintenance conversations.
ALLOW REMOTE SOURCING FLAG
Required. 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.
STOCKKEEPING UNIT OF MEASURE/PRICE CONVERSION
Required. The factor required to convert pricing to stockkeeping unit of measure.
NOTE:
The same screen area displays the Taxable Flag (for non VAT environments), the Value Added Tax Code (for VAT environments), or the PST flag and the Goods and Services Tax Code (for GST environments).
TAXABLE FLAG
Required. (This field is not displayed in a VAT or GST environment) This field indicates whether or not tax is charged on this item. Valid values are Y (yes) and N (no).
VALUE ADDED TAX CODE/GOODS AND SERVICES TAX CODE
Optional. (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. If entered, the code must exist on Reference File category 308. The VAT or GST type for this VAT or GST code cannot be exonerated or suspended.
TAXABLE FLAG
Required. (This field is not displayed in a VAT environment.) This field indicates whether or not provincial tax is charged on this item. Valid values are Y (yes) or N (no).
PRICING UNIT OF MEASURE
Required. Defines the unit in which pricing will be performed. Must exist on Reference File category 005.
COMMAND KEYS
Enter - Process request.
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.
F4 - Display a list of values for the field where the cursor is positioned. If you select one of the items from the list, it will be returned to the application screen.
F9 - Enter the Warehouse Balance file inquiry program.
F10 - Return to the Function Select screen for option selection without updating any information that you may have entered on the screen.
F15 - Clear screen values.
|