Parameter

Description/Instructions

Date Span

Select a date span for computing the average usage and for displaying sales statistics. This can be whatever date span constitutes the most applicable trends for the products on the report. For most products, selecting the past one to six months can reveal applicable usage figures. The more subject to fashion and other trends an item is, the shorter and more recent the date span should be. For seasonal products, you can select a date span representing the same season last year. For example, if you are ordering for an upcoming summer season, you can select the date range for last summer. The reorder reports will then use last summer's sales and your current inventory position to determine suggested reorder quantities. If you are ordering for an upcoming promotion, you may want to use the time span of the last similar promotion. Leaving the date span blank causes the system to compute usage based on the past year. We recommend that you always enter the applicable date span. This is one of the most important parameters, since it affects the average usage figures.

Manufacturer Code

Product Line

Cost Center

Item Rating/ABC Code

Enter a single code to limit the report to that particular parameter. Optionally, you can leave these field blank to include all the applicable entities.

Warehouse Code

or Company Code

or Warehouse Group Code

Enter a single warehouse code to limit the report to that particular warehouse. Optionally, you can leave this field blank to include all warehouses.

You can sort reports to be separate for each warehouse, to display multiple warehouses under each item, or to combine multiple warehouse statistics into a single total per item.

If the warehouse field if left blank, you can specify a company number to include all warehouses within that company.

The Item Reorder Report can be run for an established group of warehouses that are referred to as “warehouse groups”. Warehouse groups can be specified allowing the inclusion or omission of warehouses from the report. The warehouse groups, which are used only for reordering, are created within the Reorder Reports parameter. The Warehouse Group option enables you to specify which of the warehouses included on the report should be considered the “distribution center”. The distribution center warehouse is usually the warehouse where imports are received prior to shipment to other warehouses.

When you select the “Warehouse group option, you are effectively considering the available product in this warehouse to be part of the cumulative future availability that can service the other warehouses in the group. In effect, the distribution center is like a port - a temporary holding place for material that is moved to your other branches/warehouses.

Note:   Version 6 includes an option that works well with the warehouse groups concept.

Note:  If you try to enter a single warehouse and a warehouse group, you will receive an error message. You cannot specify both. You may specify a company number as well as a warehouse group. If there are warehouses in the group that are not in the specified company, they are omitted.

Item Class

Enter a single item class to limit the report to that particular item class. Optionally, you can leave this field blank to include all item class. This parameter will actually test all three item class fields. Therefore if your item class 1, 2, and 3 codes are all unique, this parameter can access any item class. If you have used the same codes in multiple classes (1, 2, or 3) then the results are unpredictable.

Supplier Code

Enter a single supplier code to limit the report to that particular supplier. Optionally, you can leave this field blank to include all supplier codes. This supplier number relates to the Usual Supplier# field in the Item File.

Reorder/Buying Category

Enter a single reorder/buying category to limit the report to that particular buying category.

Use this code to define the buyer of the product line, or to group product lines for efficient use of the reorder reports. Selecting a reorder/buying category will list only the product lines in that category. Since this field is used exclusively for purchasing, it provides the most efficient way to request reorder reports.

Color Number

Enter up to four characters of the color number to limit the report to that particular color number. Optionally, you can leave this field blank to include all color numbers. The color number is the four characters of the item number that immediately follow the manufacturer code.

Enter a growth factor % to apply to future quantities

This field enables you to apply a simple global growth factor to your usage figures. The growth factor% is controlled via the field Enter a Growth Factor% to be applied to the Usage/Activity Qtys.

For example, if you expect 10% growth over the historical usage averages, then enter 10.00 in this field. If you expect a 10% decline, enter 10.00- in this field. The average usage figure (and average activity figure) will be adjusted by this percentage, up or down.

It is recommended that this field be used to adjust for upcoming promotions, seasonality, and other instances where you expect a change the system cannot predict. You can also use this concept after a promotion. For example, if you are basing the forecast on the past three months usage, and there was a promotion during those months, you may want to apply a negative growth factor when the promotion ends.

Enter your own list of Items and/or Product Lines?

Select Y to enter your own list of item numbers or product lines. If you enter Y, an additional screen appears which enables you to request a specific list of manufacturers, product lines, and item numbers.

The additional screen appears after you have completed this screen and click next.

