Sage 100

 View Only
  • 1.  Starship and fractional quantities?

    Posted 09-14-2023 13:49

    I'm dealing with an issue related to the client using non-integer quantities being shipped (UoM = weight in lbs).  Apparently Starship cannot handle decimal precision with quantities?  How is that possible?

    I've been asked to write scripts to round up quantities into a UDF within SO_PackageTrackingByItem / SO_InvoiceDetail, and are currently struggling when the package rounded quantities don't equal the line rounded quantities, when a line is split into multiple packages... with ScanForce not triggering the script I wrote to fix the line rounded quantity UDF... all of which should not be required

    How on earth does Starship not support decimals in QuantityShipped?!?!?  Is this a struggle others have experienced?



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


  • 2.  RE: Starship and fractional quantities?

    Posted 09-14-2023 13:59

    I feel your pain !

     

    I was amazed when I was told the same thing by Starship.

     

     

     

     






  • 3.  RE: Starship and fractional quantities?

    Posted 09-14-2023 14:35

    I would find it difficult to ship half an item.

    You could change the mapping to a fixed value for quantity and always show 1 unit. Then map actual quantities to the Starship custom fields for use with any eNotify emails showing detail, etc. 

    If the problem is calculating weight and do not use a scale, then you could map the LineWeight field directly to the weight field in Starship.



    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 4.  RE: Starship and fractional quantities?

    Posted 09-15-2023 11:04

    This client ships bulk product where the UoM is weight, not "each".  Sage handles it perfectly, and how a supposedly-full-featured shipping program can't handle a product "quantity" as decimal value (where package count indeed must be an integer)... it's baffling.

    I appreciate the tips Bill.  Starship and ScanForce are working together on the issue, and they are using custom fields for the rounded quantity UDF with a special setup for weights (the details of which I have not been involved in).

    Decimal quantities should be a stock feature.  It's a pretty basic and common thing.



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