,
Trying to use the 'import from excel' function in Dyanmics to do a bulk upload of Booking Lines.
I had used the 'export to excel' function and then added data at the bottom of the sheet as per my usual process. I used the following fields;
Organisation, booker name/email, Booking source, attendee type and order number (ID).
When I tried to import, I got failures on each line saying 'Requires SalesOrder ID is missing'. Naturally I then added. column with the above name, and added the sales order ID of the booking related to the booking line- I still got the same error.
Any ideas how to combat this issue?
Thanks in advance