Parameter

Description/Instructions

Select Sort

• Option 1 shows all selected warehouses under each item. The default is option 1.

• Option 2 shows all items for one warehouse followed by all items for the next warehouse.

• Option 3 causes an additional Selection Screen to display with several more sort options. For example, an additional sorting option accessed via option 3 is option J which sorts inventory reports by Item description within each supplier, based on the Usual Supplier field in the Item Master File. We recommend this option for suppliers or cost centers that do not have meaningful or logically sequenced item numbers.

List ONLY Items that need to be reordered?

Enter Y to limit the report to only those items that require reordering. Only items that cause the system to suggest a reorder will be printed. Enter N to list all selected items. N is the default.

Totals

Use the first option to combine totals for the lots and warehouses within each item listed in the report. Each item will only show a single line of information which includes all lots and warehouses, according to the sort and selection criteria.

Use the second option to list each lot number and warehouse. Be careful not to confuse lot number with serial number or shade. This option shows each lot and warehouse on a detail line followed by a total for the item. The second option is the default.

Display Statistics and Usage

The report can show average weekly usage or average monthly usage.

M is the default.

List Serial Numbers

Enter Y to list each serial number under each detail line on the report. Along with the serial numbers are the quantities, receipt dates, shades, and status codes of each serial number. If any back orders exist for an item or warehouse, they are shown as a negative “blank” serial number.

Enter S to show a serial number summary. The summary shows the number of serial numbers available, the average quantity per serial number, the median quantity of all serial numbers, the largest serial number quantity, and the standard deviation for all serial numbers. These five statistics are shown instead of showing each individual serial number. The serial number summary combines multiple bin locations of the same serial number. The list of serial numbers shows each bin location separately.

Trim

Option 3 - to include items regardless of trim class is the default.

Items are designated as trim by entering a trim class code in the Item Master File. Your trim or support products often sell in very different and erratic cycles than your core products. They usually require different reorder parameters, and you may want to analyze them separately.

Omit Remnants From Availability Calculations

Enter Y to cause the Reorder Reports to compare the available quantity of each serial number to the remnant quantity as entered in the Item File. If the quantity available of a serial number is not greater than the remnant quantity, it is eliminated from the available total for the SKU. N is the default.

You can include or omit remnants from the availability calculations. Remnants are available quantities of a single serial number or lot number that are less than or equal to the remnant quantity/size as entered individually for each item in the Item Master File. This concept only applies to material that usually must be sold from the same or matching serial numbers, lots, or rolls. This parameter is ignored for items that are not stocked by serial or lot number. If you choose to omit remnants, the reorder report ignores the available quantity of any serial or lot number that is less than the remnant quantity in the item master record.

For example, let's say the total quantity available = 1000, consisting of three serial numbers of 900, 25, and 75. If the remnant size is 80, then the Reorder Report only considers that you have 900 available.

Report Versions 

To select more than one report version simultaneously, string together the versions in any sequence. For example, entering version number 153 simultaneously runs versions 1, 5, and 3. Versions 7 and 8 can only be run simultaneously with version 1 and each other.

Version 1

Worksheet - lists supporting information to be used in conjunction with other versions. Once you are familiar with all the reports, this version may not be necessary.

Version 2

Report with Suggested Reorder Quantities - determines suggested reorder quantities based upon the usage and the reorder parameters you have entered. This version can be lined up exactly side by side with Version 1 for easy cross reference between the two reports.

This version shows subtotals of the net available inventory after lead time figure by product line. This subtotal is useful for product lines whose items all share the same native unit of measure.

This version also includes two recaps at the bottom of each report. The first recap is by supplier and the second recap is by manufacturer. The recaps summarize the suggested reorder quantities by weight, pallets, number of items, and value ordered.

Version 3

Create Purchase Orders For Suggested Qtys - is not a reorder report. It is a purchase order edit automatically created for the items with a suggested quantity to order. It can be used in conjunction with one or more of the other versions. The goal of setting up purchasing parameters is to be able to use this option to generate automatic purchase orders.

When you select Version 3, the system goes through the process of creating a reorder report, and then automatically creates a purchase order for items that would appear on the reorder report with suggested order quantities. You can then use the Purchase Order Entry program to modify the edit and issue as an actual purchase order.

Version 4

