Build 70-sp1 (released 9/20/2007)

• User Modified Taxable Amount - The Receivables Tax Entry window and the Payables Tax Entry window allow the user to modify the Total Sales or Purchases amount and the Total Taxable Sales or Purchases amount of the individual Document Tax Details. Prior to this modification, the DynamicZip Tax Reports were restricting these amounts to the amounts entered on the face of the document. As of this modification, the DynamicZip Tax Reports will reflect the user modified amounts regardless of whether or not they match the face of the document. As always, the Reconcile Documents feature of the DynamicZip Tax Reports will reconcile the Document Tax Details back to the actual document totals.

Build 70 (released 8/10/2007)

• Added Extended SOP Tax Recalculation. DZ Extended Tax Recalculation has been added with build 70. Previously only DZ Tax Recalculation was available. We have retained DZ Tax Recalculation to preserve backward compatibility.

• Added Geocode Restriction. Added the Geocode Restriction to the DynamicZip Tax Reports.

• Address Correction & Schedule Selection for Vendor. Modified the DZ Address Correction window and the DZ Assign Tax Schedules window to allow the updates to work for vendors as well as customers. These two windows are now accessed on the Utilities menu.

• Country Added To Tax Detail Supplement Address. Added Country to the Tax Location in the DZ Tax Detail Supplement Maintenance window to provide more flexibility and control in multi-national installations.

• Customer Class Restriction Truncated. The DZ Report Options table was truncating the Customer Class ID field at 10 characters. This field should be 15 characters long. This problem was fixed as part of the DZ Report Options table conversion.

• Customer Supplement Report Improved. The DZ Customer Supplement report now includes the customers' state override information.

• Customer Tax Exemption Expiration. Added Tax Registration Numbers and Exempt Status Expiration Dates to the DZ Customer Supplement window state override section.

• Error 54 from Voided RM Credit Memos. Tax reports that included voided RM credit memos were failing with a duplicate record error. It seems that Microsoft Dynamics GP adds duplicate tax details to the document when it voids it - with a different TRX Source value.

• Force Update of POP Tax Report Records. The Force Update of POP Report Details now works with SQL optimized reports as well as non-optimized.

• Improved Handling of Pickup Type Sales. Microsoft Dynamics GP uses Shipping Type to determine the source of a document's default tax schedule ID. Prior to this enhancement, DynamicZip played no part in this initial selection of the default tax schedule ID. As a result Microsoft Dynamics GP would select the inventory site's tax schedule ID for Pickup sales with no regards to the customer's taxable status. Now, with this enhancement, a DynamicZip trigger will fire and DynamicZip will replace the inventory site's tax schedule ID with its exempt equivalent if the customer has a taxable status of exempt in the IV Site's state.

• Improved Naming Rules Application. The application of DynamicZip Naming Rules as setup and maintained in the DZ Naming Rules window has been enhanced to modify more than one word in the city or county name when appropriate. Prior to this it was only making one modification per name and the one made was the first one that occurred alphabetically.

• Improvements to DZ Modify Detail Supplement. Added the ability to restrict the update process in the DZ Modify Detail Supplement window by:
  Taxable or Exempt Tax Details
  Geocode
  Location Code
  Tax Authority

• Improvements to DZ Modify Tax Schedule. Added the ability to restrict the tax details to be added or removed using the DZ Modify Tax Schedules window by the following:
  Tax Authority
  Location Code
  Geocode

• New Restrictions for the Detail Supplement report. The following range restrictions have been added to the Tax Detail Supplement report:
  Authority
  City
  County
  Geocode
  Location Code
  State

• Now using Canadian Geocodes. Prior to this build geocodes were not being used for Canada during the ZIPsales Import process due to the fact that the ZIPsales Database does not contain cities for Canada.

• Pickup Tax Location without Valid Tax Schedule. Documents with a Shipping Type of Pickup use the Inventory Site as their Tax Location. When a document has this situation, but has no tax details and has a tax schedule ID that is either blank or invalid (i.e. no longer exists) then the DynamicZip Tax Reports use the tax details attached to the inventory site's tax schedule. Prior to build 70, the reports were erroneously using the tax details attached to the tax schedule designated in the card for the ship-to address specified in the document, which would be proper had the Shipping Type been Delivery.

