User Tools

Site Tools


dynamiczip:glossary:flat_file_test

Flat File Test

NOTE: Effective with Build 74 this has been replaced with the Verify Rates and Boundaries process. This feature was available at DynamicZip » Flat File Test in the ZIPsales Import window.

Kamp-Data uses this test internally for Software Quality Assurance (SQA) purposes as it helps verify the accuracy of the Rate & Boundary Import process. This test reads CCH's FLAT.txt file and compares the total rate contained in the FLAT.txt file for each ZIP Code with the appropriate DynamicZip tax schedule's total tax rate.

When run against the complete Rate & Boundary Database this process will test approximately 62,000 tax rates.

To Run the Flat File Test

Build 74 and later

The Verify Rates and Boundaries process can be run as part of an import or it can be run separately. To run it separately, select Custom as the Import Destination in the DZ Rate and Boundary Import window. Leave all the import destination check boxes cleared.

  1. Select Verify Rates and Boundaries in the DZ Rate and Boundary Import window.
  2. Select SQL Optimize. (Optional but faster.)
  3. Select All States or enter a Group ID.
  4. Click the Import button.

Build 73 and prior

  1. Log the process by selecting Log Processes1). You will need to specify a log file location in the DynamicZip Setup window if you haven't already. Any tax rate discrepancies will be written to this log file.
  2. Select View Log File2) to verify that your log file is valid. A Notepad window should open displaying the contents of your file.
  3. Select Flat File Test.
  4. Click Import. With Flat File Test selected, clicking Import will run the Flat File Test rather than importing the Rate & Boundary Database.
  5. Select View Log File3) to view the detailed results of the Flat File Test.

DynamicZip Additional Windows
Glossary

1) , 2) , 3)
Removed in Build 77.0
dynamiczip/glossary/flat_file_test.txt · Last modified: 2018/07/26 17:52 by chuck

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki