I’m trying to use the sales order combine to enter multiple sales order lines.
I am able to successfully import the first line however, the second line does not import. I do have the OrderDtl#OrderLine field set to 2 on my second line. Line two always throws the error “Input array is longer than the number of columns in this table” This is a CSV file and I manually entered the data into the form as I’m creating a new order not updating an existing one. I have reviewed it in notepad and do not have any extra columns. I can’t figure out why line one is successful and line two errors out. Anyone have any idea as to what might be going on or how to fix it?
Try setting your orderline to 0 for all lines and make sure they are in the order that you want then to appear in the SO. Let me know your result. I just had a look at my input data and it does have OrderDtl#OrderLine with numbers. What version of DMT are you using? Do you have any bpms enabled?
I am not versed in DMT but I wonder what is the end of line delimiter? Different OS’s and even text editors can handle line breaks\feeds differently. When you view a text file, all you see is a new line, so its hard to tell.
Morbid curiousity - does the problem still exist if you use an Excel sheet instead of a CSV? DMT will work with both.
If it does, then perhaps BOM markings and underlying unicode silliness are happening in your CSV that aren’t being displayed properly in Notepad. You may find additional weird characters using a different editor like Notepad++
I changed the order line number to 0 on each line and it’s trying to create a new order for line two as I’m getting a duplicate PO number error. I have several BPMs running against sales orders. We used to do this in 9.05 without issue so I’m stumped as to why I can’t do this in 10.2
My DMT version is 4.0.36
I receive the same error when trying to import as an xlsx file.
Here is our template for SO combined. The process I use is create the sql query in SSMS run it and copy paste with headers.SPCombinedTemplate.xlsx (9.0 KB)
One of the issues I had was if we had one line with an incorrect UOM the subsequent order lines would fail.
I believe the problem is OrderNum=0 which is setting the next order number, but I assume you have that customer set to CheckDupPO=true which prevents the second duplicate sales order from being created. Why not just create the next OrderNum in your series and assign it instead of letting DMT handle it?
I checked my DMT preferences and they mimic yours. I also tried using the file you provided, but still received the same error on line 2. Thanks for your assistance!
Since DMT processes one line at a time, passing a 0 for the order number and a line 2 does not make sense. If you cannot predict the sales order number in advance, you will need to make two DMT files, one to create the sales orders and the other to add the lines. I’ve had to do this for labor details DMT loads and although it stinks, you can do this with powershell scripts.
If you only want to do one order at a time (judging from the conversation of wanted order number 0 to make a new order and all be the same), couldn’t you just make an order and then in the list tab do a paste insert for the lines?