Solved

Limit to single lot/serial in warehouse location

  • 20 October 2023
  • 5 replies
  • 60 views
R
Rank

In our warehouse, only one lot/serial can be stored in a location at the time. In Acumatica is there a feature or method to limit the location to store only one lot/serial number?

icon

Best answer by Kandy Beatty 22 October 2023, 19:08

View original

5 replies

C
Rank
Userlevel 7
Badge +9

Hi @rohaochao Please find the below steps. 
1. A lotserial class can be created to use a constant

  1. Assign this lotserial class to all those items belonging to a specific warehouse.
Chandra M
C
Rank
Userlevel 7
Badge +9

Hi @rohaochao Please find the below screenshot showing the constant lotnumber configuration in the Lotserial Class.
 

 

Chandra M
C
Rank
Userlevel 7
Badge +9

Hi @rohaochao Also, please find the below lotserial class configurations that provides you a unique reference for the day. This lotserial class can be assigned on all the items of the warehouse.

Note: Acumatica throws an error if you are trying to assign a new type of lotserial class to an which is already used in transaction.
 

 

Chandra M
Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @rohaochao 

There is currently nothing out of the box that will essentially lock a lot/serial number to a warehouse. 

There is a package on GitHub for Lot/Serial numbers that has some good reports for Lot/Serial Numbers. One is the Lot/Serial number Search, it will tell you warehouses and locations which could help you check to see if more than one lot is in a location. 

You could have a developer customize it a bit more to add the security for the features you need. 

Here is the link for that customization and the features:

https://github.com/Acumatica/Acumatica-LotSerialNbrAttribute-2023R1-ONWARD

 

This extension allows to add attribute support to Lot/Serial Number so that each Lot/Serial Number's unique characteristic (Example – color variation, stone pattern etc. in case of Granite Slab) can be tracked. With this extension, you can:

  • View Lot/Serial numbers in listing Screen (IN2025LS)
  • Define numeric type (Integer and Decimal) of controls for Attributes (CS205000)
  • Define attributes to be tracked for each Lot/Serial class
  • Assign attribute values, Manufacturing Lot/Serial number while receiving items via Allocations dialog in Inventory Receipt (IN301000), Purchase Receipt (PO302000) and Move (AM302000) Screens
  • Assign attribute values and image for individual Lot/Serial Number (IN202501)
  • Assign description, detailed description, Sales Price, MSRP and E-Commerce settings at individual Lot/Serial Number (IN202501); values will be defaulted from Stock Item during receiving process
  • Bulk assignment of attribute values via Import Scenario
  • Access custom Web Services Endpoint (eCommerceLotSerial) exposing Lot/Serial Screen (IN202501)
  • Search and allocate Lot/Serial Number by attribute value/s in Sales Order (SO301000) and Material (AM300000) Screens
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
R
Rank

Thank you all for the response @kandybeatty49. Seems like have to go with the customized route in order to limit one lot per location.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved