Sage 100

 View Only

  • 1.  Warehouse Transfers and Landed Cost

    Posted 07-27-2021 09:34
    When the company transfers inventory items between the Chicago and L.A. warehouses, there is freight involved. The Transaction Entry for Warehouse Transfer in Sage 100 does not provide the opportunity for "Landed Costs". Any ideas?

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Warehouse Transfers and Landed Cost

    Posted 07-27-2021 10:00
    DSD has an enhancement where a Bill can be a component of itself, allowing you to do the warehouse move as Production entry, adding the freight costs that way.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Warehouse Transfers and Landed Cost

    Posted 07-27-2021 15:21
    I think Scanco has this as well @Therese Logeais????
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: Warehouse Transfers and Landed Cost

    Posted 07-27-2021 15:30
    I appreciate the recommended solutions.  They don't currently have any enhancements so I am probably going to recommend a manual method although it is a bit more labor intensive.  Here's my manual solution:

    Instead of using warehouse transfers, use 2 inventory adjustments.  Example: transfer 10 of item ABC from Chicago to L.A.  Current cost in the Chicago warehouse is $10 each.  Cost of shipping to L.A. is $100.

    Adjustment1: remove qty 10 @$10 from the Chicago whse.

    Adjustment 2: add qty 10 @ $20 to L.A. warehouse.  $100 shipping / 10 units = $10 / unit shipping cost.  $10 shipping cost + $10 base cost = $20 landed cost.

    This method requires manually calculating the landed cost which may be error prone and cumbersome if there are more than one or two each day.  Depending on the volume, they ,may elect to use an automated solution such as the DSD add-on.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 5.  RE: Warehouse Transfers and Landed Cost

    Posted 07-28-2021 11:02
    I also believe DSD has an enhancement for this. I spec'd this exact scenario for a client many years ago. Allow a cost change during a warehouse transfer. It may have been a one off, so maybe not current inn their offerings.

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


Related Content