We are trying to setup a template to import multi line orders through DMT.
I can import single line orders successfully using Sales Order Combined template. But when tried to do the multi line order it is failing on the 2nd line as DMT assumes that 2nd line is a separate order (order number is 0 for all the lines). How can we setup the data in the template to show the system that other lines are part of the same order?
You don’t need to do anything special other than have the same order number in each row. For example, if you have order 123 and it has 3 lines then you should have 123 listed 3 times under the OrderNum column.
Leaving ordernum as 0 means the system will generate the order number which I guess you want it to do. I think if you’re using Sales Order Combined template, you also need column OrderDtl#OrderLine. Set this field to be equal to 1, 2, 3 then back to 1 to indicate a new order.
Tel :+44 (0)20 8451 8700 | Fax: +44 (0)20 8459 6301
Unit 6 Iron Bridge Close | Iron Bridge Business Park | London | NW10 0UF | UK
This email and any attachments may be confidential and are intended solely for the use of the individual(s) to whom it is addressed. If you are not the intended recipient of this email, you must not take any action based upon its contents. Please contact the sender if you have received this email in error. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Integral Memory plc. Computer viruses can be transmitted with emails. The recipient(s) must virus-check this email and any attachments. Emails may be monitored and stored. Integral Memory plc is registered in England and Wales. Reg. No: 2480354. Reg. office: Unit 6 Iron Bridge Close, Iron Bridge Business Park LONDON. NW10 0UF. UK
@Rashid would you be able to post the file used. We are trying this out and I have been struggling to get the lines to be on one order. The DMT keeps creating new orders per line.
Only just quickly glanced before leaving the office for the weekend I would try moving the OrderNum column further to the left, perhaps right next to Company.
You need to make sure your using PONum and increment OrderLine by one each time and it will start a new order when the PONum changes. I’ve been using the Sales Order Combined for years with multiple orders and multiple lines in the same
file with no issues.
I am struggling with this right now. I have a file and when the PO num changes, I get a new sales order for each line. Any thoughts? I keep trying different things to no avail.