By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
Can Acumatica track Attributes on Lot numbers and Serial numbers?
The answer is yes. Not out of the box, but with a free customization project that you can download on Github.
First, you need to download the appropriate PXLotSertialNbrAttributeExtPkg.zip file from the Releases area of the Github project:
https://github.com/Acumatica/Acumatica-LotSerialNbrAttribute/releases
Then load the .zip file into the Customization Projects (SM204505) screen and Publish. When you're done it should look like this:
You create Attributes in the normal Attributes (CS205000) screen in Acumatica. Then you add them to Lot/Serial classes using the ATTRIBUTES tab on the Lot/Serial Classes (IN207000) screen (this tab was added by the Customization Project).
Once you add some attributes to a Lot/Serial Class, then try receiving in an item in that Lot/Serial Class using the Purchase Receipts (PO302000) screen.
Everything looks normal until you click the ALLOCATIONS button:
When you click that button, the ALLOCATIONS window that comes up looks different. Now there is a section on the right-hand side where you can enter attribute information about the specific lot / serial number:
Cool huh?
One issue I noticed with this though when auto numbering lots is that Acumatica doesn't assign the lot / serial number until you release the transaction. You can see the number is still LREX000000000 in the screenshot above. The problem with this is that the attributes will get assigned to lot LREX000000000 which will never actually exist in inventory so it will appear that the attributes disappear.
But if you click the GENERATE button, then Acumatica will assign the next lot / serial number (LREX000000005 in the screenshot below). Now when you assign attributes, they will "stick" because this lot number will actually exist in inventory:
Bottom line, when auto numbering lots or serial numbers, make sure you always click the GENERATE button before assigning any attribute information.
Lastly, note that there is also a screen called Item Lot/Serial # Info (IN202501) that allows you to assign or edit lot/serial attributes or attach files to them after they have been received into inventory:
Tim,
Nice little customization to add for couple of attributes, our JewelShop plugin uses attributes close to 80+ attributes at style/serial level and copies all data from Inventory to serial level along with images. We also have smart searches that let's you search on these serial level attributes and much more ...
Acumatica should allow customization of the attribute screen/tab, instead of showing the attributes in grid if they can introduce the concept of customizing the screen like UDF's (User defined fields) then attributes will fly, check few screenshots here https://www.info-sourcing.com/cloudERP/Acumatica-JewelShop.htm
- Harsha
Nice Harsha! Are you using Acumatica Attributes in this screenshot? Or are they custom fields all added to a tab that you happened to call ATTRIBUTES?
Hey Tim,
We use close to 100 attributes for this JewelShop plugin, and we decided to use "Acumatica Attributes" rather than custom fields, so customers can update the attribute values much easier and we could customize the screen if required, all these attributes are linked to Item classes and much easier to manage during implementation, this was 2 yr old concept and now have a customer up and running 🙂
Harsha
Very cool. You are the Attribute master Harsha! I remember that Sales Order screen you showed me back at Acumatica Summit 2016 in Orlando. I doubt there is anyone who has more experience than you do with tracking a bunch of Custom Fields / Attributes on a record in Acumatica.
Tim,
This is a great customization and meets a requirement we have perfectly. Has anyone tried creating a generic inquiry to allow a search by serial number or an attribute value. If so, what key is used to tie the attribute in CSAnswers back to the InventoryItem? I had no success in doing this. Any suggestions would be greatly appreciated!
Bob
@bnowatzky Bob, how did you do it? I'm trying to show the attributes from the receipts to carry with the item through to the invoice.
Nevermind. The trick is to link the UsrInventoryLotSerialContainer table into your query and the <ATRIBUTE NAME>_Attribute field shows up as a field you can put on your GI.
@mikerosz Think I got it. on the receipt at least...haven't pushed through to carry to the serial attributes all the way to so and invoices...we'll see.
@bnowatzky Also curious how you were able to do this. I can't seem to get the attributes from the lot level to show up on a GI
Good day,
How do I get the UsrInventoryLotSerialContainer Attributes to show up properly on my forms (shipment confirmation, invoices, etc.)? I am having difficulty setting up the relationship in the schema builder.
Thanks in advance!!
Mike
Anybody know if a 2021 R1 update is in the works?
@wildlifetracker Funny you should ask, I installed this on 2021R1 yesterday and tested it and it seems to work just fine for what I am doing.
Excellent, happy to hear it!
Following up on this same question. We are on 2020r2 and using the Acumatica-LotSerialNbrAttribute extension.
We are considering upgrading to 2021r1 or even 2021r2. Is this still working for you guys?
@atiu Yes, it works for us in 2021 R1.
We have one bug that prevents us from deactivating attributes from an item in the lot/serial class screen. It needs a checkbox that allows you to deactivate an active attribute. You can substitute an attribute for a different attribute as a somewhat workaround, but once you have 3 attributes, you will always have 3 attributes. Unless I'm missing something.
It works with 2021 r1...I have a client using it in that release.
Online Members
