Eric Lehti
VIP Member
Although we have not yet implemented Subsystem processing for P42520 Pick Slip printing, we do manage to programmatically adjust DREAM writer data selection so that Pick Slips for our many distribution centers can select according to these rules:
On Mondays thru Thursdays, we want to select orders promised for *tommorrow. Do so with this SQL:
UPDATE F98301 SET DESVL='*TODAY + 1 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64
============================
On Fridays prior to 2-day weekends, we want to select orders promised for Monday (3 days future).
UPDATE F98301 SET DESVL='*TODAY + 3 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64
===========================
On Fridays prior to 3-day holiday weekends, we want to select orders promised for the following Tuesday (4 days future).
UPDATE F98301 SET DESVL='*TODAY + 4 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64
===========================
On Wednesday prior to the 4-day Thanksgiving day holiday weekend, we want to select orders promised for the following Monday (5 days future)
UPDATE F98301 SET DESVL='*TODAY + 5 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64
On Mondays thru Thursdays, we want to select orders promised for *tommorrow. Do so with this SQL:
UPDATE F98301 SET DESVL='*TODAY + 1 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64
============================
On Fridays prior to 2-day weekends, we want to select orders promised for Monday (3 days future).
UPDATE F98301 SET DESVL='*TODAY + 3 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64
===========================
On Fridays prior to 3-day holiday weekends, we want to select orders promised for the following Tuesday (4 days future).
UPDATE F98301 SET DESVL='*TODAY + 4 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64
===========================
On Wednesday prior to the 4-day Thanksgiving day holiday weekend, we want to select orders promised for the following Monday (5 days future)
UPDATE F98301 SET DESVL='*TODAY + 5 '
WHERE DEPID ='P42520' AND
DEVERS LIKE 'SLEEP%' AND
DETY='S' AND DESQN=64