Thank you for your reply, we ran into the same gotcha on PO and Sales Orders. The DMT tool is perfect but our data is not.
On May 3, 2015, at 3:04 PM, bruce.d.ordway@... [vantage] <vantage@yahoogroups.com> wrote:
<div id="ygrps-yiv-1829051039ygrp-text"> <p>>>I figured out the process to change<br>Sounds good.<br>I know it took me a while to start using multiple passes. <br>Since the DMT is using the business logic to update records and not writing directly to the tables.<br>And it might simply ignore some values instead of showing an error.<br><br><br>Reminds me of another "gotcha" I ran into on job sub-assembly imports<br>Some jobs had been edited so there were gaps in the numbering the subs, i.e. 1, 2, 4, 6.....<br>The DMT import ignored the numbering and used business logic to renumbered them in sequence as new jobs. So 1,2,3,4 instead of 1,2,4,6. It was driving me crazy until I finally realized what was going on.</p> </div>