Blank Phone Number in Pickhead & Tote Master

Blank Phone Number in PickHead

— run this to find all orders without a phone number assigned

select ship_telno, * from PICKHEAD where ship_telno = ‘ ‘

— run this code to populate a phone number so the order will process
— replace the ‘XXX’ with a 7 digit phone number

update pickhead

set ship_telno = ‘XXX’

where ship_telno = ‘ ‘

Blank Phone Number in TOTMASTR

— run this to find all orders without a phone number assigned

select ship_telno, * from TOTMASTR where ship_telno = ‘ ‘

— run this code to populate a phone number so the order will process
— replace the ‘XXX’ with a 7 digit phone number

update TOTMASTR

set ship_telno = ‘XXX’

where ship_telno = ‘ ‘