MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Inventory Control > Screens > Warehouse Balance > IC220S04 - Sales Data

IC220S04 - Sales Data

 

 

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.