Fixed a bug that could affect all non-optimized tax reports as well as SQL optimized cash basis reports: Documents with over 20 tax detail records were getting excluded from reports that had an address restriction (i.e. a restriction to a single state) based on the Tax Detail Supplement address.

The DynamicZip Sales & Use tax reports are designed to extract the tax location address from the DZ Tax Detail Supplement table. The design specifications allow the process to handle up to 20 unique tax details this address extraction process. Prior to this service pack, our non-optimized tax reports were aborting the process if there were more than 20 total details (as opposed to more than 20 unique details). This bug only affects document selection when an address restriction (city, county, state or country) is used. Documents with more than 20 total details would be excluded from the address restriction. This could occur for example if the document has 20 line-items with one tax detail each plus the summary tax detail or 10 line-items with two tax details each, etc. The SQL Optimized reports (unless cash basis was selected) did not have this problem. This bug did not exist prior to Build 69-sp2.

Build 69