Inventory Forecasts - tests your reorder parameters. The report shows either a 12-week or 12-month forecast (depending upon your choice of weekly or monthly usage) using current inventory status and assuming that average usage remains constant. The purpose of this report is to see what would happen to your stock levels if the system was to run on “auto pilot” based upon the reorder parameters in the Product Line, SKU, and ABC Files. The report deducts the average usage each week or month, and then illustrates when new purchase orders would be generated and received, and what the quantity available would be each week or month. You should then compare the stock levels achieved with the quantity to stock parameters you have entered. If the available quantity is consistently and significantly lower or higher than your desired quantity to stock, then your reorder parameters may need adjusting. Important: If your reorder frequency or lead time is less than one month, then only run this report with weekly usage in order to list meaningful data.

Version 5

Gordon Graham Format - contains certain attributes that are consistent with those recommended by Gordon Graham, who writes and lectures on inventory control for distributors. It expresses each statistic in actual quantity and in weeks or months. It also shows a six month trend regardless of the date span selected for usage. The six month trend shows the sales each month. Underneath the sales is an “S” whenever the month ended with an “Out of Stock” condition. An “S” will often explain low sales levels in that or the following month.

Version 6

Importing Format - is intended primarily for companies who allocate purchase orders and customer back orders to specific vessels or shipments. Version 6 displays availability statistics separately for current stock and for each incoming vessel or shipment.

This version can be run in the following formats:

• Regular

• Cumulative Months available by vessel - shows the future cumulative quantity available (expressed in months) by vessel by day.

• Distribution Center - shows the future cumulative quantity available. Additionally this format designates one warehouse as a distribution center, and calculates availability using a special formula.

Version 7

Activity Format - has similarities to versions 2 and 5, but uses a very different inventory concept referred to as activity. Activity replaces usage in all formulas used for reordering on this version. Activity is defined as sales plus the change in open order quantities for the selected date span.

Version 7 of the report contains the following columns:

• Activity - Quantity sold plus the change in open order position in the selected date span.

• Average Activity - Activity divided into the number of weeks or months as shown.

• Back Orders - Quantity of open customer back orders.

• Stock Allocated - Quantity of open customer orders that are allocated against stock. Total allocated equals the sum of the back orders and the stock allocated.

• Pre-Receipts - The quantity in transit from supplier. Located in Pre-Receipts File, but not in inventory yet.

• Scheduled - The quantity of open purchase orders less those also in pre-receipts.

An additional parameter screen is displayed when Reorder Report version 7 is selected. The following options are:

• display a single line on the report for every SKU record shown. The single line displays figures primarily in total quantities.

• print two lines for every SKU record. The first line is primarily figures expressed as total quantities. The second line shows averages per month or week. The six monthly columns show activity per month, with sales per month underneath.

This version includes two recaps at the bottom of each report. The first recap is by supplier and the second recap is by manufacturer. The recaps summa­rize the suggested reorder quantities by weight, pallets, number of items, and value ordered.

Version 8

Create Purchase Orders using Activity instead of Usage - Version 8 (create Purchase Order Edit) is the same as Version 3 except it is based on activity instead of sales. Version 8 uses the same formulas and logic as Version 7.

Version 9

Fill Rate and Ranking Report - is not actually a reorder report. It is an item ranking by sales activity which shows the fill rate of your top items. This report shows how good (or poor) a job you do at keeping top sellers in stock.

The Fill Rate version of the Reorder reports is a logical place to show lost orders because fill rates and lost orders go hand in hand.

This report version includes an additional parameter screen.

Select reorder point

If you enter Y, the Reorder Report programs checks both the Product Line and SKU File reorder points, and uses the greater of the two reorder point values. Use this option if your SKU File reorder point is set as a “minimum” quantity, yet you want to reorder earlier when sales or demand is rising. During rising sales, the product line parameters might dynamically figure a higher reorder report than the minimum quantity set in the SKU File Reorder Point field.

If you enter X, the program checks both the Product Line and SKU Files for reorder points and quantities to stock. The program uses the greater of the two values for each of the fields. For example, if the SKU File reorder point is used, then so is the SKU file quantity to stock.

N is the default.

List individual P.O.s & quantities under total scheduled quantity?

