WikiAdmin: 1 revision imported

2023-07-14T13:00:37Z

1 revision imported

← Older revision

Revision as of 13:00, 14 July 2023

Intra>User: 1 revision imported

2017-01-10T00:02:20Z

1 revision imported

New page

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:
<PRE>
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
</PRE>

<PRE>
Update artprod
set AUTO_qty='B' WHERE PRODUCT_CLASS='AD' AND UNIT_OF_MEASURE='YD'
</PRE>

(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.)
<PRE>
Update artprod
set AUTO_qty='B' WHERE PRODUCT_CLASS='AD' LIST_PRICE < 10.00
</PRE>

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

See: [[Dispatch Data Setup ]]

Setting up Default Quantities to Optimize Dispatch - Revision history

WikiAdmin: 1 revision imported

Intra>User: 1 revision imported