I need to enter new items into our inventory that have serial numbers from the manufacture, in bulk. Is there a way to enter these serial numbers as a batch? I have created the item and did a custom serial and lot number series, see below.
A little history here, we are a telecommunications construction company and have received a lot sterilized and lot numbered of equipment from our client. We have a few thousand parts and pieces to enter and track. We have to track the serial/lot numbers as we build the sites and will later be using service contacts for the maintenance and repair of these facilities. For tax reason we created a virtual warehouse to keep track of these items and are currently using zero-dollar POs to enter the equipment into the virtual warehouse. This mean using Item Tracking Lines to enter the serial/lot numbers one at a time. Even with a scanner this is time consuming.
The only source of information I have been able to locate is Track Items with Serial, Lot, and Package Numbers - Business Central | Microsoft Learn. However, this makes no mention of anytime of bulk update/entry function for the equipment with serial/lot numbers.
The "share with other apps" button only opens the file in excel, but it does not open so it can be edited in excel.
Anyone have any experience with this?
