Sage 100

I have a client that has multiple companies in their Sage install, 1 has Sales Tax turned on in SO & 1 does not. Recently, the one that does not is getting a message (see attached) that Sales Tax Reporting needs to be turned on in AR Options. I don't want it turned on. And, this happens at the point of keying in the Ship To zip code in Sales Order Entry. We have narrowed it down to the SY_SalesTaxScheduleZipXRef table. If the zip code is present in this table, we get the message; if its not in this table, no message. All zip codes are fine in the standard SY_ZipCode file. If someone is keying in an order, the user can click OK & it allows them to proceed with the order just fine. However, we are working with Website Pipeline & when they are bringing in orders from the web, this is stopping them. Any thoughts? I don't know how Sage is using this 2nd zip code file, assuming to calculate the correct sales tax for that zip code, but why is it looking at it for a company that doesn't have sales tax turned on & never has? I assume I need it for one company, but not the other. TIA!

In the company that is using Sales Tax Reporting, are you utilizing the functionality to assign the proper Sales Tax Schedule based on the Zip Code? If you are not, you an probably reinitialize that table. Website Pipeline may need to modify their code to ""check the AR Setup Option"", and if Sales Tax is not turned on, then they need to skip reading the SY_SalesTaxZipXRef table. (If I am understanding your problem correctly). I wonder what happens when you try and use VI to import an order into the company with sales tax turned off? If you get an error there, then I would report it to Sage as a Bug.

Thanks for the feedback; it helped point me where to dig a bit further into the Sales Tax Schedule Maintenance & Zip XRef screen. The existing website (without Website Pipeline) for the company without sales tax is currently using VI to import orders into SO Entry & does not have an issue with this table or warning. This table has had data for years, but it seems like the warning is only recent, so trying to figure out what changed.

The SY_SalesTaxScheduleZipXRef table is not setup by company. It looks like what is happening, is a new customer in the (non Sales Tax) company gets set up with a zipcode matching one of the entries in the table. The customer then is assigned the matching Sales Tax Schedule even though sales tax is not used for the company. Could be a recent entry added to the file, or something in a recent Sage update that caused the change in behavior . Either way, it sounds like a bug. Work around might be to clear that table, and have users select the Tax Schedule manually for customers added in the company that does track Sales Tax.