Skip to main content

Sage 100 - Enabling Freight Amount to Populate in Sales Order Totals

Explains why the rFreightAmt field passed by TrueCommerce does not populate in the Sales Order Totals tab in Sage 100 when a ShipVia is also being passed, and how to resolve it by updating Sales Order Options.

Written by Doug Heckman

Product: Sage 100


When exporting a Purchase Order (850) from TrueCommerce Foundry to Sage 100 and opening the resulting Sales Order, the Freight Amount on the Totals tab is not populating — even though TrueCommerce is passing a value for the rFreightAmt field.

Sage 100 is configured to calculate freight charges based on the Shipping Code (ShipVia) rather than accepting the incoming freight value directly. The ShipVia is a carrier/shipping method identifier that can be passed on an inbound Purchase Order (850). When Sage 100 detects a ShipVia value and is set to use it for freight calculation, it overrides the incoming rFreightAmt value — causing the freight amount from TrueCommerce to be ignored.


Disable Freight Calcuation


To allow the freight amount passed from TrueCommerce to populate correctly on the Sales Order Totals tab, you must disable the Use Shipping Code to Calculate Freight setting within the Sales Order Options.

This change affects ALL customers in Sage 100. Consult your Sage administrator before making any changes.

Navigate: Modules → Sales Order → Setup → Sales Order Options

Select: Entry tab

Set: Use Shipping Code to Calculate Freight → No

Select: Accept

Once saved, re-export the Purchase Order (850) from TrueCommerce Foundry to Sage 100 — the freight amount will now write correctly to the Sales Order Totals tab.


Additional Resources


rev 07/27/26

Did this answer your question?