https://support.kampdata.com/ 2026-05-13T12:52:43+00:00 https://support.kampdata.com/ https://support.kampdata.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2019-03-04T18:44:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:allow_use_of_zip_code_tax_schedules_for_single_rate_states&rev=1551725068&do=diff Allow use of Zip Code Tax Schedules for single rate states Situation Starting with Build 74 DynamicZip began using Statewide Tax Schedules for single rate states. This has proven to be problematic for some users who have other integrating software that expects ZIP Code tax schedules. text/html 2017-09-18T18:43:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:automatic_customer_schedule_selection_not_honoring_outside_city_selection&rev=1505760236&do=diff Automatic customer schedule selection not honoring Outside City selection Situation When Assign Tax Schedule is selected in the DynamicZip Setup window, tabbing or clicking into the Tax Schedule ID field in the Customer Address Maintenance window automatically selects a tax schedule for the address. This process should consider any tax schedule that contains city level taxes as invalid for a customer flagged as being text/html 2017-09-18T17:26:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:build71_to_build74_conversion_problem&rev=1505755616&do=diff Fix problem converting from build 71 and earlier Situation Build 71 and earlier tracked only the last modification to each tax detail. This tracking was done in the DZ Tax Detail Supplement table. Build 72 and later track all tax detail modifications in the DZ Tax Detail Modifications table. The conversion problem was related to a query that copied this last modification into the new table. text/html 2018-06-27T16:43:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:canadian_city_and_province_fips_codes_removed_by_rate_and_boundary_import&rev=1530117798&do=diff Canadian city and province FIPS codes removed by rate and boundary import One process that occurs during the Rate and Boundary Import is synchronization of the DZ Geocode Master table with the FipsCodes.txt File. Since this file does not contain Canadian city and province FIPS codes, the process was removing them. text/html 2025-05-31T13:30:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:city_level_taxes_getting_setup_as_county_locals&rev=1748698238&do=diff City level taxes getting setup as county locals This bug did not exist for the import of the ZIPsales Database and this fix has no effect on that import. This fix resulted in the applicable city name being included in the tax schedule. For example, prior to this fix the tax schedule for Cullman AL 35077 had the tax schedule description of AL CULLMAN co local 9%. After this fix, the tax schedule for Cullman AL 35077 has the tax schedule description of AL CULLMAN, CULLMAN co 9%. The city nam… text/html 2018-06-27T20:24:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:complete_import_failing_when_path_on_server_is_blank&rev=1530131045&do=diff Complete+ import failing when path on server is blank Running the DZ Rate and Boundary Import was failing with a SQL error when SQL Optimized was selected and the path on server was blank. text/html 2017-09-18T20:10:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:correct_casing_problem_related_to_case_sensitive_table_conversions&rev=1505765455&do=diff Correct casing problem related to case sensitive table conversions The DynamicZip table conversion of the DZ Tax Detail Supplement table includes replacing KDCty (a 28 character field) with KdCty (a 35 character field). When selecting records from versions of the table that predate build 74, the DynamicZip code was erroneously selecting KdCty instead of KDCty. This causes a SQL error on installations using a case sensitive sort order. text/html 2017-09-18T18:40:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:customer_taxable_status_ask_not_asking&rev=1505760002&do=diff Customer Taxable Status of Ask was not asking Situation A customer's taxable status set to Ask in the DZ Customer Supplement window should prevent DynamicZip from selecting a schedule if both a taxable schedule and an exempt schedule exist for the tax location and no tax schedule has previously been selected for this tax location. Once a schedule has been selected, it is considered valid for this location whether it is taxable or exempt. text/html 2017-09-18T17:12:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:default_import_source_to_zipsales_database&rev=1505754772&do=diff Default import source to ZIPsales Database Situation Prior to this modification the Rate and Boundary Import Source defaulted to KampDatabase. This proved to be confusing to our users. Resolution As of this update, the Import Source defaults to ZIPsales Database. text/html 2017-09-18T21:17:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:disabled_company_not_fully_disabled&rev=1505769455&do=diff Disabled company not fully disabled When a company is disabled in the DZ System Setup window it was not fully disabling DynamicZip. A workaround for this was to turn off the DynamicZip features for that company in the DynamicZip Setup window. This problem has been fixed as of Build 76.14. ---------- text/html 2017-09-18T21:58:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:document_freight_and_misc_tbic_error&rev=1505771898&do=diff Document Freight and Misc TBIC Error DynamicZip Tax by Item Category was not properly updating the taxability of the document's freight and misc charges when a change was made to the document's ship-to state. This was fixed in the following builds: * DynamicZip Build 74.3 * DynamicZip Build 75.3 * DynamicZip Build 76.2 ---------- Modifications text/html 2017-09-18T18:26:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:dz_extended_tax_recalculation_report&rev=1505759193&do=diff DZ Extended Tax Recalculation report Situation When running DZ Extended Tax Recalculation, a report should be generated listing the changes that were made by this process. This report was not being generated. Resolution The DZ Extended Tax Recalculation report is now being generated. text/html 2017-09-18T18:27:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:dz_sales_batch_processing_report&rev=1505759271&do=diff DZ Sales Batch Processing report Situation When using the Base Freight Tax on Sales in SOP option for a state that also has the FREIGHT category setup in TBIC can produce confusing results on the DZ Sales Batch Processing report. Example * Tax by Item Category (TBIC) is selected in the DynamicZip Setup window * TBIC has FREIGHT setup to be nontaxable in a state text/html 2016-06-14T18:42:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:error_converting_dz_import_history_table_from_build_71_or_earlier&rev=1465929727&do=diff Error converting DZ Import History table from Build 71 or earlier When converting the DZ Import History table from Build 71 or earlier to Build 77 or above, the conversion would fail due to a missing comma in the SQL statement used to copy the data from the old table to a new temp table. text/html 2017-09-18T21:18:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:exempt_schedule_selected_but_tax_not_zeroed_out&rev=1505769515&do=diff Exempt schedule selected but tax not zeroed out Situation When the tax location is changed in the Sales Item Detail Entry window as a result of the user modifying the Site ID, Ship To Address ID or the Shipping Method to a tax location in which either the item is nontaxable based on DynamicZip Tax by Item Category or the customer is exempt based on the setting in the text/html 2023-09-04T14:28:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:exempt_tax_details_not_being_created_or_updated&rev=1693837733&do=diff Exempt tax details not being created or updated The rate and boundary import process was referring to the Update Number in the DZ Tax Detail Supplement table to determine if the tax detail has already been updated during the current import. If it had already been updated, the update process was not repeated in order to help speed up the import. Since the exempt detail is created/updated immediately after the taxable detail and both details are linked to the same detail supplement record, the up… text/html 2017-09-18T17:06:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:failure_to_find_statewide_exempt_schedule_when_always_exempt_selected&rev=1505754392&do=diff Failure to find statewide exempt schedule when Always Exempt selected Situation * Always Exempt is selected in the DZ Customer Supplement window * The customer's address is in a single rate state. Indication When tabbing or clicking into the tax schedule ID field for the above customer: text/html 2020-10-20T21:19:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:fixed_inconsistent_character_casing&rev=1603228746&do=diff Fixed inconsistent character casing This fix affects only SQL installations using a binary, case-sensitive collation. Inconsistent character casing was causing SQL errors during various DynamicZip processes. Resolution This inconsistency has been corrected. This was completed in the following builds: text/html 2025-05-31T13:25:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:fixes_and_enhancements_to_the_onesource_complete_rate_and_boundary_import&rev=1748697935&do=diff Fixes and enhancements to the ONESOURCE Complete+ rate and boundary import * Maximum amount taxable with tax over max not handled correctly * City level taxes getting setup as county locals * Purchase tax details not getting created for single rate states text/html 2025-05-31T13:33:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:fixes_and_enhancements_to_the_sts_rate_and_boundary_import&rev=1748698401&do=diff Fixes and enhancements to the STS rate and boundary import * Maximum amount taxable with tax over max not handled correctly * City level taxes getting setup as county locals * Purchase tax details not getting created for single rate states text/html 2017-09-18T17:53:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:freight_taxability_update&rev=1505757219&do=diff Freight Taxability Update Situation With the Base Freight Tax on Sales in SOP option, freight taxability must be updated whenever something changes on the SOP document that may affect the freight taxability. Prior to this modification, deleting a line-item did not trigger this action. This action cannot run while the text/html 2015-02-11T18:02:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:geocode_error_running_dynamiczip_tax_reports&rev=1423677768&do=diff Geocode error running DynamicZip tax reports Fixed a bug that was causing the following error when running a DynamicZip tax report: Can't find specified column SQL #207: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'KDGeoCode'. text/html 2015-02-11T18:03:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:geocode_from_ship-to_address_for_sql_optimized_tax_reports&rev=1423677784&do=diff Geocode from ship-to address for SQL optimized tax reports A bug in the code that identifies the geocode associated with the ship-to address was causing the SQL optimized version of the DynamicZip tax reports to have a blank geocode. This bug has been fixed. text/html 2015-02-11T18:03:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:handle_errors_caused_by_missing_tables&rev=1423677808&do=diff Handle errors caused by missing tables If a user other than sa or DYNSA logged into a company that was missing one or more of the DynamicZip tables, it would result in an error that disabled DynamicZip. If after getting the error, the user logged into a company that was not missing any DynamicZip tables, DynamicZip failed to re-enable. text/html 2017-09-18T18:41:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:improved_table_status_information&rev=1505760061&do=diff Improved Table Status Information Situation Under certain circumstances, the DZ Table Status window was erroneously showing one or more tables as missing when in fact they were not missing. For example, if the user did not have permission to access the table(s) the Table Status window showed those tables as missing. Under other circumstances the DZ Table Status window was showing a status of Error for tables that were actually missing. text/html 2022-03-17T14:41:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:local.txt_key&rev=1647528088&do=diff LOCAL.txt file current rate identification bug The rate and boundary import process was using the geocode in the LOCAL.txt file to determine which records are current and which are history. With the first line considered to be current and subsequent lines history. The actual determination is the geocode plus the city name. This has been fixed. This bug resulted in the El Paso city local tax not getting imported as there was a line proceeding it for Desert Haven which used the El Paso geocode. text/html 2019-03-04T19:51:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:lock_taxable_and_exempt_ids_in_dz_state_setup&rev=1551729105&do=diff Lock Taxable and Exempt ID's in DZ State Setup For states whose rates & boundaries are imported, DynamicZip manages the Taxable and Exempt ID's as shown in the DZ State Setup window. However there are situations where you may need to manage those manually. The DZ State Setup window now includes a check box to Lock Taxable & Exempt ID's. When this check box is selected, the text/html 2017-09-18T18:25:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:make_auto_dz_tax_recalculation_optional&rev=1505759118&do=diff Make Auto DZ Tax Recalculation optional Situation In the prior minor update Auto DZ Tax Recalculation was made not optional when Tax by Item Category (TBIC) is selected in the DynamicZip Setup window. Resolution Auto DZ Tax Recalculation is now optional. This was completed in the following builds: * DynamicZip Build 74.10 * DynamicZip Build 75.10 * DynamicZip Build 76.9 ---------- Modifications text/html 2017-09-18T18:24:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:make_it_optional_to_use_exempt_schedules_for_nontaxable_items&rev=1505759076&do=diff Make it optional to use exempt schedules for nontaxable items Situation Prior to this update, using exempt schedules for nontaxable items was not optional. This could create a problem when using custom tax schedules. Also, if the exempt tax schedule did not exist, it could result in the line-item having no tax schedule. text/html 2025-05-31T13:30:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:maximum_amount_taxable_with_tax_over_max_not_handled_correctly&rev=1748698216&do=diff Maximum amount taxable with tax over max not handled correctly This bug did not exist for the import of the ZIPsales Database and this fix has no effect on that import. Some jurisdictions cap the amount taxable at a specified rate and tax the amount over the cap at a different rate. DynamicZip failed to create the tax detail for the amount over the cap. This has now been corrected. text/html 2015-04-08T21:04:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp8&rev=1428527094&do=diff Microsoft Dynamics GP v.8 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 8.0. Build 68 * Build 68 ---------- Modifications text/html 2015-05-21T17:44:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp9&rev=1432230295&do=diff Microsoft Dynamics GP v.9 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP v.9.0. * Build 69 * Build 70 ---------- Modifications text/html 2015-05-21T17:44:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp10&rev=1432230241&do=diff Microsoft Dynamics GP 2010 Modifications The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 10.0. * Build 72 * Build 71 text/html 2015-05-21T17:41:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp11&rev=1432230116&do=diff Microsoft Dynamics GP 2010 Modifications The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2010 (v.11). Build 74 * Build 74 Build 73 * Build 73 text/html 2015-05-21T17:38:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp12&rev=1432229909&do=diff Microsoft Dynamics GP 2013 Modifications The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2013 (v.12). Build 75 * Build 75 Build 73 * Build 73.14 * Build 73.13 text/html 2016-06-01T17:25:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp14&rev=1464801943&do=diff Microsoft Dynamics GP 2015 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2015 (v.14). Build 76 * Build 76 * Build 77 Modifications text/html 2016-10-21T23:05:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp16&rev=1477091114&do=diff Microsoft Dynamics GP 2016 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2016 (v.16). Build 78 * Build 78 Modifications text/html 2020-10-23T16:56:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18.2&rev=1603472218&do=diff Microsoft Dynamics GP 2019 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2019 (v.18.2). * Build 82 Modifications text/html 2020-10-23T16:56:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18.3&rev=1603472203&do=diff Microsoft Dynamics GP 2020 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2020 (v.18.3). * Build 83 Modifications text/html 2021-10-25T16:08:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18.4&rev=1635178112&do=diff Microsoft Dynamics GP 2021 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2021 (v.18.4). * Build 84 Modifications text/html 2022-10-13T21:07:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18.5&rev=1665695255&do=diff Microsoft Dynamics GP 2022 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2022 (v.18.5). * Build 85 Modifications text/html 2023-11-22T16:54:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18.6&rev=1700672079&do=diff Microsoft Dynamics GP 2023 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2023 (v.18.6). * Build 86 Modifications text/html 2024-11-07T15:46:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18.7&rev=1730994412&do=diff Microsoft Dynamics GP 2024 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2024 (v.18.7). * Build 87 Modifications text/html 2026-01-06T16:24:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18.8&rev=1767716671&do=diff Microsoft Dynamics GP 2025 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2025 (v.18.8). * Build 88 Modifications text/html 2019-10-29T16:39:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:microsoft_dynamics_gp18&rev=1572367169&do=diff Microsoft Dynamics GP 2018 The DynamicZip builds listed below are compatible with Microsoft Dynamics GP 2018. * Build 80 * Build 81 Modifications text/html 2026-01-06T16:27:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:modifications&rev=1767716863&do=diff Modifications How do I tell what build of DynamicZip is installed? Click here for a link to the KampData Download Page. Click here for instructions on how to install DynamicZip. by DynamicZip build number * Build 88 * Build 87 * Build 86 * Build 85 * Build 84 * Build 83 * Build 82 * Build 81 * Build 80 * Build 79 * Build 78 * Build 77 * Build 76 * Build 75 * Build 74 * Build 73 * Build 72 * Build 71 * Build 70 * Build 69 * Build 68 by Microsoft Dyn… text/html 2017-09-18T19:55:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:no_longer_prompt_user_to_save_customer_card_before_creating_supplement&rev=1505764516&do=diff No longer prompt user to save customer card before creating supplement When a user creates a new customer card and selects DZ Customer Supplement from the Additional menu in the Customer Maintenance window, DynamicZip no longer prompts the user to save the new customer card. In the past DynamicZip called the script 'Handle Changes' of window RM_Customer_Maintenance of form RM_Customer_Maintenance to save the new customer card. However doing so causes the customer address(s) created along with t… text/html 2017-09-18T17:25:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:nontaxable_items_getting_taxed_in_sop&rev=1505755505&do=diff Nontaxable items getting taxed in SOP Items set as Nontaxable in the Item Maintenance window were getting taxed. To enhance the DynamicZip tax reports, DynamicZip changes the line-item's tax option to Base on Customer and assigns the line-item an exempt tax schedule. The line-item's tax option was getting set to Base on Customer, but the exempt tax schedule was not getting assigned. text/html 2025-05-31T13:31:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:purchase_tax_details_not_getting_created_for_single_rate_states&rev=1748698266&do=diff Purchase tax details not getting created for single rate states This bug did not exist for the import of the ZIPsales Database and this fix has no effect on that import. When sales tax rates and boundaries have been imported for a single rate state, a subsequent rate and boundary import of purchase tax rates failed to add the purchase tax detail to the state-wide tax schedule. This has been corrected. text/html 2017-09-18T21:52:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:save_operation_on_table_kd_county&rev=1505771566&do=diff Save Operation on table KD_County This modification corrected an error condition that occurred during the import of the ZIPsales Database for the state of Florida. The error first occurred with the January 2015 release of the ZIPsales Database. The warning message would appear and pause the import requiring the user to click OK to continue. At that point the import would continue and the import process would correctly import the rates and boundaries. text/html 2017-09-18T16:58:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:set_customer_taxable_status_sql_optimized_bug&rev=1505753894&do=diff Set Customer Taxable Status - SQL Optimized Bug Situation When running the DZ Customer Supplement menu choice to “Set customer taxable status” in SQL Optimized mode... Indication The resulting report contains the following line: * An error occurred setting customer taxable status. text/html 2017-09-18T19:02:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:simplify_the_dz_rate_and_boundary_import_window&rev=1505761347&do=diff Simplify the DZ Rate and Boundary Import window The DZ Rate And Boundary Import window was causing confusion for many of our users. This confusion was primarily related to the following: * Which import options to select. * What to do when the Path on Server is not accepted. To address these issues, the default import options are now automatically selected by choosing the text/html 2017-09-18T16:46:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:skip_leading_columns_if_blank_when_writing_csv_file&rev=1505753214&do=diff Skipped leading columns if blank when writing export report Fixed a bug that was causing the the first columns in a row to be skipped if they were blank. This resulted in the following columns being shifted to the left in the comma or tab delimited file being written. This affected the following reports: text/html 2016-06-30T22:42:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:some_rural_tax_schedules_were_missing_the_county_tax_rate&rev=1467326566&do=diff Some rural tax schedules were missing the county tax rate The tax rates imported do not always include tax schedules for outside city limits. To accommodate situations where the actual Tax Location is outside city limits, the rate and boundary import process creates rural tax schedules. In cases where the import file contains a collection of tax rates for a particular county that excludes city taxes, that collection of tax rates was (and still is) being used as the rural tax schedule. However… text/html 2015-02-11T18:04:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:sql_error_assigning_customer_tax_schedules&rev=1423677854&do=diff SQL error assigning customer tax schedules We fixed a bug in our code that could cause the following error when running the assign schedules routine: Error executing SQL GPS Error: 41 SQL Error: 207 [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'YT'. text/html 2017-09-18T18:43:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:sql_optimized_schedule_assignment_accepting_taxable_schedule_for_exempt_customer&rev=1505760184&do=diff SQL Optimized schedule assignment accepting taxable schedule for exempt customer Situation When a customer that already has a valid taxable schedule assigned to one or more of its address cards is flagged as exempt in the DZ Customer Supplement window, subsequently running the DZ Assign Customer Tax Schedules process with the SQL Optimized check box selected, the process was accepting the currently assigned taxable schedule instead of switching it to an text/html 2018-04-24T19:00:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:sql_optimized_tax_reports_not_printing&rev=1524596410&do=diff SQL Optimized Tax Reports Not Printing The DynamicZip SQL Optimized reports failed to print and unless Debug mode was enabled, no error message appeared. The workaround was to run the reports with SQL Optimized turned off. Resolution This was fixed as of the following builds: text/html 2015-02-11T18:03:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:sql_table_exists_function&rev=1423677820&do=diff Improved SQL TableExists() function Modified January 22, 2015 After this modification DynamicZip tests for the existence of a SQL table by using the following query: select * from sys.tables where name = {table name} If this query returns a row, then the table exists otherwise it does not. text/html 2018-06-27T20:11:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:statewide_exempt_schedules_with_no_description&rev=1530130297&do=diff Statewide exempt schedules with no description Statewide exempt schedules were getting created with no description. This happened with the SQL Optimized import if the statewide exempt schedules did not already exist and if Use Zip Schedules for Single Rate States was not selected in the text/html 2017-09-18T18:52:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:tax_detail_and_tax_schedule_import_restrictions_not_restricting&rev=1505760755&do=diff Tax detail and tax schedule import restrictions not restricting Situation The Import Status settings made in the DZ Tax Schedule Supplement window and in the DZ Tax Detail Supplement window were not working. Regardless of what was selected as the Import Status, the import was updating both (the tax detail and the tax schedule). text/html 2017-09-18T19:54:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:tax_detail_defaults_affecting_existing_tax_details&rev=1505764455&do=diff Tax Detail Defaults affecting existing tax details The Tax Detail Defaults were affecting existing tax details. This was problem was fixed as of the following builds: * DynamicZip Build 75.14 * DynamicZip Build 76.13 ---------- Modifications text/html 2017-09-18T17:51:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:tax_recalc_of_nontaxable_items&rev=1505757067&do=diff Tax Recalc of Nontaxable Items Situation To enhance the DynamicZip tax reports, DynamicZip changes a nontaxable line-item's tax option to Base on Customer and assigns the line-item an exempt tax schedule. This worked correctly when the line item is added to the document. However, when text/html 2017-09-18T17:28:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:track_tax_free_counties_option_restored&rev=1505755699&do=diff Track Tax Free Counties Option Restored Situation The DZ State Setup window option to track tax free counties was discontinued with Build 74. In certain situations, this has made extracting the necessary tax reporting information more difficult. Resolution The DZ State Setup window option to track tax free counties has been restored. text/html 2017-09-18T18:50:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:triggers_inadvertently_disabled&rev=1505760648&do=diff Triggers inadvertently disabled This situation existed only in DynamicZip Builds 74.9 through 74.11, 75.9 through 75.11 and 76.8 through 76.10. Situation When Assign Tax Schedule is not selected in the DynamicZip Setup window, certain triggers were inadvertently disabled. The triggers affected include those for the following features: text/html 2017-09-18T18:12:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:unexpected_exempt_schedules_in_tax_schedule_supplement&rev=1505758361&do=diff Unexpected Exempt Schedules in Tax Schedule Supplement Situation Prior to actually putting the DZ Tax Schedule Supplement table into use, DynamicZip code was adding records to this table. This happened with the late releases of Build 66 and the early releases of Build 67. This process added exempt schedules to this table as well as taxable schedules. Since the text/html 2017-09-18T19:01:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:update_exempt_tax_details_posting_account_by_state&rev=1505761293&do=diff Update exempt tax details posting account by state The DZ Set Posting Accounts window was failing to update the posting account on exempt tax details when the Selection Method was set to State. This problem did not occur when the Selection Method was set to Range of Tax Details. This was problem was fixed as of the following builds: text/html 2017-09-28T20:32:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:use_zip_code_schedules_for_single_rate_states_with_zip2tax&rev=1506630742&do=diff Use Zip Schedules for Single Rate States with Zip2Tax The option to Use Zip Schedules for Single Rate States in the DynamicZip Setup window was not working with the Zip2Tax Import. text/html 2015-02-11T18:04:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:install:mods:wizard_report_sort_order_for_zipsales_returns&rev=1423677864&do=diff Wizard report sort order for ZIPsales Returns Since we no longer use the geocodes from the ZIPsales Database, using our geocodes for the ZIPsales Returns could result in confusion. Also we were identifying the jurisdiction by geocode. Multiple rates or jurisdictions could exist in the same geocode which may result in reporting inaccuracies.