Motility Software Idea Board

Make freight a percentage of parts like shop supplies and have it populate the freight line on work order total.

Dealers would be able to auto collect freight.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Feb 6 2019
  • Under Review
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    08 Feb 01:17

    To add on to this, anything that can be done to better capture actual freight costs and freight revenue would be very helpful. Having a default box or section on all parts & service tickets to maintain freight cost and price, as well as shipping method and tracking number all in one area would allow us to have a better handle on our freight p&l, and having it always on every ticket will help to eliminate manual entry errors and inconsistencies.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    15 May 17:19

    On the receiving ticket the freight amount would need to be divvied proportionately, based upon cost, between the quantity of items received.  That "calculated" freight charge would be added to a freight cost "bucket" for each specific part number.  There could then be a option in the company info to "add estimated freight to parts tickets" and add estimated freight to service tickets".  When the options are enabled, the system would add a quantity of 1 "freight" part number to the ticket when a part with a dollar amount in the freight cost bucket.  The cost of the freight part would be calculated like (freightcostbucket/totalonhand)*quantitysold

    Handling the freight this way would allow for freight cost on an individual part number basis.

    There would certainly be downfalls [a tiny expensive item shipped with a large, heavy and cheap item (giving the majority of the freight cost to the small item) for example]- but it would still give the opportunity to recover some of the lost freight.  I would compare this solution to shop supplies... it is far from perfect in similar ways [an expensive repair order that used little to no shop supplies, and a cheap repair order that used a ton of shop supplies (charging the customer that didn't use many shop supplies a larger amount of shop supplies) for example.]

    To help with the downfalls, maybe the system could first attempt to proportionately divide the freight cost based upon an algorithm of part weight and dimensions.  If that info does not exist in the system, it would instead use cost.  Some of the parts suppliers are including the part weights and dimensions in their price files (used for the price book updates).