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

IC930S04 - Sales Data

 

 

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.