Data Import Function - Delivery Notes

Hi there,

I am currently looking at a way of bulk uploading delivery notes that are linked to an existing sales order using the Data Import feature. I am using the below headers:

  • Against Sales Order (Items)
  • Date
  • Customer
  • Delivery Date
  • Item Code (Items)
  • Quantity (Items)
  • Batch No (Items)
  • Project Set
  • Source Warehouse

While the data import is successful, ERP is assigning a separate delivery note for each batch used on the delivery note/each item code.

Essentially I am looking to find a way for multiple batches to appear on a single delivery note using this function, to save a lot of admin time.

Any suggestions on how this could be achieved with this method or an alternative? Attached is a photo of the current headers and data used.