 Field Descriptions Location Display only The location identification. The supplier that you normally purchase this product from. Sub-code The supplier's sub-code. Product Display only The product identification. Description Display only
Description 2 Display only The second description for this product. This field can be manually entered in Screen 1 of 5 of Product Maintenance. Some users like to store the UPC code or other product identification here because this field is displayed on the product detail screen (K3S_1040) and most screens where the product description appears.
On hand The amount of product in stock. Regular on order The amount of product that is currently on order from the regular supplier. Back orders The quantity customers have ordered from you that has not been shipped out. Hold out sum (Hold out summary) Display only The sum of hold out quantities for this product. One use is Bookings where Customer Booking information is interfaced or manually entered through the Special Program "Hold Out Quantities". Transfer pending Display only The quantity pending transfer from one location to another. One use is to transfer quantities where K3S has determined that a product is overstocked at one location and needed at another. It is also used where a product is not purchased from the manufacturer but is purchased from a different location (Hub).
Promotional (Quantity) The Promotional quantity represents how much inventory you think will be sold during the promotional period. Begin (Promotional Begin Date) The date the promotional period begins. Starting the Promotional Begin Date, the quantity in the Promotional field will be subtracted from the balance. End (Promotional End Date) The date the promotional period ends. Balance Display only A product's balance represents its stock status. After counting your inventory in stock, adding what is on order from the regular supplier and subtracting Back order quantities, Hold out quantities, Transfers pending and Promotional quantities, this is the quantity of product that K3S uses as available. This is an extremely important value as it triggers when K3S Replenish(R) will need to order this product to meet its service level goal. When a product's balance falls below its order point, a suggested order quantity is calculated. The balance is the sum of the inventory values. Example: On Hand ................... + 1000 Regular on order...... + 500 Back orders............... - 100 Hold out sum............. - 0 Transfer pending...... - 0 Promotional............... - 100 Balance = 1300 Unit Units are used to accumulate sums from products to meet minimums or maximums from their supplier. It may be that a supplier requires that Purchase Orders meet a minimum or maybe it is more economic to order exactly a truck load. The accumulation of product units appears on the Supplier Detail screen. For a product to be included in the totals it must have a value in the corresponding unit. The product's SOQ is multiplied by the current unit value and added to the supplier's P.O. values (except 5-Purchase increment which is a divisor). Notice that under Unit there are the numbers 3, 4, 5, 6, 7, 8 and 9. These represent units defined to fit your company's environment. This screen does not display Units 1 and 2. The dollar units are defined in other areas of Replenish. 3 – Weight 4 – Volume 5 – Purchase Increment 6 – Other 7 - Cube adjusted weight 8 - Unit 8 9 - Unit 9
Note: The unit values do not affect a product's SOQ, only the addition of the product's SOQ to the appropriate Supplier Minimum or Maximum. 3. Weight The weight of one product (this could be singles, pack, case etc.). Over-ride The product's weight that was manually entered. This value will replace the value in Current. To revert to the weight from your ERP system, key in all zeros and press enter. The next K3S night job will update Current equal to what is passed from the host. The weight of the product that is used to accumulate weight to the Supplier's Minimum or Maximum. . Divisor Display only The weight divisor works with the current weight value. As an example, the weight could represent the weight of a pallet while all other values represent layers. The divisor should then represent how much a pallet of product weighs. The product's SOQ would then be multiplied by the current weight factor then divided by the divisor to accumulate weight toward the supplier's minimum or maximum pallets. Over-ride Divisor The divisor can be manually entered here. 4. Volume The product's volume. Over-ride The product's Override Volume amount. If this field is blank, you know the current value was passed from the host. Current Display only The volume factor of the product used to accumulate volume from products to supplier. Divisor Display only The Volume divisor works with the current Volume value. If the volume factor in current is in an increment that is different from the product's other values, the divisor is used to make sure the volume for this product is in the same increment. In other words - apples to apples. This factor is used in accumulating volume up to the supplier's P.O. to meet minimums or maximums. Example: SOQ 324 Current Volume X 40 Divisor . /. 54 = Volume added to Supplier 240 Total The divisor can be manually entered here. 5. Purchase increment Purchase Increment is the one Unit that works as a Divisor to the SOQ to accumulate towards a supplier minimum or maximum.
Over-ride The product's Purchase Increment amount that was keyed in. If blank, the current amount displayed was sent from the host. Current Display only The Purchase increment used to accumulate this product up to the supplier's purchase order. Example: SOQ 324 = Purchase increment added to Supplier total 6 6. Other The user can set up an Other category such as gallons. The text for Units can be changed by K3S personnel. If changed, Gallons would show here instead of Other. Over-ride The product's Override amount for the Other category. Current Display only The Purchase increment used as a multiplier to accumulate this product's SOQ up to the supplier's purchase order. 7. Cube adjusted weight Unit 7 can be set up as Cube adjusted weight. Certain products such as cereal boxes can take up a lot of room in a truck but weigh very little. These products make it difficult to build the best full truck. The text for Units can be changed by K3S personnel. It was changed in our example to show Cube adjusted weight. Over-ride The over-ride amount represents the value manually entered. If this field is blank, you know the current value was sent from the host system. Current Display only The cube adjusted weight factor is used as a multiplier to convert the product's SOQ to cube adjusted weight. 8. Unit 8 This field is used to determine how to accumulate this product's SOQ to the supplier's purchase order. Unit 8 represents the value used to build minimum or maximum purchase orders for Suppliers. It can represent any unit you need to convert the product's SOQ to the value that is added to the Supplier's purchase order total for that unit.
Over-ride The product's Unit 8 value that was manually entered. If blank, the current amount displayed was sent from the host. Current Display only The Unit 8 value is used as a multiplier to accumulate this product up to the supplier's purchase order. This field is used to determine how to accumulate this product's SOQ to the supplier level purchase order. Unit 9 represents the value used to build minimum or maximum purchase orders for Suppliers. It can represent any unit you need to convert the product's SOQ to the value that is added to the Supplier's overall purchase order.
Over-ride The product's Unit 9 value that was manually entered. If blank, the current amount displayed was sent from the host. Current Display only The Unit 9 value is used as a multiplier to accumulate this product up to the supplier's purchase order. On order special Transfer Display only
Alt source Display only
Buy multiple
Orders Display only This is the value actually used to round the product's SOQ. Over-ride If an amount is manually entered, the value will appear here. If blank, no amount was manually entered. Interface Display only This is the value sent from the host. Minimum order qty This is the minimum amount that can be purchased of this product. When ordered, the system will make sure that at least this many will be ordered. Minimum Display only
Over-ride
Convenience pack This feature is available to allow internal savings when a product can be purchased at a cheaper price if bought in a package of a specified size. In our screen example the convenience pack is 540. 70% of 540 is 378. Once the SOQ reaches 378 or higher, K3S will bump the SOQ up to 540. Pack Display only This is the convenience pack size used to round the SOQ up to this level. Over-ride This is the manually entered value. If blank, the value was passed from the host. Threshold The threshold level is the percentage at which it is best to buy the convenience pack. This may mean ordering more than you need for service level goals. The product's SOQ will be rounded to the convenience pack value once the SOQ has reached this threshold.
|
|
|
K3S_3000 Quantity Criteria - Screen 4 of 5 |