dynamiczip:faq:customer_combiner
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dynamiczip:faq:customer_combiner [2017/01/04 19:09] – chuck | dynamiczip:faq:customer_combiner [2017/01/06 17:47] – [Using the Professional Service Tools Customer Combiner] chuck | ||
---|---|---|---|
Line 1: | Line 1: | ||
======Using the Professional Service Tools Customer Combiner====== | ======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 [[dynamiczip: | + | 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 [[dynamiczip: |
- | Also, if two customers | + | Also, if two customers have an identical address ID, you may receive the following error on the [[dynamiczip: |
**[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ' | **[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ' | ||
- | |||
- | The [[dynamiczip: | ||
Each record in the DZ Customer Supplement table is used to identify whether a customer is taxable or exempt. Typically, customers being combined would have the same tax status, but you may still want to validate the end result. One way you could validate would be to run the [[dynamiczip: | Each record in the DZ Customer Supplement table is used to identify whether a customer is taxable or exempt. Typically, customers being combined would have the same tax status, but you may still want to validate the end result. One way you could validate would be to run the [[dynamiczip: |
dynamiczip/faq/customer_combiner.txt · Last modified: 2019/03/13 18:51 by conni