• POP Docs Missing From Reports. Part of the DynamicZip purchase tax reporting process copies the DynamicZip POP accrued tax details from the DZ Purchasing Tax History table to the DZ PM Taxes Work and History table which is the source of the data included in the DynamicZip purchase tax reports. As a result, those POP transactions were not included in the accrued purchase tax reports. As of this enhancement, this copy process is occurring and will occur for all transactions included in the report's range restrictions. This means the documents entered prior to Build 70 will now also be copied if the report's range restrictions do not exclude them. In addition, we added a Refresh button to DZ Tax Detail Zoom window that when clicked will copy the POP documents accrued tax details from the DZ Purchasing Tax History table to the DZ PM Taxes Work and History table.

• Reconcile Document Entry More Precise. In past builds, the reconcile entry typically was given a sort value of (BALANCE). As of build 70 if the sort value of the tax detail records being balanced are all the same, the reconcile entry will be given that common value. If they have multiple values, the reconcile entry gets a sort value of **. If one or more of the tax detail records being balanced has a blank value, the reconcile entry will also have a blank value.

• Skip Update of Inactive Customers and Vendors. When updating addresses from the DZ Address Correction window or assigning tax schedules from the DZ Assign Tax Schedules window, inactive customers and/or vendors will now be skipped.

• SOP Batch Tax Verification. A new process has been added that will examine a batch of sales order documents and report on any errors found related to Zip Addressing, Tax Schedule Selection and Tax by Item Class. This process is run from the DZ Sales Batch Processing window.

• Tax by Item Class Nontaxable Enhancement. Handling of the Nontaxable selection in the DynamicZip Tax by Item Class feature has been enhanced. Prior to this modification, the Nontaxable selection resulted in the applicable line-items being added to the SOP document with a Tax Option of Nontaxable. The problem with this method is that it results in no tax details being added to the document related to this line-item. The primary and preferred way that DynamicZip Tax Reports identify the document's tax location is by reference to the tax details attached to the document. As of this modification, the DynamicZip Tax by Item Class feature will attempt to assign the appropriate exempt tax schedule to the line-item. If unable to assign an exempt tax schedule, the line-item will be set to nontaxable as it was prior to this modification.

• Taxable & Exempt Details for Same Tax Location. The SQL Optimized tax reports would fail with a duplicate record error if one line-item on a document had a ZIP Code Tax Schedule and another line-item on the same document had the ZIP Code Exempt Schedule for the same tax location.

• ZIPsales Import - Purchases/Sales Conflict. If both Sales and Purchase tax were imported for a state that had city taxes on sales but no city taxes on purchases, the last import (Sales or Purchases) run would remove some or all of the previous import's tax schedules. This problem would not occur if Tax Sales at Use Tax Rates was selected in the DZ State Setup window for the state in question.
  As of this enhancement, the ZIPsales Import process for Purchase tax will add the appropriate Purchase tax details to the existing Sales Tax Schedules. It is important that you import the ZIPsales Database for sales prior to importing it for Purchases.

• ZIPsales Returns Added to Report Wizard. The DynamicZip Report Wizard now includes the option to create the export report file in the format requested by CCH for ZIPsales Returns.

Table Conversions:

DZ Customer Tax by State (DZ01102)

DZ Report Options (DZ70501)

DZ Tax Detail Supplement (DZ00400)

New Tables:

DZ Plus4 Geocode Cross Reference (DZ00800)

Top

Build 69-sp2a (released 8/29/2006)

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

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

Build 69-sp2 (released 7/27/2006)

• SQL 2005 duplicate record error running SQL Optimized reports. The DynamicZip pass-through SQL statements used to create records in the DZ Tax Report Document Header Temp table were encountering an error 54 while running DZ SQL Optimized reports with SQL 2005.

• Option D and F summary reports excluding exempt freight & misc. The summary format of these export file reports did not have a column that contained non-taxable freight or non-taxable misc. charges. Below is an illustration of the export file format using the ZIPsales Returns specifications:

Original Format

New Default Format

New Alternate Format (For backward compatibility)

• Country added to jurisdiction sort order. The basic sort order by jurisdiction is now Country / State / County / City. For detail centric reports, this information comes directly from the DZ Tax Detail Supplement record except for Country. With our next table conversions we will add the Country field to the DZ Tax Detail Supplement record. Until then the Country value will be taken from the related Tax Detail record’s country field. For document centric reports, the jurisdiction value is the accumulation of information gleaned from all of the document’s tax details combined.

