Hello.
We would like to know if it is possible to import sales orders via Excel that contain multiple rows per order and use the automatic numbering feature. We have found several topics on this in the community, but none of them have worked for us yet.
Any help would be appreciated.
Thank you.
+17
Please try with the below import scenario and verify.
Hi. Unfortunately this is not included in our German Haufe X360 version. I found a scenario in the community where the person suggested to just use "1,2,3,4..." in the excel as order nbr to show the system which rows are associated with the same order, but with this error that the order number does not exist / cannot be empty.
+17
Let me know if you need any help!!
Hi
Thank you very much. This Import Scenario does look like its made for manual numbering, isn’t it?
How can we modify it to allow automatic numbering to import sales orders on the fly whenever our customer gets a new pre-filled excel file?
+17
Example: if you 2 records for each order, please fill the Excel like below.
Also, I have created new import scenario with few fields and you can review.
Hej
with the Acumatica Import-Scenario - aswell as yours - i always get the same Error: '[OrderNbr]' must not be empty. Could this be a bug in X360? My Excel looks like this which should be fine
+17
I just changed to the Auto Numbering value like <AUTO> and it worked for me. Please find the screenshot for reference.
Hello
But if i change it to “<AUTO>” how does the import scenario determine which lines should go with which order? If in my Excel i have 20 lines it would now create 20 Orders, no?
+17
Yeah, Understood. All the lines are adding it to the one Sales Order. I will check and let you know if I found any solution for this.
+1
Hi
Here’s a video where you can find detailed explanation on how import scenario works when auto-number is enabled (min 7:24):
Hope this helps.
Hello
Thank you, but as mentioned this does not seem to work in X360 the way it works in Acumatica.
Hello
Any solution to this?
To clarify, we need an import scenario to bring in all lines on one sales order - with auto-numbering?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
