Setting up Default Quantities to Optimize Dispatch

Keystone Dispatch performance is greatly affected by default the default quantity setting in ARTPROD. When the AUTO_QTY is set to N, the quantity for any product after line 1 (the mix) will be 0.

Auto Quantity values:

• Yes (Y): The quantity for each ticket will be set to the Default Quantity.

Good for Load Delivery Charge

• Bringdown (B): Carry down quantity from the main product.

Good for admixes by the Yard

• Order Remaining (R): Will put all undelivered quantity on the ticket. If the quantity is lowered the remaining will end up on the next ticket.

Good for Rebar, Expansion joints, etc.

• Order Quantity: The quantity for each ticket gets set to the Order Quantity for every load.

Good for Transportation by the Hour (e.g. 1.5 Hours per ticket).

and Test Cylinder (e.g. set to 1)

Simple Default Quantity Review query:

select p.product_class,p.product_code,unit_of_measure,auto_qty,default_qty,p.DESCRIPTION_1 from artprod p
WHERE product_class<>'CO'
order by product_class,unit_of_measure,auto_qty,default_qty

Update artprod
set AUTO_qty='B' WHERE PRODUCT_CLASS='AD' AND UNIT_OF_MEASURE='YD'

(Alternative to above script... This one assumes if it is an additive and it is less than $10, it is likely a per-yard based price. Check this with client before executing, as it is hardly foolproof.)

Update artprod
set AUTO_qty='B' WHERE PRODUCT_CLASS='AD' LIST_PRICE < 10.00

Update artprod
set AUTO_QTY='Y' , default_qty=1, WHERE PRODUCT_CLASS='TR' AND UNIT_OF_MEASURE='LD'

See: Dispatch Data Setup