Solved

lot number conversion with attribute carry over


We have a scenario where we sometimes need to convert lot numbers from one type to another.

My question is. Is there a way to do this and have the attributes automatically carry over from the old lot number to the new lot number?

icon

Best answer by hkabiri 8 May 2023, 23:42

View original

3 replies

Userlevel 6
Badge +5

@bclemons  It depends on what you mean by conversion and if this action result into a new record being created or adjust the existing one. If record on table remain the same the corresponding attributes would remain linked.

Please provide more details on which attributes and how the conversion is being done.

We currently have an 8 digit lot number system and are currently converting the existing inventory to a 10 digit system. so we would like to convert the existing inventory to the new system without losing the specific attributes associated the existing products. Basically we are trying to keep all the existing records and attributes and not create a new line of records.

Userlevel 6
Badge +5

@bclemons The attributes are linked to InventoryID which is a uniqueID (noteID) behind the scene and changing the InventoryID (InventoryCD Field on DB) or Lot serial Number on UI should not unlink them from their corresponding Attributes.

Reply


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