AP

A/P Balance

This threshold monitors the dollar amount of the open A/P balance.

The A/P balance is the total dollar value of the accounts payable balance, including all outstanding (unpaid) A/P invoices, across all vendors. This total is negative if the dollar total of credits is greater than the dollar total of unpaid invoices.

Actual dollar value

The actual A/P balance value is the value defined in the Open A/P balance field in the Order Control Summary file for the most recent transaction date.

AR

A/R balance

This threshold monitors the dollar amount of the open A/R balance.

The A/R balance is the total dollar value of the open accounts receivable balance, including all open, allocated, or disputed open items across all bill to accounts. This total is negative if the dollar total of credits is greater than the dollar total of open invoices.

Actual dollar value

The actual A/R balance value is the value defined in the Open A/R balance field in the Order Control Summary file for the most recent transaction date.

BO

Backorders

This threshold monitors the number of open orders and held orders that contain at least one unit on backorder and/or the merchandise dollars of units on backorder that are located on open or held orders.

The system determines if an item is on backorder using this calculation: open quantity on order line - reserved quantity on order line = backorder quantity. The system uses this calculation to determine the open quantity: order quantity - shipped quantity - cancelled quantity - soldout quantity = open quantity.

Actual number value

The actual backorders number is the total number of open orders and held orders that contain at least one unit on backorder, including the total number of ship-to addresses for orders with multiple ship-tos. For example, an order with two ship-to addresses updates the number of orders total by 2.

This is the sum of the Future use 1 number field and Future use 2 number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual backorders value is the sum of the Open backordered dollars field and the Held backordered dollars field in the Order Control Summary file for the most recent transaction date.

HP

Purchase Orders On Hold

This threshold monitors the number of held purchase orders and/or the merchandise dollars of items on held purchase orders.

Held purchase orders are POs that are in a held (H) status; this does not include recurring POs or drop ship POs. The PO line status can be open (O) or held (H) to be included in these totals.

Actual number value

The actual purchase orders on hold number is the value defined in the Held PO number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual purchase orders on hold value is the merchandise dollar total for held purchase orders, as defined in the PO Detail file.

The system determines the merchandise dollar total for held purchase orders by subtracting the quantity received from the quantity ordered and multiplying by the PO price.

This is the value defined in the Held PO dollars field in the Order Control Summary file for the most recent transaction date.

IB

Inventory On Backorder

This threshold monitors the number of units on backorder that are on open or held orders and/or the total merchandise dollars of backordered units on open or held orders.

Actual number value

The actual inventory on backorder units is the sum of the Open quantity backordered field and Held quantity backordered field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual inventory on backorder value is the Open dollars backordered field and the Held dollars backordered field in the Order Control Summary file for the most recent transaction date.

IP

Inventory Pending Putaway

This threshold monitors the number of units received into a pending putaway warehouse and/or the merchandise dollars of items received into a pending putaway warehouse.

A pending putaway warehouse is a warehouse where you place inventory that is on its way to its final destination. You can define a warehouse as a pending putaway warehouse by assigning a warehouse location type of PP (pending putaway warehouse) to the warehouse in Working with Default Warehouse Locations (WWDL).

The system increases these totals when you receive a PO line or a partial quantity on a PO line into a pending putaway warehouse.

Actual number value

The actual inventory pending putaway units is the total number of units received into a pending putaway warehouse, as defined in the Pending Putaway Detail file.

This is the value defined in the Pending putaway quantity field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual inventory pending putaway value is the merchandise dollar total of items received into a pending putaway warehouse, as defined in the Pending Putaway Detail file.

The system multiplies the quantity pending for each pending putaway detail record by the PO cost to determine the merchandise dollar amount for each pending putaway detail record (if a PO cost is not defined, the system uses the SKU cost defined in the SKU file). The system then sums the merchandise dollars for each pending putaway detail record to determine the total pending putaway merchandise dollars.

This is the value defined in the Pending putaway dollars field in the Order Control Summary file for the most recent transaction date.

IS

Inventory In Staging Whs

This threshold monitors the number of units received into a staging warehouse and/or the merchandise dollars of items received into a staging warehouse.

A staging warehouse is a warehouse that designates an area within your actual warehouse where you keep stock that needs to be put away. You can define a warehouse as a staging warehouse by entering the warehouse code in the Default Staging Warehouse (E15) system control value.

The system increases these totals when you receive a PO line or a partial quantity on a PO line into a staging warehouse.

Actual number value

The actual inventory in staging warehouse units is the total number of units received into a staging warehouse.

