Sage 100

 View Only

  • 1.  Restrict Shipper ID to specific warehouse

    Posted 02-01-2019 15:32
    Is it possible to restricted a Shipper ID to ship from a single warehouse? Can't find it in Sage 100 or an enhancement. Am I missing something?

    ------------------------------
    Myron Stevenson
    Clearis Consulting
    ------------------------------


  • 2.  RE: Restrict Shipper ID to specific warehouse

    Posted 02-01-2019 16:36
    Sorry, don't have an answer but how cold did it get?  Any Scout earning a Winter survival badge?

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Restrict Shipper ID to specific warehouse

    Posted 02-01-2019 16:57
    Northern MN weather - Duluth yesterday morning it went to -31 at the airport. Windchill was about -50. Been to busy to sleep outside. -31 would have been a personal best. Sad to missing the opportunity. In Cotton, MN (35 miles north of Duluth) got to -56 yesterday morning. That was air temperature. 

    Once it goes below -25, it's hard to tell the difference between -25 and -50. The body just can't distinguish the difference. 


    ------------------------------
    Myron Stevenson
    Clearis Consulting
    ------------------------------

    Original Message


  • 4.  RE: Restrict Shipper ID to specific warehouse

    Posted 02-01-2019 16:58
    Edited by Jim Woodhead 02-01-2019 17:19
    Myron,  sounds like an easy task in scripting but there are some details it depends on. for example is it per order or per line.  You could script for either.  if it got complicated you could setup a role for each warehouse and build the script  around that but it sounds doable.

    ------------------------------
    Jim Woodhead
    VP Professional Services
    DSD Business Systems
    San Diego, CA
    619-990-3946
    ------------------------------



  • 5.  RE: Restrict Shipper ID to specific warehouse

    Posted 02-01-2019 17:48
    According to the news, Cotton, MN, was the coldest at -55.9 degrees.

    ---------------------------------
    Robert Wood
    Consultant
    90 Minds
    Ocala FL
    352-615-5898
    ---------------------------------



    Original Message


  • 6.  RE: Restrict Shipper ID to specific warehouse

    Posted 02-01-2019 18:02
    +1 what Jim said.

    ---------------------------------
    Robert Wood
    Consultant
    90 Minds
    Ocala FL
    352-615-5898
    ---------------------------------



    Original Message


  • 7.  RE: Restrict Shipper ID to specific warehouse

    Posted 02-02-2019 10:27
    Edited by Dan Burleson 02-02-2019 10:28
    If the goal is to restrict ShipperID's - not UserID's and since role isn't tied to a ShipperID, once might prefer to add a UDF for WarehouseCode to the SO_ShipperID table. Then, use the UDF as the basis from rejecting the order warehouse or individual line warehouse. Either method would be scriptable.

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 8.  RE: Restrict Shipper ID to specific warehouse

    Posted 02-02-2019 12:34
    +1 what Dan Burleson said. 

    -1 what Jim Woodhead said. 

    --
    Robert Wood
    352-615-5898

    --

    Sent from my portable brain


    ------Original Message------

    If the goal is to restrict ShipperID's - not UserID's and since role isn't tied to a ShipperID, once might prefer to add a UDF for WarehouseCode to the SO_ShipperID table. Then, use the UDF as the basis from rejecting the order warehouse or individual line warehouse. Either method would be scriptable.

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


Related Content