If you enter Y, each open purchase order will print under the corresponding items and warehouses. The purchase order number prints along with the ETA, the quantity ordered, and the status. If you use this option, we recommend that you also use the following pre-receipts option. N is the default option.

List individual back orders under total allocated quantity?

If you enter Y in this field, each open customer back order prints under the corresponding items and warehouses. The customer's name, order number, status, and quantity of each back order is shown. N is the default.

List all unposted pre-receipts on reorder report?

If you enter Y, the Reorder Reports will list all unposted pre-receipts under the corresponding items and warehouses. The pre-receipts list with the quantity, serial number, shade, and receipt date. Pre-receipts are receipts that have been entered into the Receiving System, but not yet posted into the actual inventory files.

List individual lost orders under sales?

Lost order information can be included in Reorder Reports. This functionality pertains to versions 1, 2, 5, 7 and 9.

An order may be considered “lost” due to several reasons such as the following:

• You do not carry the product the customer is requesting

• The price was too high

• The item was not available and back order time was too long

• The specific dye lot could not be matched

The following entries are available:

• Y - generates a detail list of lost orders for the entered date range shows. Essentially each lost order is displayed on the report. This is similar to the detailed lists of purchase orders, back orders, and pre-receipts that are also available.

• S - a summary line is added for each item showing the monthly lost order averages and also the corresponding monthly sales and activity figures. This adds a line to each item on the reorder report(s).

Select a warehouse to generate P.O. Edits with suggested reorder quantities. Enter ALL to generate P.O. Edits with suggested reorder quantities for all warehouses.

This parameter is used only if you have selected Version 3 or 8, which creates automatic purchase orders.

Enter a specific warehouse to direct all automatically created purchase orders to that warehouse. Enter ALL to automatically create purchase orders for all warehouses that show suggested reorders. This method is a perfect compliment to the stocking matrix option. Purchase orders are automatically created for the items and warehouses that need to reorder material. In most cases, ALL is the recommended option.

The warehouse ALL causes purchase orders to be created at the SKU level instead of the item level. This means that POs for multiple warehouses can be created in a single run of the reorder programs. The ALL warehouses parameter also activates the use of SKU level reorder parameters, such as fixed quantity stocking levels. Note: This is even true when you have selected only a single warehouse to include.

Adhere to the following guidelines:

• Entering a specific warehouse in the Auto PO Warehouse parameter causes the reorder system to create POs at the item subtotal level, diverted to the specified warehouse.

• Entering ALL as the Auto PO Warehouse parameter cause the reorder system to create POs at the default warehouse (SKU) level.

• Leave blank to direct automatically created purchase orders to the last warehouse needing a reorder that is shown on the report for each item. This option may have unpredictable results in a multiwarehouse environment.

Item Type

1- Stock Only - suggest quantities to order based upon all of your reorder parameters - lead time, order frequency, desired days to stock, etc. The programs order to cover all customer orders and reach the desired days to stock.

2 - Non-Stock Only - suggest quantities that fill the back orders for non-stock items. These do not include special orders, which are already managed by the special orders system. All of the logic for determining optimum reorder quantities for stock items is bypassed for non-stock items. It is replaced by the following formula; suggested reorder amount for non-stock items equals zero minus net available if net available is negative. In other words, back orders are covered by ordering the exact amount back ordered. No stock quantities are ever suggested for non-stock items. This allows a thorough and seamless ability to generate automatic purchase orders for all items.

3 - Both Stock & Non-Stock - This is the recommended reorder method, for each supplier it will order both stock and non-stock items on the same purchase order. Stock items are brought up to your desired days to stock, and non-stock items are ordered only to fill back orders.

4 - Back Orders Only - This method should be used when:

• Due to cash restraints, you can only afford to purchase what you need to fill orders in house, rather than buying for stock.

• You can not wait to fill a truck, and you need order on an LTL basis to cover your back orders.

This option has no affect on how non-stock items are purchased, because only back orders are ever covered for non-stock. However, for stock items it will only order enough to cover the back orders, instead of enough to achieve the desired stock quantities. An example of how this option can be helpful, is if you need to order on an emergency basis, and don't have time to fill your next truck. You are filling on an LTL (less than truckload) basis, and just want what is absolutely needed to fill the back orders in house.

Notes about option 4:

• Supplier purchasing rules apply

