DMT - Sales Order Combined

Kinetic ERP
1

I’ve got a working template to upload and create sales orders, single line single release, single line multiple release, and multi line multi release. However I cannot seem to get the “ship by” and “need by” dates to upload correctly on the releases. It always sets all the release dates to the last date specified. For example: one line, two releases, first release has a shipby and needby date of 11/7/2025, second release has a shipby and needby date of 11/10/2025. No matter what I try the DMT upload sets both to 11/10/2025, the date of the last specified release.

I’m guessing this has to do with the built in logic that occurs when manually entering order lines and releases. When you change a date on one a little dialog box pops up and asks if you want to update the date on the other associated record(s). I’m guessing that I need to find a way to basically say “NO” to this logic, but via the DMT.

Any ideas?

2

Run a second data import with the correct dates?

You also might check the template, sometimes there is a column were you can add the NO response to the “dialog box”

3

Are you doing add new/update? Releases are automatically created initially. I have tried doing the combined DMT file and find it always results in more trouble than it’s worth. If you are hell bent on using Sales Order combined, I’d do your headers and lines as 1 and then do your releases separately and update the values. For every line you will have 1 release, so then when you are needing to making multiple releases per line you’re going to update rel 1 and add new rel 2, 3 etc with different values.