Can anybody help us please?

Hard to provide specific help on this type of issue without someone remoting into your system to troubleshoot it further. Here are some shots in the dark:

1. Since changing 8.50 for less than $200 works but >= $200 doesn't, maybe in 2018 (but not in 2014) you have a 3rd party  enhancement OR a User Defined Script (UDS) that is executing after and overriding your Ship Via / Shipping Rate logic for orders created outside the Launcher.

To check if a UDS is attached to the business objects go to Custom Office > Main > UDF Maintenance. Find SO Sales Order Header then rt-click and choose User-Defined Scripts. If you see any, identify which event they run on and review the code. Perhaps there is a SetValue("FreightAmt", 0) line. Repeat the procedure for SO Sales Order Detail and look for similar. For enhancements you can go to Installed Modules Listing under Library Master > Reports. Some of them do have their own Freight logic.

2. Part of SData at least uses BOI which is known to occasionally have issues with Premium due to the wrong SQL driver info in the Sota.ini file. Probably you're ok here just in case, run OITest.exe in \mas90\home to verify.

3. In S/O > Setup > Sales Order Options > Entry tab, is Use Shipping Code to Calculate Freight possibly set to Actual instead of Yes? That means the item weights in Item Maintenance override.

4. In Shipping Rate Maintenance, if you pull up your Ship Via code used on your SData and eBiz Web Services orders, is there something other than 0.00 for the Base Amount? Maybe a negative number?

Hope that helps.

Thanks for your advice. Unfortunately it didn't help and we still have that issue.

1) we checked enhancements and there are no 3rd party enhancements installed. We have one UDS script that add weight value into new UDF field (multiply weight by quantity). It doesn't affect anything else and was in place for years and worked before too.

2) We did driver test and ran that script. It ran ok:

3) We checked Use Shipping code to Calculate Freight is set to Yes:

4) We checked ship via code in shipping rate maintenance and it has zeros:

Can anybody help?

We also made another test, we put in the first line the "invoice amount up to" = 0.01 and "freight charge" = .00 and it made all orders with 0 freight. It means that invoice amount is coming to this function as zero, for any order. Doesn't matter what you order and how many - it always coming as 0 invoice amount to this evaluation. Maybe, it's because invoice is not yet created when we submitted the order?

Can anybody help pls?

Can anybody help please? Still having this awful issue :-(

Hello! We are still having this issue. :-(

Please help!

This is a highly specialized thing.  Have you called Sage technical support?

At some point in time, and I don't remember when as we've been on almost every release of Sage 100 in the last 15+ years, Sage changed how this worked if I'm remembering correctly.    We used to use Shipping Rate Maintenance, our tiers were by weight, and freight was added to each SO and all was good.   Sometime, way back, we used EBM also, and it worked then too.   Sage changed how it worked during one of the updates and I seem to remember the issue for us was that the shipping rate was OK the first time you added it to an order, but as soon as the order was touched in anyway again it disappeared (went to $0.00).   Sage Tech Support was finally able to tell us that is was working as designed :-(      As others suggested, talk to tech support and escalate until they answer you!  Hope I'm wrong, btw!

Yes we called, but there are no support nor for SData, nor for e-business Web Services. It worked great in previous versions of MAS but after upgrade it always return 0 as invoice amount to that shipping rate maintenance....

But it works when someone enter order manually in desktop application. :-(