• If the ISO setting “cannot mix serial numbers” is off, the system orders what is back ordered less what is still available in stock. If the ISO setting “cannot mix serial numbers” is on, then the program ignores available quantities and covers the full back order qty.

• Existing open P.O.s are considered. If enough is already scheduled, the system will not create another P.O.

• In the Qty-To-Stk column, non stock items usually show “NON-STK”. When “back order only” is selected, the message “BOs ONLY” is printed, so users are aware that only back orders are being covered, and not the qty to stock (this applies to versions 2,5,7).

• If the program finds there are back orders - and there is available stock > or = to the back orders, then a warning is printed “note: available stock is > = back orders”. The program assumes that you back ordered the items because of shade/dye lot considerations, but will warn you “just in case”. (versions 2,5,7).

All of this logic is only applied when the default option of “2” to List Each Lot# & Warehouse Sub-Total Within Each Item on the second screen of settings is selected.

Ignore back orders required after this date

This field enables you to buy only enough products to cover back orders through a specified date.

The reorder reports also include a note at the bottom, indicating if this option is used. Furthermore, if you use the reorder report option that lists all back orders, back orders that are omitted from the availability calculations on the report are noted with **.

This option does NOT affect the “Inventory Activity” calculation. Activity still includes all back orders. However, report versions based upon Activity are affected, because the future back orders are removed from the allocations used to calculate availability. Therefore reports based upon either usage or activity omit the future back orders, and do NOT purchase those quantities. The activity calculation, which is a measure of trends in open orders, is still influenced by all back orders.

Note:   You may also set the Enter “Y” to list individual back orders under total allocated qty field to Y to list back orders, and all individual back orders will be listed on the report.

The back order date works as follows:

Any back orders that have a “date required” greater than the date specified are omitted from the availability calculation. In other words, the program will NOT attempt to purchase material to fill those future back orders. The quantity available is not reduced by those future back orders.

For example, if you have none onhand and four back orders for an item:

• 500 required on 10/15/03

• 300 required on 10/31/03

• 400 required on 11/15/03

• 800 required on 11/25/03

If you exclude back orders after 11/01/03, the quantity available is considered to be <800>, (0-500-300), and the program orders at least enough to cover that 800. If you do not enter a date, then all back orders are considered, and the quantity available is <2000> (0-500-300-400-800). In that case, the program orders enough to at least cover 2000.

The affected back orders appear on the report but are denoted with astericks (**).

Field

Description

Print quantities in

• 1 to Print Quantities in Native (Usual) U/M - This option is the default. It causes the report to print in the normal unit of measure. The normal (native) unit of measure is the unit measure in which an item is priced.

• 2 to Print Quantities in Sales U/M - This option converts the report to the sales unit of measure for each item as defined in the Item File. For rolled goods, this options causes the report to print in RL (whole rolls).

• 3 to Print Quantities in Pick U/M - This option converts the report to the pick unit of measure for each item as defined in the Item File. For rolled goods, this option causes the report to print in LF (lineal feet). For items with a pick unit of measure of PC, EA, CT, or blank, the report attempts to convert to cartons (CT).

•  4 to Print Quantities in Order Entry U/M - This option converts the report to the Order Entry unit of measure for each item as defined in the Item File. This unit of measure will always be the pricing unit of measure.

•  5 to Print Quantities in Supplier U/M - This option converts the report to the supplier unit of measure for each item as defined in the Item File. If the supplier's unit of measure is properly set in each item, this is the most logical choice. This creates the Reorder Report in the unit of measures in which the supplier expects you to order.

Use the Stocking Matrix File?

A stocking matrix is a set of rules which govern where stock is carried to meet the demands of each geographic grouping of customers. If you do not use the Stocking Matrix File, the system assumes that stock should be replenished to the warehouse where it was stocked. Enter Y to use the stocking matrix in order to calculate usage.

Parameter

Description

Rank By

Enter S to cause the report to be sorted, highest to lowest, based on sales. Enter A to cause the report to be sorted, highest to lowest, based on order activity.

Only print the top percent of the Running/Cumulative Sales or Order Activity

Enter a number between 1 and 100 to control through what percentage of cumulative sales or order activity to print. 80% is the default. For example, if you enter 80, only the items representing 80% of cumulative sales or item activity are printed. This leaves off the items comprising the bottom 20%. Usually you are interested in the fill percentage of your top items.