To determine the number of units received into staging, the system totals the on hand quantity for each item warehouse record defined for the staging warehouse.

This is the value defined in the Staging inventory quantity field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual inventory in staging warehouse value is the merchandise dollar total of items received into a staging warehouse.

To determine the merchandise dollars of items received into staging, the system multiplies the total on hand quantity in the Item Warehouse file for the staging warehouse by the SKU cost.

This is the value defined in the Staging inventory dollars field in the Order Control Summary file for the most recent transaction date.

LP

LTD purchase dollars

This threshold monitors the number of orders placed by a sold to customer and the merchandise dollars of the orders placed by a sold to customer.

The system monitors this threshold only when the sold to customer places an order in order entry.

If the Update Demand for Order Maintenance Transactions (C72) system control value is set to Y, the system increases a sold to customer’s LTD orders number and LTD orders dollars when you add an order line to an order in order maintenance.

The system reduces a sold to customer’s LTD orders number and LTD orders dollars when you cancel an order if the cancel reason you enter is set to update demand.

Note: You must manually create this threshold value. Also, the threshold’s actual number and actual value do not display on the Work with Thresholds Screen since these values apply to a specific sold to customer. The system never sends an email when this threshold is breached but instead displays a pop-up window in order entry.

Customer Order History Window

The system displays the Customer Order History Window in order entry when the customer’s life to date order dollars reaches the threshold value, to indicate the customer has exceeded the LTD purchase dollars and should be given preferential treatment.

Actual number value

The actual LTD purchase dollars units is the number of orders placed by a sold to customer; this does not include returns created through order entry, exchange items entered on an order, or entering an order to purchase a gift certificate only. This is the value defined in the Order number LTD field in the Customer Sold To Order History file for the most recent transaction date.

Actual dollar value

The actual LTD purchase dollars value is the merchandise dollars of the orders placed by a sold to customer, including any backordered or soldout items and the purchase of any gift certificates; this does not include returns created through order entry. This is the value defined in the Order dollars LTD field in the Customer Sold To Order History file for the most recent transaction date.

NP

Orders Rsvd/Not Printed

This threshold monitors the number of reserved units on open and held orders and/or the total merchandise dollars of reserved units on open and held orders.

Actual number value

The actual orders reserved but not printed units is the sum of the values defined in the Open unprinted quantity field and Held unprinted quantity field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual orders reserved but not printed value is the sum of the values defined in the Open unprinted dollars field and Held unprinted dollars field in the Order Control Summary file for the most recent transaction date.

OH

Orders On Hold

This threshold monitors the number of units on held orders and/or the merchandise dollars of items on held orders. This includes units on backorder and regardless of whether the units are printed or unprinted. This does not include units on held order lines if the order is not held.

Actual number value

The actual orders on hold units is the sum of the values defined in the Held backordered quantity field, Held printed quantity field, and Held Unprinted quantity field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual orders on hold value is the sum of the values defined in the Held backordered dollars field, Held printed dollars field, and Held unprinted dollars field in the Order Control Summary file for the most recent transaction date.

OR

Pending Refund

This threshold monitors the number of pending refunds and/or the merchandise dollars for pending refunds.

Pending refunds are refunds in an open or held status that have not yet been processed; these totals do not include refunds that are in a pending cancelled, cancelled, pending write off, write off, or processed status.

Actual number value

The actual pending refund units is the value defined in the Refunds pending number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual pending refund value is the value defined in the Refunds pending dollars field in the Order Control Summary file for the most recent transaction date.

PC

Pending RA Credit

This threshold monitors the number of pending return authorization credits and/or merchandise dollars for pending return authorization credits.

Pending return authorization credits are return authorizations that have been received, but not yet credited. You can only enter a pending RA credit using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is set to Y).

These totals include items returned in return transactions and items returned in exchange transactions, not items ordered in exchange.

Actual number value

The actual pending RA credit units is the total number of pending return authorization credits, regardless of whether the returns are on the same order. For example, an order with 2 pending RA credit order lines processed separately updates this total by 2; however, if the same 2 pending RA credit order lines on a single order are processed in the same transaction, the total updates by 1.

The system determines the number of pending RA credits by totaling the number of RA header records whose date received is greater than 0 and date credited is 0.

This is the value defined in the Pending RA credit number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The merchandise dollar total of items on pending return authorization credits.

The system determines the merchandise dollars of items on pending RA credits by multiplying the uncredited quantity by the order detail price.

The actual pending RA credit value is the value defined in the Pending RA credit dollars field in the Order Control Summary file for the most recent transaction date.

PD

Purchase Orders Past Due

