We currently are assigning lot numbers at the kit creation level, but would like to switch to assigning lot numbers at invoicing instead. Can we simply change the lot class of each item in our system to have the lot be assigned when used instead of when received?
Changing the lot class of preexisting item numbers
Hi
I suggest you change this when the on hand quantity is zero. You may test on demo data and let us know the result.
Regards,
Hi
- Extract the list of Kit items with Location, Cost and Unit Cost that has the old lot/serial class
- Issue out all the items using the Issues screen
- Create the new Lotserial Class
- In Stock Items Screen, update all the items (from step#1) with the new Lotserial class
- Using Receipts screen, receive the items with the same cost as in the issue.
Thanks
Hi
Thanks
Hi Chandra:
I had assigned a serial class where I had to manually enter the serial number, The serial class as existing in the Sales Demo data set, was:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/afdbb169-4b91-4908-8a60-2def49cea7ae.png)
When I had a PO and a purchase receipt of 40 units for the stock item ABC with the above serial number class, the purchase receipt asked me to enter 40 serial numbers.
I canceled the Purchase Receipt and the Purchase Order.
I checked the inventory for that ABC stock item, the inventory was zero. No serial numbers existed for that ABC stock item.
I taught that I could change the serial number class for that ABC stock item to the one with sequence auto numbering:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/50c6e35e-698f-43bf-971f-6fd402479758.png)
but I got the error:
-
-
- . IN Error: Lot/serial class cannot be changed when its tracking method is not compatible with the previous class and the item is in use.
-
What should I do? Luckily I created only two stock items with the old serial number class. (enter manually the serial #)
Thanks for your help
Toon SIx
Hi
- ChangeID for the 2 items for which you need the new Lotserial class
- Create the new Stock Item with the Same Inventory ID of the items.
Thanks
Hi
Reproduced Error on my instance:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/453a634c-ff3b-40bc-9ea6-0af161b3a0da.png)
Steps to Change the Lotserial class:
- As shown below, use the ChangeID for the 2 items for which you need the new Lotserial class.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1649289b-4211-45ab-82a9-76873e63106e.png)
- Create the new Stock Item with the Same Inventory ID of the items. Change the Lotserial Class to the new one you wish.
Tip: You could use the Copy paste option to create the new Item. Always use the Paste option only after entering the InventoryID.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.