Page Break and Ranking

Enter 1 to run a single cumulative ranking report. All selected items are ranked by sales or order activity. Enter 2-7 to run separate ranking reports, with a page break after each one, based on the categories shown.

• Enter 2 to sort by sales or order activity within each Manufacturer.

• Enter 3 to sort by sales or order activity within each Product Line.

• Enter 4 to sort by sales or order activity within each Item Class 1.

• Enter 5 to sort by sales or order activity within each Cost Center.

• Enter 6 to sort by sales or order activity within each ABC Code.

• Enter 7 to sort by sales or order activity within each Buying Category - If each of your buyers are represented by a buying category code, use this option to check each buyer's fill percentage.

Consider an Item to be “In Stock” if

This option determines how the report should consider an item to be in stock or not. Select one of the three options:

Items are considered “in stock” if the quantity available is at least equal to the average sales quantity per invoice.

Items are considered “in stock” if a certain fixed quantity is available. To select this option, enter the fixed quantity representing an “in stock” quantity.

Include back orders against available quantity

Enter Y to include back orders in the total allocations.

Enter N to omit back orders from total allocations. Only include orders allocated against stock. This option causes your fill percentage to be higher. However, this may give a more fair analysis, as items that have stock that can be sold can be counted as `in stock”, even though back orders can exist. Sometimes back orders are created in order to have special shade or dyelots, and not because you are actually out of stock.

Include lost order stats

Orders may be considered “lost” due to several reasons such as the following:

• You do not carry the product the customer is requesting

• The price was too high

• The item was not available and back order time was too long

• The item could not match a specific dye lot

Term

Description

onhand

The amount physically in stock.

allocated

The amount of stock committed to customer orders.

available

The amount onhand less the amount allocated.

scheduled

The amount currently on open purchase orders (on order) from suppliers.

net available

The amount available plus the amount scheduled, It is the total available including what is on purchase orders.

net available after lead time

Net available after lead time is the amount you will have net available after a time frame equal to your lead time. If this figure is negative, you will probably be out of stock even if immediate action is taken. Net Available After Lead Time equals Net Available less lead time in weeks multiplied by average weekly usage.

credited returns

Amount in credit memos that was automatically received to stock by the invoicing program.

usage

The total quantity sold in selected date range unless it is expressed in weeks or months, in which case it is the average per week or month.

average usage

The total usage (quantity sold in date range selected on report) divided by the number of weeks or months in the selected date range.

reorder amount (or reorder quantity)

The quantity to reorder based on the average usage and the reorder parameters in the Product Line, ABC, Purchasing Rules, and SKU Files.

suggested quantity to reorder

The quantity to reorder which will cause net available to equal the amount to stock within the lead time (amount needed in order to achieve the amount to stock based upon usage and the reorder parameters).

quantity sold

The total quantity sold within the date range selected for the report.

highest qty sold

The largest individual sales quantity in the date range selected for the report.

months available

The quantity available divided by the average monthly usage.

weeks available

The quantity available divided by the average weekly usage.

months scheduled

The quantity scheduled divided by the average monthly usage.

weeks scheduled

The quantity scheduled divided by the average weekly usage.

fill percentage

The percentage of quantity that was ready for invoicing (not including back orders) that was actually invoiced. This statistic is calculated from invoices only, not from open orders. For example, if an order for 100 each is invoiced as 100 each, that is a 100 percent Fill%. If an order for 100 each is back ordered it does not affect Fill% until it is invoiced. If an order for 100 each is invoiced as 95 each, that is a 95 percent Fill%. The fill% shown on reorder reports is accumulative Fill% for each product, including total quantity invoiced for date range.

demand

Actual usage divided by Fill%. If Fill% is less than 100%, then demand was higher than actual use.

transfers

The quantity transferred on stock-to-stock transfers. Stock-to-stock transfers are processed via the stock transfer account, or by using the Inventory Transfer program. Stock-to-stock transfers are not included in usage. However, Version 5 of the reorder reports lists transfers next to usage and demand.

Largest Serial#

The serial number with the largest available quantity. For non-rolled goods all bin locations with the same serial number, for an item at the specified warehouse, are combined and then sorted to determine the largest serial number.

Average Serial#

The average quantity available of all available serial numbers for the specified item and warehouse. For non-rolled goods all bin locations with the same serial number and warehouse are combined before being averaged.

Median Serial#

If there is an odd number of available serial numbers, the median is the quantity available of the middle serial number, when sorted smallest to largest. If there is an even number of available serial numbers, the two middle serial numbers are averaged to compute the median. For non-rolled goods, all bin locations for the same serial number and warehouse are combined before calculating the median.

Standard Deviation

The average deviation, in quantity, between all serial numbers and the average serial number. For non-rolled goods, all bin locations for the same serial number and warehouse are combined before calculating the standard deviation.

Activity

When reorder reports versions 7 and 8 are requested, quantity sold is replaced by activity, and average usage is replaced by average activity. Activity equals the quantity sold plus the change in open order quantity within the specified date span.

Stock Allocated

The portion of the allocated figure that has been assigned to stock. (Allocated - Back Orders = Stock Allocated)

Quantity Backordered

The portion of the allocated figure that has not been assigned to stock. (Qty Back Ordered = Allocated - Stock Allocated)

Field

Description

Company

Warehouse

Manufacturer

Item

Use these fields to narrow the report to a specific company, warehouse, manufacturer, or item number.

Sort Customer Back Orders By

Determines the order that the back orders appear on the Back Order ETA Report. However, the first sorting priority is the Customer Priority.

Global Warehouses

Purchase orders for these warehouses can be used to fill back orders for any other warehouse. For example, you can enter the code for a warehouse that acts as a distribution center.

Assign Priority to Customers By Type and ABC Code

Use this section to determine which customers get their back orders filled first. The Customer type and ABC code ratings work together to ensure your best customers automatically receive preference when filling back orders. Give your best customers a high priority by assigning a low priority sequence number. The lower the number, the higher the priority.

Customer Types are two-character codes that represent the type of business or service a customer is involve in. For example, CO could stand for contractor or HC for home center.

Note:  A customer type code is assigned to each customer in the Customer Type field of the Billto File.

ABC codes enable you to categorize and rate customers and items. For example, you might designate your most important customers with an ABC code of “A”.

Note:   ABC codes are created using the ABC Code File (FIL 34) and are assigned to customers via the Billto File (FIL 1).

Access Production Schedule Files

This setting is for companies that have a manufacturing plant, or can receive production schedules from a supplier. Activating this setting directs the system to check these production schedules (via a file entitled PSCHEDULE), to see if a production date can be found for a back ordered item, and if no PO is found first, that production schedule date is used as the back order ETA date.

Status Code to use when BO is updated based on Production Schedule

If you use manufacturer or supplier production schedules to update your back order ship dates, you can automatically assigned the status code entered here to the back order detail lines.

Since several of the available order status codes are user defined you can create a status code that means “back order date is based on production schedule”.

Some of the user defined order status codes are @, $, %, G, M, N, W, Y, Z.

Note:  Unlike system-defined order status codes, user-defined status codes have no implicit meanings within any system programs. For example, whereas the system recognizes that status codes X, A, and S are used within the picking and shipping activities, the system does not attempt to assign meaning to the user-defined codes.

Update Date & Status of Back Orders?

When this field is activated, the detail lines on the back order are changed to reflect any new dates procured from purchase orders or production schedules.

The status of the detail line is also updated to the entry made in the setting above.

When no PO available for BO item, update the BO line ETA date to 2/22/22?

Back Ordered lines are dated 2/22/22 if there are no POs or Production Schedules that can fill them.

Field

Description

Date span for calculating average usage and activity

Enter a date span for computing the average usage and activity. This can be whatever date span constitutes the most applicable trends for the products on the report. For most products, selecting the past one to six months can reveal applicable usage figures. The more subject to fashion and other trends an item is, the shorter and more recent the date span should be. For seasonal products, you can select a date span representing the same season last year. For example, if you are forecasting for an upcoming summer season, you can select the date range for last summer. The forecast report will then use last summer’s sales and your current inventory position to determine suggested reorder quantities. If you are ordering for an upcoming promotion, you may want to use the time span of the last similar promotion. Leaving the date span blank causes the system to compute usage based on the past year. We recommend that you always enter the applicable date span. This is one of the most important parameters, since it affects the average usage figures.

Report Version

The recommended version is 12 weeks.

Growth Factor%

This field enables you to apply a simple global growth factor to your usage figures.

For example, if you expect 10% growth over the historical usage averages, then enter 10.00. If you expect a 10% decline, enter 10.00-. The average usage figure (and average activity figure) will be adjusted by this percentage, up or down.

It is recommended that this field be used to adjust for upcoming promotions, seasonality, and other instances where you expect a change the system cannot predict. You can also use this concept after a promotion. For example, if you are basing the forecast on the past three months usage, and there was a promotion during those months, you may want to apply a negative growth factor when the promotion ends.

Stocking Matrix

The Stocking Matrix is a set of rules that govern where stock is carried to meet the demands of each geographic grouping of customers. If you do not use the Stocking Matrix File, the system assumes that stock should be replenished to the warehouse where it was stocked. For example, if the stock was picked from warehouse NYC, then without a stocking matrix, the system assumes that stock in NYC should be replenished. If this replenishment method is satisfactory for your operation, or if you have a single stocking warehouse, you do not need to use this file. With a single central stocking warehouse, you should run the reorder reports for all warehouses combined.

Omit Remnants

You can include or omit remnants from the forecast calculations. Remnants are available quantities of a single serial number or lot number that are less than or equal to the remnant quantity/size as entered individually for each item in the Item Master File. This concept only applies to material that usually must be sold from the same or matching serial numbers, lots, or rolls. This parameter is ignored for items that are not stocked by serial or lot number. If you choose to omit remnants, the report ignores the available quantity of any serial or lot number that is less than the remnant quantity in the item master record.

For example, let’s say the total quantity available = 1000, consisting of three serial numbers of 900, 25, and 75. If the remnant size is 80, then the Stock Out Predictor Report only considers that you have 900 available.

Use Sales or Activity

Activity is defined as sales plus the change in open order quantities for the selected date span.

Only include items with a predicted stock out?

Activate this setting to only display those items with a forecasted stock out.

Omit inactive items? (no usage, and available >= 0)

For an item to be considered inactive it must:

• Have no sales within the last year

• Have inventory on hand

Setting

Description

Print quantities in

• 1 - Native (Usual) - This option is the default. The native/nor­mal (native) unit of measure is the unit measure in which an item is priced.

• 2 - Sales - This option converts the report to the sales unit of measure for each item as defined in the Item File. For rolled goods, this options causes the report to print in RL (whole rolls).

• 3 - Pick - This option converts the report to the pick unit of measure for each item as defined in the Item File. For rolled goods, this option causes the report to print in LF (lineal feet). For items with a pick unit of measure of PC, EA, CT, or blank, the report attempts to convert to cartons (CT).

• 4 - Order Entry - This option converts the report to the Order Entry unit of measure for each item as defined in the Item File. This unit of measure will always be the pricing unit of measure.

• 5 - Supplier - This option converts the report to the supplier unit of measure for each item as defined in the Item File. If the supplier’s unit of measure is properly set in each item, this is the most logical choice. This creates the Reorder Report in the unit of measures in which the supplier expects you to order.

Use the Stocking Matrix File?

The Stocking Matrix File is used to establish a search sequence for warehouses. If this setting is activated the warehouses are searched in the order set-up in the Stocking Matrix File.

Even if No is selected, the system still looks at the Stocking Matrix File to determine the product’s distribution center.

Note: If you elect to use the Stocking Matrix File and you have the stocking matrix setup at the item level for everything, you will see quantity shipped. If your Stocking Matrix is not set-up at the item level and you select "Y" for this setting the quantity shipped will not appear.

For more information, refer to the Stocking Matrix.

Allow transfer regardless of DC safety stock level?

Activate this setting to override the DC safety stock established in the Safety Days for Distribution Center table.

Use Branch Transfer Rules Table?

Set to Yes to use transfer rules and stock to Stock transfer reorder parameters. If No, the report uses Stock to Stock Transfer reorder parameters and rules to calculate transfer quantities. Settings involved include Minimum and Maximum order quantities and Multiples to Order, as well as Lead Time and Reorder Frequency.

Include Bill of Material items in transfer?

Activating this setting, directs the system to include items designated as mandatory in the Bill-of Material File. The Transfer Report only displays the top level item. It does not list the items included in the bill-of-material.