Sage 100

Good morning - I'm wondering if anyone has a fancy idea for a workaround for how to use the ""Use Shipping Code to Calculate Freight"" option. When it's set to ""Actual"" the sales order calculates the Ship Weight field that the client needs, but it does not feed the freight to the invoice. If we set it to ""No"", we are able to retain the freight, but then the Ship Weight never calculates. Is this something I should try to do with scripting to ""copy"" the freight from the order into invoice/shipping data entry (I have not been able to practice my scripting at all), or is there something easier that I don't know about?

@JaneScanlan does this sound familiar to you? :smirk: I think this is something we came accross - didn't we? I can't remember.

I had a similar situation with a bookstore, using Actual. We created a script that asked the user while they were in SO Invoice Entry if they wanted to use the Freight from the SO.

Oh, and I just found that script, which was written for 4.40 in 2011.

Hi, Amber. This didn't sound right, so I tested ACTUAL in V2013 SP5 and it works as expected (don't you just cringe at those words?!). What version and SP are you on and I'll test here. Are the users changing anything such as the quantity shipped or ship-via that might not have weight associated that that ship to? Or, perhaps the weight tables have something like a zero in some of the weights? Invoice DE does recalculate the amount of the shipping based on changing items in Invoice.

Yes @NicoleRonchetti you did write a script for something like this. Although I'm not sure if it's working 100% correctly because of ever-changing things here. :)

Thank you everyone. Steve, Roberta - I will dig into your responses more. I appreciate the time!

@RobertaChase - I think I've uncovered another strange thing with ABC demo data (like not having drill down history in places). I was also able to see freight come into Invoice Data Entry (but not Shipping Data Entry, regardless of whether I had SO Options set to Actual or Yes) when using any of their Ship Via Codes that were previously defined. Once I created a new ""UPS GROUND"" code, the freight stopped feeding into IDE as well. Just wanted to give what update I could. @SteveIwanowski - thanks again for the script. Even if neither of my customers are interested, I will still be looking into trying to make it work for IDE and SDE in v5.x.

Hi, Amber. That is too odd. Can you copy both the main and the charges tab for UPS GROUND and post it here?

I set up UPS GROUND the exact same way as the ABC ""UPS RED"" and ""UPS BLUE"" codes.