By using this website, you agree to our Terms of Use (click here)
We are currently experiencing an issue with adding Posts to Discussion Topics. You can click a REPLY button to reply to an existing Post, but you can't click ADD REPLY to add a Post to the bottom of a Topic. This is being investigated.
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
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
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.
Online Members