This threshold monitors the number of purchase orders that contain purchase order lines that are past due and/or merchandise dollars of items on purchase orders that are past due. This does not include drop ship purchase orders.

Past due purchase orders contain PO lines that have not yet been received and are past the expected due date (the Due date defined for the PO line is less than the current date). The PO line status can be open (O) or held (H) to be included in these totals.

Actual number value

The actual PO past due units is the total number of open, held, and docked POs that contain PO lines that are past due, as defined in the PO Detail file

This is the sum of the values defined in the Open past due PO number field, Held past due PO number field, and Docked past due PO number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual PO past due value is the merchandise dollar total for items on open, held, and docked POs that are past due, as defined in the PO Detail file.

This is the sum of the values defined in the Open past due PO dollars field, Held past due PO dollars field, and Docked past due PO dollars field in the Order Control Summary file for the most recent transaction date.

PK

Purchase Orders Docked

This threshold monitors the number of docked purchase orders and/or the merchandise dollars of items on docked purchase orders.

Docked purchase orders are POs that are in a docked (D) status. The PO line status can be open (O) or held (H) to be included in these totals.

If you partially receive a docked PO, the system updates the PO status from docked (D) to open (O).

Actual number value

The actual PO docked number is the value defined in the Docked PO number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual PO docked value is the merchandise dollar total for docked purchase orders, as defined in the PO Detail file.

The system determines the merchandise dollar total for docked purchase orders by subtracting the quantity received from the quantity ordered and multiplying by the PO price.

This is the value defined in the Docked PO dollars field in the Order Control Summary file for the most recent transaction date.

PO

Pending Pick Slips

This threshold monitors the number of pending pick slips and/or merchandise dollars for pending pick slips.

Pending pick slips are pick slips that have not yet been billed, not including pick slips voided, waiting for authorizations, or suspended.

The system increases the pending pick slip number, units, and dollars for drop ship orders if the drop ship output defined for the vendor is drop ship pick slip; if the drop ship output defined for the vendor is drop ship purchase order or collaborative shipping, the system only increases the total units and total dollars pending and does not increase the total number pending.

Actual number value

The actual pending pick slips units is the value defined in the Pending picks number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual pending pick slips value is the sum of the values defined in the Open printed dollars field and Held printed dollars field in the Order Control Summary file for the most recent transaction date.

RA

Pending RA Receipt

This threshold monitors the number of pending return authorization receipts and/or merchandise dollars for pending return authorization receipts.

Pending return authorization receipts are return authorizations that have been entered, but not yet received. You can only enter a pending RA receipt using non-streamlined return authorizations (the Use Streamlined Return Authorizations (F44) system control value is set to Y).

These totals include items returned in return transactions and items returned in exchange transactions, not items ordered in exchange.

Actual number value

The actual pending RA receipt units is the total number of pending RA receipts, regardless of whether the returns are on the same order. For example, an order with 2 pending RA receipt order lines processed separately updates this total by 2; however, if the same 2 pending RA receipt order lines on a single order are processed in the same transaction, the total updates by 1.

The system determines the number of pending RA receipts by totaling the number of RA header records whose date received is 0.

This is the value defined in the Pending RA receipt number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual pending RA receipt value is the merchandise dollar total of items on pending return authorization receipts.

The system determines the merchandise dollars of items on pending RA receipts by multiplying the unreceived quantity by the order detail price.

This is the value defined in the Pending RA receipt dollars field in the Order Control Summary file for the most recent transaction date.

RS

Suspended PO Receipts

This threshold monitors the number of PO lines received into suspense and/or the merchandise dollars of items received into suspense.

Actual number value

The actual suspended PO receipts units is the total number of PO lines received into suspense, including PO lines that only have a partial quantity received into suspense. This is the value defined in the Suspense receipts number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual suspended PO receipts value is the value defined in the Suspense receipts dollars field in the Order Control Summary file for the most recent transaction date.

SB

Suspended Batches

This threshold monitors the total number of order batches that are in a suspended status.

The system does not monitor a threshold dollar value for suspended batches.

Actual number value

The system determines the number of order batches in a suspended status by totaling the number of orders in the Order Batch file whose Batch suspended field is set to Y.

This is the value defined in the Batches suspended number field in the Order Control Summary file for the most recent transaction date.

SI

Suspended Inventory

This threshold monitors the number of units received into suspense and/or merchandise dollars of items received into suspense.

Actual number value

The actual suspended inventory units is the value defined in the Suspense receipts quantity field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual suspended inventory value is the value defined in the Suspense receipts dollars field in the Order Control Summary file for the most recent transaction date.

