Thank you pmax9999
//@whse
if {orderlines.whse} in [ '001', '001p', '002', '011', '019'] then "001 Linden" else
if {orderlines.whse} in [ '003', '004', '009', '017', '025', '031', '090', '092', '045' ] then "003 Houston" else
if {orderlines.whse} in [ '005' ] then "005 Turtle Energy" else
if {orderlines.whse} in [ '007', '007p', '035' ] then "007 Bridgewater" else
if {orderlines.whse} in [ '013', '013a', '013b', '013c', '013d', '013e', '013f', '013g' ] then "013 THIS Hamden" else
if {orderlines.whse} in [ '015' ] then "015 THIS Puerto Rico" else
if {orderlines.whse} in [ '021', '069' ] then "021 New Haven" else
if {orderlines.whse} in [ '023', '023c' ] then "023 Plainfield" else
if {orderlines.whse} in [ '027' ] then "027 Pleasantville" else
if {orderlines.whse} in [ '029' ] then "029 LIC" else
if {orderlines.whse} in [ '033', '033l' ] then "033 Whippany" else
if {orderlines.whse} in [ '037' ] then "037 CDC" else
if {orderlines.whse} in [ '039' ] then "039 THIS BWAY Cincinnati" else
if {orderlines.whse} in [ '041' ] then "041 THIS BWAY Chicago" else
if {orderlines.whse} in [ '042', '044', '046' ] then "042 MIE-TH HOLDING" else
if {orderlines.whse} in [ '043' ] then "043 THIS BWAY Homerville" else
if {orderlines.whse} in [ '047', '047a', '047b' ] then "047 THIS Manati" else
if {orderlines.whse} in [ '009', '051', '053', '055', '057', '065' ] then "051 TNH Industrial" else
if {orderlines.whse} in [ '059' ] then "059 T&H Green Energy" else
if {orderlines.whse} in [ '061' ] then "061 Richards" else
if {orderlines.whse} in [ '063', '063a', '063b', '063c', '063d', '063e', '063f', '063g', '063h', '063i', '063j', '063k', '063l', '063m' ] then "063 THIS Sharebuyer" else
if {orderlines.whse} in [ '067' ] then "067 THIS Stryker Mahwah" else
if {orderlines.whse} in [ '071' ] then "071 THIS Honeywell CPG" else
if {orderlines.whse} in [ '073' ] then "073 THIS Honeywell Greenville" else
if {orderlines.whse} in [ '075' ] then "075 THIS Fostoria" else
if {orderlines.whse} in [ '077' ] then "077 THIS HW Elberton" else
if {orderlines.whse} in [ '079' ] then "079 THIS HW Sharebuyer" else
if {orderlines.whse} in [ '081' ] then "081 THIS J&J Lilitz" else
if {orderlines.whse} in [ '083' ] then "083 THIS HW Duncan" else
if {orderlines.whse} in [ '085' ] then "085 THIS Tect Newington" else
if {orderlines.whse} in [ '087' ] then "087 THIS Tect Thomasville" else
if {orderlines.whse} in [ '089' ] then "089 THIS Tect Whitesboro" else
if {orderlines.whse} in [ '091' ] then "091 THIS Tect Cleveland" else
if {orderlines.whse} in [ '093' ] then "093 THIS Unilever Clinton" else
if {orderlines.whse} in [ '095' ] then "095 THIS Unilever Hammond" else
if {orderlines.whse} in [ '097' ] then "097 THIS DSM" else
if {orderlines.whse} in [ '099' ] then "099 THIS EGS Appleton" else
if {orderlines.whse} in [ '101' ] then "101 THIS EGS Shoemakersville" else
if {orderlines.whse} in [ '103' ] then "103 THIS EGS Mexico" else
if {orderlines.whse} in [ '105', '105a', '105b' ] then "105 THIS HW Golden Valley" else
if {orderlines.whse} in [ '107' ] then "107 THIS HW Freeport" else
if {orderlines.whse} in [ '109' ] then "109 THIS HW BDG" else
if {orderlines.whse} in [ '110' ] then "110 THIS ATS" else
if {orderlines.whse} in [ '111' ] then "111 THIS J&J North Wales" else
if {orderlines.whse} in [ '113' ] then "113 THIS Alza Corp" else
if {orderlines.whse} in [ '115' ] then "115 THIS Akzo La Porte" else
if {orderlines.whse} in [ '117' ] then "117 THIS Akzo Pasadena" else
if {orderlines.whse} in [ '119' ] then "119 WGI" else
if {orderlines.whse} in [ '121' ] then "121 THIS Vistakon" else
if {orderlines.whse} in [ '122' ] then "122 THIS J&J Depuy Raynham" else
if {orderlines.whse} in [ '123' ] then "123 THIS Mcneil" else
if {orderlines.whse} in [ '124' ] then "124 THIS J&J Depuy Warsaw" else
if {orderlines.whse} in [ '125' ] then "125 THIS Ethicon Cornelia" else
if {orderlines.whse} in [ '127' ] then "127 THIS Ethicon San Angel" else
if {orderlines.whse} in [ '129' ] then "129 THIS Neutrogena" else
if {orderlines.whse} in [ '131' ] then "131 THIS J&J Bridgewater" else
if {orderlines.whse} in [ '133' ] then "133 THIS Merck Rahway" else
if {orderlines.whse} in [ '135' ] then "135 THIS Merck West Point" else
if {orderlines.whse} in [ '137' ] then "137 THIS Merck Barceloneta" else
if {orderlines.whse} in [ '139' ] then "139 THIS Merck" else
if {orderlines.whse} in [ '141' ] then "141 THIS Merck Elton" else
if {orderlines.whse} in [ '143' ] then "143 THIS Merck Durham" else
if {orderlines.whse} in [ '145' ] then "145 THIS Merck Wilson" else
if {orderlines.whse} in [ '147' ] then "147 THIS Janssen" else
if {orderlines.whse} in [ '149' ] then "149 THIS Janicki Hamilton" else
if {orderlines.whse} in [ '151' ] then "151 THIS Janicki Layton" else
if {orderlines.whse} in [ '153' ] then "153 THIS KIK Elkhart" else
if {orderlines.whse} in [ '155' ] then "155 THIS KIK Gainesville" else
if {orderlines.whse} in [ '157' ] then "157 THIS KIK Etobicoke" else
if {orderlines.whse} in [ '159' ] then "159 THIS KIK Danville" else
if {orderlines.whse} in [ '161' ] then "161 THIS KIK Memphis" else
if {orderlines.whse} in [ '163' ] then "163 THIS J&J Raritan" else
if {orderlines.whse} in [ '165' ] then "165 THIS J&J Rochester" else
if {orderlines.whse} in [ '167' ] then "167 THIS J&J Ariba" else
if {orderlines.whse} in [ '169' ] then "169 THIS Ampac" else
if {orderlines.whse} in [ '171' ] then "171 THIS Hitchner" else
if {orderlines.whse} in [ '173' ] then "173 THIS J&J Montreal" else
if {orderlines.whse} in [ '191' ] then "191 TSI" else
if {orderlines.whse} in [ '193' ] then "193 Rhino" else
if {orderlines.whse} in [ '194' ] then "194 T&H Ontario" else
if {orderlines.whse} in [ '195' ] then "195 Mag-Trol" else
{orderlines.whse}
//@Selling Whse
//if {orderlines.whse} <> '037' then {@Whse} else
//if {orders_ext.User1} = " " then "No Selling Whse" else
if {orders_ext.User1} in [ '001', '001p', '002', '011', '019'] then "001 Linden" else
if {orders_ext.User1} in [ '003', '004', '009', '017', '025', '031', '090', '092', '045' ] then "003 Houston" else
if {orders_ext.User1} in [ '005' ] then "005 Turtle Energy" else
if {orders_ext.User1} in [ '007', '007p', '035' ] then "007 Bridgewater" else
if {orders_ext.User1} in [ '013', '013a', '013b', '013c', '013d', '013e', '013f', '013g' ] then "013 THIS Hamden" else
if {orders_ext.User1} in [ '015' ] then "015 THIS Puerto Rico" else
if {orders_ext.User1} in [ '021', '069' ] then "021 New Haven" else
if {orders_ext.User1} in [ '023', '023c' ] then "023 Plainfield" else
if {orders_ext.User1} in [ '027' ] then "027 Pleasantville" else
if {orders_ext.User1} in [ '029' ] then "029 LIC" else
if {orders_ext.User1} in [ '033', '033l' ] then "033 Whippany" else
if {orders_ext.User1} in [ '037' ] then "037 CDC" else
if {orders_ext.User1} in [ '039' ] then "039 THIS BWAY Cincinnati" else
if {orders_ext.User1} in [ '041' ] then "041 THIS BWAY Chicago" else
if {orders_ext.User1} in [ '042', '044', '046' ] then "042 MIE-TH HOLDING" else
if {orders_ext.User1} in [ '043' ] then "043 THIS BWAY Homerville" else
if {orders_ext.User1} in [ '047', '047a', '047b' ] then "047 THIS Manati" else
if {orders_ext.User1} in [ '009', '051', '053', '055', '057', '065' ] then "051 TNH Industrial" else
if {orders_ext.User1} in [ '059' ] then "059 T&H Green Energy" else
if {orders_ext.User1} in [ '061' ] then "061 Richards" else
if {orders_ext.User1} in [ '063', '063a', '063b', '063c', '063d', '063e', '063f', '063g', '063h', '063i', '063j', '063k', '063l', '063m' ] then "063 THIS Sharebuyer" else
if {orders_ext.User1} in [ '067' ] then "067 THIS Stryker Mahwah" else
if {orders_ext.User1} in [ '071' ] then "071 THIS Honeywell CPG" else
if {orders_ext.User1} in [ '073' ] then "073 THIS Honeywell Greenville" else
if {orders_ext.User1} in [ '075' ] then "075 THIS Fostoria" else
if {orders_ext.User1} in [ '077' ] then "077 THIS HW Elberton" else
if {orders_ext.User1} in [ '079' ] then "079 THIS HW Sharebuyer" else
if {orders_ext.User1} in [ '081' ] then "081 THIS J&J Lilitz" else
if {orders_ext.User1} in [ '083' ] then "083 THIS HW Duncan" else
if {orders_ext.User1} in [ '085' ] then "085 THIS Tect Newington" else
if {orders_ext.User1} in [ '087' ] then "087 THIS Tect Thomasville" else
if {orders_ext.User1} in [ '089' ] then "089 THIS Tect Whitesboro" else
if {orders_ext.User1} in [ '091' ] then "091 THIS Tect Cleveland" else
if {orders_ext.User1} in [ '093' ] then "093 THIS Unilever Clinton" else
if {orders_ext.User1} in [ '095' ] then "095 THIS Unilever Hammond" else
if {orders_ext.User1} in [ '097' ] then "097 THIS DSM" else
if {orders_ext.User1} in [ '099' ] then "099 THIS EGS Appleton" else
if {orders_ext.User1} in [ '101' ] then "101 THIS EGS Shoemakersville" else
if {orders_ext.User1} in [ '103' ] then "103 THIS EGS Mexico" else
if {orders_ext.User1} in [ '105', '105a', '105b' ] then "105 THIS HW Golden Valley" else
if {orders_ext.User1} in [ '107' ] then "107 THIS HW Freeport" else
if {orders_ext.User1} in [ '109' ] then "109 THIS HW BDG" else
if {orders_ext.User1} in [ '110' ] then "110 THIS ATS" else
if {orders_ext.User1} in [ '111' ] then "111 THIS J&J North Wales" else
if {orders_ext.User1} in [ '113' ] then "113 THIS Alza Corp" else
if {orders_ext.User1} in [ '115' ] then "115 THIS Akzo La Porte" else
if {orders_ext.User1} in [ '117' ] then "117 THIS Akzo Pasadena" else
if {orders_ext.User1} in [ '119' ] then "119 WGI" else
if {orders_ext.User1} in [ '121' ] then "121 THIS Vistakon" else
if {orders_ext.User1} in [ '122' ] then "122 THIS J&J Depuy Raynham" else
if {orders_ext.User1} in [ '123' ] then "123 THIS Mcneil" else
if {orders_ext.User1} in [ '124' ] then "124 THIS J&J Depuy Warsaw" else
if {orders_ext.User1} in [ '125' ] then "125 THIS Ethicon Cornelia" else
if {orders_ext.User1} in [ '127' ] then "127 THIS Ethicon San Angel" else
if {orders_ext.User1} in [ '129' ] then "129 THIS Neutrogena" else
if {orders_ext.User1} in [ '131' ] then "131 THIS J&J Bridgewater" else
if {orders_ext.User1} in [ '133' ] then "133 THIS Merck Rahway" else
if {orders_ext.User1} in [ '135' ] then "135 THIS Merck West Point" else
if {orders_ext.User1} in [ '137' ] then "137 THIS Merck Barceloneta" else
if {orders_ext.User1} in [ '139' ] then "139 THIS Merck" else
if {orders_ext.User1} in [ '141' ] then "141 THIS Merck Elton" else
if {orders_ext.User1} in [ '143' ] then "143 THIS Merck Durham" else
if {orders_ext.User1} in [ '145' ] then "145 THIS Merck Wilson" else
if {orders_ext.User1} in [ '147' ] then "147 THIS Janssen" else
if {orders_ext.User1} in [ '149' ] then "149 THIS Janicki Hamilton" else
if {orders_ext.User1} in [ '151' ] then "151 THIS Janicki Layton" else
if {orders_ext.User1} in [ '153' ] then "153 THIS KIK Elkhart" else
if {orders_ext.User1} in [ '155' ] then "155 THIS KIK Gainesville" else
if {orders_ext.User1} in [ '157' ] then "157 THIS KIK Etobicoke" else
if {orders_ext.User1} in [ '159' ] then "159 THIS KIK Danville" else
if {orders_ext.User1} in [ '161' ] then "161 THIS KIK Memphis" else
if {orders_ext.User1} in [ '163' ] then "163 THIS J&J Raritan" else
if {orders_ext.User1} in [ '165' ] then "165 THIS J&J Rochester" else
if {orders_ext.User1} in [ '167' ] then "167 THIS J&J Ariba" else
if {orders_ext.User1} in [ '169' ] then "169 THIS Ampac" else
if {orders_ext.User1} in [ '171' ] then "171 THIS Hitchner" else
if {orders_ext.User1} in [ '173' ] then "173 THIS J&J Montreal" else
if {orders_ext.User1} in [ '191' ] then "191 TSI" else
if {orders_ext.User1} in [ '193' ] then "193 Rhino" else
if {orders_ext.User1} in [ '194' ] then "194 T&H Ontario" else
if {orders_ext.User1} in [ '195' ] then "195 Mag-Trol" else
{orders_ext.User1}
The CDC (location 037) needs to have its Sales Totals for each Selling Whse redistributed back to the associated Whse.
Thank you for your assistance.
Polarican0115