• Cash basis reports now include applied credit memos and returns as well as cash receipts.

• POP tax accrual not creating distributions from Actions button. Prior to this service pack, using the Actions button in the Purchase Order Entry window to Receive or Receive and Invoice a purchase order, the DZ purchase tax accrual distributions were not getting automatically created. This service pack corrects that problem.

• Non-optimized purchase tax accrual reporting certain billed amounts as accrued. In the situation where purchase tax is billed by the vendor but none is accrued, the non-optimized DZ Use Tax Accrued reports were incorrectly showing the billed amount as accrued. The SQL Optimized reports were properly reporting this situation.

• Reporting of exempt freight and miscellaneous charges improved. In the past these non-taxed charges were often included in the report via the reconciling adjustment. Now they are normally detected and included in the report even when the Reconcile documents check box is cleared.

• Improved handling of non-standard, incomplete, damaged or missing document records.

  • Receivables documents with no tax details were omitted from SQL Optimized reports if the related customer master record was missing.

  • Purchasing documents were omitted from SQL Optimized reports if the related vendor master record was missing.

  • Non optimized reports included an SOP document’s subtotal in both the taxable and the exempt amount column when the documents line-items are missing.

  • RM history documents where the tax detail record’s tax amount does not equal the total of the sales tax amount, the freight tax amount and the miscellaneous tax amount. With these documents, the DZ reports showed the tax details with a zero total amount and with exempt and taxable amounts that offset each other. The reconciling adjustment then adjusted the report correcting the erroneous amounts.

  • Documents with tax but no tax details were appearing as exempt in the DZ reports.

  • RM documents with tax details having a value in the tax amount field but showing a sales tax amount of zero, a freight tax amount of zero and a miscellaneous tax amount of zero. The DZ reports showed these tax details with no tax amount. The reconciling adjustment then adjusted the report for the missing tax amount.

  • Documents with tax details showing a tax amount but a total sales amount of zero and a total taxable amount of zero. The tax details for these documents were reported as zero total, zero taxable and zero exempt but with a tax amount. The reconciling adjustment then adjusted the report for the missing amounts.

  • Purchase documents with tax details having a Type of Sales instead of Purchases. The DZ reports were rejecting the details and creating a "no details found" record in their place.
     

Top

Build 69.05.24 (released 5/25/2006)

• Monitor the status of DynamicZip tables. Prior to this release, DynamicZip created and maintained the DZ Table Status table as a way of tracking which build the tables were created under and thereby identifying which tables need to converted and which conversion process to use. This proved to be problematic. This build introduces dynamic monitoring of the DynamicZip tables. The status of the tables is now determined by examining the tables themselves instead of relying on the contents of the DZ Table Status table.

• New and improved SQL table conversion process. We are now using SQL temp tables and SQL statements for most of the conversion process in place of using the conventional ctree tables and Dexterity functions and procedures. This improves the performance and reliability as well as giving us more control over the process.

• Improved error handling when table problems exist. Prior to this release, attempting to access a DynamicZip window or feature when DynamicZip tables are missing, damaged or require conversion would result in a system error message box popping up. We now disable DynamicZip when these problems exist and present the user with a message to that effect if they attempt to access DynamicZip in a way that would otherwise have thrown the system error message.

• Require system passwords to open certain DynamicZip windows. Opening the following windows will now require the Microsoft Dynamics GP system password: (This requirement doesn’t apply to 'sa' or 'DYNSA'.)

Build 69.03.06 (released 3/6/2006)

Reports

• Made the Wizard button more prominent as user feedback indicated that many of our users were not aware we had a report wizard.

• Added a brief description of the currently selected report option at the bottom of the DZ Reports window.

• Added a report legend indicating when the Description option is set to Schedule instead of Name. This setting allows you to display the tax schedule description instead of the customer or vendor name in our reports.

Table Conversions:

DZ Report Options (DZ70501)

DZ State Setup (DZ00500)

DZ Tax Administrator (DZ00300)

DZ Zip Address (DZ40400)

Top

home   about us   contact   products   download   support   links   awards   search   site map

©2008 Mojave Solace, LLC All rights reserved

Page last updated 01/07/2008