Inventory Re-Order Information (Sales Products)


Inventory Control Menu -> Sales Inventory -> Re-Order Info -> Inventory Re-Order Information

Utilities Menu -> Inventory Control -> Update Make/Model Information -> Inventory Re-Order Information

Purchase Order Menu -> Purchase Order detail -> Order Qty field window -> window to Inventory Re-Order Information


This window can be accessed for Sales Inventory to define the re-order quantities with re-order multiple and order conversion values that are reported on the Sales Inventory Min/Max Report.

This window can also be triggered from Purchase Order entry on the Order Qty field, when the operator has role permission to update the Update Reorder Information on P.O. for Sales and Rental products as set in the Miscellaneous window of the Security Role Permissions.
If the operator does not have role permission, the re-order information is view only on the P.O. in the Update Make/Model Information window.

Many of the values in this screen can be updated using the Inventory Clean-Up export/import utility.

Other suppliers with their pricing for this product can be setup in the Alternate Vendor Purchasing table.

The re-order information that can be defined for this product, includes:

MIN INVENTORY QTY
Enter the desired minimum inventory quantity for this product. This is equivalent to the SAFETY STOCK LEVEL and it is used for re-ordering.
If inventory ordering is controlled by location for this product, this becomes the default minimum quantity for the locations.

This value can also be updated from the Edit Min/Max Utility, from the Update Re-Order Min/Max Qty's by Sales History and from the Update Product Min/Max import tool.


MAX INVENTORY QTY
Enter the desired maximum inventory quantity for this product.
This is used for re-ordering. The software will advise to re-order a quantity up to the maximum level.
If inventory ordering is controlled by location for this product, this becomes the default maximum quantity for the locations.

This value can also be updated from the Edit Min/Max Utility, from the Update Re-Order Min/Max Qty's by Sales History and from the Update Product Min/Max import tool.


RE-ORDER MULTIPLE
Enter the standard quantity for re-ordering this product.

e.g. If 3 cases are always ordered regardless of the quantity on hand, then the re-order/multiple is 3 and the Order UOM (Unit of Measure) is CASE.
It is sometimes necessary to exceed the Maximum Inventory quantity on the re-order report, to allow for the Re-Order Multiple.

If inventory ordering is controlled by location for this product, this becomes the default Re-Order Multiple for the locations.


RE-ORDER BY LOCATION
Uncheck this box to use these re-order quantities company wide for this product when ordering is NOT done by the individual location for this product.
Sales products that are not ordered by Location will always display Location as 'ALL' on the Sales Inventory Min/Max Report.

Check this box if this Sales product is re-ordered by location and record the location order details in the Re-Order Information by Location.
The icon is provide to re-access the Re-Order Information by Location window.

Note: If the primary order Min/Max quantities and/or Re-Order Multiple are changed for a sales product that is ordered by location, the Update Re-Order by Locations window is automatically triggered to provide the option to also update the location re-order values.


ORDER UNIT OF MEASURE
The Order UOM describes how the product is ordered.
e.g. BOX, CS (case), PKG (package), DOZ (dozen) or EA (each).
This descriptive field will accept up to 3 characters.

ORDER CONVERSION
This value is used to convert the quantity ordered to the quantity count entered into inventory during A/P Invoices.
e.g. Nails are ordered by the case, but sold by the box, with 10 boxes in the case. The order conversion is 10 for 10 boxes per case.

Note: The Order Conversion does not apply when stock is being returned using a negative quantity on the P.O. so the actual quantity to be returned to the supplier needs to be entered.
e.g. 3 boxes out of the case are being returned and should be returned on the P.O. as -3 quantity


ORDER CODES
The Product/Group Purchase Order Codes windows are provided to maintain order information notes that apply when re-ordering this product.
If no Order Codes are entered for the specific product then any Group Order Codes defined for this product's Group will apply.
PRODUCT ORDER NOTES
This version of the Product/Group Purchase Order Codes window can be used to Add or Delete notes associated with re-ordering this Sales product.

GROUP ORDER NOTES
This version of the Product/Group Purchase Order Codes window can be used to review Order Codes and the notes defined for this product's Group without the ability to change them.


SALE UNIT OF MEASURE
The field describes how the product is sold.
e.g. BOX, CS (case), PKG (package), DOZ (dozen) or EA (each). This descriptive field will accept up to 3 characters.

SALE CONVERSION
Used to convert the selling price to the quantity sold for each unit.
e.g. The price of glasses could be listed as $24.00 per dozen. If only one glass is sold, the price is converted to $2.00 each.

Order and Sales Conversion Examples

Example 1: Nails purchased by the case (with 10 boxes per case), are sold by the box (EA). Purchasing one case puts 10 boxes into inventory:

    ORDER U/M            CS        ORDER CONVERSION    10.000
    SALE U/M             EA        SALE CONVERSION      1.000
Example 2: Glasses are purchased by the dozen & are listed as $24.00 per dozen or $2.00 each.
(NOTE: they are stored in inventory as EACH to accommodate partial dozens)
    ORDER U/M            DOZ       ORDER CONVERSION    12.000
    SALE U/M             DOZ       SALE CONVERSION     12.000

