Planned Assemblies - Bulk Upload
We have many assemblies per month - a bulk upload feature would be MASSIVELY of benefit.
Currently we input each assembly one by one manually, we have a few hundred a month.
We know what we need to build the month before, based on sales figures and stock levels. We then create and authorise assemblies, which tells us how much available stock we have. We then order from this figure in DEAR.
We then upload via csv assembly SKU's and quantities to a choice of draft or authorised.
Then when the day comes to manufacture those lines, we pick off the assemblies that are required from the list of authorised assemblies, pick them (only then should DEAR request an expiry date), and complete them.
Expiry dates can't be expected to be entered before you've authorised or even picked your stock - we don't know what the expiry dates of the components are before we've picked them, thus we cannot set the expiry of the FG until components have been picked.
DEAR would auto-populate an expiry date based on the earliest expiring product (it already does this when picking components). This can then be overridden if required.
An alert set for a min expiring dates for components would be hugely beneficial too, then it would flag up if something with poor dates are used (which would cause problems down the line if the user forgot to check).
(Currently we create a manual assembly, try to authorise it. "Expiry date is required"...ok lets put a year from now, then authorise it, pick it, sort by expiry dates. Then if we remember, we reset the FG expiry date to the first expiring component. Or we remove that product, and replace it with another better date component, set the FG expiry date, allocate stock and away we go.) It sounds simplistic but that's the process. Theres loads of room for error.
6 people like this idea