https://support.kampdata.com/ 2026-05-13T13:35:45+00:00 https://support.kampdata.com/ https://support.kampdata.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2017-09-07T18:50:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:allow_override_by_state_faq&rev=1504810215&do=diff Customer exempt in specific states only Can a customer be exempt in one state while taxable in other states? The DZ Customer Supplement window has a feature to allow the customers' to be taxable or exempt based on the state. This feature is the Allow Override by State option on the DZ Customer Supplement window. text/html 2017-09-08T21:23:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:apply_naming_rules_faq&rev=1504905829&do=diff Apply Naming Rules The following applies to DynamicZip Build 73 and earlier. As of Build 74 place names are controlled by the use of the FipsCodes.txt File. DynamicZip comes with default naming rules that are meant to keep your customer addresses standardized and identifiable for text/html 2015-03-06T20:44:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:assign_schedules_report_messages&rev=1425674698&do=diff Assign Schedules Report Permission to access this report is granted to the Customer Cards Task. This report is generated when you click Preview or Process in the DZ Assign Customer Tax Schedules window and can be restricted based on your Exceptions Reported settings. You can use this report to view any changes made by the Assign Tax Schedules process, and to find & correct any addresses that DynamicZip was unable to assign a tax schedule to. text/html 2015-03-06T22:44:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:assign_schedules_unhandled_script_faq&rev=1425681856&do=diff Assign Schedules Unhandled Script The following message can occur when upgrading from builds prior to DynamicZip Build 73.9 to a later release of Build 73. This does not apply to Build 74 and later. Unhandled script exception: [Microsoft][SQL Server Native Client x.x][SQL Server] Could not find stored procedure 'XX.dbo.kd_CstmrUpdt_OpenCrsr'. text/html 2019-03-20T17:08:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:automatically_select_schedule_faq&rev=1553101713&do=diff How does DynamicZip automatically select a tax schedule? The Assign Tax Schedule option must be selected in the DynamicZip Setup window. DynamicZip has two methods of automatically assigning a tax schedule to a ship-to address: * City, state, and ZIP Code method using text/html 2017-09-08T18:55:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:bad_break_field_faq&rev=1504896956&do=diff Bad Break Field How do I fix a Bad Break Field error? The error message, “Bad break field in an additional footer or header. Recheck.” may be caused by an issue with the DynamicZip modified report dictionary (The KD581R.DIC file found in your Microsoft Dynamics GP Data folder). text/html 2024-01-05T21:08:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:california_report_faq&rev=1704488928&do=diff Reporting Sales & Use Tax in California How can I use DynamicZip to generate the amounts needed to complete my CA State tax return ? By printing an Option D Tax Report with the proper settings (Please see below.), then opening that report in a spreadsheet software, like Microsoft Excel, and adding four additional columns and a row of totals at the bottom. The resulting spreadsheet should provide the information required to accurately complete a CA State sales tax return. Here are our instructi… text/html 2015-05-20T21:32:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:category_overrides_faq&rev=1432157563&do=diff What are item category overrides for? * An inventory item is set to base on customers in the Item Maintenance window. This is the base level. * If the item needs to be nontaxable for some states, then you can add it to an Item Category and setup that category as nontaxable for those states. text/html 2019-03-20T18:28:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:clean_reimport_database_faq&rev=1553106520&do=diff How do I do a clean re-import of the Rate & Boundary Database? Simply re-importing the Rate & Boundary Database will refresh your current tax schedules along with their tax details. Under normal circumstances, this re-import is all that is required. text/html 2019-03-20T18:53:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:colorado_home_rule_faq&rev=1553108013&do=diff Colorado Nexus How can I handle a Home Rule taxing situation in Colorado? Colorado State may require for you to collect sales tax based on the city and county in which you are physically located. This “Home Rule” requires city tax to be collected only for your text/html 2019-03-20T17:29:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:copy_dz_company_tables_faq&rev=1553102992&do=diff Can I copy over DynamicZip tables from one Microsoft Dynamics GP company to another? Many of the DynamicZip tables are supplementary to Microsoft Dynamics GP company tables, and for this reason we do not recommend copying just the DynamicZip tables. text/html 2015-05-20T21:40:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:copy_item_classes_to_categories_faq&rev=1432158059&do=diff Can I create matching Item Categories for all my Item Classes? NOTE: Upgrading from DynamicZip build 71 or earlier may require that you convert from using Microsoft Dynamics GP Item Classes for taxability by State (Tax by Item Class) to using DynamicZip Item Categories (Tax by Item Category). Please see text/html 2017-09-07T22:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:correct_invalid_schedules_faq&rev=1504823449&do=diff How do I correct invalid schedules? The “No valid ID found for...” message can occur where ever DynamicZip Automatic Tax Schedule Selection occurs. This message it typically the result of an invalid address. Customer, Vendor or Site Cards If clicking on, or tabbing to, the Tax Schedule ID field causes DynamicZip to throw the text/html 2015-03-05T22:28:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:create_new_report_option_faq&rev=1425594516&do=diff How do I create a new report option? * Open the DZ Reports window. * Select a report from the Reports list. * Click New to open the DZ Report Options window. * Name your new report option and modify the sort order by clicking the Primary Sort expansion button to open the DZ Report Section Options window. The selections available for sort order will vary depending on the report you select. text/html 2017-09-08T16:50:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:create_sql_tables_faq&rev=1504889420&do=diff How do I create SQL tables? If you are using Microsoft >> SQL Server, an extra step is required to create the DynamicZip tables. This procedure must be run by sa as ordinary users will not have the required rights to create tables. Automatic Table Creation: text/html 2019-03-20T17:31:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:creating_a_dz_test_company_faq&rev=1553103119&do=diff How can I create a test company for running DynamicZip in Demo Mode The following steps will allow you to run DynamicZip in Demo Mode using data that matches what's in your live Microsoft Dynamics GP company. * Create a backup of your Microsoft Dynamics GP accounting system. text/html 2019-03-13T18:51:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:customer_combiner&rev=1552503096&do=diff Using the Professional Service Tools Customer Combiner The Professional Service Tools Customer Combiner can be used to combine two customers into one. It does this by modifying all occurrences of one of the Customer ID's to the other Customer ID. This can result in a duplicate key error if Customer ID is part of a unique key in any SQL table. For example, the text/html 2019-03-20T18:45:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:delete_report_option_faq&rev=1553107500&do=diff How do I delete a report option? * Open the DZ Reports window. * Select a report from the Reports list. * Select the report option you want to delete and click Modify to open the DZ Report Options window. * Click Delete. ---------- FAQ text/html 2018-05-02T18:42:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:demo_mode&rev=1525286577&do=diff Free Trial of DynamicZip Demo Mode is provided so that users may try out DynamicZip prior to purchasing. Follow this link for information about creating a test company for running DynamicZip in Demo Mode. Registration keys are not required for Demo Mode. DynamicZip is fully functional in Demo Mode, but only in the Microsoft Dynamics GP text/html 2015-03-03T21:42:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:determination_remove_obsolete_schedules_faq&rev=1425418962&do=diff How is the determination made to remove obsolete tax schedules? Obsolete Tax Schedules will be removed only if all of the following are true: * The first 5 characters of the tax schedule ID = a ZIP Code included in the current import. * The first 2 characters of the tax schedule description = a state code included in the current import. text/html 2017-09-08T21:00:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dictionary_needs_to_be_upgraded&rev=1504904428&do=diff Dictionary needs to be upgraded Dictionary '(path) KD581R.DIC' needs to be upgraded. Use Microsoft Dynamics GP (Great Plains) Utilities to update your modified DynamicZip forms and reports. This message may occur if you are upgrading from a previous build of DynamicZip and have an existing DynamicZip report dictionary (KD581R.DIC). The file KD581R.DIC contains any modifications that you make to DynamicZip reports. The original report is stored in KD581.DIC (the DynamicZip application dictionar… text/html 2019-03-26T16:58:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:disable_enable_dynamiczip_faq&rev=1553619535&do=diff How do I disable/enable DynamicZip IMPORTANT: Disabling a company using DZ System Setup window is effective system-wide. There may be times when you will need to disable DynamicZip for troubleshooting or testing purposes. Disable DynamicZip per workstation: * Open the Customization Status window (Tools text/html 2015-03-06T19:41:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:documents_missing_faq&rev=1425670908&do=diff Why would documents be missing from my reports? Standard DynamicZip tax reports are based on the RM Key File. This table provides a good starting place to pull transactions originating in any sales module into the report. If the RM Key File record is missing for any sales document, that document will be excluded from standard DynamicZip reports. text/html 2015-05-22T16:50:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:drop_recreate_sql_table_faq&rev=1432313411&do=diff How do I drop and recreate a SQL table? If you need to delete a DynamicZip table so that you can recreate a fresh empty table, then please follow these steps: * Determine the table(s) to be deleted. * Open the DZ Table Maintenance window. * Set the Procedure field to Drop & Recreate. text/html 2017-09-08T16:49:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_accomodate_migrations_to_sql_server_faq&rev=1504889380&do=diff How does DynamicZip accommodate migrations to Microsoft SQL Server? NOTE: The following applies to migrations from other databases such as Btrieve or c-tree to Microsoft >> SQL Server. It does not apply to upgrades from one version to another on Microsoft SQL Server. text/html 2018-05-02T18:44:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_build_installed_faq&rev=1525286668&do=diff How do I tell what build of DynamicZip is installed? You can determine which build of DynamicZip you are running by opening the About DynamicZip window. This shows a sample of DynamicZip build 77 as Version 14.0.77.1. The version number is in the following format: Microsoft Dynamics GP Release Number text/html 2018-05-02T18:43:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_install_workstation_faq&rev=1525286637&do=diff DynamicZip Workstation Installation Does DynamicZip need to be installed on each workstation? DynamicZip must be installed on each workstation that needs access to its features. The tax details and tax schedules will be available to all workstations, but the following features will only be available to the workstations that DynamicZip installed: text/html 2018-04-30T18:52:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_installation_reinstallation_faq&rev=1525114348&do=diff DynamicZip Installation Checklist Testing DynamicZip before you buy? Please read about running in demo mode. How Do I install DynamicZip? NOTE: Backup your Microsoft Dynamics GP accounting system before beginning a DynamicZip installation or upgrade. * See the Download Page to download the appropriate installation file. If you need help choosing, please refer to text/html 2018-05-02T18:50:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_integration_manager_faq&rev=1525287057&do=diff Does DynamicZip work with Integration Manager? Yes, but there may be some issues. Integration Manager simulates keystrokes so DynamicZip works with Integration Manager as it would if the documents were being entered manually. The issues come down to the situations that could be handled easily when entering the documents manually, but that pose a potential problem when using Integration Manager. These are: text/html 2020-06-22T20:22:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_new_company_faq&rev=1592857363&do=diff How do I add DynamicZip to a new company? NOTE: This section assumes that you already have DynamicZip installed and working in at least one company in your Microsoft Dynamics GP accounting system. * From a computer that has DynamicZip installed open Microsoft Dynamics GP and select the new company. text/html 2018-04-24T18:27:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_recalcalltax_failed_to_register_for_pop_purchasing_invoice_entry&rev=1524594454&do=diff DynamicZip RecalcAllTax failed to register for POP Purchasing Invoice Entry This message can be related to custom code when installing or upgrading DynamicZip. We have only seen that during development if there is a problem when modifying a startup script. text/html 2018-05-02T19:08:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_registration_keys_work_faq&rev=1525288094&do=diff Why won't my DynamicZip registration keys work? * Be sure you are entering them in the DZ Registration window. * Verify that the DZ Registration window's Site Name matches exactly with the Site Name listed with the registration keys we generated. * Verify that the DZ Registration window shows the correct version of Microsoft Dynamics GP . text/html 2019-03-20T17:45:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:dynamiczip_report_wizard_faq&rev=1553103904&do=diff What is the DynamicZip Report Wizard? As DynamicZip reports have become increasingly more flexible and powerful, the report options have increased, resulting in a more complex setup. To make it simple for you to generate the reports you desire, we have added the report wizard. text/html 2018-02-12T22:11:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:error_45&rev=1518473512&do=diff Error 45 This error has been seen to occur when attempting to convert a DynamicZip table that was being replicated by SQL. After turning replication off, the table was successfully converted with no error. text/html 2017-09-07T20:21:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:exempt_county_by_customer_faq&rev=1504815713&do=diff Customer County Tax Exemption How can I make a single customer exempt from a county tax? To handle a customer who is tax exempt from a county tax you could create a custom Tax Schedule The custom tax schedule could have the state Tax Detail, the exempt county Tax Detail (So your sales to this customer's county could be tracked and reported as exempt sales) as well as any city or local Tax Detail that may apply. text/html 2017-09-07T18:47:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:exempt_customer_faq&rev=1504810024&do=diff How does DynamicZip handle tax exempt customers? DynamicZip allows you to flag customers as tax exempt via the DZ Customer Supplement window. Here are some steps you can follow for setting up a customer as tax exempt. * Open the Customer Maintenance window (Cards >> Sales text/html 2017-09-08T18:26:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:exempt_fl_reporting_faq&rev=1504895183&do=diff How can I find the Exempt Amount of Items Over $5,000 for FL tax reporting? Several counties in Florida have a maximum taxable amount of $5,000.00. Items costing over $5,000 are partially exempt at the county level. In other words, just the first $5,000 is taxed by the county. text/html 2019-08-06T15:05:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:frequently_asked_questions&rev=1565103948&do=diff DynamicZip Frequently Asked Questions Please select the relevant category from the options on the right tool bar to view the related list of FAQs. Installation, Setup, and Upgrades * How do I setup a new installation of DynamicZip? * How do I upgrade DynamicZip? * Can I test DynamicZip before buying? * Which DynamicZip build should I download and install? * Does DynamicZip need to be installed on each workstation? * How can I tell what build of DynamicZip is installed? * How do … text/html 2018-10-03T21:00:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:grant_sql_table_rights_faq&rev=1538600440&do=diff How do I grant SQL table rights? After creating or converting SQL tables and/or stored procedures, rights must be granted to make these tables and/or procedures available to the SQL users. Microsoft Dynamics GP creates and uses a Microsoft SQL Server group text/html 2017-09-07T21:59:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:handle_items_taxable_some_states_faq&rev=1504821576&do=diff How do I handle items taxable in some states and not in others? Some items or services are taxable in certain states and exempt in others. How does DynamicZip handle this situation? You have two primary options available to deal with this situation. text/html 2017-10-31T17:56:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:how_modify_remove_faq&rev=1509472606&do=diff How Can I Modify/Remove Details or Schedules? DynamicZip has tools and utilities to help you manage your tax details and tax schedules. Modify Tax Schedule * Open the DZ Modify Tax Schedules window. * Select the range of tax schedules that you want to modify. * Select which schedules you want to modify - All, Exempt, or Taxable. text/html 2015-05-22T20:06:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:identifying_documents_that_cause_reporting_errors&rev=1432325166&do=diff Identifying Documents that cause Reporting Errors I am getting a SQL error when printing DynamicZip tax reports. What can I do to resolve this error? Begin by trying to print the report non-SQL Optimized. This may allow you to print the report successfully and serve as a workaround until the problem is resolved. text/html 2019-03-20T18:15:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:import_group_id_single_state_faq&rev=1553105720&do=diff How do I update a single state or group of states? DynamicZip has a function called Group ID to allow for a single state or group of states to be linked together for things like the Rate & Boundary Import, Assign Tax Schedules and Address Correction routines. From the DZ Rate and Boundary Import window, DZ Assign Customer Tax Schedules window or the DZ Customer Address Correction window. * Clear the Update all states check box. text/html 2015-03-02T23:42:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:import_work_some_states_faq&rev=1425339732&do=diff Why doesn't the import work for some states? When you select Update all states from the DZ Rate & Boundary Import window, the scrolling window displays all records in the DZ State Setup table. Two things that can prevent a state displayed in the scrolling window are: * If the state does not exist in the text/html 2018-09-25T22:01:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:import_zip_addresses_only_faq&rev=1537912862&do=diff How do I import ZIP Addresses only? Zip Addresses will be imported automatically during the Rate & Boundary Import process. To import zip addresses for states in which you do not collect sales tax: Build 74 and Later * Create a group of the desired states making sure not to include any of the states in which you do collect sales tax. text/html 2017-09-08T20:59:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:invalid_registration_keys&rev=1504904377&do=diff Invalid Registration Keys DynamicZip registration keys are entered in the DZ Registration window. To check your registration keys for validity you can open that window (the keys should already be displayed) and click Save. The window should close with no error message. text/html 2017-09-07T22:04:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:items_partially_taxable_faq&rev=1504821868&do=diff How do I handle items that are partially taxable? Some states tax certain items at a percentage of the normal rate or tax only a portion of the sales amount for a particular item. The best way to handle these situations is to use the DynamicZip Tax By Item Category feature. text/html 2015-03-06T00:38:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:jurisdiction_sort_faq&rev=1425602292&do=diff What is meant by Jurisdiction Sort? DynamicZip defines a Jurisdiction as a unique collection of Tax Detail In other words, if a transaction has three associated tax details, those three tax details represent a jurisdiction. Every other transaction included in the report that has those three and only those three tax details will be included in that particular jurisdiction. text/html 2015-03-06T22:34:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:kd_convertfiles_table_citrix_faq&rev=1425681296&do=diff Why do I get an error when I login using Citrix, but not when I login with Remote Desktop? If logging into Microsoft Dynamics GP using a Citrix server causes the following error, SqlTableExists() of form KD_ConvertFiles Table: SQL_GetData() returned status: 102| Internal error #58 SQL error #102 SQL error: [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'FROM'. ODBC error: 37000 text/html 2015-03-05T00:42:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:maintain_tax_system_faq&rev=1425516124&do=diff How do I maintain my tax system? The primary tasks involved in maintaining your tax system are handled automatically when you perform the monthly updates by importing the Rate & Boundary Database. This process updates the appropriate tables to reflect the latest tax rates and other setup options. This import process is typically performed monthly. text/html 2015-04-28T17:40:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:modify_dz_reports_faq&rev=1430242810&do=diff Can DynamicZip reports be modified using Microsoft Dynamics GP Report Writer? DynamicZip reports can be modified using Report Writer. For example, you may wish to add Taxable/Exempt Freight and Misc. columns to the Sales - Option E report, which can be done using Report Writer. text/html 2017-09-08T18:01:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:modify_existing_report_option_faq&rev=1504893687&do=diff How do I modify an existing report option? * Open the DZ Reports window. * Select a report from the Reports list. * Select the report option you want to modify and click Modify to open the DZ Report Options window. * Choose a new name for your modified report (Optional). * Make any changes that you want for your modified report. text/html 2017-09-08T17:28:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:multicurrency_faq&rev=1504891733&do=diff Does DynamicZip allow multicurrency? Microsoft Dynamics GP performs the tax calculations, not DynamicZip which means using multicurrency should have no effect on DynamicZip functionality. Microsoft Dynamics GP Sales Transaction Entry breakdown: * text/html 2019-03-20T18:43:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:multiple_countries_faq&rev=1553107430&do=diff How does DynamicZip handle foreign countries? DynamicZip currently supports only the U.S.A. and Canada. You may have customers who do business in other countries that have ZIPs/Postal Codes similar to the U.S.A. (For example; Italy, Mexico, Australia, Malaysia, etc.). In this situation, you need a way to restrict DynamicZip functionality to only affect the supported countries. Otherwise, text/html 2019-03-20T17:06:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:naming_rules_faq&rev=1553101591&do=diff What are Naming Rules? Build 74 and later Naming Rules are no longer used starting with Build 74. The FipsCodes.txt import file is now used to manage and control place names. Prior to Build 74 DynamicZip naming rules are used to control and standardize the county and city names in the text/html 2020-06-19T14:34:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:new_install_instructions&rev=1592577259&do=diff New Installation Setup Instructions Note: For specific help with any DynamicZip window or field, please use the built in DynamicZip Help by pressing F1 or clicking on the “?” button. * Install DynamicZip. * Open the DynamicZip Setup window to configure the general DynamicZip settings. * Open the text/html 2019-03-20T17:34:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:online_help_faq&rev=1553103252&do=diff DynamicZip Online Help DynamicZip is installed with an Online Help file (KD581.chm) that can be easily accessed from any DynamicZip window. To use the DynamicZip Help: From any DynamicZip window, press the F1 key or click on the “?” button to open the DynamicZip Help. The DynamicZip Help will open focused on the documentation for that specific window. text/html 2015-04-20T22:23:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:please_enter_registration_keys&rev=1429568630&do=diff Please enter registration keys for DynamicZip This message can occur when the DynamicZip product that has been installed is not the correct one for the registration keys that you have received or for the release of Microsoft Dynamics GP you are running. text/html 2016-09-26T22:16:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:pop_project_accounting_faq&rev=1474928193&do=diff How can I use Use Tax Accrual with Project Accounting? I need accrued tax to be included in the Forecasting window's Total Cost. Tax accrued in the background by DynamicZip is not automatically added to a project's cost. However, the steps below may provide a functional workaround for updating a project's cost to include tax on purchases. text/html 2017-09-08T18:02:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:print_report_option_faq&rev=1504893732&do=diff How do I print a report option? * Open the DZ Reports window. * Select a report from the Options list and click Insert to insert the report into the Print List. You can insert all of the reports by clicking All. * To select where you want the report to print, click Destination. Reports can be printed to the screen, to a printer, to a file (text, comma or tab-delimited, or text/html 2017-09-08T18:51:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:printing_same_page_faq&rev=1504896703&do=diff How can I keep multiple states from printing on the same page? The DynamicZip Tax Reports do not have forced page breaks by default. You can add page breaks using the Report Writer. * Select Tools >> Customize >> Report Writer. * Select DynamicZip as the product. text/html 2019-03-20T17:51:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:purchase_tax_accrual_debit_credit_faq&rev=1553104265&do=diff Why does the use tax accrual distribution contain both a debit and a credit? For invoices, the debit side of the accrual is based either on the Purchases account assigned to the vendor or the Tax account specified in Posting Account Setup for Purchasing, depending on your selection in the text/html 2020-06-15T15:24:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:rate_and_boundary_import_checklist&rev=1592234690&do=diff Rate and Boundary Import Checklist Click here for a video tutorial on the Monthly Rate and Boundary Import process. IMPORTANT: For first time installations, please be sure to complete the new install instructions prior to importing. Some setup options will only take effect once the import process completes. Before Importing text/html 2017-09-08T18:24:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:reconcile_reports_dynamics_gp_faq&rev=1504895090&do=diff How can I reconcile DynamicZip reports to Microsoft Dynamics GP Transaction History Reports? The Option B, E and F reports are good reports to use when reconciling DynamicZip tax reports to Microsoft Dynamics GP sales transaction history reports. These reports are text/html 2015-03-06T00:59:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:reconcile_tax_period_reports_faq&rev=1425603568&do=diff How can I reconcile DynamicZip tax reports to Microsoft Dynamics GP Tax Period Reports? At the present time we are not aware of a way to reconcile these reports for the following reasons: * The Microsoft Dynamics GP Tax Period Report draws its numbers directly from the tax detail records attached to transactions. This means that if a transaction or even a line item on a transaction has no tax details then those sales numbers will not be included in the Microsoft Dynamics GP Tax Period Report… text/html 2017-09-08T16:52:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:recreate_dynamiczip_stored_procedures_faq&rev=1504889522&do=diff When do I need to recreate DynamicZip stored procedures? This procedure is rarely used. The DynamicZip stored procedures are created as part of the DynamicZip create tables procedure. These are the stored procedures automatically generated by Dexterity for SQL table access. Under normal circumstances these stored procedures are permanent and do not change for the life of the table to which they pertain. text/html 2017-09-08T17:29:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:report_option_selection_faq&rev=1504891797&do=diff How do I choose which report option to use? DynamicZip provides two types of tax reports. We refer to these two types as Document Centric and Detail Centric. Document Centric Document centric reports assume that all the charges on each document have a single tax location. In other words, if your document includes text/html 2017-09-08T18:49:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:report_section_options_faq&rev=1504896596&do=diff How should I set the report section options? To access the DynamicZip report section options select Reports >> DynamicZip and select the desired report option. Then click Modify to open the DZ Report Options window. Click the Primary Sort expansion button to open the DZ Report Section Options window. Modify the report section options to text/html 2015-03-06T20:17:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:reports_sorting_properly_faq&rev=1425673026&do=diff Why aren't my reports sorting properly? The DynamicZip™ Tax Detail Supplement table contains much of the information that is used to sort the DynamicZip Reports. This table is created and maintained automatically as part of the Rate & Boundary import Database import process. If you create your own tax details, you will need to enter the appropriate information into this table by hand. text/html 2015-05-22T17:44:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:reports_zipsales_returns_faq&rev=1432316667&do=diff How do I use DynamicZip reports with ZIPsales Returns? The Sales - Option F report type is used for printing the text file for CCH's Sales Tax Returns Online. With DynamicZip's Report Wizard you can create the report in 7 easy steps. Modifications for state restrictions, date restrictions, file path modifications, etc. can be made using the text/html 2015-04-16T21:46:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:rest_of_state_faq&rev=1429220782&do=diff Illinois Nexus How can I handle Illinois' Rest of State tax? Example You may have situations in Illinois where the state requires the IL state sales tax to be collected throughout the state, but only require the city, county and county local taxes for sales in Chicago (all other city, county and local sales taxes being exempt). This page details two methods of approaching this kind of situation. text/html 2015-05-20T22:30:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:run_assign_tax_schedules_logged_in_faq&rev=1432161005&do=diff Can I run the Assign Tax Schedules and/or Address Correction routines while other users are logged in? While the assign tax schedules and address correction routines are running, the customer address cards are in a state of flux. Customer addresses or tax schedule IDs may be modified or replaced. Users entering sales transactions during these processes may end up with the old, unmodified address or tax schedule ID, or they may end up with the newly updated address/tax schedule ID (Depending on … text/html 2015-03-02T23:34:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:run_dynamiczip_updates_logged_in_faq&rev=1425339296&do=diff Can I run the Rate & Boundary Import while other users are logged in? While importing the Rate & Boundary Database, the tax details and tax schedules are in a state of flux. Therefore, no transactions involving sales or use tax should be entered or modified during the import process. Also, other DynamicZip processes or reports should be deferred until after the import process completes. text/html 2017-05-10T17:15:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:running_sql_optimized_reports_faq&rev=1494436502&do=diff What's the difference between running SQL Optimized and non-SQL Optimized reports? Temporary tables are required to create our tax reports. The difference between SQL Optimized and non-SQL Optimized reports is the SQL Optimized process builds the temp tables on the Microsoft SQL Server using SQL queries, while the non-SQL Optimized process builds the temp tables on the local workstation using native Dexterity. text/html 2015-03-06T00:40:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:sales_tax_adjustments_reports_faq&rev=1425602456&do=diff How can I enter sales tax adjustments that will be properly reported using the DynamicZip sales tax reports? The “correct” way to handle tax adjustments, as far as DynamicZip tax reports are concerned, is to create a return for the entire incorrect document and then reenter it correctly. This way the return offsets/zero's out the incorrect document on the report. The replacement document is complete and will be handled correctly by the reporting process. text/html 2015-03-05T20:25:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:sales_tax_posting_account_faq&rev=1425587156&do=diff How can I setup the sales tax posting account? You can setup default accounts, and you can assign accounts to tax details. Default Posting Account Setup Microsoft Dynamics GP provides a default posting account for sales tax liability. Taxes associated with any text/html 2019-03-20T17:47:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:schedule_assigned_to_new_sales_faq&rev=1553104055&do=diff Why isn't a tax schedule assigned to new sales documents? When new sales documents are created, Microsoft Dynamics GP automatically assigns a tax schedule to the document. This is a function of Microsoft Dynamics GP and additional information on this feature should be available in your Microsoft Dynamics GP documentation and Online Help. text/html 2017-09-29T18:02:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:schedules_removed_during_import_faq&rev=1506708160&do=diff Why are some tax schedules removed during the import process? There are a variety of reasons for which Tax Schedules are removed or made invalid during the rate & boundary import. Typically, the schedule being removed is being replaced with multiple schedules, or multiple schedules are being replaced with a single schedule. Here are a few possibilities: text/html 2019-03-20T18:32:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:select_states_collect_tax_faq&rev=1553106762&do=diff How do I select which states to collect tax in? For purposes of the Rate & Boundary Import procedure, “all states” means all the states included in your Rate & Boundary Database subscription. Prior to Build 74, states for which you have specified a statewide Taxable ID were also excluded. As of build 74, the import process determines which states will use statewide tax schedules. text/html 2018-06-13T14:16:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:service_pack_faq&rev=1528899405&do=diff Minor Updates The following applies to upgrades of DynamicZip when the build number stays the same while only the minor update number increases. Occasionally, software minor updates are released to fix bugs or to add/improve features and functionality. It is our mission to keep minor release installations quick and easy. Minor releases are not considered a new build or version. For example Builds 73.1, 73.2, 73.3, etc are all minor releases of Build 73. Table conversions or significant changes… text/html 2017-09-07T17:59:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:setup_country_default_faq&rev=1504807141&do=diff Country Default FAQ How do I set the default country value for my U.S. addresses? * Open the DynamicZip Setup window. * Select the checkbox for Country Default for U.S.A., and then enter the country code that you wish to use for all of the addresses in the United States.Examples: USA, U.S.A., US. text/html 2017-12-07T21:32:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:setup_tbic_faq&rev=1512682325&do=diff How can we setup and use DynamicZip Tax By Item Category feature? To enable and use Tax By Item Category, you could perform the following steps. * Enable Tax By Item Category on the DynamicZip Setup window. * Create an Item Category in the DZ Item Category Maintenance window. * Assign one or more items to your Item Category with the DZ Item Supplement window. * Setup rules to control how the items in your new text/html 2018-10-10T17:07:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:standard_schedules_work_company_faq&rev=1539191229&do=diff  How do I create custom tax schedules? DynamicZip provides certain tools to assist with the maintenance of non-standard tax schedules. If the Tax Details and Tax Schedules automatically created by the Rate & Boundary Import do not work for your tax situation, then the use of these tools and procedures may be helpful to you. text/html 2019-03-20T18:33:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:start_charging_tax_new_state_faq&rev=1553106824&do=diff How do I begin charging sales tax in a previously untaxed state? These steps were written with the assumption that you were using Statewide Schedules for the previously untaxed state. * Open the DZ State Setup window and pull up the state. * Delete the values from the Taxable ID and the Exempt ID fields. text/html 2019-03-20T18:02:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:states_exclude_taxation_faq&rev=1553104973&do=diff How do I handle the states that I want to exclude from taxation? To handle nontaxable states, you can use Statewide Schedules This approach allows you to specify a single tax schedule ID to use for all taxable customers, and another, single tax schedule ID for all exempt customers (in the given state). By using text/html 2015-04-13T18:10:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:statewide_exempt_schedules&rev=1428948608&do=diff Statewide Exempt Schedules To create exempt tax details and schedules for each state: * Open the DZ State Setup window * Use the Create Statewide Exempt Schedules menu option. NOTE: When creating statewide exempt schedules, you will be given the option of auto inserting these tax schedule IDs into the state setup table as the Exempt ID for each state. Auto-inserting saves you the trouble of manually entering the Exempt IDs for each state in the text/html 2019-03-20T17:07:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:statewide_tax_schedule_id_format&rev=1553101662&do=diff Statewide Tax Schedule ID Format DynamicZip can create Statewide Tax Schedule for use with states in which you do not collect tax. You can create these schedules from the DZ State Setup window Create Statewide Taxable Schedules and Create Statewide Exempt Schedules menu options. Character 1 - 2 text/html 2019-03-20T17:23:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:statewide_taxable_or_exempt_schedules_faq&rev=1553102587&do=diff When should I use statewide taxable & exempt schedules? By using Statewide Tax Schedules you can specify a single taxable and a single exempt tax schedule to be used for all shipments into a particular state. This selection is made by entering a tax schedule ID in the Taxable ID and text/html 2017-09-08T16:55:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:switch_city_names_uppercase_faq&rev=1504889755&do=diff How can I switch city names to uppercase for addressing purposes? This is controlled by the Uppercase Address setting in DynamicZip Setup. If you would like to use uppercase, you can make this selection in the ZipAddressing section of DynamicZip Setup, it will be effective immediately on all new entries. text/html 2018-05-02T19:08:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:table_conversion_fail_faq&rev=1525288130&do=diff What do I do when a table conversion fails? DynamicZip Table Conversions are required whenever the design of a DZ table is modified. The DZ Table Status window has been designed to determine if any DZ tables need to be upgraded/converted, and if so, it can also help you convert those table(s). text/html 2015-04-22T23:27:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_by_item_category_faq&rev=1429745246&do=diff How can I control the taxation of Items, Freight & Misc. on a per state basis? DynamicZip has a feature called Tax By Item Category that allows you to control the taxation of inventory items, freight, and miscellaneous charges on a per state basis. The DZ Tax By Item Category Setup window allows you to choose a state, an text/html 2017-12-07T21:34:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_by_item_class_faq&rev=1512682457&do=diff Item Taxability by State How can I control the taxation of Items, Freight & Misc. on a per state basis? DynamicZip has a feature called Tax By Item Category which allows you to control the taxation of inventory items as well as freight and miscellaneous charges on a per state basis. The text/html 2017-09-07T18:51:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_certificate_faq&rev=1504810286&do=diff Tax Exemption Certificates How does DynamicZip manage tax exemption certificates? The DZ Customer Supplement window contains two fields for managing state issued tax exemption certificates. They are the Tax Exemption Number and Exempt Status Expiration Date fields. To setup a tax exemption certificate for a customer: * Open the text/html 2017-09-07T22:25:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_detail_benefits_faq&rev=1504823156&do=diff Why should I use DynamicZip's exempt tax schedules instead of my own? Every nontaxable schedule created by DynamicZip contains at least one Zero Rate Tax Detail. This is necessary because of the way transaction history is stored by Microsoft Dynamics GP When you post a transaction, the tax details used on that transaction are stored in the Microsoft Dynamics GP history tables. Information such as which state, county and city the transaction was taxed for is only trackable through the tax deta… text/html 2015-03-05T20:34:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_part_of_item_faq&rev=1425587688&do=diff We have taxable and nontaxable goods that are always sold together. We would like to use a single Inventory Item for the sale of these goods. Is this possible with DynamicZip? At times you may have a single Inventory Item in which you are only required to collect partial tax on. For example you may be selling a package which includes nontaxable labor plus a taxable item. If you setup this package as a single item you will find that when entering this package on a sales document it must be eithe… text/html 2018-10-18T17:07:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_report_messages&rev=1539882475&do=diff Tax Report Messages We have listed some of the report messages you may see and their meaning. * = Tax detail summary out of balance with tax detail line This message at the end of a DynamicZip tax report indicates that for at least one document included in the report, the sum of the line item tax detail records do not equal that tax detail ID's summary record. You can identify the questionable document and tax detail by text/html 2017-09-07T22:33:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_schedule_format_change&rev=1504823605&do=diff Tax Schedule ID with astrisk NOTE: The asterisk in the Tax Schedule ID proved to be confusing and its use has been discontinued as of Build 74. Upgrading from DynamicZip build 71 or older to Build 72 or Build 73 includes a modification in the tax schedule ID format. The addition of an asterisk in position 10 is used to identify the default city and county combination when more than one city and county exists in a ZIP code. Please read the information on this page to help ensure a smooth trans… text/html 2019-03-13T22:28:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_schedule_selection_logic_faq&rev=1552516105&do=diff Tax Schedule Selection Logic Build 74 and later * If DynamicZip is set to Restrict Tax Schedule Selection by Country Code and the tax location has a non blank country code that does not match the country code specified in the DynamicZip Setup window for the USA or for Canada, then no schedule will be selected and the process ends here. text/html 2017-09-08T20:56:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:tax_schedule_selection_messages&rev=1504904187&do=diff Tax Schedule Selection Messages Current ID accepted The current tax schedule is accepted as valid for this address. DynamicZip Tax Schedule Selection is disabled The Assign Tax Schedule option is not selected in the DynamicZip Setup window. EXEMPT ID accepted The current Tax Schedule ID is accepted under the text/html 2018-04-24T17:24:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:the_following_file_s_cannot_be_found_in_the_import_folder&rev=1524590644&do=diff The following file(s) cannot be found in the import folder If you receive any of the following messages when trying to import the rate and boundary files * Make sure you have downloaded the KampDatabase files from www.kampdata.com * Make sure you have downloaded the rate and boundary import file you use text/html 2018-04-24T16:51:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:the_rate_boundary_import_file_rates.txt_is_not_in_this_folder&rev=1524588701&do=diff The Rate & Boundary import file Rates.txt is not in this folder This message occurs when KampDatabase is selected in the Import Source dropdown in the DZ Rate and Boundary Import window and another rate database is being imported. Selecting the correct database as the import source will prevent this message. text/html 2015-03-05T23:07:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:track_tax_free_faq&rev=1425596866&do=diff How can I show full length geocodes in my ZIPsales Returns report? By default, the DynamicZip report specifies only the neccessary length Geocode for identifying the tax jurisdiction (State geocodes are 2 digits. County geocodes are 5. City geocodes are 10.). However, for some states additional settings need to be made so the report will show full length Geocodes. Hawaii and Wyoming are two of the known states. text/html 2015-03-06T01:01:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:transactions_selected_cash_basis_reports_faq&rev=1425603700&do=diff How are transactions selected for inclusion in cash basis reports? The Cash Basis report option will include only the sales and portions of sales that have a cash receipt within the range of Receipt Dates selected. If the cash receipt application amount is for less than the full amount of the sales document, then only the proportionate part of the sale and tax amounts will be included in the report. text/html 2015-03-06T21:41:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:unable_to_open_dictionary&rev=1425678104&do=diff Unable to open dictionary: .../KD581R.DIC The file KD581R.DIC contains any modifications that you make to DynamicZip reports. The original report is stored in KD581.DIC (the DynamicZip application dictionary) and is not modified. After modifying a report, you must grant security to each user and company that will be using that report. This is done by choosing Setup text/html 2018-12-03T18:53:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:uninstall_dynamiczip_faq&rev=1543863182&do=diff How do I uninstall DynamicZip? DynamicZip can be uninstalled by deleting all references to DynamicZip from the Dynamics Set File and from the Dex.ini. After these files have been modified, DynamicZip will effectively be removed from the Microsoft Dynamics GP application. text/html 2019-03-20T18:01:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:unknown_error_number54&rev=1553104893&do=diff Unknown error number 54 / SQL #515 /ODBC error: 23000 This is a SQL error that occurs when an attempt is made to insert a record into a SQL table that would result in duplicating one of the table's unique keys. SQL does not allow this to occur and throws this error. text/html 2015-03-06T22:42:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:unknown_error_number197&rev=1425681764&do=diff Unknown error (197) The following error message, “An open operation on table 'KD_TableStatus_TEMP' has caused an unknown error (197).” and you are subsequently unable to log into Microsoft Dynamics GP may have been triggered by attempting to install a 64 bit printer driver. text/html 2019-03-20T18:00:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:update_customer_address_records_faq&rev=1553104841&do=diff Customer Address Correction How can I update a large number of customer address records? DynamicZip provides a way for you to automate the process of updating your customer address records based on the DZ Zip Address table. This process assumes that the ZIP Code contained in the customer address records is correct, and will then update the city and state to match the spelling contained in the DZ Zip Address table. text/html 2015-04-16T21:06:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:updating_manually_created_tax_schedule_faq&rev=1429218386&do=diff How can I keep DynamicZip from updating my manually created Tax Schedule IDs? Create a tax schedule that contains a single tax detail having the appropriate tax rate. (Please refer to your Microsoft Dynamics GP documentation for instructions.) The Tax Schedule ID can be any non-zip type ID such as NVCUSTOM or NVSPECIAL. We recommend using the appropriate state code as the first two characters of the ID. The tax detail ID can be the same as the tax schedule ID. text/html 2018-05-02T19:04:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:upgrade_dynamiczip_faq&rev=1525287878&do=diff What happens during a DynamicZip Upgrade? You can upgrade DynamicZip by completing the Upgrade Instructions Technical Description of the Upgrade Process. DynamicZip is a Dexterity based program. Once installed, DynamicZip exists as the KD581 dictionary file (.DIC) located in your text/html 2021-03-29T20:28:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:upgrade_instructions&rev=1617049730&do=diff Upgrade Instructions NOTE: Settings and options from a previous build are retained, unless they are not compatible with the new build. * Before installing DynamicZip, we recommend that you make a complete backup of your accounting system. * text/html 2015-03-06T00:13:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:use_dynamiczip_report_wizard_faq&rev=1425600800&do=diff How do I use the DynamicZip Report Wizard? The DynamicZip™ Report Wizard will assist you in creating new report options. Create Report For The DynamicZip Report Wizard now includes predefined reports for all states with a sales tax. You can select a state or select N/A (manual). text/html 2017-09-08T17:04:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:use_tax_on_free_items_faq&rev=1504890289&do=diff We need to collect use tax for promotional items that our company gives away for free. We charge this tax to our customers. How can DynamicZip help address this situation? The recommended approach is to enter a mock purchase transaction to accrue the use tax for reporting, and then enter a sales transaction for the free items and the amount of use tax owed. This method will charge the use tax to the customers, without requiring any custom tax schedules or details. text/html 2019-03-20T18:41:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:use_tax_rates_sales_tax_rates_faq&rev=1553107279&do=diff Can sales be taxed at Use Tax rates rather than Sales Tax rates? Yes. DynamicZip allows you to make this selection on a state-by-state basis in the DZ State Setup window. NOTE: Changing the Tax Sales At Use Tax Rates option will have no effect until the Rate & Boundary Database is imported. text/html 2017-09-07T22:24:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:when_run_assign_schedules_routine_faq&rev=1504823047&do=diff When should I run the Assign Tax Schedules routine? The Assign Tax Schedules routine scans the address records to validate and update the Tax Schedule IDs. This routine should be run: * After each Rate & Boundary Import. The import process deletes Tax Schedules that are no longer valid, but does not remove those schedules from the address records. The Assign Tax Schedules routine updates address records with the proper tax schedule IDs. When a state creates a new tax or drops an old tax, … text/html 2018-05-02T18:43:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:which_dynamiczip_download_faq&rev=1525286611&do=diff Which DynamicZip build should I download and install? New installations You should download and install the latest build of DynamicZip that is compatible with your version of Microsoft Dynamics GP. Existing installations Determine which DynamicZip build you have installed by checking the text/html 2017-09-07T18:44:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:why_would_tax_schedule_selection_fail_to_work&rev=1504809897&do=diff Why would tax schedule selection fail to work? Tax schedules are normally assigned using these DynamicZip Routines: * DZ Assign Customer Tax Schedules window * DZ Assign Site Tax Schedules window * DZ Assign Vendor Tax Schedules window Tax schedules assignment can also be triggered automatically while the user is entering transactions as well as when creating or editing customer, vendor and/or site addresses. text/html 2015-03-05T01:25:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:year_end_faq&rev=1425518702&do=diff Does DynamicZip have any yearend closing procedures? If we do not perform the Microsoft Dynamics GP yearend procedures, will that affect DynamicZip? DynamicZip does not have yearend closing procedures and is unaffected by performing or not performing Microsoft Dynamics GP's yearend procedures. text/html 2018-05-02T19:07:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:yearend_faq&rev=1525288051&do=diff DynamicZip Year End Procedures DynamicZip does not have year end closing procedures and is unaffected by performing or not performing Microsoft Dynamics GP year end procedures. DynamicZip tax reports are extracted from the Microsoft Dynamics GP sales and purchases transaction history tables. These tables are not affected by the Dynamics GP year end procedures. text/html 2019-03-20T18:56:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:zip_address_state_setup_faq&rev=1553108207&do=diff Why isn't ZipAddressing working? Why doesn't ZipAddressing update the city and state when I modify the ZIP Code? * Check the About DynamicZip window or the DZ Registration window to verify that ZipAddressing is enabled for your DynamicZip installation. * Check to see if the window you are working in is one listed in text/html 2019-03-20T17:57:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:zip_addressing_messages&rev=1553104622&do=diff Address Auto Correction Report Messages Permission to access the Address Auto Correction Report is granted to the Customer Cards Task. Country updated The Country has been (or will be) updated to agree with the Country Default setting specified in the DynamicZip Setup window. Multiple Choices Exist There is more than one choice (in/out of city limits, same city in different counties); DynamicZip is not able to select one. text/html 2015-04-16T20:45:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:zipsales_database_install_workstation_faq&rev=1429217134&do=diff Does the Rate & Boundary Database need to be downloaded on each workstation? No. The Rate & Boundary Database import updates the tax details, schedules, and supplementary tables on your server. A single import on a single workstation (or on the server) will update the tax data for all users in that particular company. text/html 2017-11-01T16:52:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://support.kampdata.com/doku.php?id=dynamiczip:faq:zipsales_database_must_contain_geocodes&rev=1509555153&do=diff ZIPsales Database must contain GeoCodes. Import aborted. The ZIPsales Database originally did not contain Geocodes and you can still get the database without them. DynamicZip requires that the Geocodes exist in the ZIP.txt file of the ZIPsales Database, and uses them to help ensure an accurate link to the tax details we are updating. If this error happens, just let us know you need the version of the ZIPsales Database that contains Geocodes in the ZIP.txt file (zdg.zip rather than zd.zip).