Sage 100

So you have 3 options re Calculate Freight in SO Options - Yes, No, Actual.  It appears that you have to choose Actual if you want the line weights calculated on an order.  But that means if you have manually entered a freight charge for an order and then change something, it will wipe out your freight amount as it tries to recalculate (assuming you do not have freight tables setup in Sage).  Has anyone found a way around this?  I feel like we really need a 4th option - "No, but calculate weights"

------------------------------
Beth Bowers
Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
(269) 358-0989
------------------------------

Agreed - total weight is useful info to have no matter how you calculate shipping.

Lee

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

Yes. If the orders are being V/I imported, make the H.FreightAmt in the Data tab appear AFTER all the Line fields are set. For the manual S/O Entry case, this is what I saw on one customer's system that was pretty cool.

In Customizer:

• Lock the Freight Amt field on pTOTALS panel
• Add UDF for Billed Freight just below. Users key in the Freight amt here.
• Add checkbox UDF next to Billed Freight. Call it Lock Frt (or something)

A script runs from these 2 places:

• When the Lock Frt box is ticked, it copies UDF Billed Freight to FreightAmt.
• On the PreTotals event. This means when you add / change / delete a line and the weights change, script re-copies the Billed Freight over.

(For 2024.1, 2024.0, 2023.0 - 2023.4, you must call into Sage Support to get a scripting hotfix to avoid Error 88s and 65s)

------------------------------
Alnoor Cassim
Accounting Systems, Inc. (ASI)
------------------------------