I am prepping for a go live and I am running into an issue with the Sales Order Combined DMT. It seems to work fine for most orders but when I have an order with multiple lines, some of them error saying “Invalid OrderRelNum”. Each of these lines is 1 release and no matter the setup I try this error keeps coming back. This doesn’t apply to all of them either. It seems to be random.
I have tried remove the OrderRel#OrderRelNum field completely, setting it 1 for all records on the order, and setting it 0 to see if would create it.
3 of the 4 lines create the lines correctly and the 1 release with any of these setups but the 4th errors no matter what. I have other orders that have the same exact setup that entered fine via DMT and some of those have lines that aren’t in a sequential order. One of them went from line 1 to 5 to 6 and went in just fine and created the lines as 1,2, and 3 on the order.
Has anyone ever seen this before? I can’t find anything so far in the data that explains this.
We use the Sales Order Combined daily. We have one that we don’t include the Order Release at all and we have another that we need to specify they warehouse so we set the order rel num field to 1 for all order lines and set the warehouse code.
Maybe you could try adding the warehouse code? Our order release columns are the last 2 columns of our DMT file. Maybe try moving it from being after the order line to being the last column.
Thanks for the suggestion. I moved the OrderRel fields. It looks like anything that errors with the “Invalid Column name ‘OrderRelNum’” actually DMTs just fine.
Would you be willing to provide a sample DMT that you use please? If not, no big deal. I am still running into some strange issues but most of the records work fine.
