Start a new topic

Automatic serial number allocation per unit on purchase invoice importing

At the moment, when importing a .csv for purchase invoices, DEAR requires each individual unit to be listed separately for it to be allocated a unique serial number. This causes issues as all invoices are supplied with SKU number and then the quantity of that product. For example:


TH78-119B-Q1 : 376 Units


rather than 

TH78-119B-Q1 : 1 Unit

TH78-119B-Q1 : 1 Unit

TH78-119B-Q1 : 1 Unit

etc

etc

etc 


DEAR demands this is split in to 376 separate line items with a quantity of 1 for it to be able to allocate each item a unique serial number. This is incredibly time consuming to do manually for every invoice and at first glance should be something that's automated on import.


1 person likes this idea
Login or Signup to post a comment