Sage 100

I'm curious if anyone has developed something fancy to address a situation like this: The client has orders of 2,000+ items. These 2,000 items usually ship to 2,000 different locations which Standard Sage dictates each item on its own sales order. I'm trying to find a way where the client doesn't have to manage thousands upon thousands of sales orders (and the resulting invoices). I considered consolidating the items by ship date and using UDFs to store ship to information on the lines table, but they use StarShip and Avatax which break that option. Has anyone encountered something like this before?

National accounts for the billing portion?

Believe it or not, we did this with one client using Sales Order line level UDFs to store the individual ship to addresses and the Shipping is done with a modification to the old Barsa Shipping Link owned by ISM now. Our client is on maintenance and ISM keeps it up to date for us. Our customer imports the order lines on these occasional orders that have hundreds of ship to addresses.

That almost sounds like they're selling to a big box store and need EDI.

thanks for your responses! @BrettLyder - did they have any Avatax in the mix? I was hoping someone had fought the same battle, that is helpful information. @RhondaMcNamara - Would EDI consolidate the orders and address the taxing? My clients using EDI still end up with an order for each ship to location.

That's the difference. I'm pretty sure they don't have Avatax in their mix.

If they ARE selling to a big box, you can get all their orders through EDI (import them as SO's, send them back out as invoices and shipping notices) and they actually will be separate SO's with the distribution center (or final destination store) as their ship to address. But you don't care that it's a hundred SO's because everything is automated. HighJump (True Commerce) brings in the orders, you fill them, it sends the shipping info and invoices back to the bill to party. Don't be surprised if they aren't already doing some of this EDI on some website but don't realize that's what it is. With True Commerce, you buy a 'partner, like Walgreens. And however Walgreens does their orders and wants their invoices, True Commerce already knows their way and uses their way and it doesn't even matter if Walgreens uses X EDI provider. Everything can go through your VAN (network) and come out looking the same. (Mapadoc and SPS also have EDI integration for Sage 100) Sales Tax? I don't feel like EDI would address that, but my clients sell to resellers more than direct to consumer.

Sadly not going to a big box retailer. I have an inquiry out to Avalara to see if AvaTax can talk to UDFs. If so, then I'll plan to go the UDF route. If they can't, then I'll plan to go the heavy drinking route.

Avalara came back and said while they can't talk to UDFs, there is a new piece of functionality where you can enable line-level ship to addresses. This looks about perfect but I'm curious if anyone has turned this on yet. Anyone have feedback? https://help.avalara.com/kb/001/Line_Level_Ship-to_Addresses_in_Sage_100