RE-ORDER PRICE
This is the price used by the primary supplier when making new purchases of this item.

Alternate pricing for this and other suppliers can be setup in Alternate Vendor Purchasing, with varying Order Conversions and UOM.

The Re-order pricing is used as the ORDER COST when entering a Purchase Order.
If a new Order Cost is entered on a P.O., the operator is prompted to Update Re-Order Cost? This helps to keeps pricing current.

Any changes made to the Re-Order Price are tracked.
An audit report on history of Re-Order Price changes can be generated from Product Value Override Report.
Re-Order Price changes are also included in the more general Override Report.


RE-ORDER L.C.F.
This factor is used to calculate the Landed Re-Order Cost of the product in the local currency.
It must be updated manually.

LANDED RE-ORDER PRICE
This is the product cost in the local currency.
The Re-order Price * Re-order LCF = Landed Re-order Price.

SPECIAL ORDER
Check this box if this product is ordered specially and should be excluded from the Inventory Re-Order Report.
Uncheck this box to always consider this product when re-ordering inventory through the Inventory Re-Order Report.

NON-RETURNABLE AFTER
Enter the date after which this product is not returnable.

STOP P.O.s
This field can be used to flag products such as discontinued items, that should no longer be ordered on Purchase Orders.

Uncheck this box if the product is eligible for ordering on a P.O.
Check this box if this product should not be ordered on a P.O.

This flag is reflected in the Inventory Inquiry, and is respected for products in the details of the Purchase Orders, in Clone Products, in Generate P.O. From Worksheet, in Purchase Orders created from the Sales Order Totals, and in Purchase Orders created from a Contract using the Contract/Purchase Order Link feature.


MODEL NUMBER
Enter the optional model information, or select a standard model number from the "master list" using the Make & Model Search window.
The Model Number can be used in the Inventory Search filters to help find products, and it prints on many inventory reports including the spreadsheet output of the Equipment Summary Report.

MAKE
Enter the make of this item, or select a standard make description from the "master list" using the Make & Model Search window.
The Make also prints on many inventory reports including the spreadsheet output of the Equipment Summary Report.

CONTAINED IN CYLINDER
Sometime a container is required for the sale of a product such as gas or propane.
A window is provided to view the containers or cylinders that pertain to this sales product as outlined in Contained In Cylinder.

FUEL TYPE
Fuel Types are used by 'Texada Web to capture Fuel used on the Delivery/Pickups that is then billed to the associated Service or Sales Part, as outlined in the Product Fuel Types window.
Fuel types can also be used find a product in the Inventory Search window using a 'Fuel Type' filter.

If a single Fuel Type has been defined in the Product Fuel Types window then that Fuel description is displayed.
If multiple Fuel Types have been assigned, then the number of Fuel Type records is displayed.


ALLOW DISCOUNTS
Check this box to allow Special Pricing and discounts to be setup for this product.
Uncheck this box to disallow any Special Pricing or discounts for this product. The price can still be over-written at the counter, if required.

CYCLE BILL
Specific sales items should never be invoiced on interim billing runs.
e.g. Fuel

Uncheck this box if this sales product should never be cycle billed.
These items are not reflected in Unbilled Revenue Report as they are not invoiced until the contract is returned.

Check this box if this item should be invoiced on a cycle billing invoice.


DATE OF MANUFACTURE
An optional date that this sales product was manufactured can be recorded.
This date is displayed in the Inventory Inquiry, and reported on the Sales Inventory Value Report in the Product detail when the report is generated by Date, serialized and non-serialized, and Average Cost, and the spreadsheet output of the Equipment Summary Report.

SECONDARY PRODUCT NUMBER
Because Sales parts that are sold in packages are sometimes also sold singly, a secondary related product number can be identified here to track quantities of this product that are to be sold individually.
Providing a secondary product number allows partial sales and partial returns of the primary product, on Invoices, and Rental Returns.

This prompt appears for any Sales part that has NOT already been flagged as a Secondary Product #. If applicable, enter the Secondary Product number or look it up in the window.
The Secondary Product must be a Sales item in the same Product Class. It cannot be a serialized sales item, nor can it require a cylinder.
Then in the Re-order window of sales parts that have been identified as Secondary Products, the Primary Product # and description are displayed instead.

Leave this field blank if no Secondary Product is required.

SECONDARY PRODUCT QUANTITY
Enter the quantity in the package, that could be sold singly. This is the conversion quantity that is used when the Primary Product is transferred to the Secondary Product number.
The cost transferred out of the primary product number is at the average cost. This is then used in the cost calculation for the quantity transferred into the secondary product number.

This field does not apply if there is no Secondary Product number entered.


