AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Live
  • Login
  • Start Here
  • Rolodex
  • Courses
  • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Everything Else
Acumatica Lot and S...
 
Notifications
Clear all

Acumatica Lot and Serial Number Attributes  

    Last Post
RSS

Tim Rodman
Posts: 2519
 Tim Rodman     ★★ All-Star ★★
November 28, 2018 10:04 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

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:

ncantral liked
Topic Tags
acumatica user group acumatica lot attributes acumatica serial number
9 Replies
Harsha Sarjapur
Posts: 51
 Harsha Sarjapur
February 18, 2019 10:39 pm
(@infosourcing)
51-100 Posts
Joined: 11 months ago

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 

Reply
Tim Rodman
Posts: 2519
 Tim Rodman     ★★ All-Star ★★
February 24, 2019 12:07 am
(@timrodman)
Over 200 Posts
Joined: 5 years ago

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?

Reply
Harsha Sarjapur
 Harsha Sarjapur
(@infosourcing)
Joined: 11 months ago

51-100 Posts
Posts: 51
April 26, 2019 5:56 pm
Reply toTim RodmanTim Rodman

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

Reply
Tim Rodman
Posts: 2519
 Tim Rodman     ★★ All-Star ★★
April 29, 2019 9:47 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

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.

Reply
Bob Nowatzky
Posts: 3
 Bob Nowatzky
April 15, 2020 4:54 pm
(@bnowatzky)
2-5 Posts
Joined: 11 months ago

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

Reply
Bob Nowatzky
 Bob Nowatzky
(@bnowatzky)
Joined: 11 months ago

2-5 Posts
Posts: 3
April 16, 2020 3:57 pm
Reply toBob NowatzkyBob Nowatzky

Never mind....got it!

Bob

Reply
Tim Rodman liked
mgraci
 mgraci
(@mgraci)
Joined: 4 months ago

2-5 Posts
Posts: 4
December 2, 2020 8:12 pm
Reply toBob NowatzkyBob Nowatzky
Bob Nowatzky

@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.

 

 

Reply
lucas
 lucas
(@lucas)
Joined: 2 months ago

2-5 Posts
Posts: 2
January 11, 2021 8:04 pm
Reply toBob NowatzkyBob Nowatzky
Bob Nowatzky

@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

Reply
mgraci
Posts: 4
 mgraci
October 28, 2020 10:49 pm
(@mgraci)
2-5 Posts
Joined: 4 months ago

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

Reply
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Making AUG Forums Better
    3 months ago
  • Extend to Customer or Extend to Vendor
    5 months ago
  • Automatically email shipment confirmations and record when shipment actually sent
    7 months ago
  • Outside Processing Flag on Work Center
    11 months ago
  • XML (Old) vs. MSDL (New)
    1 year ago
Topic Tags:  acumatica user group (48), acumatica lot attributes (1), acumatica serial number (1),
  Forum Statistics
11 Forums
1,707 Topics
7,873 Posts
9 Online
1,159 Members

Latest Post: GI with customer and customer location Our newest member: mpryor@vyapay.com Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×