This topic provides definitions for the fields in the Inventory Balancing Report (RIB). This topic is organized by the various pages of the report screen (Print Setup page, From/To page, Understock page, Overstock page, etc.). To display a definition, click the appropriate link.
These are standard fields on all reports. Click here for more information.
Understock StoreThe understocked store to which inventory is going to be transferred. You can only select a single store; selecting a Store Group is not allowed. This field defaults to the locked-in store.
Overstock StoreThe overstocked store from which inventory is going to be transferred. You can select a single store, blank store (to search all stores), or a pre-defined Store Group. If you select a Store Group, the system searches the stores in the order in which they were entered when the Store Group was created.
Understock Store RangesIf you want to limit the items that are included on the report for the understocked store, select the range in the Store Ranges.
For example:
You select 1 in the "From" Department and 5 in the "To" Department field. This limits the report so that the system only prints information for departments 1 through 5.
Note: If you enter an Alternate Vendor in your from/to range, only the items with an alternate vendor falling in this range are selected. Furthermore, as long as Option O is not used, the Vendor Order Multiple will be used in calculating the amount understocked.
Print SequenceIdentifies the order in which the items will print on the report. This is a drop down box with the following selections:
1 – Department/Line/Seq#
2 – Primary Vendor/Department/Line/Seq#
3 – Manufacturer/Department/Seq#
4 – Line/Seq#
The default is 4.
SubtotalsUse this field to specify whether subtotals print. Grand totals print regardless of what you enter in this field.
Y = Print subtotals based on the Printing Sequence field.
N = Do not print subtotals.
The default is Y.
Start New PageThis field determines whether or not you want a new page to print after a subtotal prints.
N = Do not start a new page after a subtotal prints.
Y = Start a new page after a subtotal prints.
Finalizing OptionsF – Finalize Inventory Balance (perform transfer).
This option performs the transfer of stock from the overstocked stores to the understocked store by creating “Request” transfers in the overstocked stores. You can't view these transfers via the VIEWRIB viewer; however, you can view them via the POS Order Viewer using transaction type T.
P – Create Pending Transfers
This option creates pending transfer records which you can review and make changes to, as needed, via VIEWRIB.
Note: If neither options F, P nor T (on Overstock screen) are selected, then the report will simply print an audit of what the potential transfers will be. No pending transfer records will be created and no transfer will occur.
Note: Options F and P are mutually exclusive (only one of them can be selected).
Understock OptionsNote: These options (except option P and Z) are also used by the Suggested Order Report (RSO) when creating purchase orders.
B = Use Negative QOH in Understock Calculation.
Use negative quantity on hand (if it exists) when calculating whether or not an item in the understocked store is understocked. If option B is not selected, negative QOH is treated as zero.
G = Don’t Use Comm Qty in Understock Calc
Don't use committed quantity when calculating whether or not an item in the understocked store is understocked. Committed quantity will be treated as zero when you select this option.
I = Ignore PO Season code to allow out of season items to be included in Stock Transfer Balancing.
O = Ignore Order Multiple/Std Pk in Understock Calc
Don't use the order multiple quantity or the standard package quantity when calculating whether or not an SKU in the understocked store is understocked.
Order multiple is used when the “Order Indicator” field in Inventory Maintenance is set to “W” (Primary vendor is the only vendor from whom you can order this item). Standard package is used when the “Order Indicator” field is set to “D” (Mfg (drop ship) vendor is only vendor from whom you can order this item).
P – Ignore Pending Transfers in Understock Calc.
Ignore the quantity being transferred on pending orders in the “Transfer To” store when calculating whether or not an item in the understock store is understocked. The transfer quantity is treated as zero when you select this option.
Q – Don’t Use QOO in Understock Calculation
Don't use quantity on order when calculating whether or not an SKU in the understocked store is understocked. Quantity on order is treated as zero when you select this option.
R – "Return all overstock (ignore understock calculation)." Use this option to move the overstock from the stores identified in the Overstock Stores field to the Store entered in the Understock Store, regardless of the understocked store’s current stocking level. This option can be useful if you want to move all overstock to the main store or warehouse for returning to the vendor. When using option R, the ‘From/To’ Understock Store Ranges’, ‘Exclude from understock if’ rules, and selection options I, X, and Z do apply.
X – Calculate Transfer for Items with Blank QOH
Allow a transfer quantity to be calculated for those SKUs whose Quantity On Hand field is blank.If this option is not selected, those SKUs with blank QOH are skipped, even if they are understocked.
Y – Don’t Use Raincheck Qty in Understock Calc
Don't not use the raincheck quantity when calculating whether or not an SKU in the understocked store is understocked.
Z – Ignore Items with QOH = 0
Ignore any SKU that has a quantity on hand of zero, even if it is understocked. Example: you don't want balancing transfers to be used to fill stock-outs. If an item's quantity on hand is low, you can wait for a transfer, and have some risk tolerance for whether the transfer makes the truck. If an item is out, you can't wait, and your risk tolerance for getting the transfer is zero. For these items, you want to go to the supplier.
Understock MethodThis is the method you want to use to determine if the SKU in the understocked store is understocked.
Note: option 1057 "Multiple Order Points on System" must be set to Yes in order to use the additional choices of OP A, B, C or D (see list below)
Transfer to OP (order point/max stock level)
Transfer to OP A (aux order point/max stock level A)
Transfer to OP B (aux order point/max stock level B)
Transfer to OP C (aux order point/max stock level C)
Transfer to OP D (aux order point/max stock level D)
Exclude from Understocked ifWhen an item is identified as understocked in the understocked store, the system compares the sales and number of months entered here with actual sales in the understocked item. If the item matches the criteria specified above, it is excluded as an understocked item and no transfer quantity is calculated.
For example, you enter 10 and 3 in the fields above. If SKU XYZ is understocked in store 1 and it had 10 or fewer sales over that last three months, then it will not be considered understocked. If it had more than 10 sales then it would be considered understocked.
Units sold represent the sum of units sold during the specified number of months.
Units sold can be between 0 and 99999, inclusive. Months can be between 0 and 13, inclusive. If the “months” field is zero or blank then the option doesn't apply.
Note: promotional sales history will be included or excluded depending on the setting of option 9409 "Exclude promo sales history when running inventory balancing (RIB)."
Use Case: I don't want to replenish inventory on slow moving items through inventory transfers. Inventory transfers cost my business money, so I don't want to spend that money to replenish slow movers. For example, Post Cap Anchors are a slow moving product. I can get them from my supplier to reach a minimum order when I'm ordering faster movers from the same supplier. Plus, I'm not spending labor moving slow items around my business. Therefore, I'd want to exclude from the understock items that only sell 5 per month.
Units sold are ___ or less in the last ___ monthsWhen an item is identified as understocked in the understocked store, the system compares the sales and number of months entered here with actual sales in the understocked item. If the item matches the criteria specified above then it is excluded as an understocked part and no transfer quantity is calculated.
For example, you enter 10 and 3 in the fields above. If SKU XYZ is understocked in store 1 and it had 10 or more sales over that last three months then it won't be considered understocked. If it had fewer than 10 sales then it would be considered understocked.
Units sold represent the sum of units sold during the specified number of moths.
Units sold can be between 0 and 99999, inclusive. Months can be between 0 and 13, inclusive.
If the “months” field is zero or blank then this option doesn't apply.
Use Case: As a user, my risk tolerance for potential stock-outs on fast movers is very low. Since a sending store has a right to refuse any transfer item, or may be in a situation where they can't fit an item on the transfer truck today, I'd prefer to restock my fast movers from my suppliers instead. As a result, I'd want to be able to exclude items that sell 10 or more in a month from the transfer process.
Note: promotional sales history will be included or excluded depending on the setting of option 9409 "Exclude promo sales history when running inventory balancing (RIB)."
Note: The inventory balance process also considers option 9410 – Consider “Unusual Usage” (in ITR) in Inventory Balancing (RIB) in Options Configuration.
Understock qty is ___ or less and cost is less than___Use this rule if you want the system to NOT transfer low cost items unless they are understocked more than a certain amount you specify. In other words, use this rule so you don't transfer small quantities of low cost items, as it is not cost effective. Note: The cost used in this rule is determined by option 102 “Cost Used in Calculation”.
Overstock OptionsNote: Some of these options are also used by the Suggested Return Report (RSRO) when creating return goods memos.
C – Don’t Use Comm Qty in Overstock Calculation. Do not use committed quantity when calculating whether or not an item in the overstocked store is overstocked. Committed quantity is treated as zero when you select this option.
D – Don’t Use QOO in Overstock Calculation.
Do not use quantity on order when calculating whether or not an item in the overstocked store is overstocked. Quantity on order is treated as zero when you select this option.
G – Transfer based on greatest overstock first. Use this option when you are pulling overstock from a Store Group and you want the quantity that is needed to come from the store with the highest amount of overstock first. When you don't use option G, then the report fills the understock based upon the order of the stores in the store group you enter in the Overstock Store field (e.g.,using a store group created with closest stores first).
I – Include Non Stock Items (OP = blank or 0).
Include those items that are designated as non-stocked (order point is blank or zero) in the overstocked store. If this option is not selected, then non-stocked items are excluded from the report.
M – Ignore Order Multiple Rounding.
Ignore order multiple rounding when calculating whether or not an item in the overstocked store is overstocked.
O–Ignore the quantity being transferred on pending orders in the “Transfer To” store when calculating whether or not an item in the overstock store is overstocked. The transfer quantity is treated as zero when you select this option.
P- Print All Overstocks
Print overstocked items that are associated with understocked items, even if they are not used to fill an inventory transfer.
Note: This option only applies to those items that are considered overstocked based on the rules specified on the Overstock options page and the rules associated with options 9401 through 9410 in Options Configuration.
Q – Ignore Pending Transfers in Overstock Calculation is used to control if pending transfers are included or not in the overstock calculation.
T – Create Pending Transfers for All Overstocks.
Create transfer records for all overstocked items printed on the report. This option can be used in conjunction with Overstock Option P (Print All Overstocks) to create transfer records for overstocked items that have a transfer quantity of zero.
Note: If Overstock option T is selected and Overstock option P is not selected, then the pending transfers created with transfer quantity of zero do not print on the report.
Note: If Overstock option T or Finalizing option F or P (on the Understock page) are not selected, then the report simply prints an audit list of potential transfers. No pending transfer records are created and no transfer will occur.
Note: When creating transfers, option T can be combined with Finalizing options F or P (on the Understock page) or selected by itself.
U – Unique Batch ID for each overstock store
Create unique batch ids for each overstock store that is creating pending transfer records that can be viewed in VIEWRIB. This option is only valid when either Option T (create pending transfers for all overstocks) or Option F (finalize inventory balancing) or Option P (create pending transfers) is selected. The batch id can be used in VIEWRIB to limit the selection to a specific overstocked store.
Overstock MethodThis is the method used to determine if the item in the overstocked store is overstocked. Note: option 1057 "Multiple Order Points on System" must be set to Yes in order to use the additional choices of OP A, B, C or D (see list below).
Overstock if over Standard OP (order point/max stock level)
Overstock if over OP A (aux order point/max stock level A)
Overstock if over OP B (aux order point/max stock level B)
Overstock if over OP C (aux order point/max stock level C)
Overstock if over OP D (aux order point/max stock level D)
Plus QuantityThe quantity entered here is added to the quantity associated with the selected Overstock Method. The results are used when determining whether or not an item is overstocked. For instance, if the overstock method selected is “Overstock if over Standard OP” and the quantity associated with Standard OP is 10 and the user enters 2 in the “Plus Quantity” field, then an item is considered overstocked when quantity on hand is greater than 12. The field can be blank or any positive numeric value. Blank is the default. Blank and zero are equivalent.
Note: The “Overstock Method” and “Plus Quantity” fields cannot both be blank. One or both of them has to have a non-blank value.
Note: this field can be selected only when an overstock method is selected.
Note: When calculating units sold, promotional sales history is included or excluded depending on the setting of Option 9409 "Exclude Promo Sales History" in Options Configuration.
Exclude from Overstock ifUnits sold are __or less in the last _ months
When an item is identified as overstocked in an overstocked store, the system compare sthe sales and number of months entered here with actual sales in the overstocked item. If the item matches the criteria specified above then it is excluded as an overstocked item and no transfer quantity is calculated.
For example, you enter 10 and 3 in the fields above. If SKU XYZ is overstocked in store 1 and it had 10 or fewer sales over that last three months then it isn't considered overstocked. If it had more than 10 sales then it would be considered overstocked.
Units sold represent the sum of units sold during the specified number of moths.
Units sold can be between 0 and 99999, inclusive. Months can be between 0 and 13, inclusive.
If the “months” field is zero or blank, then this option does not apply.
Use Case: I strive to stock and have stock even on some slower moving completion items as well as the fast movers. In some cases, I'd want slow movers to be excluded from the transfer process as well, to ensure that I have the completion items in stock at the sending store. For example, I sell #8 Finish nails in bulk. Typically, we sell 1 or 2 boxes a month of this product by the box. Therefore, my order point is low on this product. However, I need the boxes to be available for those customers who need a larger quantity for a project, so I would likely want to exclude these items from transfer, especially since I'd likely have 2 boxes on hand, and an order point of 1. I would not want to transfer the one box out.
Units sold are __or more in the last __ months
When an item is identified as overstocked in an overstocked store, the system compares the sales and number of months entered here with actual sales in the overstocked item. If the item matches the criteria specified above, then it is excluded as an overstocked item and no transfer quantity is calculated. For example, you enter 10 and 3 in the fields above. If SKU XYZ is overstocked in store 1 and it had 10 or more sales over that last three months then it isn't considered overstocked. If it had fewer than 10 sales then it would be considered overstocked.
Units sold represent the sum of units sold during the specified number of months.
Units sold can be between 0 and 99999, inclusive. Months can be between 0 and 13, inclusive.
If the “months” field is zero or blank, then this option does not apply.
Use Case: I'm always concerned with having stock on my fast selling items. For example, 1 gallon bleach is a fast mover in all my stores. As a result, I want fast moving items excluded from the transfer process because I run the risk of not having what I need at the sending store if I transfer it out. This could result in not enough stock at 2 stores now, instead of just 1, on a high moving item. Therefore, I'd want to exclude fast movers from transfer by entering a unit sold quantity over a period of months to be sure these fast movers are excluded. This would also prevent items like fasteners from being transferred as well.
Note: When calculating units sold, promotional sales history is included or excluded depending on the setting of Option 9409 "Exclude Promo Sales History" in Options Configuration.
Note: The inventory balance process also considers option 9410 "Consider Unusual Usage in Unit Sold Calculation" in Options Configuration.
Days since last receipt is less than XXX days. This will exclude overstocked items whose last receipt date is less than the value entered into this field. This rule helps to eliminate sending back items that were sent to the store for a customer pickup and they have not yet come in to pick them up. :
Item uses Vendor_and overstock is less than_times order pointIf an item is identified as overstocked in an overstocked store, the system compares the vendor id entered here with the primary vendor associated with the item. If they are equal, the item is not considered overstocked unless its calculated overstocked quantity is less than the specified multiplier times the order point associated with the selected overstock method. If one or both of these conditions are not true, then the item is considered overstocked.
Use Case: I want to exclude any product available from my primary supplier because I can get the product in a very short lead time from the supplier with high fill rates. For example, I can receive most coop warehouse products on shipments two times per week, with a better than 98% fill rate. As a result, I want to be able to ignore products available from this supplier, unless the overstock amount on an item is so significant (e.g., 5X) that it makes sense to transfer the item.
Note: You must fill in both fields of this option.