189
A

Add Lot & Serial No. to Item Journal Lines

Andrew Trayfoot on 3/10/2020 10:29:21 AM
Currently when you do an Item Journal (Item Journal, Physical Inventory Journal, Reclassification Journal, Consumption Journal, Output Journal, and Production Journal) you have to enter the Item Tracking in a sub page.
This causes masses of extra work especially with Physical Inventory Journals

I have been modifying NAV since v3.6 right up to a current BC15 implementation to allow you to enter the details on the face of the Item Journal Line.

In an ideal you would have the ability to have both options controlled by a flag on the Journal Batch.

Category: Inventory
STATUS DETAILS
Completed
Ideas Administrator

Business Central Team (administrator)

Thank you for your feedback. We released this feature as part of the functionality in Easier to create opening balances for item tracked inventory

Note that feature was implemented for Item Journal only. 

Please log separate suggestions if feature is needed for other journals/documents: Physical Inventory Journal, Reclassification Journal, Consumption Journal, Output Journal, and Production Journal

Sincerely,
Andrei Panko
PM, Microsoft

Comments

A

A

RE: Add Lot & Serial No. to Item Journal Lines

Herman Sadhra on 11/14/2023 2:26:29 PM

The functionality that was added to the Item Journal is great. It would be nice to add this functionality to Purchase Order and Sales Order Lines as well. It would make data entry so much simple in a lot of cases.


Category: Inventory

A

A

RE: Add Lot & Serial No. to Item Journal Lines

Chris Husband on 10/24/2022 7:57:41 AM

Two years on from this initial request, I am not sure if anything has actually been done but here is what I did to overcome this issue.

We had the need to import large numbers of serial numbers as we fit meters to buildings as part of construction contracts. So we may book out or receive in 500 or more meters at a time.

I added a button on an item journal and item reclassification journal to allow the user to import from Excel the serial numbers for output or movement. It checks the serial number exists for that item / location and isn't already reserved against another journal.

I also added the button to the purchase order sub-form to allow for the import of serial numbers to receive. In this case it checks that the serial number doesn't already exist for the item.

The data required in the Excel spread sheet is simply a list of serial numbers (one column).

Happy to share this solution with anyone who wants to use it

Category: Inventory

A

A

RE: Add Lot & Serial No. to Item Journal Lines

Mirko Draškovič on 8/31/2022 12:46:19 PM

Also "Copy Item Journal Line" button will be desired. then you just correct SerialNo or LotNo. columns...

Category: Inventory

A

A

RE: Add Lot & Serial No. to Item Journal Lines

Marcel Duizendstraal on 10/12/2021 11:16:05 AM

The fact is that fields "Serial No." and "Lot No." are editable in table 7311 "Warehouse Journal Line". Allas not "Warranty Date", "Expiration Date", "New Serial No." etc. So please include this table also in this request. I also have been setting these T83 fields to editable all the way up to NAV3.01B. We cannot go to SaaS at all if this is not changed in the very near future.

Category: Inventory