PRIMARY PRODUCT NUMBER
Alternatively this prompt only appears on a product that has already been identified as a secondary sales part in the "Re-Order window" of the primary sales product. This related Primary part number and description cannot be changed here.
Primary/Secondary Product Examples
Saw blades are generally sold in blister packages containing 5 blades.
  1. Using the Primary Product number, 2 packages (10 blades) could be put out on a Contract. If the customer used 7 of the 10 blades, the remaining three blades could still be returned to the Secondary Product number.
    • The actual processing shows quantity 1 of the Primary product sold, and quantity 1 of the Primary product returned.
    • Then quantity 1 of the Primary product is transferred out, and quantity 5 of the Secondary product is transferred in.
    • Quantity 2 of the Secondary product is then sold.
    This means that the rental return invoice shows a sale of 1 package of blades (Primary product) and a sale of 2 individual blades (Secondary product).
  2. If the individual blades (the Secondary Product) are sold on an Invoice, but there is not sufficient quantity available at that location, a window opens to allow the operator to break open a new package of blades (the Primary Product) to meet the quantity requirement.

    • The actual processing transfers a package or quantity 1 of the Primary product out, and a quantity 5 of the Secondary product is transferred in.
    • The sale quantity is relieved from the Secondary product number.

Manual transfers can be entered in Transfer Primary Items To Secondary Items.
No posting is required as both the primary and secondary products belong to the same Product Class, and transfers are not possible across divisions.
If transfers are made in error, negative transfers can be done in Transfer Primary Items To Secondary Items to reverse the conversion.


MISSING DATE
A date when this item went missing can be recorded.
If the item is missing, be sure to change the Status on the Fixed Asset Tag to M - Missing. This applies only to non-bulk items and is disabled for bulk products.
MISSING NOTE
Enter a comment about this missing item.
Use up to 40 characters. This applies only to non-bulk items.

DATE OF MANUFACTURE
The date that this rental product was manufactured can be recorded.
This date is displayed in the Inventory Inquiry, and reported on the Book Value Report when all products are included, by Owning Division, not Inventory Location, and the report is printed by Tag, sorted by Product, and on the spreadsheet output of the Equipment Summary Report

Note: The date becomes the model year and is mandatory on a non-bulk rental product for SmartEquip exports and can be updated by an import from the SmartEquip Compliance utility.
This date is mandatory for non-bulk rental equipment when the Mandatory Make/Model/Manufacture Date feature is activated in the Company Inventory Parameters, and also for non-bulk and for bulk equipment belonging to a Re-Rent Product Class, or when Rouse is activated in the Software Integration.


REFURBISH
Uncheck this box if this is NOT a refurbished product.

Check this box if this is a refurbished product.

REFURBISH DATE
Enter the date that the equipment was refurbished.

Note: This date is mandatory for non-bulk rental equipment when the Rouse feature is active in the in the Software Integration.


CYLINDER CONTAINS
This field only applies if the cylinder tracking feature has been activated in the Company Rate Parameters by assigning a Cylinder Contract Cycle Billing Day Code.
Refer to the Cylinder Settings section in Company Rate Parameters for an overview and parameter setup information.

If this rental product is to be used as a container such as a cylinder or bottle for a consumable sales product, enter the specific sale product that it will contain, or select it from the Inventory Search window.
Multiple cylinder rental products of varying capacities can be linked to the same sales product.
e.g. 40kg, 100kg

Note: The consumable sales product can not be a serialized sales part nor a primary sales product that is associated with a secondary product.

CYLINDER CAPACITY
Enter the capacity or volume of this cylinder or bottle.
This measurement is used to calculate the price to charge on the invoice for the consumable sales product as several containers can be linked to the same sales product.

Selling price = (cylinder capacity * price per unit of sales product) * number of cylinders

Note: If your firm has setup the full price per cylinder as the List Price for a consumable sales product in Sales Inventory, do not also enter the Cylinder Capacity or the price charged will be inflated on the invoice.


Measurements:
If product specific measurements are not defined then the measurements setup in the "Additional Options" of the Group are applied as the defaults.

Note: The Weight and Cubes values are used by the Winroute processing to determine truck scheduling as outlined in the Software Integration.

LENGTH
Enter the product length measurement if relevant.
This is information only that can be useful for delivery/pickup shipping.

WIDTH
Enter the product width measurement if relevant.
This is information only that can be useful for delivery/pickup shipping.

HEIGHT
Enter the product height measurement if relevant.
This is information only that can be useful for delivery/pickup shipping.

WEIGHT
Enter the product weight if applicable.
When a new product is added, this value defaults from the Weight as defined in the Groups.
Specific product weights can also be adjusted using Update Product Weight.

If the flag in the Company Inventory Parameters is set to display the weight, the total weight of rental and sales products is displayed in the Totals window on each counter document including Contracts, Invoices, Quotes, and Reservations.
The weight total is also displayed on the screen in P.O.s, and Orders, and when inventory is shipped in Record Quantity Shipped By Transfer, and the total shipment weight prints on the packing slip.
The Weight and Cubes values are used by the Winroute processing to determine truck scheduling.

The Clone Group Information to Products can be used to copy the weight defined for the Group to the existing products within that Group replacing any existing weight values.


CUBES
This is an optional standard shipping term that can represent a cubic or volume measurement, or a one-dimensional footprint measurement such as square feet.
Enter the Cubes value for this product to be used in the Winroute shipping calculation to determine truck scheduling.

Finished?
Click OK to proceed and exit this window.

Topic Keyword: RSPFWIN6
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)