SO

Suspended Orders

This threshold monitors the number of suspended orders and/or the total dollar value of suspended orders, regardless of whether the order is batched.

Actual number value

The actual suspended orders units is the total number of suspended orders; this is the number of orders in a suspended status or error status as defined in the Order Header file.

This is the value defined in the Orders suspended number field in the Order Control Summary file for the most recent transaction date.

Actual dollar value

The actual suspended orders value is the merchandise dollar total of suspended orders, including orders in a suspended status and error status. This is the sum of the merchandise dollars for suspended and orders in error in the Order Ship To file.

This is the value defined in the Orders suspended dollars field in the Order Control Summary file for the most recent transaction date.

VC

Virtual Card Numbers

This threshold monitors the number of stored value card numbers available to assign to a virtual stored value card.

Actual number value

The actual number of records in the Virtual Card Number File (FLSVCA).

Description

A description of the threshold.

See System Delivered Thresholds for a listing of system-delivered threshold values and the calculations performed.

Alphanumeric, 30 positions; optional.

Threshold number

The number defined for the threshold.

Numeric, 7 positions; display-only.

Threshold value

The dollar amount defined for the threshold.

Note: You can only enter a whole dollar amount.

Numeric, 7 positions; display-only.

Actual number

The actual number for the threshold, such as the actual number of units on backorder.

Numeric, 7 positions; display-only.

Actual value

The actual dollar amount for the threshold, such as the dollar amount associated with the number of units on backorder.

Note: The system rounds the actual dollar amount down to the nearest whole dollar.

Numeric, 7 positions; display-only.

Msg queue

The message queue for the user who should be notified when the threshold has been breached.

Alphanumeric, 10 positions; display-only.

Action

The message that is sent to the message queue defined in the Message queue field. This message indicates the action that should be taken if the threshold has been breached, for example if the OH (Orders on Hold) threshold has been breached, you can have the system generate the Held Orders report.

Alphanumeric, 50 positions; display-only.

Last update

The date and time when the threshold was last updated.

Date: Alphanumeric, 6 positions; display-only.

Time: Alphanumeric, 6 positions; display-only.

Threshold

The code and description that represents a threshold.

See System Delivered Thresholds for a list of system-delivered thresholds.

Threshold code: Alphanumeric 2 positions.

Create screen: required.

Change screen: display-only.

Threshold description: Alphanumeric, 30 positions; required.

Comparison

Defines when the system determines the threshold is breached.

Valid values:

G = The threshold is breached when the actual system value is greater than the threshold value.

L = The threshold is breached when the actual system value is less than the threshold value.

Alphanumeric, 1 position; optional.

Value

The number that represents the threshold value.

Numeric, 7 positions; optional.

$ Value

The dollar amount the represents the threshold value.

Note: You can only enter a whole dollar amount.

Numeric, 9 positions with a 2-place decimal; optional.

Actual value

The actual number for this threshold, updated by the system.

Example: The actual number of units on backorder.

Numeric, 7 positions; display-only.

$ actual value

The actual dollar amount for this threshold, updated by the system.

Example: The dollar amount associated with the number of units on backorder.

Note: The system rounds the actual dollar amount down to the nearest whole dollar.

Numeric, 9 positions with a 2-place decimal; display-only.

E-mail address

The email address where the system delivers an email when the threshold has been breached.

Note: You can only define one email address for each threshold. See Email Address Validation for information on how the system verifies that your entry is formatted correctly.

See Threshold Monitor Breach Email for a sample email.

Alphanumeric, 50 positions; optional.

E-mail interval

The number of hours the system waits before sending another e-mail for the breached threshold.

Numeric, 3 positions; optional.

Last sent on/at

The last date and time when an e-mail was sent for the threshold.

Date: numeric, 6 positions (MMDDYY format); display-only.

Time: numeric, 6 positions (HHMMSS format); display-only.

Message queue

The message queue for the user who should be notified when the threshold has been breached.

Alphanumeric, 10 positions; optional.

Action

The message that is sent to the message queue defined in the Message queue field. This message indicates the action that should be taken if the threshold has been breached, for example if the OH (Orders on Hold) threshold has been breached, you can have the system generate the Held Orders report.

Alphanumeric, 50 positions; optional.

Command

The command that the system submits when you enter 9 next to the threshold at the Work with Thresholds Screen.

Alphanumeric, four 63-position lines; optional.

Code

A code for the application area associated with the threshold.

Alphanumeric, 3 positions; required.

Group code

A code for the application group associated with the threshold.

Alphanumeric, 3 positions; required.