Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Calculated freight amount changing between Sales Order and invoice

  • 1.  Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 12:28

    Sage 100 Premium 2022. Multiple instances where calculated freight amount based on shipvia and weight changes when an order is converted to an invoice.  Quantities do NOT change.

    Has anyone seen this?  Any ideas on how it is happening?



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------


  • 2.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 13:16

    Changes UP or DOWN or both?



    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 3.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 13:25

    Any entries in the Shipping Rate Maintenance table (sales order setup menu)?  You can look using the UI by making sure the setup options are set correctly.  Ther may be a shipping rate entry recalculating the freight when the order is invoiced.

    1. Expand Modules, Sales Order, Setup, Sales Order Options
      • Click Entry tab
      • For "Use Shipping Code to Calculate Freight", select Yes or Actual
      • Click Accept
    2. Expand Modules, Sales Order, Setup, Shipping Rate Maintenance
    3. If shipping codes will not be used to calculate freight charges, repeat Step 1 above and change to the value back to No.


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



  • 4.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 13:59

    They are using the Shipping rate maintenance, 



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------

    Original Message


  • 5.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 14:00

    Seems to be going up, but that may be the only ones the customer complains about...



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------

    Original Message


  • 6.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 14:04

    What's are the calculation types they use?  can you narrow it down to one shipping code?  



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

    Original Message


  • 7.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 15:41

    It's all on one shipping code - the one they use for delivery, and there are no qty breaks - all one rate.



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------

    Original Message


  • 8.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 15:00

    Line weights may change between SO and invoice... and shipping rates may change between SO and invoice.  I believe the recalculation of freight amount always happens in the Pre-Totals event (which is why manual freight amounts never work with the SO option enabled for freight calculations).



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



  • 9.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 15:42

    I built a query to check if the weight changed and it doesn't



    ------------------------------
    Phil McIntosh
    Friendly Systems
    ------------------------------

    Original Message


  • 10.  RE: Calculated freight amount changing between Sales Order and invoice

    Posted 07-07-2025 16:11
       Is this a recent phenomena?   Could someone have changed the shipping rate between order-entry and invoice-creation?

    Lee
    --

    Friendly Systems

    Visit us on the web at www.friendlysystems.com
    Office:  678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:       678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com



    Original Message


Related Content